SQL Full Course | SQL For Beginners | Mysql Full Course | SQL Training | Simplilearn
Data Scientist Masters Program (Discount Code - YTBE15) -
IITK - Professional Certificate Course in Data Science (India Only) -
Caltech Post Graduate Program in Data Science -
Brown University - Applied AI & Data Science -
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?
Dataset Link -
Subscribe to our Channel to learn more about the top Technologies:
⏩ Check out the SQL training videos:
️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
Key Features
- Post Graduate Program certificate and Alumni Association membership
- Exclusive hackathons and Ask me Anything sessions by IBM
- 8X higher live interaction in live online classes by industry experts
- Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc.
- Master Classes delivered by Purdue faculty and IBM experts
- Simplilearn's JobAssist helps you get noticed by top hiring companies
- Resume preparation and LinkedIn profile building
- 1:1 mock interview
- Career accelerator webinars
Skills Covered
- Data Analytics
- Statistical Analysis using Excel
- Data Analysis Python and R
- Data Visualization Tableau and Power BI
- Linear and logistic regression modules
- Clustering using kmeans
- Supervised Learning
Learn More at:
Caltech Data Analytics Bootcamp(US Only):
Смотрите видео SQL Full Course | SQL For Beginners | Mysql Full Course | SQL Training | Simplilearn онлайн без регистрации, длительностью 08 часов 02 минут 36 секунд в хорошем hd качестве. Это видео добавил пользователь Simplilearn 15 Июнь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2 миллионов раз и оно понравилось 33 тысяч людям.