SQL Course for Beginners [Full Course]

Posted By on March 20, 2019

Master SQL โ€“ an essential skill for AI, machine learning, data analysis, and more! ๐Ÿ“š This beginner-friendly course teaches you SQL from scratch.

โค๏ธ Join this channel to get access to perks:
https://www.youtube.com/channel/UCWv7vMbMWH4-V0ZXdmDpPBA/join

๐Ÿš€ Want a complete SQL deep dive?
– Check out my full course: https://mosh.link/sql-course
– Subscribe for more awesome content: https://goo.gl/6PYaGF

โœ‹ Want more? Follow me on:
– Twitter: https://twitter.com/moshhamedani
– Facebook: https://www.facebook.com/programmingwithmosh/
– Instagram: https://www.instagram.com/codewithmosh.official/
– LinkedIn: https://www.linkedin.com/school/codewithmosh/

๐Ÿ“• Get the FREE goodies:
– SQL cheat sheet: https://mosh.link/sql-cheatsheet
– Scripts to create databases: https://bit.ly/3rvtqdO

๐Ÿ“– TABLE OF CONTENT
0: 00: 00 Introduction
0: 01: 02 What is SQL?
0: 04: 24 Cheat Sheet
0: 04: 50 Installing MySQL on Mac
0: 09: 48 Installing MySQL on Windows
0: 15: 08 Creating the Databases for this Course
0: 23: 40 The SELECT Statement
0: 29: 30 The SELECT Clause
0: 38: 18 The WHERE Clause
0: 43: 35 The AND, OR, and NOT Operators
0: 51: 38 The IN Operator
0: 54: 41 The BETWEEN Operator
0: 56: 53 The LIKE Operator
1: 02: 31 The REGEXP Operator
1: 11: 51 The IS NULL Operator
1: 14: 18 The ORDER BY Operator
1: 21: 23 The LIMIT Operator
1: 24: 50 Inner Joins
1: 33: 16 Joining Across Databases
1: 36: 03 Self Joins
1: 40: 17 Joining Multiple Tables
1: 47: 03 Compound Join Conditions
1: 50: 44 Implicit Join Syntax
1: 53: 04 Outer Joins
1: 59: 31 Outer Join Between Multiple Tables
2: 05: 50 Self Outer Joins
2: 08: 02 The USING Clause
2: 13: 25 Natural Joins
2: 14: 46 Cross Joins
2: 18: 01 Unions
2: 26: 29 Column Attributes
2: 29: 54 Inserting a Single Row
2: 35: 40 Inserting Multiple Rows
2: 38: 58 Inserting Hierarchical Rows
2: 44: 51 Creating a Copy of a Table
2: 53: 38 Updating a Single Row
2: 57: 33 Updating Multiple Rows
3: 00: 47 Using Subqueries in Updates
3: 06: 24 Deleting Rows
3: 07: 48 Restoring Course Databases

๐Ÿ’ก Why Learn SQL?
– It’s the standard language for working with databases.
– In-demand skill for developers, data scientists, and more.
– MySQL is popular, open-source, and easy to learn.

๐Ÿ‘‰ This tutorial is perfect for you if:
– You’re completely new to SQL.
– You want a practical, hands-on approach.
– You work (or want to work) with data.

#programming #coding