Our career paths help you become job ready faster
Google AI Professional Certificate - Learn AI Skills That Get You Hired
Overview
Syllabus
Introduction.
What is SQL?.
Cheat Sheet.
Installing MySQL on Mac.
Installing MySQL on Windows.
Creating the Databases for this Course .
The SELECT Statement.
The SELECT Clause.
The WHERE Clause.
The AND, OR, and NOT Operators .
The IN Operator.
The BETWEEN Operator.
The LIKE Operator.
The REGEXP Operator.
The IS NULL Operator.
The ORDER BY Operator.
The LIMIT Operator.
Inner Joins.
Joining Across Databases.
Self Joins.
Joining Multiple Tables.
Compound Join Conditions.
Implicit Join Syntax.
Outer Joins.
Outer Join Between Multiple Tables .
Self Outer Joins.
The USING Clause.
Natural Joins.
Cross Joins.
Unions.
Column Attributes.
Inserting a Single Row .
Inserting Multiple Rows .
Inserting Hierarchical Rows .
Creating a Copy of a Table .
Updating a Single Row .
Updating Multiple Rows .
Using Subqueries in Updates .
Deleting Rows.
Restoring Course Databases.
Taught by
Programming with Mosh
Reviews
4.5 rating, based on 2 Class Central reviews
-
The course was so easy to understand MySql , for beginners i would suggest it for sure, A bit issue is lengthy dragging. Thanks for class central to suggest a usefull course
-
Probably the best crash courses I’ve ever taken. All concepts are covered, and explained in brief. Thank you so much Mosh!