SQL The Complete Guide: SQL from Beginner to Advanced

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

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

1. Introduction

1. What is a Database

2. Schemes and Tables

3.1 dvdrental.zip

3. Preparing the Ground

2. SQL Fundamentals

1. Section Introduction

2. Starting Queries

3. Comments on Queries

4. Renaming Columns in Queries

5. Using DISTINCT

6. Using WHERE

7. AND, OR and NOT Operators

8. Filtering with BETWEEN

9. Filtering with IN

10. Filtering with LIKE

11. Using ORDER BY

12. Using LIMIT

13. Using COUNT

14. About Coding Exercises

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

2. Using GROUP BY

3. MAX, MIN, AVG and SUM Aggregation Functions

4. Using HAVING

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

2. Using INNER JOIN in Queries

3. Using LEFT JOIN in Queries

4. Using RIGHT JOIN in Queries

5. Using FULL JOIN in Queries

6. Using CROSS JOIN in Queries

7. Using UNION in Queries

8. Using UNION ALL in Queries

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

2. STRING Functions Part 1

3. STRING Functions Part 2

4. Date and Time Functions Part 1

5. Date and Time Functions Part 2

6. Mathematical Functions Part 1

7. Mathematical Functions Part 2

8. CAST Function

9. NULLIF Function

10. COALESCE Function

11. CASE Conditional

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

2. Subqueries

3. Common Table Expressions (CTE)

4. EXISTS Operator

5. Window Functions Part 1

6. Window Functions Part 2

7. Window Functions Part 3

8. Advanced SQL Exercise 1.html

9. Advanced SQL Exercise 2.html

10. Advanced SQL Exercise 3.html

11. Next Steps

Files.zip

139,000 تومان

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

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

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

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