SQL for Newcomers - The Full Mastery Course

A course to make you an SQL genius!

4.55 (482 reviews)

Udemy

platform

English

language

Databases

What you will learn

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.

Why take this course?

"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.

Content

Introduction

Tools Used in This Course

Setting Up Course Tools

Download PostgreSQL

Install PostgreSQL

Download SQLectron

Install SQLectron

Connect to PostgreSQL - Credentials

Connect to PostgreSQL Using SQLectron

Import Course Data Using SQLectron

FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver

FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

Browsing & Filtering Data

Check Imported Data

So.. What is a Database?

SQL Data Types

Finally Some Fun! Extracting Data Based on Requirements

Filtering Data using WHERE Keyword

Filter Data by Range Using BETWEEN

Filter Data by Set of Values Using IN

Filter Data by Date

More Filtering by Date

Another Query Filtering by Date

Filter Data by Strings (Names, Addresses, ...)

More Filtering by Strings

More Filtering by Strings 2

More Filtering by Strings 3

How to Ignore Caps when Filtering by String

Filter Data with AND, OR, NOT Operators

AND Operator

OR Operator

NOT Operator

AND, OR & NOT Operators: Which Has The Highest Priority?

Math Operations

Basic Math Operations

Modulo Operator

It's Payday! Calculate The Net Salary for Employees

Filter Data with Math Equations

String Concatenation

Concatenate Strings with '||' Operator

Concatenate Strings with Numbers

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

Give Your Report Fields A Cool Name

A Report for Payroll

Order Records by Column

Order Records by Multiple Columns

How Alias Names Cannot Be Used with WHERE

LIMIT Record Count Fetched by Your Query

NULL, DISTINCT & CASE Statements

Fetch A Field's Unique Values Using DISTINCT

Using DISTINCT Keyword with Multiple Columns

What is a NULL Value Anyway?

Build More Sophisticated Queries with CASE Statements

Your Knowledge So Far Under A Great Test

Functions in SQL: Multiple-Row Functions

Let Me Introduce You to Functions

SUM Function

AVG (Average) Function

COUNT Function

MIN & MAX Functions

How To Count Your Field's Unique Values

GROUP BY Clause: Use Functions with Dimensions

GROUP BY More Than One Dimension

Now For Some Tough Workout

Filter By Aggregate Functions with HAVING Clause

Functions in SQL: Single-Row Functions

Character Functions - UPPER, LOWER & INITCAP

Character Functions - CONCAT & LENGTH

Character Functions - LPAD & RPAD

Character Functions - TRIM

Character Functions - REPLACE

Character Functions - SUBSTR

Number Functions - MOD & ROUND

Number Functions - TRUNC

Nested Queries

Selectception: A Select Query Inside Another Select Query!

Casting & Data Conversion

Auto Data Conversion in SQL

Cast Date to Character

Cast Number to Character

Cast Timestamp to Character

Cast Character to Number

Cast Character to Date & Timestamp

Combination Relationships

UNION

UNION ALL

Important Note about Combining Queries

INTERSECT

EXCEPT

Joins in SQL

Employees & Departments Tables Revised

Entity Relationship Diagram (ERD)

Cartesian Join

Table Aliases with Joins

Why I Don't Recommend Cartesian Joins

Inner Join

In-Depth Look into Join Types in SQL

Outer Join - Right, Left & Full

Data Manipulation (DML)

INSERT a New Record to a Table

Insert Without Specifying Column Names

UPDATE a Record's Field Values

CAUTION! How an UPDATE Query Can Go Wrong

Update a Record Using Single-Row Functions

A Good Exercise: Extract Employee's Email Address

Hints on How to Extract Employee's Email Address

Solution: Extract Employee's Email Address

DELETE a Table's Record

Insert Records with Nested Select Queries

SQL Data Definition Language (DDL)

SQL Data Types Revised

Bookstore Data Set: Let's Move It to Database

Create Your First Table!

Insert Data to Your New Table

Change Column Data Type

Rename Column

Add a New Column to Table

Constraints in SQL

Primary Keys

NOT NULL Constraint

UNIQUE Constraint

DEFAULT Constraint

Foreign Keys

Use Foreign Keys with Joins - Books & Publishers

Foreign Keys - Properties

Drop Column

DROP Table

Create a New Table with Select Statement

A Trick to Create an Empty Table with Select Statement

Insert New Records Using Select Statement

Views

Schemas

Create & Use Schemas

Access Control

Introduction to Access Control

Create User

Grant SELECT to User

Grant Insert & Update to User

Revoke Privilege from User

User Groups

Screenshots

SQL for Newcomers - The Full Mastery Course - Screenshot_01

SQL for Newcomers - The Full Mastery Course - Screenshot_02

SQL for Newcomers - The Full Mastery Course - Screenshot_03

SQL for Newcomers - The Full Mastery Course - Screenshot_04

Our review

--- **Overall Course Rating:** 4.55/5 Based on recent student reviews, this SQL course stands out for its clarity, practical exercises, and real-world application. The majority of reviews praise the course's content delivery and the instructor's ability to make complex concepts understandable for beginners. Here's a detailed breakdown of the course's strengths and areas for improvement: ### Course Strengths: - **Comprehensive Content:** Students find the course very helpful and comprehensive, covering all the necessary topics to get started with SQL. (Multiple Reviews) - **Instructor's Explanation:** Sameh, the instructor, is highly praised for his simple and clear explanation of SQL concepts. He uses practical examples that are relevant to real-world scenarios. (Several Reviews) - **Practical Exercises:** The course includes nice, practical exercises that make sense and help students apply what they've learned. (Multiple Reviews) - **Ease of Understanding:** Even SQL beginners find the course easy to follow, with the instructor starting from the basics and making the content engaging. (Several Reviews) - **Real-World Application:** The course provides access to a database to follow along with real examples, enhancing the learning experience. (Multiple Reviews) ### Areas for Improvement: - **Pacing:** Some students find the pacing of the course a bit slow, which might be an asset for beginners but could be accelerated for those with prior knowledge or a faster pace preference. (Several Reviews) - **Technical Issues:** A few reviews mention audio issues in the videos and a desire for better sound quality. (One Review) - **Comprehensiveness:** While the course is great for beginners, some advanced features like creating tables, inserting/deleting data, etc., are not covered, which could be included for more comprehensive learning. (Multiple Reviews) - **Platform Specificity:** Some students suggest adding a comparison between different SQL platforms (e.g., PostgreSQL, MySQL, MS SQL) and including MySQL-specific commands for a broader appeal. (One Review) - **Advanced Topics:** There is a recommendation to include more complex topics, such as using JOINs, and to provide examples of advanced queries in the future. (Several Reviews) - **Additional Features:** The course is currently focused on the SELECT statement. Students suggest adding more content on saving queries, creating datasets, and explaining the use of Integrated Development Environments (IDEs). (Multiple Reviews) - **Case Studies and Projects:** Some students recommend incorporating more case studies and capstone projects to enhance practical learning. (Two Reviews) ### Student Experience: - **Beginners Welcome:** The course is particularly well-suited for those with no prior SQL knowledge, as it starts from the basics and builds up. (Several Reviews) - **Engaging Content:** Students find the lecture excellent and engaging but express a need for more basic content like creating tables and handling data operations. (Multiple Reviews) - **Overall Positive Experience:** Despite some areas for improvement, the overall experience with the course is positive, with many students enjoying the course and finding it informative and well-presented. (Several Reviews) In summary, this SQL course offers a solid foundation in SQL for beginners and is appreciated for its practical approach and clear explanations. With some enhancements, it could become an even more comprehensive learning tool for students at all levels of SQL proficiency.

Charts

Price

Rating

Enrollment distribution

SQL for Newcomers - The Full Mastery Course - Distribution chart