2024 Complete SQL Bootcamp from Zero to Hero in SQL
Learn how to use SQL quickly and effectively with this course!
You’ll learn how to read and write complex queries in SQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.
Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you’ll learn quickly and receive challenges and tests along the way to improve your understanding!
In this course you will learn everything you need to become a SQL Pro! Including:
-
Get started with DBeaver , one of the world’s most popular SQL tool
-
Learn he basics of SQL syntax
-
Analyzing data using aggregate functions with GROUP BY commands
-
Running advanced queries with string operations and comparison operations
-
Learn to use logical operators to add logic flow to your SQL queries
-
Learn to create tables and databases with constraints on data entries
-
Learn common SQL JOIN commands
-
Learn how to convert ER Diagram into a SQL Table.
Who this course is for:
-
Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills.
-
Anyone looking to answer complex business problems and generate reports using data.
-
Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
-
Developers who are looking to build applications (e.g. social network, ecommerce site) using SQL.
SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!
I’ll see you inside the course!
Check out the free preview videos for more information!
DDL Commands
DML Commands
Constraints in SQL
Data Querying
Set Operations & Views in SQL
-
21
SELECT Command -
22
WHERE Clause
-
23
Working with Bakery items table -
24
LIKE Condition
-
25
Simple Queries : BETWEEN/ NOT BETWEEN
-
26
Simple Queries : IN/ NOT IN
-
27
Simple Queries : ORDER BY clause
-
28
Simple Queries : Aggregation
-
29
Simple Queries : GROUP BY clause
-
30
Simple Queries : HAVING clause
-
31
Hands-on working with Customer table
-
32
Quiz on Data Querying Language
-
33
Practice Task-1 on Data Querying -
34
Practice Task-2 on Data Querying
-
35
Practice Task-3 on Data Querying
Working with Sub-Queries
Joins in SQL
Working with sailors database
-
48
Cross Join
-
49
Inner Join
-
50
Left Outer Join
-
51
Left Join Excluding Inner Join
-
52
Right Outer Join
-
53
Right Join Excluding Inner Join
-
54
Full Outer Join
-
55
Full Outer Excluding Inner Join
-
56
Solved Example Query #1
-
57
Solved Example Query #2
-
58
Quiz on Join Operations
-
59
Practice task-1 on Joins in SQL
-
60
Practice task-2 on Joins in SQL
Solved Examples in SQL Queries
-
61
Find sailor name whose rating is morethan 8
-
62
Find sailor name and age whose age is in the range of 35 to 45
-
63
Find young sailor with rating as 10
-
64
Find the sids of sailors who have reserved a red boat.
-
65
Find the names of sailors who have reserved a red boat.
-
66
Find the colors of boats reserved by Lubber.
-
67
Find the names of sailors who have reserved at least one boat.
-
68
Find sid’s of all sailors who have a rating of 10 or reserved boat 104
-
69
Practice Task-1 on Sailors Database
Generating SQL Table structure from E-R Diagrams
Assignments
Final Test in SQL
-
80
Working with Real-Estate Database
-
81
Assignment #1 : Teacher Database
-
82
Assignment #2 : Hospital Database
-
83
Assignment #3 : Garments and Fabric Database
-
84
Assignment #4 : Airline Flight Information Database
-
85
Assignment #5 : Employee Works in Department
-
86
Assignment #6 : Works On Database
-
87
Final Assignment
