Chod Matrix > Development > Database Design & Development > SQL for Newcomers – The Full Mastery Course
4.6 out of 5
4.6
481 reviews on Udemy

SQL for Newcomers – The Full Mastery Course

A course to make you an SQL genius!
Instructor:
Sameh Sharaf
12,061 students enrolled
English [Auto]
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.

“Wow! I really regret learning SQL”

– No one ever

Hi!

I’m Sameh Sharaf. I am a data engineer. I have worked on data since 2010 so I guess I can say I’m experienced enough.

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.

Introduction

1
Introduction
2
Tools Used in This Course

Setting Up Course Tools

1
Download PostgreSQL
2
Install PostgreSQL
3
Download SQLectron
4
Install SQLectron
5
Connect to PostgreSQL - Credentials
6
Connect to PostgreSQL Using SQLectron
7
Import Course Data Using SQLectron
8
FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver
9
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

Browsing & Filtering Data

1
Check Imported Data
2
So.. What is a Database?
3
SQL Data Types
4
Finally Some Fun! Extracting Data Based on Requirements
5
Filtering Data using WHERE Keyword
6
Filter Data by Range Using BETWEEN
7
Filter Data by Set of Values Using IN
8
Filter Data by Date
9
More Filtering by Date
10
Another Query Filtering by Date
11
Filter Data by Strings (Names, Addresses, ...)
12
More Filtering by Strings
13
More Filtering by Strings 2
14
More Filtering by Strings 3
15
How to Ignore Caps when Filtering by String

Filter Data with AND, OR, NOT Operators

1
AND Operator
2
OR Operator
3
NOT Operator
4
AND, OR & NOT Operators: Which Has The Highest Priority?

Math Operations

1
Basic Math Operations
2
Modulo Operator
3
It's Payday! Calculate The Net Salary for Employees
4
Filter Data with Math Equations

String Concatenation

1
Concatenate Strings with '||' Operator
2
Concatenate Strings with Numbers

Tidy Up Your Results: Sorting, Alias Names, Limit Records

1
Give Your Report Fields A Cool Name
2
A Report for Payroll
3
Order Records by Column
4
Order Records by Multiple Columns
5
How Alias Names Cannot Be Used with WHERE
6
LIMIT Record Count Fetched by Your Query

NULL, DISTINCT & CASE Statements

1
Fetch A Field's Unique Values Using DISTINCT
2
Using DISTINCT Keyword with Multiple Columns
3
What is a NULL Value Anyway?
4
Build More Sophisticated Queries with CASE Statements
5
Your Knowledge So Far Under A Great Test

Functions in SQL: Multiple-Row Functions

1
Let Me Introduce You to Functions
2
SUM Function
3
AVG (Average) Function
4
COUNT Function
5
MIN & MAX Functions
6
How To Count Your Field's Unique Values
7
GROUP BY Clause: Use Functions with Dimensions
8
GROUP BY More Than One Dimension
9
Now For Some Tough Workout
10
Filter By Aggregate Functions with HAVING Clause

Functions in SQL: Single-Row Functions

1
Character Functions - UPPER, LOWER & INITCAP
2
Character Functions - CONCAT & LENGTH
3
Character Functions - LPAD & RPAD
4
Character Functions - TRIM
5
Character Functions - REPLACE
6
Character Functions - SUBSTR
7
Number Functions - MOD & ROUND
8
Number Functions - TRUNC

Nested Queries

1
Selectception: A Select Query Inside Another Select Query!

Casting & Data Conversion

1
Auto Data Conversion in SQL
2
Cast Date to Character
3
Cast Number to Character
4
Cast Timestamp to Character
5
Cast Character to Number
6
Cast Character to Date & Timestamp

Combination Relationships

1
UNION
2
UNION ALL
3
Important Note about Combining Queries
4
INTERSECT
5
EXCEPT

Joins in SQL

1
Employees & Departments Tables Revised
2
Entity Relationship Diagram (ERD)
3
Cartesian Join
4
Table Aliases with Joins
5
Why I Don't Recommend Cartesian Joins
6
Inner Join
7
In-Depth Look into Join Types in SQL
8
Outer Join - Right, Left & Full

Data Manipulation (DML)

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
481 Ratings

Detailed Rating

Stars 5
229
Stars 4
187
Stars 3
55
Stars 2
6
Stars 1
4
5da91f4ef41ad5061dca6fcabdb50b2c
Get course
Available in "ESSENTIAL LEARNER" plan Available in "PREMIUM SCHOLAR" plan

Includes

11 hours on-demand video
2 articles
1 lectures
Certificate of Completion