SQL Mastery: Learn Enough SQL To Be A Professional [2023]

Focused View

SDE Arts | Octavo,Ahmed Ibrahim

4:34:45

57 View

1. Introduction

1. Course Intro.mp4

02:43

2. Database Overview.mp4

02:02

3. Tools and Work Environment illustration.mp4

01:25

4. Work Environment hands-on.mp4

02:29

5. DBMS & RDBMS Overview.mp4

03:03

2. The Basics of SQL

1. SQL Queries.mp4

02:18

2. Select Statement.mp4

02:29

3. Hands-On Select an existing table.mp4

02:44

4. Hands-On Select a particular column.mp4

02:53

5. Hands-On Select number of columns.mp4

03:42

6. Select Distinct.mp4

01:19

7. Hands-On Select Distinct and count unique rec.mp4

02:50

8. Where Statement.mp4

02:01

9. Hands-On Where and filtering records.mp4

03:56

10. Add Some Logic for conditions.mp4

02:40

11. Hands-On Logics for conditions.mp4

05:01

12. Aliases.mp4

01:54

13. Hands-On Aliases and renaming columns.mp4

05:21

14. Limitations.mp4

02:21

15. Hands-On Limitations by examples.mp4

03:13

16. Inserting Data.mp4

01:54

17. Hands-On Inserting records with column names.mp4

03:13

18. Hands-On Inserting values for all columns.mp4

02:45

19. Hands-On Inserting data for specified columns.mp4

02:51

20. Hands-On Inserting many records.mp4

04:20

21. Updating data.mp4

02:16

22. Hands-On Updating data by examples.mp4

04:40

23. Hands-On Updating all records.mp4

01:59

24. Deleting Data.mp4

02:46

25. Hands-On Deleting records by examples.mp4

04:07

26. Comments.mp4

03:27

27. Hands-On Types of Comments.mp4

03:30

28. SQL Operators.mp4

03:36

29. Hands-On SQL Arithmetic Operators.mp4

04:42

30. Hands-On SQL Comparators.mp4

04:25

31.1 work files.zip

31. Hands-On SQL BETWEEN and IN Operators.mp4

04:31

3. SQL Constraints & Data Types

1. Data Types.mp4

02:21

2. Hands-On Data Types by example.mp4

03:17

3. Adding Constraints.mp4

03:11

4.1 work files.zip

4. Hands-On Constraints by examples.mp4

04:00

4. Creating DB and Tables

1. Creating DB and Tables.mp4

02:31

2. Hands-On Creating Tables by examples.mp4

08:15

3. Hands-On Creating Tables from tables.mp4

02:53

4. Dropping DB and Tables.mp4

02:53

5. Hands-On Dropping Tables.mp4

02:00

6. Alter tables.mp4

03:12

7.1 work files.zip

7. Hands-On Alter table by examples.mp4

10:45

5. Data Sorting and Conditions

1. Orders.mp4

01:55

2. Hands-On Order by.mp4

03:52

3. Union.mp4

04:32

4. Hands-On Union and Union All.mp4

04:49

5. Any and All.mp4

01:47

6. Using Any Operator Hands-On.mp4

01:40

7. SELECT ALL example 1 Hands-On.mp4

03:09

8. ALL with two tables example 2 Hands-On.mp4

03:55

9. Group By.mp4

01:28

10. Hands-On Group By.mp4

05:12

11. Having clause.mp4

02:59

12. Use Having clause to filter data Hands-On.mp4

05:44

13. Wildcards.mp4

01:30

14. Hands-On Like and Wildcards.mp4

04:17

15. Case Statement.mp4

03:05

16.1 work files.zip

16. Performing tasks with Case Clause Hands-On.mp4

03:43

6. Functional Programming in SQL

1. The concept of function.mp4

01:21

2. Aggregate functions.mp4

02:31

3. Scalar functions.mp4

02:23

4.1 work files.zip

4. SQL Functions examples hands-on.mp4

14:33

7. SQL Joins

1. Joins overview.mp4

01:51

2. Inner Join.mp4

02:01

3. Inner Join hands-on.mp4

05:25

4. Left Join.mp4

02:03

5. Left Join hands-on.mp4

07:04

6. Right Join.mp4

02:20

7. Right Join hands-on.mp4

02:41

8. Full Outer Join.mp4

03:03

9.1 work files.zip

9. Full Outer Join hands-on.mp4

03:03

8. More Learning and Applying

1. Views in detail hands-on.mp4

07:30

2. SQL Project.mp4

02:49

3.1 work files.zip

3. SQL Project Solution Hints.mp4

03:46

Description

Learn all the SQL skills you need to know to develop, manipulate, manage and communicate with relational databases

What You'll Learn?

SQL Introduction, tools and DBMS vs RDBMS
The basics of SQL Queries and CRUD Skills
Working with Different data types and operations in SQL
Manipulating result tables and using aliases
SQL Constraints, Rules & Data Types
Data Sorting and Filtering by Orders
Combining tables with Union & Union All
Managing and Joining Multiple tables at the same time
Set Conditions and filtering fields and records using many ways
Creating DB and tables and essential skills for relational databases
Copying tables and Views
Functional Programming in SQL
Task to apply all the SQL fundamentals to be A SQL Professional

Who is this for?

SQL Beginners

Developers and Programmers

Non-Programmers

Software Engineers

Anyone who wants to become a Professional Database Engineer in the future

Data Engineers and Scientists

What You Need to Know?

No requirements to take this course. You will learn everything you need to know.

More details

Description
Hi, welcome to This Comprehensive SQL Bootcamp â€œSQL Mastery: Learn Enough SQL To Be A Professional [2023]â€
Developing, manipulation and managing relational databases with SQL is a very powerful and useful skill for any engineer, developer, programmers and also, non-programmers.
SQL is a tool that will open up many jobs and offers for you because of its great importance and benefits in the software industry and companies.
SQL is a must-have skill for anyone who wants to become a professional developer, engineer, or data scientist.
By the end of this course, you'll learn all the SQL skills you need to know to develop, manipulate, manage and communicate with relational databases effectively and in no time!
You will be able to manipulate and combine all of the SQL skills together, and you will become truly an expert in SQL and Relational Databases.

You'll learn:
SQL Introduction, Work Environment, DBMS vs RDBMS
The basics of SQL Queries and CRUD Skills
Working with Different data types and operations in SQL
SQL Constraints, Rules & Data Types
Data Sorting and Filtering by Orders
Combining tables with Union & Union All
Managing and Joining Multiple tables at the same time
Set Conditions and filtering fields and records using many ways
Creating Databases and tables and essential skills for relational databases
Copying tables and Views
Functional Programming in SQL
Task to apply all the SQL fundamentals to be A SQL Professional

Hi, my name is Ahmed Ibrahim El-mohandes, I'm a Lead Software Engineer and Data Science Professional and I'll be the instructor for this SQL Programming Course. Iâ€™ll be very very happy to teach you this Course.
Learn and practice the essential concepts of SQL Programming to become a professional database engineer effectively and quickly without wasting your valuable time.
So, what are you waiting for, enroll now to go through this complete and powerful course to learn on of the most popular skills in the software industry, SQL.
Letâ€™s get started
Who this course is for:
SQL Beginners
Developers and Programmers
Non-Programmers
Software Engineers
Anyone who wants to become a Professional Database Engineer in the future
Data Engineers and Scientists

User Reviews

Rating

average 0

Total votes0

Focused display

SDE Arts | Octavo provides Software Development & Data Science online video courses.SDE Arts | Octavo's main objective is to provide high-value skills in Software Technologies by using high quality, well prepared, focused and direct to the point videos to save your precious time.We will show you practically how to become very skilled in the Software Engineering field to make your career better and move forward with amazing speed.We taught for more than 500,000 happy students, developers and engineers from over 190 countries around the world.

Ahmed Ibrahim

Instructor's Courses

Software Engineer | Data Science Professional | Course Creator/DeveloperI taught for more than 300,000 developers and engineers from over 175 countries around the world.- Programming Languages: Python, R, JavaScript, Java and Go.- Data Science: Data Analysis and Visualization tools and Libraries with Python, R, SQL and Spark.- Databases: Relational and Non-Relational.- Applied experience with many programming languages and tools, also a proficient knowledge and experience in Software Engineering and Data Science with skills to analyze, design and develop. - Bachelor's degree of Electrical, Communications and Computer Engineering.I'm always have a passion to develop my work and I like to simplify and clarify Software and Data Science skills and tools, and sharing my skills and expertise with others via high quality, and direct to point video training courses.

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.