SQL From A to Z from absolute scratch - Learn SQL with MySQL
- Description
- Curriculum
- FAQ
- Reviews
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.
Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.
Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases – to name just a few.
So, to be a successful developer or data scientist you need to know SQL inside-out.
But – SQL can seem complicated. Especially if you’re a beginner or more familiar with other programming languages. Don’t worry – there’s some good news…
SQL isn’t complicated – or at least it doesn’t need to be, so long as you learn it the right way.
Problem is – too many other courses out there jump around, skipping important concepts or simply teaching things badly.
That’s why this course goes further than most. You’ll get in-depth knowledge and skills that are built-up sequentially to make sure you don’t have any gaps.
-
6Retrieve Data using Select StatementVideo lesson
-
7Closer look at Select ClauseVideo lesson
-
8Closer look at Where ClauseVideo lesson
-
9Logical Operators in SQLVideo lesson
-
10How to use IN OperatorVideo lesson
-
11How to use the Between OperatorVideo lesson
-
12Matches pattern using Like OperatorVideo lesson
-
13How to use REGEXP Operator in SQLVideo lesson
-
14Is Null operator in SQLVideo lesson
-
15Order By ClauseVideo lesson
-
16The Limit ClauseVideo lesson
-
17Select Data from Multiple TablesVideo lesson
-
18Select Data from Multiple DatabasesVideo lesson
-
19Joining table with itselfVideo lesson
-
20Joining table with many TablesVideo lesson
-
21Compound Join ConditionsVideo lesson
-
22Implicit Join SyntaxVideo lesson
-
23Why we use Outer JoinsVideo lesson
-
24Outer Join Between Multiple TablesVideo lesson
-
25How to use Self Outer JoinsVideo lesson
-
26The USING ClauseVideo lesson
-
27Natural JoinsVideo lesson
-
28Cross JoinsVideo lesson
-
29UnionsVideo lesson
External Links May Contain Affiliate Links read more