SQL Full Course - in 3 hours | SQL Tutorial for Beginners | Free Certification 2023

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 🔥
---------------------------------------------
- with 50+ Industry Projects
- 1:1 Mentorship Sessions
- Personalised Learning Path
- Dedicated Interview Preparation & Placement Support

---------------------------------------------
Learning Roadmaps 🔥
---------------------------------------------

---------------------------------------------
Free Certification Courses 🔥
---------------------------------------------

------------------
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:

[Analyticsvidhya]

Book FREE 1:1 Mentorship for Gen AI / Data Science

[Euterpesong]

just a heads up for anyone taking this course there is no csv files for the last part of the tutorial. Also, if you don't have chat gpt you wont get through this course. The Files are not at the link attached to the site mentioned in the comment section either.

[iwelusamuel]

Thanks for uploading. However, I'm finding something difficult, I have the Microsoft SQL server management studio previously installed (which am used to even as a a biginner). But I am finding it difficult to use the SQL shell as used here. What should i do please?