Course
Introduction to SQL
- BasicSkill Level
- 4.9+
- 35.6K
Learn how to create and query relational databases using SQL in just two hours.
Data Manipulation
Data, AI, and Cloud Courses
Master skills that matterFollow short videos led by expert instructors and then practice what you’ve learned with interactive exercises in your browser.
- Learn at your own pace
- Get hands-on experience
- Complete bite-sized chapters
Create Your Free Account
Continue with GoogleShow more optionsor
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
33 Courses
Course
Intermediate SQL
- BasicSkill Level
- 4.9+
- 19.7K
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Data Manipulation
Course
Joining Data in SQL
- BasicSkill Level
- 4.8+
- 17.7K
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
Data Manipulation
Course
Data Manipulation in SQL
- BasicSkill Level
- 4.8+
- 10.5K
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Data Manipulation
Course
Exploratory Data Analysis in SQL
- IntermediateSkill Level
- 4.8+
- 6.6K
Learn how to explore whats available in a database: the tables, relationships between them, and data stored in them.
Exploratory Data Analysis
Course
Introduction to Relational Databases in SQL
- BasicSkill Level
- 4.8+
- 5.9K
Learn how to create one of the most efficient ways of storing data - relational databases!
Software Development
Course
Database Design
- BasicSkill Level
- 4.8+
- 5.7K
Learn to design databases in SQL to process, store, and organize data in a more efficient way.
Data Engineering
Course
PostgreSQL Summary Stats and Window Functions
- IntermediateSkill Level
- 4.8+
- 4.9K
Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!
Software Development
Course
Functions for Manipulating Data in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 4.1K
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Data Manipulation
Course
Data-Driven Decision Making in SQL
- IntermediateSkill Level
- 4.8+
- 2.6K
Learn how to analyze a SQL table and report insights to management.
Data Literacy
Course
Introduction to SQL Server
- BasicSkill Level
- 4.8+
- 2.4K
Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.
Software Development
Course
Introduction to SQL Querying with AI
- BasicSkill Level
- 4.8+
- 1.4K
Learn SQL Querying with AI by writing prompts, generating queries, and analyzing data to solve real-world problems.
Data Manipulation
Course
Analyzing Business Data in SQL
- IntermediateSkill Level
- 4.9+
- 1.2K
Learn to write SQL queries to calculate key metrics that businesses use to measure performance.
Reporting
Course
Applying SQL to Real-World Problems
- IntermediateSkill Level
- 4.9+
- 1.2K
Find tables, store and manage new tables and views, and write maintainable SQL code to answer business questions.
Reporting
Course
Creating PostgreSQL Databases
- BasicSkill Level
- 4.8+
- 920
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Data Preparation
Course
Introduction to NoSQL
- BasicSkill Level
- 4.8+
- 889
Conquer NoSQL and supercharge data workflows. Learn Snowflake to work with big data, Postgres JSON for handling document data, and Redis for key-value data.
Data Engineering
Course
Intermediate SQL Server
- IntermediateSkill Level
- 4.9+
- 856
In this course, you will use T-SQL, the flavor of SQL used in Microsofts SQL Server for data analysis.
Software Development
Course
Reporting in SQL
- IntermediateSkill Level
- 4.8+
- 763
Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, and validation skills.
Reporting
Course
Intermediate SQL Querying with AI
- BasicSkill Level
- 4.9+
- 541
Build SQL skills by writing AI prompts that generate queries for sorting, grouping, filtering, and categorizing data.
Data Manipulation
Course
Introduction to Oracle SQL
- BasicSkill Level
- 4.8+
- 530
Sharpen your skills in Oracle SQL including SQL basics, aggregating, combining, and customizing data.
Data Manipulation
Course
Improving Query Performance in SQL Server
- IntermediateSkill Level
- 4.8+
- 495
In this course, students will learn to write queries that are both efficient and easy to read and understand.
Software Development
Course
Cleaning Data in PostgreSQL Databases
- IntermediateSkill Level
- 4.8+
- 463
Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Data Preparation
Course
Writing Functions and Stored Procedures in SQL Server
- IntermediateSkill Level
- 4.9+
- 456
Master SQL Server programming by learning to create, update, and execute functions and stored procedures.
Software Development
Course
NoSQL Concepts
- IntermediateSkill Level
- 4.8+
- 450
In this conceptual course (no coding required), you will learn about the four major NoSQL databases and popular engines.
Data Engineering
Course
Improving Query Performance in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 376
Learn how to structure your PostgreSQL queries to run in a fraction of the time.
Software Development
Course
Time Series Analysis in SQL Server
- IntermediateSkill Level
- 4.8+
- 331
Explore ways to work with date and time data in SQL Server for time series analysis
Data Manipulation
Course
Building and Optimizing Triggers in SQL Server
- IntermediateSkill Level
- 4.8+
- 312
Learn how to design and implement triggers in SQL Server using real-world examples.
Software Development
Course
Functions for Manipulating Data in SQL Server
- IntermediateSkill Level
- 4.9+
- 303
Learn the most important functions for manipulating, processing, and transforming data in SQL Server.
Data Manipulation
Course
Transactions and Error Handling in SQL Server
- IntermediateSkill Level
- 4.8+
- 298
Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.
Software Development
Course
Transactions and Error Handling in PostgreSQL
- IntermediateSkill Level
- 4.8+
- 235
Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.
Software Development
FAQs
What is data science?
Data science is an area of expertise focused on gaining information from data. Using programming skills, scientific methods, algorithms, and more, data scientists analyze data to form actionable insights.
How can I learn data science?
You’ll need to learn a programming language such as Python or R and master the principles of math and statistics. Knowledge of data analysis methods and data science tools is also essential. There are many ways to learn data science. As well as formal means of education, such as a degree or university study, there are plenty of other resources to help you learn at your own pace. As well as online courses and tutorials, there are books, videos, and more.
What skills are required for data science?
As well as knowledge of mathematics and statistics, data scientists need programming skills in languages such as Python, R, and SQL. Additionally, data science requires the ability to work with large data sets, knowledge of data visualization, data wrangling, and database management. Skills in machine learning and deep learning can also be useful.
What can I use data science for?
In a professional capacity, almost every industry can use data science to some degree. Healthcare organizations use data science to detect and cure diseases, while finance companies use it to detect and prevent fraud. All kinds of industries use data science for marketing, such as building recommendation systems and analyzing customer churn.
Is data science a good career?
Yes, data science is among the fastest-growing sectors in the US and worldwide. It’s also one of the best-paid careers out there. According to data from Payscale, experience data scientists earn an average of $97,609 and have a satisfaction rating of four stars out of five in the US.
Is it difficult to become a data scientist?
There are a few things to consider here. First, data science degrees can be competitive to get onto, often requiring consistently high grades. Similarly, many of the skills required for data science require a lot of study and patience. It can take several months to master all of the necessary basics, as well as a lot of practical experience to secure an entry-level position.
Does data science require coding?
Yes, you’ll need some coding experience in languages such as Python, R, SQL, Java, and C/C++. However, due to its relatively simple syntax, Python programming language is often the preferred choice among newcomers.
How long does it take to become a data scientist?
For a person with no prior coding experience and/or mathematical background, it can typically take 7 to 12 months of intensive studies to be at the level of an entry-level data scientist. However, it is important to remember that learning only the theoretical basis of data science may not make you a real data scientist.
What topics can I study within data science?
Once you’ve mastered the foundations of data science, you can then specialize in a variety of areas, including machine learning, artificial intelligence, big data analysis, business analytics and intelligence, data mining, and more.
Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.