image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Learn SQL data analysis by actually analyzing data :) 
This course is by far the
most extensive program for learning SQL by doing
.
There are no shortcuts, If you want to gain a real understanding, and become ready for SQL interviews - you must practice a lot.
And this is what this course all about: allowing you to gain a real, tangible SQL data analyses skills the only way they can be achieved - by getting your hands dirty, and

learning SQL by doing

Build The Analytical SQL Skills You Need
This SQL course will empower you with the tips and tricks necessary to analyze real data by following industry best practices. You’ll become ready for SQL job interviews after learning how to perform more than a hundred tasks and analyses, across a dozen different case studies.
Develop Reliable Data Intuition

This isn’t something that can be taught without real experience, but thanks to our beginner-friendly course, you’ll gain constant exposure to different data sets which means that you’ll automatically gain a feel and understanding of handling other datasets in the future.
Show That You’ve Got What It Takes
Our Certificate of Completion shows not only the knowledge you acquired. Our certificate proves your willingness to go that extra mile, and put in the hours of practice in order to master your SQL Skills.
Think Like a Data Analyst

Being able to analyze data is one thing, but being able to think like a real data analyst is another ballgame altogether. Our video-guided instructions and practical exercises will teach you more about how you can approach and solve problems from a data analysis mindset.
Learn SQL From the Pros Who Love Teaching

This course was developed by data professionals who have been in the industry for more than 15 years. Everything you’ll learn is based on real, tangible experiences and skills that are used every single day, so make sure you pay attention! You’ll learn how to:
Write Clean, Understandable Queries
Approach and Solve Problems Like a Data Analyst
Use Different SQL Clauses Efficiently
Implement Practical Solutions
Join A Cross-Platform SQL Environment
Our beginner-friendly SQL course (and the professional SQL certification that comes with it) is applicable to MySQL, SQL Server, and PostgreSQL. You can switch from one to the other with ease thanks to the universal skills that our course will teach you.
We’re truly passionate about what we do

The satisfaction of our customers and students is our top priority. That’s why we can guarantee you’ll get the highest possible value out of our course!
Ready To Get Started?
You don’t need any experience to obtain our professional SQL certification. Simply enroll and start learning!
Who this course is for:
Anyone interested in learning how to effectively analyze data using SQL

What you'll learn

Become ready for your SQL interview by performing 150 analysis tasks

Gain confidence toward your SQL interview by analysing 12 real-world datasets

Learn how to solve SQL interview challanges

Learn SQL by doing, and build strong analytical skills

Cross platform environment - SQL Server, MySQL, and PostgreSQL

Develop your own Data Intuition

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Course Introduction
5
1.1-Course Introduction
1.2-About your Instructors
1.3-Syllabus
1.4-Cheat Sheats!
1.5-Important FAQ - Please Read
2-Installations
5
2.1-MySQL - Windows Download and Installation, Inc. Database Installation
2.2-MySQL - MacOS Download and Installation, Inc. Database Installation
2.3-MSSQL Server - Windows Download and Installation
2.4-PostreSQL - Windows Download and Installation, Inc. Database Installation
2.5-PostgreSQL - MacOS download and installation, Inc. Database Installation
3-Course Resources
1
3.1-Database Creation Scripts
4-Basic SELECT Statements
8
4.1-Working with MySQL Workbench
4.2-Writing your first SQL query
4.3-Column Manipulations
4.4-Basic SELECT Statments
4.5-Column Aliases
4.6-Column Manipulations & Column Aliases
4.7-Distinct Statement
4.8-Distinct Statement
5-Concluding Exercise - Online Campus Data Analysis
1
5.1-OnlineCampus Data Analysis
6-Filter & Sort the Dataset
18
6.1-Introducing the WHERE Clause
6.2-Basic Filtering
6.3-IN operator
6.4-IN Operator
6.5-BETWEEN Operator
6.6-BETWEEN Operator
6.7-LIKE operator
6.8-LIKE Operator
6.9-IS NULL Operator
6.10-IS NULL Operator
6.11-AND & OR Operators
6.12-AND & OR Operators
6.13-Modulus and Integer Division
6.14-Interim Summary SELECT-FROM-WHERE
6.15-ORDER BY Clause
6.16-ORDER BY Clause
6.17-LIMIT Statement
6.18-LIMIT Statement
7-Concluding Exercise - Netflix Data Analysis
1
7.1-Netflix Data Analysis
8-Scalar Functions
12
8.1-Introducing Scalar Functions
8.2-String Functions
8.3-String Functions
8.4-Numeric Functions
8.5-Numeric Functions
8.6-Datetime Functions
8.7-Datetime Functions
8.8-NULL Handling
8.9-NULL Handling
8.10-Scalar Functions Summary
8.11-Using the CASE Statement
8.12-CASE Statements
9-Concluding Exercise - Job Adverts Data Analysis
2
9.1-Job Adverts Data Analysis, part 1
9.2-Job Adverts Data Analysis, part 2
10-Aggregating Data
8
10.1-Group Functions
10.2-Group Functions
10.3-The GROUP BY Clause
10.4-The GROUP BY Clause
10.5-Grouping by Manipulated Columns
10.6-The Having Clause
10.7-The HAVING Clause
10.8-Interim Summary All Clauses
11-Concluding Exercise - Spotify Data Analysis
1
11.1-Spotify Data Analysis
12-Joining Multiple Tables
10
12.1-Introducing the JOIN Statement
12.2-Inner JOIN
12.3-Inner JOIN
12.4-Joining More than 2 Tables
12.5-Joining Multiple Tables
12.6-LEFT and RIGHT Joins
12.7-LEFT and RIGHT Joins
12.8-FULL Join
12.9-Self Join
12.10-Self Join
13-Concluding Exercise - CarsOnline Data Analysis
1
13.1-CarsOnline Data Analysis
14-Sub Queries
4
14.1-Single Row Subqueries
14.2-Single Row Subqueries
14.3-Multiple Row Subqueries
14.4-Multiple Row Subqueries
15-Concluding Exercise - AppStore Data Analysis
1
15.1-AppStore Data Analysis