4.60
(5 Ratings)

Data Analysis using SQL

Categories: Data Analysis
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

Course Introduction

  • Course Introduction
    14:52
  • 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
    06:03
  • Restoring dvdrental.tar file to pgAdmin
    05:46
  • Restoring CSV datasets to PgAdmin
    14:02

Week 2: SQL Statement Fundamentals

Week 3: GROUP BY Statement

Week 4: Assessment 1

Week 5: Advanced SQL Commands

Week 6: JOINS

Week 7: Assessment 2

Week 8: Final Exams

Project 1

ChatGPT – Application to Data Analysis (SQL)

Creating Databases and Tables in SQL

PostgreSQL with Python

Student Ratings & Reviews

4.6
Total 5 Ratings
5
3 Ratings
4
2 Ratings
3
0 Rating
2
0 Rating
1
0 Rating
RA
3 weeks ago
Great knowledge received
YH
11 months ago
It was insightful, but there is need to structure the use of chartGPT and also uploading conerted CSV file to SQL and finally putting it on posgrade SQL
11 months ago
It's been amazing. The instructor has been doing a great job since I started this course.
1 year ago
I really enjoyed the course. It was quite progessive and very easy to understand.
1 year ago
It's an expository and exploratory course that gives a hands-on understanding of the underlying principles about data, database, data querying and data analysis.

Want to receive push notifications for all major on-site activities?