SQL Bootcamp 2024: Master SQL & PostgreSQL - Hands-On Course

Focused View

Temotec Learning Academy

4:04:26

6 View

1. Introduction

1. Course Intro.mp4

04:49

2. Beginner PostgreSQL Downloading & Installing + Preparing Airlines Database

1. SQL PostgreSQL Down and install.mp4

03:02

2. PostgreSQL Database creation.mp4

01:09

3.1 airlines.zip

3. SQL Restore.mp4

01:13

3. Beginner Database Airlines Overview

1. SQL Database Overview Part 1.mp4

02:11

2. SQL Database Overview Part 2.mp4

03:54

3. SQL Data Types.mp4

01:13

4. Beginner SQL Basics Part 1

1. Select Statement.mp4

04:54

2. Select Challenge Solution.mp4

02:55

3. Select Statement For all Airlines Database Tables.mp4

03:34

4. Distinct.mp4

01:53

5. Beginner SQL Basics Part 2

1. Where Clause.mp4

07:15

2. Operators used with Where Clause.mp4

04:43

3. Where Clause + AND & Where Clause + OR.mp4

03:14

4. Where Clause + LIKE.mp4

04:57

5. (Where Clause + BETWEEN & IN) & AS.mp4

05:51

6. Beginner SQL Basics Part 3

1. LIMIT & ORDER BY.mp4

07:49

2. FETCH vs LIMIT.mp4

02:54

3. NOT IN.mp4

03:55

4. ISNULL & IS NOT NULL.mp4

02:56

5. CAST.mp4

03:55

7. Intermediate SQL Aggregations

1. COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.mp4

04:09

2. SUM( ) Function.mp4

00:59

3. MIN( ) , MAX( ) & AVG( ) Functions.mp4

01:55

4. GROUP BY & HAVING.mp4

02:08

8. Intermediate SQL Conditional

1. CASE Clause in SQL.mp4

05:53

2. NULLIF() Function in SQL.mp4

03:55

3. COALESCE() Function in SQL.mp4

02:32

9. Intermediate SQL Time Data management

1. Overview of Time Functions in PostgreSQL.mp4

02:58

2. TIMESTAMP EXTRACT().mp4

03:11

3. DATE TRUNC() & DATE PART().mp4

08:04

4. Double Column + DATE IN PostgreSQL & CURRENT DATE & now( ).mp4

02:59

10. Intermediate SQL Joins

1. INNER JOIN.mp4

06:38

2. Joins Types Overview.mp4

08:48

3. LEFT OUTER JOIN.mp4

03:54

4. Deep understanding of LEFT JOIN.mp4

03:25

5. RIGHT OUTER JOIN.mp4

02:56

6. FULL OUTER JOIN.mp4

05:24

7. CROSS JOIN.mp4

02:29

8. UNION, UNION ALL, INTERSECT & EXCEPT.mp4

05:54

9. SELF JOIN.mp4

02:32

10. USING.mp4

02:03

11. NATURAL JOIN.mp4

01:53

11. Intermediate Sub-queries & Common Table Expression in SQL

1. Sub-queries.mp4

06:44

2. SQL Sub-query + EXISTS, ANY OR ALL.mp4

08:56

3. Common Table Expression.mp4

09:30

12. Advanced PostgreSQL Math & Window functions

1. Math Functions.mp4

03:55

2. Window Functions OVER().mp4

02:54

3. Window Functions RANK() + OVER() & NTILE() + OVER().mp4

05:31

4. Window Functions OVER() + LEAD().mp4

05:52

5. Window Functions OVER() + LAG().mp4

04:04

13. Advanced PostgreSQL String Functions

1. PostgreSQL POSITION Function.mp4

02:51

2. STRPOS() & REPLACE() in PostgreSQL.mp4

04:16

3. PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT PART() Functions.mp4

04:55

4. PostgreSQL CONCAT Function.mp4

03:55

5. PostgreSQL LOWER(), UPPER() & INITCAP() Functions.mp4

04:56

14. Advanced Other SQL Functions

1. GROUPING SETS(), ROLLUP(), CUBE().mp4

05:01

2. SELECT Statement + INTO & SELECT Statement + INTO + IN.mp4

04:10

3. VIEW().mp4

04:01

15. Lots of SQL Challenges

1. Challenge(1).html

2. Solution.html

3. Challenge(2).html

4. Solution.html

5. Challenge(3).html

6. Solution.html

7. Challenge(4).html

8. Solution.html

9. Challenge(5).html

10. Solution.html

11. Challenge(6).html

12. Solution.html

13. Challenge(7).html

14. Solution.html

15. Challenge(8).html

16. Solution.html

17. Challenge(9).html

18. Solution.html

19. Challenge(10).html

20. Solution.html

21. Challenge(11).html

22. Solution.html

23. Challenge(12).html

24. Solution.html

25. Challenge(13).html

26. Solution.html

16. Final Exam

1. Final Exam Quiz 1.html

2. Solution.html

3. Final Exam Quiz 2.html

4. Solution.html

5. Final Exam Quiz 3.html

6. Solution.html

7. Final Exam Quiz 4.html

8. Solution.html

9. Final Exam Quiz 5.html

10. Solution.html

11. Final Exam Quiz 6.html

12. Solution.html

17. Bonus Section

1. Thank you.html

Description

Master PostgreSQL applicable to Oracle SQL, Microsoft SQL Server, and MySQL for Data Science, Apps and Web development.

What You'll Learn?

Using Real World PostgreSQL Database Airlines Database.
Use Python Pandas to Analyze and visualize Postgres Data Output.
SQL Test Your Self, SQL Challenges, SQL Final Exam and more
Use Python to visualize Postgres Data Output and get your Conclusion about Data.
Use SQL to create databases.
Use SQL to insert data into a table.
Use SQL to Query & retrieve data from databases.
Use SQL to Sort records after retrieving from databases.
Use SQL to Group data by specific conditions.
Use SQL to Filter data by using where clause.
How & when to use Joins types in SQL.
How to create and deal with Sub-queries in SQL.
How to create and deal with common table expression in SQL.
Use SQL to perform data analysis of real world databases
Use SQL to perform advanced techniques to retrieve data from databases.

Who is this for?

Are you want to learn more about SQL & PostgreSQL ?

Are you ready for upcoming SQL interview questions?

Are you want to use SQL in Data Analysis, Apps Development or Web Development?

What You Need to Know?

Computer and internet.

No prior knowledge required for this course.

More details

Description
Ready to take your data querying skills to the next level? Look no further than this comprehensive PostgreSQL course!

Using real-world examples from the Airlines Database, this course covers everything you need to know about PostgreSQL, including:

- Installing and creating tables in PostgreSQL
- Understanding SELECT statements, WHERE clauses, and operators
- Advanced techniques like GROUP BY, HAVING, and Aggregation QueriesÂ
- Handling time and date data in SQL
- Table joins, sub-queries, and window functions for analytics
- SQL challenges and a final exam for extra practice

But why learn SQL in the first place? SQL was originally created to enable non-IT professionals to query data from datasets without needing to ask a programmer for help. By learning SQL, you'll develop new mental models for thinking about data, which is a powerful skill in today's data-driven world.

Plus, PostgreSQL is free, open, and unlimited, making it the perfect tool to learn about relational databases. Its advanced implementation of SQL is very close to the SQL standard, making your knowledge transferable to other SQL databases.

And perhaps the most compelling reason to learn SQL? It can do wonders for your career. Having PostgreSQL knowledge on your resume and online profile can make you a highly attractive candidate to recruiters, opening up new career opportunities and possibilities for advancement.

This course is taught by a top-rated instructor with years of real-world experience using PostgreSQL for data analysis. The lectures are clear, concise, and filled with practical examples to solidify your learning.

By the end of this course, you'll have job-ready skills in:

- Installing and configuring PostgreSQL
- Designing and normalizing database schemas
- Querying data with complex SELECT statements
- Using aggregate functions for analysis
- Joining multiple tables together
- Tuning queries for optimal performance

So what are you waiting for? Enroll in this course today and become a PostgreSQL querying expert! Your journey to becoming a data analysis pro starts now.
Who this course is for:
Are you want to learn more about SQL & PostgreSQL ?
Are you ready for upcoming SQL interview questions?
Are you want to use SQL in Data Analysis, Apps Development or Web Development?

User Reviews

Rating

average 0

Total votes0

Focused display

Hello there! With over 350,000 happy students enrolled in my courses, I'm thrilled to be sharing my programming and data science expertise with you.As a programmer and data scientist, I've mastered several programming languages, including Python, SQL, JavaScript, R Programming, as well as tools like Excel, Tableau, Jupyter Notebook, Apache Cassandra, Apache Spark, Apache Airflow, Apache Kafka, AWS, and R Studio. I'm passionate about teaching and sharing my knowledge with the community.When I'm not coding, you can usually find me hiking or reading a good book. I believe that lifelong learning is essential for personal development, and my courses are designed to encourage students to continue learning outside of formal education.I update my courses every month to add new sections based on your feedback and requests. So don't wait – enroll in my courses now and start your journey towards mastering programming, web development, data science, data Engineering and Machine Learning!

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.