Master the art of data management with our SQL training program! Learn the fundamentals of SQL, including database design and data manipulation, and take your skills to the next level with advanced topics like subqueries and window functions. Put your knowledge to the test with real-world case studies and competitive coding challenges, and gain the expertise you need to excel in today's data-driven world.
Module 1: Introduction to SQL (1 hour)
Introduction to SQL and its uses Differences between SQL and other programming languages Basic SQL syntax and structure
Module 2: Installing and Setting Up a DBMS (1 hour)
Downloading and installing a DBMS (e.g. SSMS) Configuring a local server
Module 3: Data Manipulation (2 hours)
Adding new data with INSERT statement Updating and deleting data with UPDATE and DELETE statements Using transactions to manage data changes
Module 4: Retrieving Data from Tables (2 hours)
SELECT statement and basic query structure Filtering data with WHERE clause and LIKE operator Sorting data with ORDER BY clause Using wildcards to search for patterns.
Module 5: Aggregation and Grouping (2 hours)
Using aggregate functions like COUNT, SUM, AVG, MAX, MIN Grouping data with GROUP BY clause Filtering grouped data with HAVING clause Combining data with UNION operator
Module 6: Joins and Subqueries (2 hours)
Combining data from multiple tables with INNER JOIN, LEFT JOIN, and RIGHT JOIN Using subqueries to filter data Understanding correlated subqueries.
View this Course
Certified
You have 
