Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching SQL Tutorial for Beginners [Full Course]. and this video is uploaded by Programming with Mosh at 2019-03-19T17:50:32-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [7S_tz1z_5bA]
| Name | SQL Tutorial for Beginners [Full Course] |
| Video Uploader | Video From Programming with Mosh |
| Upload Date | This Video Uploaded At 20-03-2019 00:50:32 |
| Video Discription | Learn SQL with MySQL from scratch! 📚 This beginner-friendly tutorial covers SQL essentials for working with databases. 🚀 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 [7S_tz1z_5bA] |
| Category | Education |
| Tags | mysql tutorial | mysql | learn mysql | mysql course | learn sql | sql basics | sql for beginners | sql | sql tutorial | sql course | sql crash course | structured query language | sql beginners | mysql crash course | mysql tutorial for beginners | programming with mosh | mosh hamedani | web development | databases | code with mosh |
