Master SQL: A Comprehensive Guide from Beginner to Advanced

Name: Master SQL: A Comprehensive Guide from Beginner to Advanced
Rating: 4.9 (7 reviews)

From Basics to Advanced, Learn with hands-on, SQL for Data-Driven Decision Making,SQL tutorial, MySQL

Created byAtul Kadlag

Last updated 9/2024

English

What you'll learn

Practical SQL skills: Apply SQL concepts to real-world scenarios and solve complex data problems.
Data analysis techniques: Extract meaningful information from large datasets using SQL
Database management: Efficiently create, manipulate, and query databases.
Problem-solving abilities: Develop logical thinking and problem-solving skills through hands-on exercises.
Industry-relevant knowledge: Gain insights into SQL best practices and common use cases.

Course content

3 sections • 47 lectures • 2h 52m total length

Introduction0:20
Install MySQL workbench and create a database to begin practicing SQL basics, including select, where, from clauses, and later group by and order by.
Installing MySQL Workbench5:35
Exploring MySQL Workbench & Creating a Database in MySQL6:53
Resources to use0:09
SELECT Statement : Display data from a SQL table4:48
Master the select statement to retrieve data from a table using star or specific columns, and learn to execute queries across single or multiple databases with optional limits.
SELECT Statement : Performing mathematical operations in SQL3:32
Learn to perform arithmetic on a numeric column, creating an aliased result like h plus ten. Apply the bodmas order—parentheses, exponent, multiplication, division, then addition and subtraction.
SELECT Statement : Retrieving Unique records from SQL table3:53
Discover how the distinct keyword in a select statement returns unique records from a SQL table, exploring columns like gender and composite cases such as first name and last name.
WHERE Clause : Filtering the data from a SQL table3:30
Explore using the where clause to filter SQL results, applying conditions like first name equals Ravi and salary thresholds, and combining multiple conditions for large datasets.
WHERE Clause : Filtering the data from SQL table with multiple conditions3:41
WHERE Clause : Filtering the data from SQL table with wildcards : LIKE Operator4:30
Learn how the like operator filters records in the where clause using patterns such as starting with r, containing a, ending with t, and underscore-based matches.
Group By Clause : Grouping data in SQL table4:02
Group By Clause : Grouping data in SQL table with Aggregate Functions3:59
Order By Clause : Sorting data in SQL table2:40
Having Vs Where Clause4:20
Limit and Alias in SQL5:05
SQL Quiz

Introduction0:24
Advance your SQL skills by exploring intermediate concepts such as joins, unions, string functions, case statements, subqueries, and window functions through practical exercises.
Introduction to Joins in SQL2:34
Explore how to retrieve data from multiple tables in a single query using joins, including inner, outer, left, and right joins, with primary and foreign keys.
Join Type : Inner join in SQL6:38
Join Type : Outer Join in SQL : Left Outer Join & Right Outer Join1:46
Join Type : Self Join2:02
Joining Data from Multiple Tables3:05
Unions in SQL : Union ALL, Union DISTINCT4:31
Unions in SQL : Applying multiple queries with Where Conditions3:30
Use unions in sql to combine multiple queries with the same column list and where conditions, then label results as old man, old lady, or highly paid to categorize data.
String Functions in SQL : LENGTH, UPPER, TRIM(RTRIM/LTRIM)4:34
String Functions in SQL : Susbtring function3:12
Learn to use the substring function to extract specific characters from text, such as first names or birthdate months, by specifying start positions and lengths in real-time SQL projects.
String Functions in SQL : Locate & Concat Function2:32
Case Statement : Categorizing data on different conditions4:07
Case Statement : Performing Mathematical Operations with Case Statements6:29
Subqueries in SQL : Subquery in WHERE clause4:38
Explore subqueries in SQL, using an inner query in the where clause to filter employee demographics by department id from the salary table, and apply it with the in operator.
Subqueries in SQL : Subquery in SELECT clause2:14
Learn how to place a subquery in the select clause to compute the overall average salary from the employee salary table, returning first name, salary, and the calculated average.
Subqueries in SQL : Subquery in FROM Clause6:10
Window Functions in SQL : OVER() function5:06
Window Function in SQL : Calculate Rolling total2:51
Window Functions in SQL : ROW_NUMBER(), RANK(), DENSE_RANK()5:11
Explore window functions in SQL, including row_number, rank, and dense_rank, with practical examples using partition by gender and salary order to generate top salaries and understand ranking behavior.
SQL Quiz

Introduction0:35
Explore advanced SQL concepts such as stored procedures, temporary tables, and common table expressions, then learn triggers and events to sharpen your data-driven decisions in real-time projects.
Common Table Expressions (CTEs) in SQL : Why and How to create a CTE4:33
Common Table Expressions (CTEs) in SQL : Creating Muliple CTEs4:19
Temporary Table in SQL : Introduction0:52
Temporary Table in SQL : Creating a temporary table in mySQL Workbench6:19
Stored Procedure in SQL : Introduction0:58
Master SQL introduces stored procedures as reusable, time-saving components that let you encapsulate complex queries and perform multiple operations, and shows how to create them.
Stored Procedure in SQL : Creating & Calling First Simple Stored Procedure2:49
Stored Procedures in SQL : Creating Stored Procedure from multiple queries5:39
Stored Procedures in SQL : Creating Stored Procedure with Parameters4:48
Triggers in SQL : Introduction1:15
Triggers in SQL : Creating and testing Triggers6:58
Events in SQL : Creating and testing Events4:46
Create and test SQL events that run on schedule to automatically delete employee demographics records older than 60, using on schedule every intervals and learn dropping events and triggers.
SQL Quiz
Congratulations0:26
Congratulations on completing this course. Share feedback to help improve future courses, noting what you liked or disliked, and keep learning for your professional journey.

Requirements

Basic Computer Skills : How to use a computer, navigate files and folders, and open applications.
Understanding of basic data types (numbers, text, dates) and how data is organized in tables.

Description

Master SQL: A Comprehensive Guide from Beginner to Advanced

Are you ready to unlock the power of SQL and transform data into valuable insights? This comprehensive course is designed to guide you from SQL basics to advanced concepts, equipping you with the skills needed to excel in data analysis and management.

Key Topics Covered:

Fundamentals of SQL:
- Basic SELECT statements
- Mathematical Operations
- Filtering Data with WHERE
- Grouping and Sorting data
- Using HAVING and LIMIT clauses
- Aliases
Intermediate SQL:
- Joins (INNER,LEFT, RIGHT, FULL OUTER,SELF Join)
- Unions and subqueries
- String functions
- Case statements
- Window functions
Advanced SQL
- Common Table Expressions (CTEs)
- Temporary tables
- Stored procedures
- Triggers and events

What You'll Learn:

Practical SQL skills: Apply SQL concepts to real-world scenarios and solve complex data problems.
Data analysis techniques: Extract meaningful information from large datasets using SQL.
Database management: Efficiently create, manipulate, and query databases.
Problem-solving abilities: Develop logical thinking and problem-solving skills through hands-on exercises.

Who This Course Is For:

Beginners: Individuals new to SQL looking for a solid foundation.
Data analysts: Professionals seeking to enhance their SQL expertise.
Database administrators: Those responsible for managing and maintaining
Developers: Programmers who need to interact with databases in their work.

Enroll Today and Start Your Journey to SQL Mastery!

Who this course is for:

Beginners: Individuals new to SQL looking for a solid foundation.
Data analysts: Professionals seeking to enhance their SQL expertise.
Database administrators: Those responsible for managing and maintaining databases.
Developers: Programmers who need to interact with databases in their work.

Master SQL: A Comprehensive Guide from Beginner to Advanced

What you'll learn

Explore related topics

Course content

Basic SQL15 lectures • 57min

Intermediate SQL19 lectures • 1hr 12min

Advanced SQL13 lectures • 44min

Requirements

Description

Who this course is for: