Mastering SQL and PostgreSQL: Go from SQL Beginner to Expert

سرفصل های دوره

Master SQL, PostgreSQL, Database: Practical Hands-on, Coding Exercises, Quizzes, Interview Prep, Lifetime Query Support

1. INTRODUCTION TO THE COURSE

1. Day 0 Course Overview & Content

2. Quick points about this learning journey.html

2. DAY 1 GETTING STARTED - DATABASE, SQL & INSTALLING POSTGRES

1. What is Database and SQL

2. Introduction to PostgreSQL

3. Installing PostgreSQL on Windows

4.1 Installing PostgreSQL on Mac.pdf

4. Installing PostgreSQL on Mac.html

5.1 Common Installation challenges and how to fix them.pdf

5. Common Installation challenges and how to fix them.html

6. Introduction to pgAdmin

3. DAY 2 QUERYING DATA - PART 1

1. SELECT

2. WHERE

3. AS (ALIAS)

4. DISTINCT

5. CODING EXERCISE 1

6. CODING EXERCISE 2

4. DAY 3 QUERYING DATA - PART 2

1. ORDER BY

2. LIMIT

3. BETWEEN

4. IN Keyword

5. LIKE

6. CODING EXERCISE 1

7. CODING EXERCISE 2

5. Quiz

1. SQL Querying Data.html

6. DAY 4 GROUPING & AGGREGATING DATA

1. AGGREGATION FUNCTIONS - AVG, MIN, MAX, SUM

2. COUNT

3. GROUP BY

4. HAVING

5. SUB-QUERY

6. CODING EXERCISE 1

7. CODING EXERCISE 2

7. Quiz 2

1. Grouping & Aggregating Data.html

8. DAY 5 JOINS

1. Introduction to JOINS

2. INNER JOIN

3. LEFT JOIN

4. RIGHT JOIN

5. FULL JOIN

6. UNION

7. MUST WATCH Lets Recap Joins one more time

8. CODING EXERCISE 1

9. CODING EXERCISE 2

10. CODING EXERCISE 3

9. Quiz 3

1. Joins.html

10. DAY 6 DATA TYPES & OPERATIONS

1. Data Types & how to choose the correct one

2. DateTime Functions

3. EXTRACT

4. Mathematical Functions

5. String Functions

6. CODING EXERCISE 1

7. CODING EXERCISE 2

11. Quiz 4

1. Data Types & Operations.html

12. DAY 7 CONDITIONAL EXPRESSIONS & OPERATORS

1. CAST

2. CASE

3. COALESCE

4. NULLIF

5. VIEW

6. CODING EXERCISE 1

7. CODING EXERCISE 2

13. Quiz 5

1. Conditional Expressions & Operators.html

14. DAY 8 CREATE DATABASE AND TABLES

1. Understanding Keys - Primary Key, Foreign Key

2. Constraints

3. Database - CREATE & DROP

4. CREATE TABLE

5. INSERT

6. UPDATE

7. ALTER

8. DELETE

9. DROP

10. TRUNCATE

11. CODING EXERCISE 1

12.1 Insert Statement.txt

12. INSERT statement for next coding exercise.html

13. CODING EXERCISE 2

15. Quiz 6

1. Quiz 6 Creating Database and Tables.html

16. DAY 9 BECOME JOB READY

1. Resume Preparation & Interview Tips

2.1 Resume Template.docx

2. Download Resume Template.html

3.1 Interview Questions.pdf

3. 50 SQL Interview Questions, explained to remember.html

17. [MUST WATCH] IMPORTANT NOTE

1. Final Video - Do Watch This

2.1 SQL Course Slides.pdf

2. Download Course Materials.html

3. Connect with me on LinkedIn.html

4. Bonus Section.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy