?Data Analyst Masters Program (Discount Code - YTBE15) - https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=Vdieo&utm_medium=DescriptionFirstFold&utm_source=Youtube
?IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=Video&utm_medium=DescriptionFirstFold&utm_source=Youtube
?Purdue - Post Graduate Program in Data Analytics - https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Video&utm_medium=DescriptionFirstFold&utm_source=Youtube
?Caltech - Data Analytics Bootcamp (US Only) - https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=Video&utm_medium=DescriptionFirstFold&utm_source=Youtube
?IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitg-generative-ai-data-analytics-program?utm_campaign=Video&utm_medium=DescriptionFirstFold&utm_source=Youtube
In this SQL Data Analysis Video by Simplilearn, we will be disussing a brief introduction to SQL. After that, we will get started with the mySQL workbench and execute the basic queries in SQL that covers SELECT, FROM, ALTER, RENAME, and other foundational level queries in excel, proceeding ahead, we will learn how to create a SCHEMA in MySQL Workbench and learn how to import data from various data sources, proceeding ahead, we will learn how to implement WHERE clause, Group BY clause, ORDER BY clause in SQL. After understand these, we will learn some advanced conditional operations based onthese clauses and also implement CASE queries in SQL. Finally we will learn some advanced topics SQL that will cover JOINS and different types of JOINS in SQL.
Below are the topics covered in SQL Data Analysis:
00:00:00 Introduction to SQL Data Analysis
00:03:35 Discussing Data Tables
00:05:00 MySQL Workbench
00:05:20 Creating Schema in MySQL Workbench
00:05:45 How to Import data to MySQL WorkBench
00:08:00 USE Command in SQL
00:08:45 SELECT Command in SQL
00:10:00 ALTER Command in SQL
00:15:00 WHERE Command in SQL
00:19:00 AND Command in SQL
00:21:30 GROUP BY and ORDER BY in SQL
00:30:45 CASE Statement in SQL or SWITCH Statement in SQL
00:32:40 LIKE Statement in SQL
00:38:00 JOINS in SQL
What is SQL?
SQL stands for Structured Query Langugae. SQL is a programming language to interact with relational data bases to store, manipulate, and retreive data in a tabular format. using a variety of data manipulation commands. There 5 different types of SQL .
DML - Data Manipulation Language
DDL - Data Defination Language
DQL - Data Query Language
DCL - Data Control Language
TCL - Transaction Control Language
✅ Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH
⏩ Check out the Data Analytics training videos: https://youtube.com/playlist?list=PLEiEAq2VkUUKnB4Yzmn-B6O_hhcP-DanA
#dataAnalytics #SQl #DataAnalysis #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/post-graduate-program-data-science?utm_campaign=L6Yo8-JiXRg&utm_medium=Description&utm_source=youtube