English | MP4 | AVC 1366×768 | AAC 44KHz 2ch | 7h 11m | 2.45 GB
We cover basic–to-advanced SQL topics for SQL databases (PostgreSQL). We explain SQL databases for beginners
This complete tutorial on SQL can be completed within a weekend. SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know.
The course is taught by Abhishek and Pukhraj, who have been teaching Data Science and Machine Learning for over a decade. They are also the creators of some of the most popular online courses—with over 150,000 enrollments.
SQL is the most universal and commonly used database language. It powers the most commonly used database engines such as PostgreSQL, SQL Server, SQLite, and MySQL. Simply put, If you want to access databases then yes, you need to know SQL. It is not difficult to learn SQL. SQL is not a programming language; it’s a query language. The primary objective for which SQL was created was to enable normal people get the data they need from databases. The language resembles English, so anyone who can use the latter at a basic level can write SQL queries easily. SQL is one of the most sought-after skills by employers who are hiring.
SQL is easy but no one can determine how long it takes to learn it; it totally depends on you. The method we have adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same timetable but remember: you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.
Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message. With each lecture, there is a practice sheet attached for you to follow along. Each section contains a practice assignment for you to implement what you’ve learned practically. We have created a set of concise and comprehensive videos to teach you all the SQL-related skills you will need in your professional career. We also provide exercises to complement the videos. These exercises are carefully designed to further clarify the concepts and help you implement them on practical problems you’ll face at work.
Learn
- Master all essential SQL commands
- Become proficient in SQL tools such as GROUP BY, JOINS, and subqueries
- Become competent in using SQL sorting and filtering commands
- Master SQL’s most popular string, mathematical, and date-time functions
- Enhance the performance of your database by using views and indexes
Table of Contents
Introduction
Course Overview
Installation and getting started
Installation
Case Study – Demo
Case Study Part 1
Case Study Part 2
Fundamental SQL statements
ALTER
CREATE
DELETE
Exercise 1 – Create DB and Table
Exercise 2 – Inserting and Importing
Exercise 3 – SELECT & WHERE
Exercise 4 – Updating Table
Import data from File
INSERT
Logical Operators
SELECT DISTINCT
SELECT statement
UPDATE
WHERE
Restore and Back-up
Exercise 5 – Restore and Back-up
Restore and Back-up
Selection commands – Filtering
BETWEEN
Exercise 6 – In, Like & Between
IN
LIKE
Selection commands – Ordering
Exercise 7 – Sorting
LIMIT
ORDER BY
Side Lecture – Commenting in SQL
Alias
AS
Aggregate Commands
AVERAGE
COUNT
Exercise 8 – Aggregate functions
MIN & MAX
SUM
Group by Commands
Exercise 9 – Group By
GROUP BY
HAVING
Conditional Statement
CASE WHEN
JOINS
Cross Join
Except
Exercise 10 – Joins
Full Outer Join
Inner Join
Introduction to Joins
Left Join
Right Join
Union
Subqueries
Exercise 11 – Subqueries
Subqueries
Views and Indexes
Exercise 12 – Views
INDEX
VIEWS
String Functions
CONCATENATION
Exercise 13 – String Functions
LENGTH
LIST AGGREGATION
REPLACE
SUBSTRING
TRIM, LTRIM, RTRIM
UPPER LOWER
Mathematical Functions
CEIL & FLOOR
Exercise 14 – Mathematical Functions
POWER
RANDOM
ROUND
SETSEED
Date-Time Functions
AGE
CURRENT DATE & TIME
Exercise 15 – Date-time functions
EXTRACT
PATTERN (STRING) MATCHING
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Exercise 16 – Pattern Matching
PATTERN MATCHING BASICS
Data Type conversion functions
Converting Numbers Date to String
Converting String to Numbers Date
User Access Control Functions
User Access Control
Bonus Section – Nail that Interview!
ACID compliance
PRIMARY KEY & FOREIGN KEY
Tablespace
Truncate
Performance tuning tips
TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 (STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)
Bonus Section – Database Basics
PostgreSQL
Tables and DBMS
Types of SQL commands
What is SQL
Resolve the captcha to access the links!