SQL Masterclass – For Data Science

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

Structured Query Language

1. SQL Set Up

1. SQL Set Up

2. Introduction to SQL

1.1 Section 2.pdf

1. Introduction To SQL

2. Introduction To Database

3. Types Of Databases

4. What Is A DBMS

5. What Is A Table, Record, Row, Column

3. Data Types In SQL

1.1 Section 3.pdf

1. Data Types In SQL

2. STRING Data Types

3. NUMERIC Data Types

4. DATE & TIME Data Types

4. Working With Database

1.1 Section 4.pdf

1. Pulling list of database

2. Creating A Database

3. Using A Database

5. Working With Tables

1.1 Section 5.pdf

1. Creating A Table

2. Describing A Table

3. Pulling The List Of Tables In A Database

4. Inserting Records In A Table

5. Inserting record without specifying column name

6. Inserting Record With Changing Order Of Column

7. Inserting Record In Specified Column

8. Inserting Multiple Records At A Time

6. Fetching Records From A Table

1.1 Section 6.pdf

1. Fetching Records From All Columns

2. Fetching Records From Specific Columns

3. Fetching Specific Number Of Records

4. Fetching Specific Number Of Records From Specific Record

7. Comparison Operators In SQL

1.1 Section 7.pdf

1. Comparison Operators In SQL

2. WHERE Clause

3. WHERE Clause With EQUAL TO Operator

4. WHERE Clause With NOT EQUAL TO Operator

5. WHERE Clause With GREATER THAN Operator

6. WHERE Clause With LESS THAN Operator

7. WHERE Clause With GREATER THAN or EQUAL TO Operator

8. WHERE Clause With LESS THAN or EQUAL TO Operator

8. Understanding NULL & NOT NULL Values

1.1 Section 8.pdf

1. NULL Values

2. IS NOT NULL Values

9. Logical Operators In SQL

1.1 Section 9.pdf

1. Logical Operators In SQL

2. WHERE Clause With AND Operator

3. WHERE Clause With OR Operator

4. Combination of AND & OR Operator

5. WHERE Clause With IN Operator

6. WHERE Clause With NOT IN Operator

7. WHERE Clause With BETWEEN Operator

8. WHERE Clause With NOT BETWEEN Operator

9. BETWEEN Operator With IN Operator

10. NOT BETWEEN Operator With IN Operator

11. LIKE Operator

12. Wildcard Characters

13. Using Wildcard Characters With LIKE Operator - Zero Or More Characters

14. Using Wildcard Characters With LIKE Operator - Single Character

15. NOT LIKE Operator

16. Using Wildcard Characters With NOT LIKE Operator - Zero Or More Characters

17. Using Wildcard Characters With NOT LIKE Operator - Single Character

10. Data Sorting In SQL

1.1 Section 10.pdf

1. Sorting The Data In Ascending Order

2. Sorting The Data In Descending Order

11. Constraints in SQL

1.1 Section 11.pdf

1. Constraints in SQL

2. NOT NULL Constraint

3. UNIQUE Constraint

4. PRIMARY Key

5. AUTO_INCREMENT

6. AUTO_INCREMENT From A Particular Number

12. ALIASES In SQL

1.1 Section 12.pdf

1. Aliases

13. Arithmetic Operators In SQL

1.1 Section 13.pdf

1. Arithmetic Operators In SQL

2. Understanding Arithmetic Operator - ADD

3. Understanding Arithmetic Operator - SUBTRACT

4. Understanding Arithmetic Operator - MULTIPLY

5. Understanding Arithmetic Operator - DIVIDE

6. Understanding Arithmetic Operator - MODULUS

14. Selecting Distinct Items

1.1 Section 14.pdf

1. SELECT DISTINCT Statement

15. Altering Tables In SQL

1.1 Section 15.pdf

1. ALTER TABLE statement

2. ALTER TABLE - Add One Column Without Constraints

3. ALTER TABLE - Add More Than One Column Without Constraints

4. ALTER TABLE - Add Column By Position Without Constraints

5. ALTER TABLE - Add Column At The First Position

6. ALTER TABLE - Add Column At The Last Position

7. ALTER TABLE - Add Column At A Specific Position

8. ALTER TABLE - Add Column With Constraints

9. ALTER TABLE - Adding Column By Position With Constraint

10. ALTER TABLE - Adding Constraints In Existing Column

11. Changing Column Name & Data Type Without Constraints

12. Changing Column Name & Data Type Of More Than One Column Without Constraints

13. Changing Column Name & Data Type With Constraint

14. Changing Column Name & Data Type Of More Than One Column With Constraint

16. MODIFY & DROP

1.1 Section 16.pdf

1. MODIFY COLUMN

2. DROP COLUMN

3. DROP TABLE

4. Deleting Data From Table

5. Renaming A Table

6. ALTER DATABASE

7. Deleting A Database

17. SHOW Statements

1.1 Section 17.pdf

1. SHOW COLUMNS

2. SHOW CREATE DATABASE

3. SHOW CREATE TABLE

18. Updating & Deleting Records From A Table

1.1 Section 18.pdf

1. Update Records In A Table

2. UPDATE With CASE

3. Delete Records From A Table

19. Copying Table

1.1 Section 19.pdf

1. Copy Old Table To New Table Within Same Database

2. Copy Old Table To New Table In Between Different Database

20. Statistical Functions In SQL

1.1 Section 20.pdf

1. MIN & MAX Function

2. SUM & AVERAGE Function

3. SQUARE ROOT Function

4. ROUND Function

5. COUNT Function

6. UPPER & LOWER Function

7. MID & LENGTH Function

21. Miscellaneous Functions In SQL

1.1 Section 21.pdf

1. CONCAT Function

2. REVERSE Function

3. NOW Function

22. GROUP BY & HAVING Clause

1.1 Section 22.pdf

1. GROUP BY

2. HAVING Clause

23. Relationships Between Tables In SQL

1.1 Section 23.pdf

1. Advantages Of Multiple Table

2. Types Of Relationships

24. Data Modification Anomalies & SQL Keys

1.1 Section 24.pdf

1. Data Modification Anomalies

2. Different Types Of SQL Keys

25. Normalization In SQL

1.1 Section 25.pdf

1. Normalization

2. First normalization - 1NF

3. Second normalization - 2NF

4. Third normalization - 3NF

5. Boyce-Codd Normal Form - BCNF

26. FOREIGN Key

1.1 Section 26.pdf

1. FOREIGN Key

2. Creating Table Using Foreign Key

3. How To Find Constraint Name In SQL

4. Drop FOREIGN Key

5. ADD FOREIGN Key

6. Deleting Parent Table or Records From Parent Table

27. ON DELETE & ON UPDATE Clause

1.1 Section 27.pdf

1. ON DELETE CASCADE Clause

2. ON DELETE SET NULL Clause

3. ON DELETE NO ACTION Clause

4. ON UPDATE CASCADE Clause

5. ON UPDATE SET NULL Clause

6. ON UPDATE NO ACTION Clause

28. JOIN & UNION In SQL

1.1 Section 28.pdf

1. SQL JOIN

2. CROSS JOIN

3. INNER JOIN

4. LEFT JOIN

5. RIGHT JOIN

6. UNION

7. UNION ALL

8. FULL JOIN

53,700 تومان

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

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

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

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