SQL The Complete Guide: SQL from Beginner to Advanced

Focused View

Kauann Henrique Oliveira

3:29:25

192 View

1. Introduction

1. What is a Database.mp4

01:52

2. Schemes and Tables.mp4

01:49

3.1 dvdrental.zip

3. Preparing the Ground.mp4

05:18

2. SQL Fundamentals

1. Section Introduction.mp4

00:38

2. Starting Queries.mp4

04:42

3. Comments on Queries.mp4

04:09

4. Renaming Columns in Queries.mp4

03:04

5. Using DISTINCT.mp4

01:55

6. Using WHERE.mp4

05:00

7. AND, OR and NOT Operators.mp4

06:59

8. Filtering with BETWEEN.mp4

04:02

9. Filtering with IN.mp4

02:16

10. Filtering with LIKE.mp4

05:52

11. Using ORDER BY.mp4

04:58

12. Using LIMIT.mp4

03:01

13. Using COUNT.mp4

03:54

14. About Coding Exercises.mp4

00:32

15. SQL Fundamentals Exercise 1.html

16. SQL Fundamentals Exercise 2.html

17. SQL Fundamentals Exercise 3.html

18. SQL Fundamentals Exercise 4.html

Files.zip

3. Grouping your Data

1. Section Introduction.mp4

00:15

2. Using GROUP BY.mp4

06:45

3. MAX, MIN, AVG and SUM Aggregation Functions.mp4

05:29

4. Using HAVING.mp4

04:03

5. Grouping your Data Exercise 1.html

6. Grouping your Data Exercise 2.html

7. Grouping your Data Exercise 3.html

Files.zip

4. Crossing and Uniting Information

1. Section Introduction.mp4

00:17

2. Using INNER JOIN in Queries.mp4

07:48

3. Using LEFT JOIN in Queries.mp4

09:45

4. Using RIGHT JOIN in Queries.mp4

04:34

5. Using FULL JOIN in Queries.mp4

01:25

6. Using CROSS JOIN in Queries.mp4

00:57

7. Using UNION in Queries.mp4

07:00

8. Using UNION ALL in Queries.mp4

03:10

9. Crossing and Uniting Information Exercise 1.html

10. Crossing and Uniting Information Exercise 2.html

11. Crossing and Uniting Information Exercise 3.html

12. Crossing and Uniting Information Exercise 4.html

Files.zip

5. Basic and Conditional Functions

1. Section Introduction.mp4

00:17

2. STRING Functions Part 1.mp4

09:29

3. STRING Functions Part 2.mp4

10:33

4. Date and Time Functions Part 1.mp4

04:59

5. Date and Time Functions Part 2.mp4

07:19

6. Mathematical Functions Part 1.mp4

06:07

7. Mathematical Functions Part 2.mp4

04:43

8. CAST Function.mp4

03:26

9. NULLIF Function.mp4

05:19

10. COALESCE Function.mp4

02:40

11. CASE Conditional.mp4

06:54

12. Basic and Conditional Functions Exercise 1.html

13. Basic and Conditional Functions Exercise 2.html

14. Basic and Conditional Functions Exercise 3.html

Files.zip

6. Advanced SQL

1. Section Introduction.mp4

00:26

2. Subqueries.mp4

07:13

3. Common Table Expressions (CTE).mp4

06:53

4. EXISTS Operator.mp4

04:11

5. Window Functions Part 1.mp4

01:40

6. Window Functions Part 2.mp4

06:19

7. Window Functions Part 3.mp4

08:57

8. Advanced SQL Exercise 1.html

9. Advanced SQL Exercise 2.html

10. Advanced SQL Exercise 3.html

11. Next Steps.mp4

00:31

Files.zip

Description

SQL for Data Manipulation and Data Analysis. Comprehensive SQL Course for Beginners and Experts Alike!

What You'll Learn?

Use SQL to query any relational database
Perform data analysis with SQL in the real-world situations
Write complex queries across multiple tables
Work with real-life database and learn everything that you need to create your own SQL reports

Who is this for?

People who want to start running their own queries with SQL

People who want to increase their earning potential

Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc...

Data Engineers and Data Scientists

Technology students learning about SQL

SQL enthusiasts :)

What You Need to Know?

No prior experience is necessary, even if you are a beginner and have no technical knowledge, the only thing you need is a computer!

If you already have prior technical knowledge, great! It's always good to review some concepts and learn new things, welcome!

More details

Description
Learn how to work with SQL for real with this course!

In recent years the data area has grown a lot and has been in great demand, the SQL language has been one of the requirements in several professional areas outside the technological scope, for example in some companies in the areas of marketing, finance, HR, they use SQL to carry out analyzes and make decisions! Learning SQL nowadays is essential to increase your chances in the job market.

You will learn with an effective method, from basic to advanced and understand SQL by applying it in practice with practical examples, and you will be ready to apply it immediately in the real world. In this course we will use the PostgreSQL database to execute our queries, but this knowledge can be applied to any database that uses SQL, such as MySQL, Oracle, SQL Server, Redshift...

What will you learn:

Concepts about Databases, schemes and tables
Basic and Intermediate SQL (WHERE command, ORDER BY command, Logical Operators, Conditionals)
Group data with aggregate functions using the GROUP BY command
Filter aggregated data with HAVING command
Perform all types of SQL JOINs (Inner, Left, Right, Cross, Full...)
String functions
Date and Time functions
Mathematical functions
Subqueries
CTEs (Common Table Expressions)
Window Functions
SQL Advanced Topics
Performance Improvements on Queries

Let's learn together, from basic to advanced of SQL! Check out the free preview videos for more information about the complete guide!
Who this course is for:
People who want to start running their own queries with SQL
People who want to increase their earning potential
Professionals who work with data analysis on a relational basis, from programmers to financial areas, marketing, etc...
Data Engineers and Data Scientists
Technology students learning about SQL
SQL enthusiasts :)

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Kauann Henrique Oliveira

Instructor's Courses

Hello, I'm Kauann Henrique de Oliveira and I have over 10 years of experience in the IT market. I'm excited to share my knowledge and help you achieve your goals.I'm a dedicated and enthusiastic professional who found his passion in data. Over the years, I have accumulated hands-on experience in software development and data engineering. My commitment is to provide engaging and practical courses that not only teach concepts, but also inspire practical application.Throughout my professional journey, I have worked in a number of companies and helped deliver projects that have generated a lot of value for them, where I have been able to apply and hone my skills. My approach is focused on providing practical and relevant knowledge that students can use immediately in the real world.What you can expect:Practical and engaging courses that tackle the area of data.Real-world examples and use cases for in-depth understanding.Ongoing support and active interaction in the course community.Why Learn With Me: I believe that learning is an ongoing journey, and my goal is to empower you to achieve your goals. Join me on a journey of discovery and professional growth. Let's learn, grow and reach new heights together!

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.