Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.
Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.
Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.
Learn how to create one of the most efficient ways of storing data - relational databases!
Learn how to analyze a SQL table and report insights to management.
Learn to design databases in SQL.
In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.
Learn to write SQL queries to calculate key metrics that businesses use to measure performance.
Explore ways to work with date and time data in SQL Server for time series analysis
Find tables, store and manage new tables and views, and write maintainable SQL code to answer business questions.
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!
Learn how to build your very own dashboard by applying all the SQL concepts and functions you have learned in previous courses.
Master SQL Server programming by learning to create, update, and execute functions and stored procedures.
Learn the most important functions for manipulating, processing, and transforming data in SQL Server.
Harness the power of relational databases by learning how they are structured and writing simple SQL commands to start analyzing data.
In this course, students will learn to write queries that are both efficient and easy to read and understand.
This course teaches you the skills and knowledge necessary to create and manage your own PostgreSQL databases.
Learn how to import and manipulate data with Oracle SQL.
Learn how to structure your PostgreSQL queries to run in a fraction of the time.
Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.
Learn how to design and implement triggers in SQL Server using real-world examples.
Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights.
Learn how to write recursive queries and query hierarchical data structures.
Develop the skills you need to clean raw data and transform it into accurate insights.
Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.
Write SQL queries to answer interesting questions about international debt using data from The World Bank.
If you've never done a DataCamp project, this is the place to start!
Analyze product data for an online sports retail company to optimize revenue.
Use categorization and ranking techniques to explore 101 years of American baby name tastes.
Use summary statistics and filters to analyze test scores across New York City's public schools!
Use joins and set theory to discover the best years for video games!
Use joining techniques to discover the oldest businesses in the world.