Intermediate SQL
- Offered byDataCamp
Intermediate SQL at DataCamp Overview
Duration | 4 hours |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Intermediate SQL at DataCamp Highlights
- Earn a certificate after completion of the course
- Learn from the industry best faculty
Intermediate SQL at DataCamp Course details
Data Analysts and Scientists
Database Administrators
Business Analysts
Software Developers
Writing and optimizing complex SELECT statements
Using subqueries and correlated subqueries
Implementing common table expressions (CTEs)
Understanding and using window functions for advanced data analysis
Applying ROW_NUMBER(), RANK(), DENSE_RANK(), and other window functions
Using PARTITION BY and ORDER BY within window functions
Advanced SQL Queries
Window Functions
Advanced Joins and Set Operations
Data Aggregation and Transformation
Query Performance Optimization
Intermediate SQL at DataCamp Curriculum
Selecting Data
Learning to COUNT()
Practice with COUNT()
SELECT DISTINCT
Query execution
Order of execution
Filtering Records
Filtering results
Using WHERE with numbers
Using WHERE with text
Multiple criteria
Using AND
Using OR
Using BETWEEN
Filtering text
Aggregate Functions
Aggregate functions and data types
Practice with aggregate functions
Summarizing subsets
Combining aggregate functions with WHERE
Using ROUND()
ROUND() with a negative parameter
Sorting and Grouping
Sorting text
Sorting single fields
Sorting multiple fields
Grouping data
GROUP BY single fields
GROUP BY multiple fields
Answering business questions
Filtering grouped data
Intermediate SQL at DataCamp Faculty details
Other courses offered by DataCamp
Student Forum
Anything you would want to ask experts?
Intermediate SQL