SQL 101: Mastering the Basics

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

Building a Strong Foundation in SQL

1. Introduction to Databases and SQL

1. Welcome to SQL 101 Mastering the Basics

2. Introduction.html

3. Define a Database

4. Types of Databases.html

5. Databases.html

6. Common Database Management Systems (DBMSs).html

7. Common Database Management Systems (DBMSs).html

8.1 How to Download and Install SQLite to Your Computer.html

8.2 SQLite Installation.html

8. Setting Up Your Environment - Installing a DBMS and Creating a Sample Database

9. Creating a Database.html

2. Basic SQL Queries

1. Introduction to Basic SQL Queries.html

2. Introduction to SQL

3. Understanding CREATE TABLE and SELECT-FROM-Statement in SQL

4. Introduction to SQL.html

5. Creating a Simple Database.html

6. The use of Characters in SQL.html

7. The Use of Characters in SQL.html

8. Common Data Types in SQL Databases.html

9. Common Data Types in SQL.html

10. Adding Comments.html

11. SELECT-FROM Statement in SQL.html

12. SQL Commands - CREATE TABLE, INSERT INTO, SELECT, FROM, WHERE

13. Exploring Data with the SELECT-FROM-WHERE-INSERT INTO Clauses.html

14. Using SELECT-FROM-WHERE.html

3. Filtering Data

1. Filtering Based on Conditions (=, , , , =, =).html

2. Filtering Data in SQL.html

3. Combining Conditions (AND, OR, and NOT).html

4. Combining Conditions (AND, OR, and NOT).html

5. Sorting Data - Ascending and Descending Order.html

6. Filtering and Sorting Data Real-World Example

7. Sorting Data - Ascending and Descending Order.html

4. Data Manipulation

1. Changing Existing Data with UPDATE.html

2. SQL UPDATE statement.html

3. The DELETE Statement.html

4. SQL DELETE statement.html

5.1 SQL Alias.html

5. Understanding Aliases.html

6. Understanding Aliases.html

7. Real-World Example - Applying Aggregate Functions.html

8. Analyzing Sales Data.html

9. Grouping data using GROUP BY.html

10. Applying Aggregate Functions (COUNT, SUM, AVG, MAX, and MIN) and GROUP BY

11. SQL GROUP BY Mastery Quiz.html

12. Sales Analysis by Region.html

5. CAPSTONE - Course Conclusion

1. Applying Your Skills in Real-World Scenarios with a Practical Project.html

2. Course Project - Creating a Mini Database Application.html

45,900 تومان

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

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

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

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