Learn MySQL for Data Analysis
Master SQL within few hours
Lectures -21
Resources -1
Duration -5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again.
Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, window functions, transposing & ranking data and using conditional expressions in very interesting ways.
Goals
- Use SQL to query a database
- Use SQL to perform data analysis
- Be comfortable putting SQL on their resume
- Learn to perform GROUP BY statements
Prerequisites
- No prior knowledge on SQL is required, all you need is dedication to learn
![Learn MySQL for Data Analysis Learn MySQL for Data Analysis](https://d3mxt5v3yxgcsr.cloudfront.net/courses/8228/course_8228_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
2 Lectures
-
SQL Intro 01:59 01:59
-
Course Resources
Installation
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Basics of Data Architecture
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Introduction to SQL
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Table Basics
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Joins in SQL
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Import & Export
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Functions in SQL
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Nested Queries
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Views
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Stored Procedures
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Windows Function
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
SQL-Python Connectivity
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
BONUS!!
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Satyajit Pattnaik](https://www.tutorialspoint.com/assets/profiles/457068/profile/200_1408583-1652859826.jpg)
Satyajit Pattnaik
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)