SQL 101: A Beginner’s Guide to Structured Query Language

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

SQL Fundamentals: Get Started with Database Queries and Boost Your Data Skills

1. Course Overview

1. Course Overview

2. Introduction to SQL (Structured Query Language)

1. Introduction

2. The Relational Model

3. MySQL Workbench installation

4. Summary

3. Understanding Basic SQL Syntax

1. Introduction to the Section

2. Basic SQL Commands - SELECT

3. Basic SQL Commands - INSERT

4. Basic SQL Commands - UPDATE

5. Basic SQL Commands - DELETE

6. Course Housekeeping

7. Summary

4. Querying Data with the SELECT Statement

1. Introduction to the Section

2. Demo - SELECT

3. The SELECT List

4. SELECT List Wildcard - -

5. The FROM Clause

6. Demo - FROM Clause

7. How to Constrain the Result Set

8. DISTINCT and NOT DISTINCT

9. Demo - Distinct

10. Summary

5. Filtering Results with the WHERE Clause

1. The WHERE Clause

2. Demo - WHERE Clause

3. Boolean Operators

4. The AND Keyword

5. Demo - AND

6. The OR Keyword

7. Demo - OR

8. Other Boolean Operators

9. BETWEEN

10. Demo - BETWEEN

11. LIKE

12. Demo - LIKE

13. IN

14. Demo - IN

15. IS

16. IS NOT

17. Demo - IS AND IS NOT

18. Summary

6. Shaping Results with ORDER BY and GROUP BY

1. Introduction to the Section

2. ORDER BY

3. Demo - ORDER BY

4. Set Functions

5. Demo - Set Functions

6. Set Function And Qualifiers

7. Demo - Set Function And Qualifiers

8. GROUP BY

9. Demo - GROUP BY

10. HAVING

11. Demo - HAVING

12. Summary

7. Matching Different Data Tables with JOINs

1. Introduction to the Section

2. CROSS JOIN

3. Demo - CROSS JOIN

4. INNER JOIN

5. Demo - INNER JOIN

6. OUTER JOINs

7. LEFT OUTER JOIN

8. Demo - LEFT OUTER JOIN

9. RIGHT OUTER JOIN

10. Demo - RIGHT OUTER JOIN

11. FULL OUTER JOIN

12. Demo - FULL OUTER JOIN

13. SELF JOIN

14. Summary

8. Adding, Changing, and Removing Data

1. Introduction to the Section

2. INSERT

3. Demo - INSERT

4. BULK INSERT

5. Demo - BULK INSERT

6. UPDATE

7. Demo - UPDATE

8. DELETE

9. Demo - DELETE

10. Summary

9. Creating Database Tables

1. Introduction to the Section

2. CREATE DATABASE

3. Demo - CREATE DATABASE

4. CREATE TABLE

5. Demo - CREATE TABLE

6. NULL Values

7. PRIMARY KEY

8. CONSTRAINT

9. ALTER TABLE

10. DROP TABLE

11. Demo - CREATE TABLE

12. Summary

10. Conclusion

1. Final Words And Conclusion

235,000 تومان

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

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

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

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