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
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
Basics of Data Architecture
1 Lectures
Introduction to SQL
2 Lectures
Table Basics
3 Lectures
Joins in SQL
1 Lectures
Data Import & Export
1 Lectures
Functions in SQL
4 Lectures
Nested Queries
1 Lectures
Views
1 Lectures
Stored Procedures
1 Lectures
Windows Function
1 Lectures
SQL-Python Connectivity
1 Lectures
BONUS!!
1 Lectures
Instructor Details
Satyajit Pattnaik
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now