Learning Management Website > Development > Database Design & Development > SQL for Newcomers – The Full Mastery Course

4.6 out of 5

481 reviews on Udemy

SQL for Newcomers – The Full Mastery Course

A course to make you an SQL genius!

Instructor:

Sameh Sharaf

34 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

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)

FAQ 1

Faq Content 1

FAQ 2

Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!

4.6

4.6 out of 5

481 Ratings