(4 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
  • Overview of Data Analysis
  • Overview of Databases
  • Tools used by Data Analysts
  • Downloadable Files and Important Notes
  • Downloading and Installing pgAdmin
  • Restoring dvdrental.tar file to pgAdmin

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)

Student Ratings & Reviews

Total 4 Ratings
2 Ratings
2 Ratings
0 Rating
0 Rating
0 Rating
5 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
6 months ago
It's been amazing. The instructor has been doing a great job since I started this course.
10 months ago
I really enjoyed the course. It was quite progessive and very easy to understand.
11 months 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?