2024 Complete SQL Bootcamp from Zero to Hero in SQL
- Description
- Curriculum
- FAQ
- Reviews
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!
-
24SELECT CommandVideo lesson
-
25WHERE ClauseVideo lesson
-
26Working with Bakery items tableQuiz
-
27LIKE ConditionVideo lesson
-
28Simple Queries : BETWEEN/ NOT BETWEENVideo lesson
-
29Simple Queries : IN/ NOT INVideo lesson
-
30Simple Queries : ORDER BY clauseVideo lesson
-
31Simple Queries : AggregationVideo lesson
-
32Simple Queries : GROUP BY clauseVideo lesson
-
33Simple Queries : HAVING clauseVideo lesson
-
34Hands-on working with Customer tableVideo lesson
-
35Quiz on Data Querying LanguageQuiz
-
36Practice Task-1 on Data QueryingText lesson
-
37Practice Task-2 on Data QueryingText lesson
-
38Practice Task-3 on Data QueryingText lesson
-
52Cross JoinVideo lesson
-
53Inner JoinVideo lesson
-
54Left Outer JoinVideo lesson
-
55Left Join Excluding Inner JoinVideo lesson
-
56Right Outer JoinVideo lesson
-
57Right Join Excluding Inner JoinVideo lesson
-
58Full Outer JoinVideo lesson
-
59Full Outer Excluding Inner JoinVideo lesson
-
60Solved Example Query #1Video lesson
-
61Solved Example Query #2Video lesson
-
62Quiz on Join OperationsQuiz
-
63Practice task-1 on Joins in SQLText lesson
-
64Practice task-2 on Joins in SQLText lesson
-
65Find sailor name whose rating is morethan 8Video lesson
-
66Find sailor name and age whose age is in the range of 35 to 45Video lesson
-
67Find young sailor with rating as 10Video lesson
-
68Find the sids of sailors who have reserved a red boat.Video lesson
-
69Find the names of sailors who have reserved a red boat.Video lesson
-
70Find the colors of boats reserved by Lubber.Video lesson
-
71Find the names of sailors who have reserved at least one boat.Video lesson
-
72Find sid’s of all sailors who have a rating of 10 or reserved boat 104Video lesson
-
73Practice Task-1 on Sailors DatabaseText lesson
External Links May Contain Affiliate Links read more