SQL Course for Beginners [Full Course]
Автор: Programming with Mosh
Загружено: 20 мар. 2019 г.
Просмотров: 12 889 787 просмотров
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:
/ @programmingwithmosh
🚀 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: / moshhamedani
Facebook: / programmingwithmosh
Instagram: / codewithmosh.official
LinkedIn: / 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
![SQL Course for Beginners [Full Course]](https://ricktube.ru/thumbnail/7S_tz1z_5bA/hq720.jpg)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: