Learn MySQL for Data Analysis
Master SQL within few hours
Updated on Sep, 2023
Language - English
Lectures -21
Resources -1
Duration -5 hours
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
What will you learn in this course:
- 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
What are the prerequisites for this course?
- 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
Head of Data Science, XccelerateA Data Scientist with a passion for turning data into actionable insights, and meaningful stories. Right from the data extraction till the final data product or actionable insights, I enjoy the journey with the data.
10+ years experience working in Data Analytics and Data Sciences across different industry verticals including telecom, cyber security, insurance, e-commerce etc.
Conducted various training sessions on Data Science, Analytics, ML & AI, as well as attended various International conferences as keynote speaker & guest on Data Science, ML & AI in various universities across APAC Region.
Over 7+ years of training & teaching experience into Data Science & Analytics
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
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 now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now