Data Analysis using SQL

Categories: Data Analysis, SQL
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This course will make you SQL query expert it’s a Data Analysis (SQL focused) and, You’ll learn the skills you need to retrieve insightful data from a database. There are many test your self  quizzes distributed over the course with detailed  solutions so you to practice more and more . After completing this course and all of it’s quizzes and the Final exam,  you will be comfortable with using SQL & PostgreSQL in data analysis and data science by SQL Challenges and Final Exam and more.

What Will You Learn?

  • Use SQL to insert data into a table.
  • Use SQL to Query & retrieve data from databases.
  • Use SQL to Sort records after retrieving from databases.
  • Use SQL to Group data by specific conditions.
  • Use SQL to Filter data by using where clause.
  • How & when to use Joins types in SQL.
  • How to create and deal with Sub-queries in SQL.
  • How to create and deal with common table expression in SQL.
  • Use SQL to perform data analysis of real world databases

Course Content

Introduction

  • Course Introduction
    06:14
  • Overview of Data Analysis
    07:14
  • Overview of Databases
    08:49
  • Tools used by Data Analysts
    04:28
  • Downloadable Files and Important Notes
    00:00
  • Downloading and Installing pgAdmin
    14:57
  • Loading Data (dvdrental.tar) to pgAdmin
    05:45
  • Utility File not Found Resolved
    06:58

SQL Statement Fundamentals

GROUPBY Statement

Assessment 1

JOINS

Advanced SQL Commands

Assessment 2

Student Ratings & Reviews

No Review Yet
No Review Yet
Verified by MonsterInsights