Learn MySQL for Data Analysis

person icon Satyajit Pattnaik

4.5 ★★★★ ★

Buy Now

Learn MySQL for Data Analysis

Name: Learn MySQL for Data Analysis
Rating: 4.5 (138 reviews)
Author: Satyajit Pattnaik

Master SQL within few hours

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Satyajit Pattnaik

English [CC]

category icon Development,MySQL,Oracle

Lectures -21

Resources -1

Duration -5 hours

4.5 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

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

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

Course Certificate

Use your certificate to make a career change or to advance in your current career.