SQL Full Course | SQL For Beginners | Mysql Full Course | SQL Training | Simplilearn

This SQL full course or MySQL full course video covers everything to master structure query language using MySQL, PostgreSQL as well as SQL server. You will get an idea about built-in SQL functions, joins, subqueries, stored procedures and see the top SQL interview questions that are frequently asked in the interviews.

0:00:00 SQL Full Course
0:02:57 What is SQL?
0:05:54 What are ER Diagrams
0:15:05 Types of SQL Commands
0:18:19 How to install MYSQL on Windows?
0:25:40 MYSQL built-in functions Explained
1:04:54 How Group by and Having Clauses Work?
1:07:23 Practical demonstration of Group by and having Clause in MySQL
1:35:39 What are Joins in SQL?
1:38:00 What is an Inner Join?
1:54:16 What is Left Join?
1:58:40 What is the Right Join?
2:07:03 What is a Full outer Join?
2:10:42 What is a Subquery?
2:32:25 Triggers in SQL Explained
3:13:30 What are Stored procedures in SQL?
3:37:53 How to use Views in SQL?
4:01:46 How to use SQL with python
4:14:50 Establishing a connection with SQL Database using Python
4:18:02 How to create SQL tables using python
4:26:25 Inserting and Updating data using Python
4:32:30 Querying tables using SQl commands with python
4:49:20 What is PostgreSQL?
5:06:22 How to insert records in PostgreSQL?

#SQLTutorialForBeginners #SQLFullCourse #SQLCourseForBeginners #AdvancedSQL #SQL #LearnSQLForBeginners #SQLForBeginners #SQLTutorial #SQLCourse #SQLTraining #LearnSQLIn8Hours #SQLStructuredQueryLanguage #SQLForBeginners #Simplilearn

➡️ About Data Science Course in collaboration with IBM

This Data Science course in collaboration with IBM propels your career to become a data scientist. Gain expertise in in-demand skills like Python, SQL, Excel, Machine Learning, Tableau, generative AI, and more. Dive deep into data interpretation nuances, master Machine Learning, and enhance programming skills to elevate your Data Science career.

Key Features
✅ Simplilearn's JobAssist helps you get noticed by top hiring companies
✅ Masterclasses from IBM experts
✅ Dedicated live sessions by faculty of industry experts
✅ Industry-recognized Data Scientist Master’s certificate from Simplilearn
✅ Industry-recognized IBM certifications for IBM courses
✅ Ask-Me-Anything (AMA) sessions with IBM leadership
✅ Capstone from 3 domains and 25+ projects
✅ Exclusive hackathons conducted by IBM
✅ Lifetime access to self-paced learning content
✅ Program crafted to initiate your journey as a Data Scientist
✅ Integrated labs for hands-on learning experience

Skills Covered
✅ Generative AI
✅ Prompt Engineering
✅ ChatGPT
✅ Exploratory Data Analysis
✅ Descriptive Statistics
✅ Inferential Statistics
✅ Explainable AI
✅ Conversational AI
✅ Large Language Models
✅ Model Building and Finetuning
✅ Ensemble Learning
✅ Data Visualization
✅ Database Management

🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - [phone]

[AmanThakur-ryuj]

After checking 8 course finally landed here …..thanks to simplilearn team for
1. Explaining SQL really from scratch so here I would recommend to beginners to go with this course
2. A big thanks to team for not only this course but many more courses are free
Keep doing good works ….lots of love & best wishes to the team

[OceanLover]

Thank you for making this 8 hour course for free.
I appreciate all the efforts you took in making this course..!!

[onnew]

Nothing but respect for making this 8 hours video for free 🔥🔥🔥

[senthilnavin]

BIG APPLAUSE FOR THE TEAM! GREAT EFFORT

[tonyrosales]

I love how he explained things slow easy to follow, unlike other guys talks like 65 miles an hour.

[olamartins]

I find it so easy following your video training. You offer detailed explanations and step-by-step tutorials. Thank you.

[Anonymously]

I love you Simplilearn team, you all have saved my life. I have DBMS exam tomorrow, my teacher couldn't taught me and others properly and I haven't understood. He interpreted us in English, even you've used the same language but your teaching skills is way more better. (Your new subscriber)

[lonetravelleraj]

Free 8 hours video!!!😍 you guys are awesome and love. It's a great help for middle class people like us. We are few friends watching this video together and exploring other videos.❤️❤️❤️

[AaronDsouza-hx]

So much of extremely useful and valuable information just for free ! I am glad that I came across this channel and saw the video. I am also glad to say that I cleared my interview of a data analyst, and this course helped me a lot while answering SQL based questions. Thanks a lot and kuddos to the team for uploading this video. Just one request, I really wanted the whole dataset which was used in classic models.

[vinothviberzzz]

The course is understandable and easy to learn. Thank you Simplilearn for this awesome course!

[vastrix]

i give respect to you for creating an 8 hour long video. Must have taken long work. This taught me alot!. You just gained a new subscriber

[runilkumar]

Excellent class and easy way to understand. Best video to learn from youtube. Thank you so much.

[rpratap]

1:54:02 I get this error any one knows why "Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'classicmodels.p.productName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sec"

[kyalaleslie]

Hi, I am stuck at 27:15. When I enter the command show databases, I can’t find the database with world in it. So I am unable to continue coz I ant have world to work with. Could you help me please. Thanks

[natashasamuel]

Great Presentation.

Thank You,
Natasha

[ironeagle]

1:29:00
Can you also have
SELECT salary, dept,
FROM TABLE_NAME
WHERE salary >( SELECT avg(salary), dept FROM TABLE_NAME):
Obviously, this is without group by and having. Is this also possible for selecting department that have average salary

[nimrashafiq]

1:43:38
I have run
Select * from cricket ; 2 times and the names are repeating again also numbers are incrementing, how can i reverse it ? And i want that cricket_id till 5. Do help me plz.

[rfdrafid]

Awesome video and it's very useful for beginners in SQL and Thank you for this free session...!!!!

[zulfeqarsiddique]

This is one of the best videos to learn sql from basic to advanced. Thank you so much sir, for givng us such a wonderful session.
Sir, I request you one thing, can you tell me how can i get the data records and tables which you used in this video so we practice alot.
thanks sir.💥💥💥💥💥

[Fact_Studio_AZ]

23:41

What we need to do while having this error 1045 (28000) : Access denied for user 'root'@'localhost' (using password: YES)