IIRF Online > Development > Database Design & Development > PostgreSQL > SQL Masterclass: SQL for Data Analytics
SQL Masterclass: SQL for Data Analytics by Udemy
SQL course covering basic to advanced SQL topics for SQL Database (PostgreSQL). Beginner friendly SQL training
Course Highlights
- Knowledge of all the essential SQL commands
- Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
- Become competent in using sorting and filtering commands in SQL
- Master SQL's most popular string, mathematical and date-time functions
- Enhance the performance of your Database by using Views and Indexes
- Increase your efficiency by learning the best practices while writing SQL queries
- Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
- Solid understanding of SQL
Skills you will learn!
Curriculum
1 Topic
Introduction
4 Topics
Installing PostgreSQL and pgAdmin in your PC
This is a milestone!
If pgAdmin is not opening...
Course Resources
2 Topics
Case Study Part 1 - Business problems
Case Study Part 2 - How SQL is Used
23 Topics
CREATE
Exercise 1: Create DB and Table
Solutions to all Exercises
INSERT
Import data from File
Exercise 2: Inserting and Importing
SELECT statement
Quick coding exercise on Select Statement
SELECT DISTINCT
Quick coding exercise on Distinct Command
WHERE
Quick coding exercise on Where Statement
Logical Operators
Quick coding exercise on Logical Operators
Exercise 3: SELECT & WHERE
UPDATE
Quick coding exercise on Update Command
DELETE
Quick coding exercise on Delete Command
ALTER
Quick coding exercise on Alter Command
Exercise 4: Updating Table
Fundamental SQL statements
5 Topics
Restore and Back-up
Debugging restoration issues
Creating DB using CSV files
Debugging summary and Code for CSV files
Exercise 5: Restore and Back-up
8 Topics
IN
Quick coding exercise on IN operator
BETWEEN
Quick coding exercise on Between Operator
LIKE
Quick coding exercise on Like operator
Exercise 6: In Like & Between
Quiz
6 Topics
Side Lecture: Commenting in SQL
ORDER BY
Quick coding exercise on Order by Clause
LIMIT
Quick coding exercise on Limit Command
Exercise 7: Sorting
2 Topics
AS
Quick coding exercise on AS operator
10 Topics
COUNT
Quick coding exercise on Count function
SUM
Quick coding exercise on Sum function
AVERAGE
Quick coding exercise on Average function
MIN & MAX
Quick coding exercise on MIN & MAX function
Exercise 8: Aggregate functions
Quiz
6 Topics
GROUP BY
Quick coding exercise on Group By Clause
HAVING
Quick coding exercise on Having Clause
Exercise 9: Group By
Quiz
2 Topics
CASE WHEN
Quick coding exercise on CASE WHEN Statement
21 Topics
Introduction to Joins
Concepts of Joining and Combining Data
Preparing the data
Inner Join
Quick coding exercise on Inner Join
Left Join
Quick coding exercise on Left Join
Right Join
Quick coding exercise on Right Join
Full Outer Join
Quick coding exercise on Full Outer Join
Cross Join
Quick coding exercise on Cross Join
Intersect and Intersect ALL
Quick coding exercise on Intersect and Intersect ALL
Except
Quick coding exercise on Except
Union
Quick coding exercise on Union Operator
Exercise 10: Joins
Quiz
3 Topics
Subqueries
Quick coding exercise on Subquery
Exercise 11: Subqueries
1 Topic
Solve Murder Mystery using SQL
6 Topics
VIEWS
Quick coding exercise on Views
INDEX
Quick coding exercise on Index
Exercise 12: Views
Quiz
14 Topics
LENGTH
Quick coding exercise on LENGTH function
UPPER LOWER
Quick coding exercise on UPPER LOWER function
REPLACE
Quick coding exercise on REPLACE function
TRIM LTRIM RTRIM
Quick coding exercise on TRIM LTRIM RTRIM functions
CONCATENATION
Quick coding exercise on CONCATENATION function
SUBSTRING
Quick coding exercise on SUBSTRING function
LIST AGGREGATION
Exercise 13: String Functions
10 Topics
CEIL & FLOOR
Quick coding exercise on CEIL & FLOOR functions
RANDOM
SETSEED
ROUND
Quick coding exercise on ROUND function
POWER
Quick coding exercise on POWER function
Exercise 14: Mathematical Functions
Quiz
6 Topics
CURRENT DATE & TIME
Quick coding exercise on CURRENT DATE & TIME function
AGE
EXTRACT
Exercise 15: Date-time functions
Quiz
5 Topics
PATTERN MATCHING BASICS
Quick coding exercise on Pattern Matching Basics
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Exercise 16: Pattern Matching
Quiz
17 Topics
Introduction to Window functions
Introduction to Row number
Implementing Row number in SQL
Quick coding exercise on Row number
RANK and DENSERANK
Quick coding exercise on RANK and DENSERANK
NTILE function
Quick coding exercise on NTILE function
AVERAGE function
Quick coding exercise on AVERAGE function
COUNT
Quick coding exercise on COUNT function
SUM TOTAL
Quick coding exercise on SUM TOTAL function
RUNNING TOTAL
LAG and LEAD
Quick coding exercise on LAG and LEAD function
2 Topics
COALESCE function
Quick coding exercise on COALESCE function
4 Topics
Converting Numbers/ Date to String
Quick coding exercise on Converting Numbers/ Date to String function
Converting String to Numbers/ Date
Quick coding exercise on Converting String to Numbers/ Date function
1 Topic
User Access Control
7 Topics
Showcasing SQL Skills with HackerRank Stars
Tablespace
PRIMARY KEY & FOREIGN KEY
ACID compliance
Truncate
Practice Test 1
SQL Quiz
8 Topics
TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 (STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)
6 Topics
What is SQL?
Tables and DBMS
Types of SQL commands
PostgreSQL
The final milestone!
Bonus Lecture
SQL Masterclass: SQL for Data Analytics
Related PostgreSQL Courses
Thank You!
Your review has been submitted successfully.