SQL for Data Analytics by Start-Tech Academy

SQL for Data Analytics

SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) from Beginner to Advanced
Includes Life-time access to all videos and a course completion certificate to add in your resume

What's included?

Video Icon 93 videos File Icon 1 file

Contents

Introduction
Course Overview
5 mins
Installation and getting started
Installation
7 mins
Study Material and datasets
9.98 MB
Case Study : Demo
Case Study Part 1
5 mins
Case Study Part 2
7 mins
Fundamental SQL statements
CREATE
12 mins
Exercise 1: Create DB and Table
2 mins
INSERT
10 mins
Import data from File
5 mins
Fin_Lec_07_Create_2_edited.mp4
4 mins
Exercise 2: Inserting and Importing
1 min
SELECT statement
4 mins
SELECT DISTINCT
7 mins
WHERE
5 mins
Logical Operators
7 mins
Exercise 3: SELECT & WHERE
2 mins
UPDATE
6 mins
DELETE
5 mins
ALTER
18 mins
Exercise 4: Updating Table
2 mins
Restore and Back-up
Restore and Back-up
8 mins
Exercise 5: Restore and Back-up
1 min
Selection commands: Filtering
IN
5 mins
BETWEEN
6 mins
LIKE
9 mins
Exercise 6: In, Like & Between
1 min
Selection commands: Ordering
Side Lecture: Commenting in SQL
2 mins
ORDER BY
8 mins
LIMIT
4 mins
Exercise 7: Sorting
1 min
Alias
AS
4 mins
Aggregate Commands
COUNT
6 mins
SUM
4 mins
AVERAGE
3 mins
MIN & MAX
5 mins
Exercise 8: Aggregate functions
2 mins
Group By Commands
GROUP BY
12 mins
HAVING
6 mins
Exercise 9: Group By
2 mins
Conditional Statement
CASE WHEN
6 mins
JOINS
Introduction to Joins
3 mins
Inner Join
9 mins
Left Join
8 mins
Right Join
7 mins
Full Outer Join
5 mins
Cross Join
5 mins
Except
3 mins
Union
4 mins
Exercise 10: Joins
2 mins
Subqueries
Subqueries
15 mins
Exercise 11: Subqueries
2 mins
Views and Indexes
VIEWS
8 mins
INDEX
7 mins
Exercise 12: Views
1 min
String Functions
LENGTH
4 mins
UPPER LOWER
3 mins
REPLACE
5 mins
TRIM, LTRIM, RTRIM
7 mins
CONCATENATION
3 mins
SUBSTRING
7 mins
LIST AGGREGATION
6 mins
Exercise 13: String Functions
3 mins
Mathematical Functions
CEIL & FLOOR
4 mins
RANDOM
6 mins
SETSEED
5 mins
ROUND
3 mins
POWER
3 mins
Exercise 14: Mathematical Functions
2 mins
Date-Time Functions
CURRENT DATE & TIME
5 mins
AGE
4 mins
EXTRACT
9 mins
Exercise 15: Date-time functions
2 mins
PATTERN (STRING) MATCHING
PATTERN MATCHING BASICS
8 mins
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
16 mins
Exercise 16: Pattern Matching
2 mins
Data Type conversion functions
Converting Numbers/ Date to String
11 mins
Converting String to Numbers/ Date
6 mins
User Access Control Functions
User Access Control
14 mins
Bonus Section: Nail that Interview!
Tablespace
6 mins
PRIMARY KEY & FOREIGN KEY
6 mins
ACID compliance
6 mins
Truncate
4 mins
Performance tuning tips
TIP 1 (EXPLAIN)
12 mins
TIP 2
2 mins
TIP 3
3 mins
TIP 4 (VACCUM)
1 min
TIP 5
2 mins
TIP 6 (STRING FUNCTIONS)
3 mins
TIP 7 (JOINS)
2 mins
TIP 8 (SCHEMAS)
5 mins
Additional resources : Database Basics
What is SQL
2 mins
Tables and DBMS
4 mins
Types of SQL commands
5 mins
PostgreSQL
3 mins