SQL Tutorial for Beginners (Full Course)
Learn SQL with MySQL from scratch! 📚 This beginner-friendly tutorial covers SQL essentials for working with databases.
📖 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
Master yourself in SQL, do practical projects with MySQL, PHP and Python
By completion this course, you will be able to read and write basic and complex SQL queries using MySQL.This course gives you hands on and practical experience on world most popular RDBMS databases like MySQL. This skills are also applicable to any other RDMBS databases (Like Oracle, MS SQL Server, SQLite, etc). You will do several practical projects with MySQL, PHP & Python. Learning both SQL is one the fastest ways to improve your career. Hope this course will be used as a helping hand for your prospective career. Please dig on free preview videos for more information.