SQL for Newcomers - The Full Mastery Course

A course to make you an SQL genius!

Instructed by Sameh Sharaf

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • Select & filter 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.

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.

  • Have a PC or laptop to work on. Your old clunky notebook will do.
  • Junior data analysts and scientists.
  • Junior developers who need to work on relational databases.
  • Undergraduate students who study relational databases in their curriculum.
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Lecture 2 :
  • Tools Used in This Course

Section 2 : Setting Up Course Tools

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

Section 3 : Browsing & Filtering Data

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

Section 4 : Filter Data with AND, OR, NOT Operators

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

Section 5 : Math Operations

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

Section 6 : String Concatenation

  • Lecture 1 :
  • Concatenate Strings with '||' Operator
  • Lecture 2 :
  • Concatenate Strings with Numbers

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

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

Section 8 : NULL, DISTINCT & CASE Statements

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

Section 9 : Functions in SQL: Multiple-Row Functions

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

Section 10 : Functions in SQL: Single-Row Functions

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

Section 11 : Nested Queries

  • Lecture 1 :
  • Selectception: A Select Query Inside Another Select Query!

Section 12 : Casting & Data Conversion

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

Section 13 : Combination Relationships

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

Section 14 : Joins in SQL

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

Section 15 : Data Manipulation in SQL

  • Lecture 1 :
  • INSERT a New Record to a Table
  • Lecture 2 :
  • Insert Without Specifying Column Names
  • Lecture 3 :
  • UPDATE a Record's Field Values
  • Lecture 4 :
  • CAUTION! How an UPDATE Query Can Go Wrong
  • Lecture 5 :
  • Update a Record Using Single-Row Functions
  • Lecture 6 :
  • A Good Exercise: Extract Employee's Email Address
  • Lecture 7 :
  • Solution: Extract Employee's Email Address
  • Lecture 8 :
  • DELETE a Table's Record
  • Lecture 9 :
  • Insert Records with Nested Select Queries

Section 16 : SQL Data Definition Language (DDL)

  • Lecture 1 :
  • SQL Data Types Revised
  • Lecture 2 :
  • Bookstore Data Set: Let's Move It to Database
  • Lecture 3 :
  • Create Your First Table!
  • Lecture 4 :
  • Insert Data to Your New Table
  • Lecture 5 :
  • Change Column Data Type
  • Lecture 6 :
  • Rename Column
  • Lecture 7 :
  • Add a New Column to Table
  • Lecture 8 :
  • Constraints in SQL
  • Lecture 9 :
  • Primary Keys
  • Lecture 10 :
  • NOT NULL Constraint
  • Lecture 11 :
  • UNIQUE Constraint
  • Lecture 12 :
  • DEFAULT Constraint
  • Lecture 13 :
  • Foreign Keys
  • Lecture 14 :
  • Use Foreign Keys with Joins - Books & Publishers
  • Lecture 15 :
  • Foreign Keys - Properties
  • Lecture 16 :
  • Drop Column
  • Lecture 17 :
  • DROP Table
  • Lecture 18 :
  • Create a New Table with Select Statement
  • Lecture 19 :
  • A Trick to Create an Empty Table with Select Statement
  • Lecture 20 :
  • Insert New Records Using Select Statement
  • Lecture 21 :
  • Views
  • Lecture 22 :
  • Schemas
  • Lecture 23 :
  • Create & Use Schemas

Section 17 : Access Control

  • Lecture 1 :
  • Introduction to Access Control
  • Lecture 2 :
  • Create User
  • Lecture 3 :
  • Grant SELECT to User
  • Lecture 4 :
  • Grant Insert & Update to User
  • Lecture 5 :
  • Revoke Privilege from User
  • Lecture 6 :
  • User Groups

Sameh Sharaf,

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.
View More...
learn-to-build-sql-query-ultimate-sql-and-database-concepts

Learn to Build SQL Query Ultimate S...

By : Jazeb Akram

Lecture 24

sql-server-tutorial

SQL Server tutorial

By : Shivprasad Koirala

Lecture 22

sql-server-101-microsoft-sql-server-for-absolute-beginners

SQL Server 101 : Microsoft SQL Serv...

By : Rashid Khan

Lecture 44

data-warehouse-etl-testing-data-quality-management-a-z

Data Warehouse ETL Testing & Data Q...

By : Lorenz De Smedt

Lecture 20

beginning-t-sql-for-sql-server-developer-data-analyst-dba

Beginning T-SQL for SQL Server Deve...

By : Vikas Munjal

Lecture 46

sql-server-programming

SQL Server Programming

By : Arunprakash P V

Lecture 12

Buy

$15

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password