Summary
Keywords
Full Transcript
✅ 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: https://www.youtube.com/watch?v=KC9Z60Bu1Q4 Roadmap to become a Data Analyst: https://www.youtube.com/watch?v=1YNOf3XTjbY Roadmap to become a Data Engineer: https://www.youtube.com/watch?v=SiuS5O724aE --------------------------------------------- Free Certification Courses 🔥 --------------------------------------------- 1️⃣ Python Full Course 🔗 https://youtu.be/6sLkF-F9Oh0 2️⃣ SQL Full Course 🔗 https://youtu.be/_H4h-tWvuxs 3️⃣ Excel Full Course 🔗 https://youtu.be/MMQJ-ySgGn0 ------------------ 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: https://www.instagram.com/analytics_vidhya/ Like us on Facebook: https://www.facebook.com/AnalyticsVidhya/ Follow us on Twitter: https://twitter.com/AnalyticsVidhya Follow us on LinkedIn:https://www.linkedin.com/company/analytics-vidhya
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
