PostgreSQL and MySQL for Beginners

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

Learn most popular SQL dialects, PostgreSQL & MySQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MySQL

1. Setting up PostgreSQL and PGAdmin

1. Installing PostgreSQL and pgAdmin in your PC

2. If pgAdmin is not opening....html

2. Installing MySQL

1. Installing and Setting up MySQL

3. Course Resources

1. Course resources.html

4. Fundamental SQL statements

1. CREATE in PostgreSQL

2. CREATE in MySQL

3. INSERT in PostgreSQL

4. INSERT in MySQL

5. Import data from File in PostgreSQL

6. Import data from File in MySQL

7. SELECT statement in PostgreSQL

8. SELECT statement in MySQL

9. SELECT DISTINCT in PostgreSQL

10. SELECT DISTINCT in MySQL

11. WHERE in PostgreSQL

12. WHERE in MySQL

13. Logical Operators in PostgreSQL

14. Logical Operators in MySQL

15. UPDATE in PostgreSQL

16. UPDATE in MySQL

17. DELETE in PostgreSQL

18. DELETE in MySQL

19. ALTER Part 1 in PostgreSQL

20. ALTER Part 2 in PostgreSQL

21. ALTER in MySQL

5. Restore and Back-up in PostgreSQL

1. Restore and Back-up

2. Debugging restoration issues

3. Creating DB using CSV files

4. Debugging summary and Code for CSV files.html

6. Restore and Back-up in MySQL

1. Restoring and Back-up in MySQL

2. Restore and Back-up in MySQL

7. Selection commands Filtering

1. IN in PostgreSQL

2. IN in MySQL

3. BETWEEN in PostgreSQL

4. BETWEEN in MySQL

5. LIKE in PostgreSQL

6. LIKE in MySQL

8. Selection commands Ordering

1. Side Lecture Commenting in SQL

2. ORDER BY in PostgreSQL

3. ORDER BY in MySQL

4. LIMIT in PostgreSQL

5. LIMIT in MySQL

9. Aliases

1. AS in PostgreSQL

2. AS in MySQL

10. Aggregate Commands

1. COUNT in PostgreSQL

2. COUNT in MySQL

3. SUM in PostgreSQL

4. SUM in MySQL

5. AVERAGE in PostgreSQL

6. AVERAGE in MySQL

7. MIN & MAX in PostgreSQL

8. MIN & MAX in MySQL

11. Group By Commands

1. GROUP BY in PostgreSQL

2. GROUP BY in MySQL

3. HAVING in PostgreSQL

4. HAVING in MySQL

12. Conditional Statement

1. CASE WHEN in PostgreSQL

13. JOINS

1. Introduction to Joins

2. Concepts of Joining and Combining Data

3. Preparing the data

4. Inner Join in PostgreSQL

5. Inner Join in MySQL

6. Left Join in PostgreSQL

7. Left Join in MySQL

8. Right Join in PostgreSQL

9. Right Join in MySQL

10. Full Outer Join in PostgreSQL

11. Full Outer Join in MySQL

12. Cross Join in PostgreSQL

13. Cross Join in MySQL

14. Intersect and Intersect ALL in PostgreSQL

15. Except in PostgreSQL

16. Except in MySQL

17. Union in PostgreSQL

18. Union in MySQL

14. Subqueries

1. Subqueries Subquery in WHERE clause in PostgreSQL

2. Subqueries Subquery in FROM clause in PostgreSQL

3. Subqueries Subquery in SELECT in PostgreSQL

4. Subqueries in MySQL

15. Views and Indexes

1. VIEWS in PostgreSQL

2. VIEWS in MySQL

3. INDEX in PostgreSQL

4. INDEX in MySQL

16. String Functions

1. LENGTH in PostgreSQL

2. UPPER LOWER in PostgreSQL

3. REPLACE in PostgreSQL

4. TRIM, LTRIM, RTRIM in PostgreSQL

5. CONCATENATION in PostgreSQL

6. SUBSTRING in PostgreSQL

7. LIST AGGREGATION in PostgreSQL

8. String Functions Part 1 in MySQL

9. String Functions Part 2 in MySQL

17. Mathematical Functions

1. CEIL & FLOOR in PostgreSQL

2. RANDOM in PostgreSQL

3. SETSEED in PostgreSQL

4. ROUND in PostgreSQL

5. POWER in PostgreSQL

6. Mathematical Functions in MySQL

18. Date-Time Functions

1. CURRENT DATE & TIME in PostgreSQL

2. AGE in PostgreSQL

3. EXTRACT in PostgreSQL

4. Date-Time Functions in MySQL

19. PATTERN (STRING) MATCHING

1. PATTERN MATCHING BASICS

2. Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)

3. Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)

4. Pattern matching in MySQL

20. Congratulations

1. The final milestone!

2. Bonus Lecture.html

45,900 تومان

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

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

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

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