Published On Jan 23, 2023
✅ Free Python Coding Certificate Here 🔗 https://bit.ly/3rtHk2t
✅ Download Course Material here 🔗 https://bit.ly/40nYX0O
Learn the basics of SQL in just 3 hours with this comprehensive tutorial! This video series covers everything you need to know to start working with SQL, including data types, data structures, and basic commands. Whether you're a beginner or have some experience with SQL, you'll find something new in this tutorial. By the end of this tutorial, you'll be able to write basic SQL queries and extract valuable insights from your data. So grab a notebook and start learning today!
---------------------------------------------
Become a full-stack Data Scientist 🔥
---------------------------------------------
Enroll in our Certified AI & ML BlackBelt Plus Program 🔗 https://bit.ly/40Aa71g
- with 50+ Industry Projects
- 1:1 Mentorship Sessions
- Personalised Learning Path
- Dedicated Interview Preparation & Placement Support
---------------------------------------------
Learning Roadmaps 🔥
---------------------------------------------
Roadmap to become a Data Scientist: • Become a Data Scientist in 2023 | Ste...
Roadmap to become a Data Analyst: • Become a Data Analyst in 2023 | Roadm...
Roadmap to become a Data Engineer: • Become a Data Engineer in 2023 | Step...
---------------------------------------------
Free Certification Courses 🔥
---------------------------------------------
1️⃣ Python Full Course 🔗 • Python Full Course - in 3 hours | Pro...
2️⃣ SQL Full Course 🔗 • SQL Full Course - in 3 hours | SQL Tu...
3️⃣ Excel Full Course 🔗 • Excel Full Course - in 2 hours | Micr...
------------------
Sections 🔥
------------------
0:00:00 Why do we need Databases?
0:01:28 What is a Database?
0:02:06 Properties of a good Database
0:04:23 Types of Databases
0:05:44 Relational Databases
0:06:47 ACID Properties of RDB
0:11:15 Companies using MySQL
0:12:03 Client Server Architecture
0:13:22 MySQL Distribution
0:14:49 Installation - Mac
0:19:06 Installation - Linux
0:21:28 Installation - Windows
0:25:16 Getting started with SQL
0:28:16 Connecting to MySQL
0:36:13 Create a Table
0:38:55 Datatypes
0:41:14 Describe Command
0:43:49 Inserting Records in a Table
0:48:42 NULL & Not NULL
0:54:12 Update Records
0:57:38 Delete Command
0:59:01 Alter Command
1:03:22 Dropping a Table & Structure
1:05:14 Importing data from CSV
1:11:34 Counting Records
1:12:55 Function: SUM, AVG, MIN, MAX
1:19:25 Limit, Sort & Pattern Matching
1:33:09 Group By & Filtering
1:43:27 Export data to a CSV
1:47:15 Backing Up Databases
1:50:05 Restoring Databases
1:54:10 FIFA 2019: Descriptive Analytics
2:32:33 FIFA 2019: Advanced Data Analysis
Stay on top of your industry by interacting with us on our social channels:
Follow us on Instagram: / analytics_vidhya
Like us on Facebook: / analyticsvidhya
Follow us on Twitter: / analyticsvidhya
Follow us on LinkedIn: / analytics-vidhya