Overview
Context
SQL is widely recognized as the most popular language for turning raw data stored in a database into actionable insights. This Intermediate SQL course offered by Data Camp uses a films database to teach how to navigate and extract insights from the data using SQL.
Discover Filtering with SQL
You'll discover techniques for filtering and comparing data, enabling you to extract specific information to gain insights and answer questions about the data.
Get Acquainted with Aggregation
Next, you'll get a taste of aggregate functions, essential for summarizing data effectively and gaining valuable insights from large datasets. You'll also combine this with sorting and grouping data, adding another layer of meaning to your insights and analysis.
Write Clean Queries
Finally, you'll be shown some tips and best practices for presenting your data and queries neatly. Throughout the course, you'll have hands-on practice queries to solidify your understanding of the concepts. By the end of the course, you'll have everything you need to know to analyze data using your own SQL code today!
Programme Structure
Chapters include:
- Selecting Data
- Filtering Records
- Aggregate Functions
- Sorting and Grouping
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Data Science & Big Data View 468 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Prerequisites: Introduction to SQL
- This Intermediate SQL course covers all the basics of SQL, plus more advanced topics. It is perfect for those who have a basic understanding of SQL, and would like to take their skills to the next level.
- This course is especially beneficial for data analysts, business intelligence professionals, and database administrators as it teaches intermediate level SQL and analytical skills.
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions