SQL for Newcomers - The Full Mastery Course

Focused View

Sameh Sharaf

11:01:48

37 View

1. Introduction

1. Introduction.mp4

01:15

2. Tools Used in This Course.mp4

01:00

2. Setting Up Course Tools

1. Download PostgreSQL.mp4

02:07

2. Install PostgreSQL.mp4

02:33

3. Download SQLectron.mp4

01:31

4. Install SQLectron.mp4

00:33

5. Connect to PostgreSQL - Credentials.mp4

01:18

6. Connect to PostgreSQL Using SQLectron.mp4

01:33

7.1 emp dept.zip

7. Import Course Data Using SQLectron.mp4

02:20

8. FOR WINDOWS 32-BIT USERS SQL Alternative - DBeaver.html

9.1 emp dept.zip

9. FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data.mp4

07:51

3. Browsing & Filtering Data

1. Check Imported Data.mp4

05:42

2. So.. What is a Database.mp4

01:20

3. SQL Data Types.mp4

01:46

4. Finally Some Fun! Extracting Data Based on Requirements.mp4

00:51

5. Filtering Data using WHERE Keyword.mp4

08:28

6. Filter Data by Range Using BETWEEN.mp4

02:42

7. Filter Data by Set of Values Using IN.mp4

03:15

8. Filter Data by Date.mp4

05:24

9. More Filtering by Date.mp4

03:09

10. Another Query Filtering by Date.mp4

00:59

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

04:15

12. More Filtering by Strings.mp4

04:55

13. More Filtering by Strings 2.mp4

09:41

14. More Filtering by Strings 3.mp4

01:32

15. How to Ignore Caps when Filtering by String.mp4

03:54

4. Filter Data with AND, OR, NOT Operators

1. AND Operator.mp4

10:04

2. OR Operator.mp4

12:15

3. NOT Operator.mp4

09:24

4. AND, OR & NOT Operators Which Has The Highest Priority.mp4

06:26

5. Math Operations

1. Basic Math Operations.mp4

05:30

2. Modulo Operator.mp4

04:25

3. Its Payday! Calculate The Net Salary for Employees.mp4

06:21

4. Filter Data with Math Equations.mp4

02:43

6. String Concatenation

1. Concatenate Strings with Operator.mp4

05:57

2. Concatenate Strings with Numbers.mp4

01:50

7. Tidy Up Your Results Sorting, Alias Names, Limit Records

1. Give Your Report Fields A Cool Name.mp4

04:10

2. A Report for Payroll.mp4

07:05

3. Order Records by Column.mp4

06:22

4. Order Records by Multiple Columns.mp4

12:07

5. How Alias Names Cannot Be Used with WHERE.mp4

01:57

6. LIMIT Record Count Fetched by Your Query.mp4

07:56

8. NULL, DISTINCT & CASE Statements

1. Fetch A Fields Unique Values Using DISTINCT.mp4

02:42

2. Using DISTINCT Keyword with Multiple Columns.mp4

05:44

3. What is a NULL Value Anyway.mp4

05:01

4. Build More Sophisticated Queries with CASE Statements.mp4

10:04

5. Your Knowledge So Far Under A Great Test.mp4

09:16

9. Functions in SQL Multiple-Row Functions

1. Let Me Introduce You to Functions.mp4

04:11

2. SUM Function.mp4

04:12

3. AVG (Average) Function.mp4

04:09

4. COUNT Function.mp4

06:32

5. MIN & MAX Functions.mp4

03:48

6. How To Count Your Fields Unique Values.mp4

03:45

7. GROUP BY Clause Use Functions with Dimensions.mp4

05:53

8. GROUP BY More Than One Dimension.mp4

04:52

9. Now For Some Tough Workout.mp4

08:53

10. Filter By Aggregate Functions with HAVING Clause.mp4

08:13

10. Functions in SQL Single-Row Functions

1. Character Functions - UPPER, LOWER & INITCAP.mp4

07:49

2. Character Functions - CONCAT & LENGTH.mp4

10:24

3. Character Functions - LPAD & RPAD.mp4

13:29

4. Character Functions - TRIM.mp4

03:35

5. Character Functions - REPLACE.mp4

09:18

6. Character Functions - SUBSTR.mp4

09:34

7. Number Functions - MOD & ROUND.mp4

11:13

8. Number Functions - TRUNC.mp4

06:56

11. Nested Queries

1. Selectception A Select Query Inside Another Select Query!.mp4

06:14

12. Casting & Data Conversion

1. Auto Data Conversion in SQL.mp4

10:34

2. Cast Date to Character.mp4

10:15

3. Cast Number to Character.mp4

09:22

4. Cast Timestamp to Character.mp4

06:38

5. Cast Character to Number.mp4

07:34

6. Cast Character to Date & Timestamp.mp4

08:47

13. Combination Relationships

1. UNION.mp4

03:27

2. UNION ALL.mp4

01:45

3. Important Note about Combining Queries.mp4

01:51

4. INTERSECT.mp4

00:58

5. EXCEPT.mp4

01:25

14. Joins in SQL

1. Employees & Departments Tables Revised.mp4

02:40

2. Entity Relationship Diagram (ERD).mp4

09:13

3. Cartesian Join.mp4

09:27

4. Table Aliases with Joins.mp4

06:43

5. Why I Dont Recommend Cartesian Joins.mp4

07:42

6. Inner Join.mp4

05:56

7. In-Depth Look into Join Types in SQL.mp4

02:59

8.1 employees fl.zip

8. Outer Join - Right, Left & Full.mp4

08:25

15. Data Manipulation (DML)

1. INSERT a New Record to a Table.mp4

08:44

2. Insert Without Specifying Column Names.mp4

09:10

3. UPDATE a Records Field Values.mp4

07:12

4.1 emp dept.zip

4. CAUTION! How an UPDATE Query Can Go Wrong.mp4

04:08

5. Update a Record Using Single-Row Functions.mp4

04:15

6. A Good Exercise Extract Employees Email Address.mp4

01:50

7. Hints on How to Extract Employees Email Address.html

8. Solution Extract Employees Email Address.mp4

12:53

9.1 emp dept.zip

9. DELETE a Tables Record.mp4

06:08

10. Insert Records with Nested Select Queries.mp4

05:59

16. SQL Data Definition Language (DDL)

1. SQL Data Types Revised.mp4

12:34

2. Bookstore Data Set Lets Move It to Database.mp4

03:51

3. Create Your First Table!.mp4

08:19

4. Insert Data to Your New Table.mp4

07:31

5. Change Column Data Type.mp4

07:11

6. Rename Column.mp4

03:33

7. Add a New Column to Table.mp4

04:11

8. Constraints in SQL.mp4

01:04

9. Primary Keys.mp4

14:04

10. NOT NULL Constraint.mp4

04:34

11. UNIQUE Constraint.mp4

04:21

12. DEFAULT Constraint.mp4

04:10

13. Foreign Keys.mp4

07:31

14. Use Foreign Keys with Joins - Books & Publishers.mp4

06:19

15. Foreign Keys - Properties.mp4

06:15

16. Drop Column.mp4

00:40

17. DROP Table.mp4

01:01

18. Create a New Table with Select Statement.mp4

04:35

19. A Trick to Create an Empty Table with Select Statement.mp4

02:45

20. Insert New Records Using Select Statement.mp4

05:38

21. Views.mp4

03:29

22. Schemas.mp4

01:32

23. Create & Use Schemas.mp4

04:11

17. Access Control

1. Introduction to Access Control.mp4

01:21

2. Create User.mp4

03:01

3. Grant SELECT to User.mp4

02:30

4. Grant Insert & Update to User.mp4

03:04

5. Revoke Privilege from User.mp4

01:51

6. User Groups.mp4

04:29

Description

A course to make you an SQL genius!

What You'll 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.

Who is this for?

Students aspiring to become data analysts, scientists or engineers

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.

What You Need to Know?

Have a PC or laptop to work on. Your old clunky notebook will do.

Can work on any operating system (Windows, Linux & MacOS).

More details

Description
"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.
Who this course is for:
Students aspiring to become data analysts, scientists or engineers
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.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Sameh Sharaf

Instructor's Courses

A data engineer, working with data since 2010. Passionate for teaching as for learning.I'm a certified AWS Solution Architect - Associate and Google Cloud Data Engineer Professional. Experienced with MS Azure and Databricks.I enjoy building data solutions, aspiring to be a data architect.If you don't find me online, I can be probably playing badminton, going to short hikes or traveling somewhere around the globe for pleasure or business.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.