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.
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