DataCamp

Data Manipulation in SQL

Engineering and Technology

Short Description

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.

Long Description

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.

Related Courses

Course Details

Duration
4 hours
Difficulty
Intermediate
Format
Short Course
Price
USD39.00
Course Link
More Information
DataCamp
Description
DataCamp is an online learning platform that offers interactive courses and tutorials for data science and analytics. It provides a wide range of courses covering topics such as Python, R, SQL, machine learning, data visualization, and more. The platform offers a hands-on learning experience through coding exercises and projects, allowing users to practice and apply their skills in real-world scenarios. DataCamp also offers a personalized learning experience with adaptive learning technology that adjusts the course content based on the user's skill level and progress. It is widely used by individuals, professionals, and organizations to enhance their data science skills and stay up-to-date with the latest trends and technologies in the field.