SQL From A to Z from absolute scratch - Learn SQL with MySQL

Name: SQL From A to Z from absolute scratch - Learn SQL with MySQL
Rating: 4.6 (26 reviews)

Master the SQL statements that every software developer or data analyst needs for designing and developing databases

Created byIslam Abdou Elgaedy

Last updated 5/2022

English

What you'll learn

Dozens of targeted exercises with full explanations and solutions from beginner level right up to advanced.
Every SQL statement you need is covered thoroughly
Straight to the point, no time wasted
Every module contains information and activities that are relevant to real-life jobs or the kind of tasks you may get on interview

Course content

4 sections • 38 lectures • 3h 8m total length

SQL Histroy3:20
Setting Up My SQL On MAC5:41
Setting Up My SQL On Windows5:45
This Course's Databases8:35
How this Course is Organized?2:29

Retrieve Data using Select Statement5:52
Closer look at Select Clause8:45
Closer look at Where Clause5:08
Explore the where clause and comparison operators in SQL, filtering customers by points greater than 3000 and state equals Virginia, using quotes for strings and underscores for column names.
Logical Operators in SQL6:40
How to use IN Operator2:52
How to use the Between Operator1:53
Matches pattern using Like Operator5:01
Use the like operator in SQL to match patterns with percent and underscore wildcards, with examples filtering last names starting with b or containing b, and using not to exclude.
How to use REGEXP Operator in SQL9:20
Is Null operator in SQL2:29
Order By Clause7:15
The Limit Clause3:29
Learn to use the limit clause to cap results and paginate data with an optional offset, including ordering by points and retrieving the top three customers.

Select Data from Multiple Tables8:29
Select Data from Multiple Databases2:49
Joining table with itself4:16
Joining table with many Tables6:49
Compound Join Conditions3:43
Implicit Join Syntax2:23
Why we use Outer Joins6:29
Outer Join Between Multiple Tables6:21
How to use Self Outer Joins2:15
The USING Clause5:25
Natural Joins1:23
Cross Joins3:17
Unions8:31
Master unions in SQL by combining rows from queries with identical column counts. Rename columns and create unified results, including bronze, silver, gold customer types and active vs archived labels.

Column Attributes3:27
Adding Rows to a table5:49
Adding Many Rows to a table3:21
Insert multiple rows in a single statement using insert into shippers (name) values (...), (...), (...); rely on auto generated shipper ids and verify results in the shippers table.
Adding Hierarchical Rows5:55
Creating a Copy of a Table8:50
Updating a Single Row3:57
Updating Multiple Rows3:17
Learn to update multiple rows with a single update statement using a general where clause, and disable safe updates in MySQL Workbench while applying expressions.
Using Subqueries in Updates5:39
Deleting Rows1:27

Requirements

No Prior Knowledge Needed
For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.

Description

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.

Who this course is for:

Become an SQL all-rounder who’s a valuable asset to any company that hires developers or database specialists.
SQL really is everywhere. When you log in to pretty much any web app, your data is retrieved from a database using SQL queries. We live in a big data society and SQL is powering it. This means there’s a huge demand for SQL developers and data scientists with SQL skills.
Oh, and when you have a huge demand for a specialist skill this means one thing - big salaries!
The latest research shows that the average salary for an SQL developer is more than $84,000 per year. Not bad, especially when you consider that in a recent analysis of 25k developer job listings, over 35% specifically request SQL skills.
In fact, SQL is now the second most popular programming language, second only to JavaScript. All in all, it’s pretty clear that now is definitely the right time to get your SQL game on!

SQL From A to Z from absolute scratch - Learn SQL with MySQL

What you'll learn

Explore related topics

Course content

Introduction to SQL5 lectures • 26min

SELECT Data From a Single Table11 lectures • 59min

SELECT Data From Many Tables13 lectures • 1hr 2min

Data Manipulation in SQL9 lectures • 42min

Requirements

Description

Who this course is for: