SQL Basics to Expert: Your Complete Learning Journey-English

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

SQL, MySQL, SQL queries, joins, views, indexing, aggregate functions, advanced SQL functions, and more.

1. Lets Begin SQL Basics to Expert Course

1. Why Choose This Course Top Benefits

2. Understanding Basics of SQL and Databases

1. Why Study SQL And Databases DB Users , Future Career Scope

3. RDBMS and NoSQL Explained

1. RDBMS and NoSQL

4. MySQL Features and Server-Client Setup

1. Features Of MYSQL , Server , Client, Installation

5. SQL Basics and Database Structure

1. SQL Basics and Database Structure

6. Table Modifications ALTER and DROP Commands

1. ALTER and DROP Commands

7. Data Manipulation INSERT, UPDATE, DELETE

1. INSERT, UPDATE, DELETE Command

8. Truncating Tables for Efficient Data Management

1. Truncating a Table

9. Mastering SELECT Statements and Alias Usage

1. Select Statement and Utilizing Alias

10. Query Refinement WHERE and DISTINCT

1. Where and Distinct Clause Usage and Implementation

11. Advanced Text Matching LIKE Clause & Wildcards

1. Like Clause and Usage of Wildcard Characters

12. Logical Operations in SQL

1. SQL BETWEEN Operator

2. SQL NOT Operator

3. SQL AND Operator

4. SQL OR Operator

5. SQL IN and NOT IN Keyword

13. Managing NULL Values in SQL

1. Handling NULL Values

2. IS NULL and NOT NULLOperator

14. Advanced Comparison in SQL

1. ANY and ALL Operator

15. Controlling Query Results with LIMIT and OFFSET Clauses

1. LIMIT and OFFSET clauses

16. Mastering Sorting ORDER BY Clause Explained

1. Order by Clause

17. Analyzing Data with SQL Functions

1. SQL MIN() and MAX() Functions

2. SQL COUNT Function

3. SQL SUM Function

4. SQL AVG Function

18. Transforming Data with SQL Functions

1. SQL String Functions

2. SQL Numeric Functions

3. SQL Date Time Functions

19. Simplified Understanding SQL GROUP BY Clause

1. SQL GROUP BY

20. Simplified Understanding SQL HAVING Clause

1. SQL HAVING Clause

21. Ensuring Data Integrity with SQL Constraints

1. Constraints - NOT NULL

2. Constraints - UNIQUE

3. Constraints - CHECK

4. Constraints - Foreign Key

22. Mastering SQL Joins

1. Joins - Equi Join Inner Join

2. Left and Right Outer Join

23. Indexing in SQL

1. SQL Index

24. AutoIncremeting a column

1. SQL Auto Increment

25. Database Views

1. SQL Views

139,000 تومان

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

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

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

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