WP Tutorials

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

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



🔥 SQL Certification Course – https://www.simplilearn.com/sql?utm_campaign=SQLCert3JulyExp&utm_medium=Descriptionff&utm_source=youtube
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=SQLFSJun15&utm_medium=DescritptionFF&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=SQLFSJun15&utm_medium=DescritptionFF&utm_source=youtube
🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=SQLFSJun15&utm_medium=DescritptionFF&utm_source=youtube
🔥Data Analyst Masters Program (Discount Code – YTBE15): https://l.linklyhq.com/l/1yhwh

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 – https://drive.google.com/drive/folders/1aLVazCdDKFyL5thzOH9j08gFPMj_kLQf

✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH

⏩ Check out the SQL training videos: https://www.youtube.com/watch?v=pFq1pgli0OQ&list=PLEiEAq2VkUUKL3yPbn8yWnatjUg0P0I-Z

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

➡️ 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: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=SQLFSJun15&utm_medium=Descritption&utm_source=youtube
🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=SQLFSJun15&utm_medium=Descritption&utm_source=youtube

🔥🔥 Interested in Attending Live Classes? Call Us: IN – 18002127688 / US – +18445327688

source

Comments (38)

  1. Can you provide the full data bases

  2. Is this video is eneough to learn sql

  3. can you please provide the csv file for the same!
    the excel sheet for the corresponding database!

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

  5. Respect❤

  6. Indexing ??

  7. Helping me a lot ….keep it up …

  8. thank you

  9. Do you provide certificate?

  10. Like this so i can come back lol

  11. 1 hr:25 min :— Instead of using —> select c.product_id, sum((s.sell_price – c.cost_price)*s.quantity) as profit…. here instead if i use —> s.product_id does it make any change. Because both are same id values. someone please answer this….

  12. what is difference b/w SQL and MYSQL

  13. u r a fool for not telling us the way to download post gre sql

  14. Thank you so much for providing such an excellent content free of cost. Can you please provide the data set for practice?

  15. Can someone tell me why I’m getting a error message
    ModuleNotFoundError:No module named ‘mysql’ when I’m typing in the jupyter notebook

  16. Is this course best for aspiring data engineers?

  17. Thank you sir for this 8 hours SQL course😊

  18. Hello sir
    How I make state bus management in sql

  19. please guide me

  20. Hello sir
    i have a query regarding inner join
    I am watching your video of SQL but I installed SQL server 2022
    You creat a table C_product which is not creating at my server an error msg displaying that this is not available in stored procedure

  21. Sir i am epidemiolost .verious disease outbreaks .i am going to analyse .so how sql will help me. For database and analyse it. Pl guide

  22. In subquery section – for update and delete subquery why do we use different tables name in the sql statement.
    Delete from employees where age in ( select age from employees_b where age> 30); here employees and employees_b two tables used

  23. 1044 access denied for user 'root'@'localhost' to database how to fix it can any one please help me for creating a new table show like this error

  24. I have an doubt regarding the key attribute like in that example name could also been a key attribute ryt?

  25. I love you. Its a very detail and awesome course. 8 hourse do not feel sonlong ❤

  26. error to create table emp_details

  27. can u provid us that pre writter data sheets in note pad if possible as it is very hectic to type each and every data

  28. video is really helpful can you please provide the data set

  29. 1:11 where can i get the data set

  30. Hi.. I am planning to visit India next month….
    Is there any place you teach?

  31. Is there a website simulator I can use for my MacBook? My laptop won't allow me to download MySql.

  32. @SimplilearnOfficial
    Please give us the data table used in this SQL not just the data codes that have been used.

  33. 55:17 when you inserted a table with students name??? please check your content bfore uploading.. this can create huge confusion

  34. Please help me get the Classic models data used in this video like 'Product', 'Productlines' etc.

  35. How to find 3 Rd Max salary from 2 tables

  36. It should be in Hindi yaar

Leave your thought here

Your email address will not be published. Required fields are marked *

Enable Notifications OK No thanks