SQL for Newcomers - The Full Mastery Course
Created by Sameh Sharaf, Last Updated 23-Feb-2021, Language:English
SQL for Newcomers - The Full Mastery Course
A course to make you an SQL genius!
Created by Sameh Sharaf, Last Updated 23-Feb-2021, Language:English
What Will I Get ?
- Able to select & filter data using SQL, fetch data for useful reports based on different requirements.
- Manipulate data by adding new records & modifying or deleting existing ones.
- Create & modify tables with setting constraints to columns.
- Learn some of the most useful built-in functions in SQL, as well as data type conversion.
- Join tables using different join types SQL provides.
- Brag about how cool they are knowing how to use SQL with their friends.
Requirements
- Have a PC or laptop to work on. Your old clunky notebook will do.
- Can work on any operating system (Windows, Linux & MacOS).
Description
This course will teach you how to use SQL (Structured Query Language), a language so prominent for relational databases, databases such as MySQL, PostgreSQL, SQLlite and more.
SQL now is a great skill to have if you want to work as a data analyst, data scientist, BI developer, data engineer, database administrator or even a software developer/engineer, since all these jobs need to use databases and data in a daily basis.
I'm a beginner, is this course for me?
Sure! This course was done for beginners. Even students with experience in SQL may find it useful too to memorize some keywords and functions, as well as learning more about the bits they may miss.
Is there any prerequisites to attend this course?
The only thing you need is a PC or laptop with average performance and any operating system installed on. We'll be using Windows 10 for this course but the OS does not matter since the tech we'll be using is cross-platform and can work on Linux and Mac.
Who this course is for:
- Junior data analysts and scientists.
- Junior developers who need to work on relational databases.
- Undergraduate students who study relational databases in their curriculum.
- Anyone who's interested to learn SQL and add it to their resume.
Course Content
-
Introduction
2 Lectures 00:02:15-
Introduction
Preview00:01:15 -
Tools Used in This Course
Preview00:01:00
-
-
Setting Up Course Tools
8 Lectures 00:19:46-
Download PostgreSQL
00:02:07 -
Install PostgreSQL
00:02:33 -
Download SQLectron
00:01:31 -
Install SQLectron
00:00:33 -
Connect to PostgreSQL - Credentials
Preview00:01:18 -
Connect to PostgreSQL Using SQLectron
00:01:33 -
Import Course Data Using SQLectron
00:02:20 -
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
00:07:51
-
-
Browsing & Filtering Data
15 Lectures 00:57:53-
Check Imported Data
00:05:42 -
So.. What is a Database?
Preview00:01:20 -
SQL Data Types
00:01:46 -
Finally Some Fun! Extracting Data Based on Requirements
00:00:51 -
Filtering Data using WHERE Keyword
Preview00:08:28 -
Filter Data by Range Using BETWEEN
00:02:42 -
Filter Data by Set of Values Using IN
00:03:15 -
Filter Data by Date
00:05:24 -
More Filtering by Date
00:03:09 -
Another Query Filtering by Date
00:00:59 -
Filter Data by Strings (Names, Addresses, ...)
00:04:15 -
More Filtering by Strings
00:04:55 -
More Filtering by Strings 2
00:09:41 -
More Filtering by Strings 3
00:01:32 -
How to Ignore Caps when Filtering by String
00:03:54
-
-
Filter Data with AND, OR, NOT Operators
4 Lectures 00:38:09-
AND Operator
00:10:04 -
OR Operator
00:12:15 -
NOT Operator
00:09:24 -
AND, OR & NOT Operators: Which Has The Highest Priority?
Preview00:06:26
-
-
Math Operations
4 Lectures 00:18:59-
Basic Math Operations
00:05:30 -
Modulo Operator
00:04:25 -
It's Payday! Calculate The Net Salary for Employees
00:06:21 -
Filter Data with Math Equations
00:02:43
-
-
String Concatenation
2 Lectures 00:07:47-
Concatenate Strings with '||' Operator
00:05:57 -
Concatenate Strings with Numbers
00:01:50
-
-
Tidy Up Your Results: Sorting, Alias Names, Limit Records
6 Lectures 00:39:36-
Give Your Report Fields A Cool Name
Preview00:04:10 -
A Report for Payroll
00:07:05 -
Order Records by Column
00:06:21 -
Order Records by Multiple Columns
00:12:07 -
How Alias Names Cannot Be Used with WHERE
00:01:57 -
LIMIT Record Count Fetched by Your Query
00:07:56
-
-
NULL, DISTINCT & CASE Statements
5 Lectures 00:32:46-
Fetch A Field's Unique Values Using DISTINCT
00:02:42 -
Using DISTINCT Keyword with Multiple Columns
00:05:44 -
What is a NULL Value Anyway?
00:05:01 -
Build More Sophisticated Queries with CASE Statements
00:10:03 -
Your Knowledge So Far Under A Great Test
00:09:16
-
-
Functions in SQL: Multiple-Row Functions
10 Lectures 00:54:27-
Let Me Introduce You to Functions
00:04:10 -
SUM Function
00:04:12 -
AVG (Average) Function
00:04:09 -
COUNT Function
00:06:32 -
MIN & MAX Functions
00:03:48 -
How To Count Your Field's Unique Values
00:03:45 -
GROUP BY Clause: Use Functions with Dimensions
00:05:53 -
GROUP BY More Than One Dimension
00:04:52 -
Now For Some Tough Workout
00:08:53 -
Filter By Aggregate Functions with HAVING Clause
00:08:13
-
-
Functions in SQL: Single-Row Functions
8 Lectures 01:12:18-
Character Functions - UPPER, LOWER & INITCAP
Preview00:07:49 -
Character Functions - CONCAT & LENGTH
00:10:24 -
Character Functions - LPAD & RPAD
00:13:29 -
Character Functions - TRIM
00:03:35 -
Character Functions - REPLACE
00:09:18 -
Character Functions - SUBSTR
00:09:34 -
Number Functions - MOD & ROUND
00:11:13 -
Number Functions - TRUNC
00:06:56
-
-
Nested Queries
1 Lectures 00:06:14-
Selectception: A Select Query Inside Another Select Query!
00:06:14
-
-
Casting & Data Conversion
6 Lectures 00:53:10-
Auto Data Conversion in SQL
Preview00:10:34 -
Cast Date to Character
00:10:15 -
Cast Number to Character
00:09:22 -
Cast Timestamp to Character
00:06:38 -
Cast Character to Number
00:07:34 -
Cast Character to Date & Timestamp
00:08:47
-
-
Combination Relationships
5 Lectures 00:09:25-
UNION
00:03:27 -
UNION ALL
00:01:44 -
Important Note about Combining Queries
00:01:51 -
INTERSECT
00:00:58 -
EXCEPT
00:01:25
-
-
Joins in SQL
8 Lectures 00:53:05-
Employees & Departments Tables Revised
00:02:40 -
Entity Relationship Diagram (ERD)
00:09:13 -
Cartesian Join
00:09:27 -
Table Aliases with Joins
00:06:43 -
Why I Don't Recommend Cartesian Joins
00:07:42 -
Inner Join
00:05:56 -
In-Depth Look into Join Types in SQL
Preview00:02:59 -
Outer Join - Right, Left & Full
00:08:25
-
-
Data Manipulation (DML)
9 Lectures 01:00:19-
INSERT a New Record to a Table
00:08:44 -
Insert Without Specifying Column Names
00:09:10 -
UPDATE a Record's Field Values
00:07:12 -
CAUTION! How an UPDATE Query Can Go Wrong
00:04:08 -
Update a Record Using Single-Row Functions
00:04:15 -
A Good Exercise: Extract Employee's Email Address
00:01:50 -
Solution: Extract Employee's Email Address
00:12:53 -
DELETE a Table's Record
00:06:08 -
Insert Records with Nested Select Queries
00:05:59
-
-
SQL Data Definition Language (DDL)
23 Lectures 02:01:15-
SQL Data Types Revised
Preview00:12:34 -
Bookstore Data Set: Let's Move It to Database
00:03:51 -
Create Your First Table!
00:08:19 -
Insert Data to Your New Table
00:07:31 -
Change Column Data Type
00:07:11 -
Rename Column
00:03:33 -
Add a New Column to Table
00:04:11 -
Constraints in SQL
Preview00:01:04 -
Primary Keys
00:14:04 -
NOT NULL Constraint
00:04:33 -
UNIQUE Constraint
00:04:21 -
DEFAULT Constraint
00:04:10 -
Foreign Keys
00:07:31 -
Use Foreign Keys with Joins - Books & Publishers
00:06:19 -
Foreign Keys - Properties
00:06:15 -
Drop Column
00:00:40 -
DROP Table
00:01:01 -
Create a New Table with Select Statement
00:04:35 -
A Trick to Create an Empty Table with Select Statement
00:02:45 -
Insert New Records Using Select Statement
00:05:38 -
Views
00:03:29 -
Schemas
00:03:29 -
Create & Use Schemas
00:04:11
-
-
Access Control
6 Lectures 00:16:16-
Introduction to Access Control
00:01:21 -
Create User
00:03:01 -
Grant SELECT to User
00:02:30 -
Grant Insert & Update to User
00:03:04 -
Revoke Privilege from User
00:01:51 -
User Groups
00:04:29
-

Sameh Sharaf
Data Engineer
A data engineer, working with data for 8 years and counting. Passionate for teaching as for learning.
I'm a certified AWS Solution Architect - Associate and Google Cloud Data Engineer Professional.