Engineering and Technology
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Are you wondering what to do after learning how to aggregate and join data from tables in your database? How can you effectively manipulate, transform, and derive insights from your data? This intermediate-level course is designed to equip you with essential skills in wrangling, filtering, and categorizing information within a relational database. By expanding your SQL toolkit, you will be able to tackle complex queries and find answers to intricate questions. Throughout the course, you will delve into the powerful utilization of CASE statements, subqueries, and window functions. Additionally, you will have the opportunity to explore intriguing facts about soccer by working with the European Soccer Database.
by DataCamp
Master the complex SQL queries necessary to answer a wide variety of data science questions and prep...
by DataCamp
Learn the most important functions for manipulating, processing, and transforming data in SQL Server...
by DataCamp
Learn to use SQL Server to perform common data manipulation tasks and master common data manipulatio...
by DataCamp
Learn how to build your own SQL reports and dashboards, plus hone your data exploration, cleaning, a...
by DataCamp
Master SQL Server programming by learning to create, update, and execute functions and stored proced...
by DataCamp
In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analys...
by DataCamp
Learn to import data into Python from various sources, such as Excel, SQL, SAS and right from the we...
by DataCamp
Master the essential skills of data manipulation in Julia. Learn how to inspect, transform, group, a...
by DataCamp
Master time series data manipulation in R, including importing, summarizing and subsetting, with zoo...
by DataCamp
Master core concepts about data manipulation such as filtering, selecting and calculating groupwise...