SQL Masterclass - For Data Science

Focused View

Amit Kumar Rai

13:33:41

103 View

1. SQL Set Up

1. SQL Set Up.mp4

06:49

2. Introduction to SQL

1.1 Section 2.pdf

1. Introduction To SQL.mp4

03:58

2. Introduction To Database.mp4

02:16

3. Types Of Databases.mp4

12:53

4. What Is A DBMS.mp4

03:55

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

02:28

3. Data Types In SQL

1.1 Section 3.pdf

1. Data Types In SQL.mp4

01:19

2. STRING Data Types.mp4

03:51

3. NUMERIC Data Types.mp4

04:50

4. DATE & TIME Data Types.mp4

01:47

4. Working With Database

1.1 Section 4.pdf

1. Pulling list of database.mp4

03:45

2. Creating A Database.mp4

05:42

3. Using A Database.mp4

01:36

5. Working With Tables

1.1 Section 5.pdf

1. Creating A Table.mp4

09:49

2. Describing A Table.mp4

03:44

3. Pulling The List Of Tables In A Database.mp4

01:30

4. Inserting Records In A Table.mp4

08:27

5. Inserting record without specifying column name.mp4

05:49

6. Inserting Record With Changing Order Of Column.mp4

04:32

7. Inserting Record In Specified Column.mp4

04:53

8. Inserting Multiple Records At A Time.mp4

08:22

6. Fetching Records From A Table

1.1 Section 6.pdf

1. Fetching Records From All Columns.mp4

02:44

2. Fetching Records From Specific Columns.mp4

03:25

3. Fetching Specific Number Of Records.mp4

07:02

4. Fetching Specific Number Of Records From Specific Record.mp4

07:29

7. Comparison Operators In SQL

1.1 Section 7.pdf

1. Comparison Operators In SQL.mp4

03:02

2. WHERE Clause.mp4

05:31

3. WHERE Clause With EQUAL TO Operator.mp4

09:41

4. WHERE Clause With NOT EQUAL TO Operator.mp4

06:43

5. WHERE Clause With GREATER THAN Operator.mp4

07:04

6. WHERE Clause With LESS THAN Operator.mp4

05:07

7. WHERE Clause With GREATER THAN or EQUAL TO Operator.mp4

05:26

8. WHERE Clause With LESS THAN or EQUAL TO Operator.mp4

05:43

8. Understanding NULL & NOT NULL Values

1.1 Section 8.pdf

1. NULL Values.mp4

05:59

2. IS NOT NULL Values.mp4

05:35

9. Logical Operators In SQL

1.1 Section 9.pdf

1. Logical Operators In SQL.mp4

11:04

2. WHERE Clause With AND Operator.mp4

06:20

3. WHERE Clause With OR Operator.mp4

07:32

4. Combination of AND & OR Operator.mp4

07:40

5. WHERE Clause With IN Operator.mp4

03:50

6. WHERE Clause With NOT IN Operator.mp4

03:59

7. WHERE Clause With BETWEEN Operator.mp4

07:00

8. WHERE Clause With NOT BETWEEN Operator.mp4

07:10

9. BETWEEN Operator With IN Operator.mp4

08:15

10. NOT BETWEEN Operator With IN Operator.mp4

06:37

11. LIKE Operator.mp4

02:14

12. Wildcard Characters.mp4

03:13

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

12:05

14. Using Wildcard Characters With LIKE Operator - Single Character.mp4

08:41

15. NOT LIKE Operator.mp4

03:00

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

06:33

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

06:01

10. Data Sorting In SQL

1.1 Section 10.pdf

1. Sorting The Data In Ascending Order.mp4

06:16

2. Sorting The Data In Descending Order.mp4

03:10

11. Constraints in SQL

1.1 Section 11.pdf

1. Constraints in SQL.mp4

07:15

2. NOT NULL Constraint.mp4

11:16

3. UNIQUE Constraint.mp4

10:01

4. PRIMARY Key.mp4

08:20

5. AUTO_INCREMENT.mp4

09:28

6. AUTO_INCREMENT From A Particular Number.mp4

07:43

12. ALIASES In SQL

1.1 Section 12.pdf

1. Aliases.mp4

07:03

13. Arithmetic Operators In SQL

1.1 Section 13.pdf

1. Arithmetic Operators In SQL.mp4

02:57

2. Understanding Arithmetic Operator - ADD.mp4

03:56

3. Understanding Arithmetic Operator - SUBTRACT.mp4

03:42

4. Understanding Arithmetic Operator - MULTIPLY.mp4

01:50

5. Understanding Arithmetic Operator - DIVIDE.mp4

01:29

6. Understanding Arithmetic Operator - MODULUS.mp4

04:08

14. Selecting Distinct Items

1.1 Section 14.pdf

1. SELECT DISTINCT Statement.mp4

04:05

15. Altering Tables In SQL

1.1 Section 15.pdf

1. ALTER TABLE statement.mp4

02:17

2. ALTER TABLE - Add One Column Without Constraints.mp4

04:28

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

04:09

4. ALTER TABLE - Add Column By Position Without Constraints.mp4

03:09

5. ALTER TABLE - Add Column At The First Position.mp4

03:00

6. ALTER TABLE - Add Column At The Last Position.mp4

02:33

7. ALTER TABLE - Add Column At A Specific Position.mp4

04:04

8. ALTER TABLE - Add Column With Constraints.mp4

04:52

9. ALTER TABLE - Adding Column By Position With Constraint.mp4

07:17

10. ALTER TABLE - Adding Constraints In Existing Column.mp4

04:41

11. Changing Column Name & Data Type Without Constraints.mp4

06:11

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

05:16

13. Changing Column Name & Data Type With Constraint.mp4

04:21

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

05:08

16. MODIFY & DROP

1.1 Section 16.pdf

1. MODIFY COLUMN.mp4

04:50

2. DROP COLUMN.mp4

06:10

3. DROP TABLE.mp4

02:07

4. Deleting Data From Table.mp4

03:01

5. Renaming A Table.mp4

01:53

6. ALTER DATABASE.mp4

03:22

7. Deleting A Database.mp4

02:03

17. SHOW Statements

1.1 Section 17.pdf

1. SHOW COLUMNS.mp4

02:50

2. SHOW CREATE DATABASE.mp4

01:55

3. SHOW CREATE TABLE.mp4

02:40

18. Updating & Deleting Records From A Table

1.1 Section 18.pdf

1. Update Records In A Table.mp4

09:00

2. UPDATE With CASE.mp4

10:17

3. Delete Records From A Table.mp4

03:51

19. Copying Table

1.1 Section 19.pdf

1. Copy Old Table To New Table Within Same Database.mp4

05:25

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

09:39

20. Statistical Functions In SQL

1.1 Section 20.pdf

1. MIN & MAX Function.mp4

05:28

2. SUM & AVERAGE Function.mp4

03:47

3. SQUARE ROOT Function.mp4

03:14

4. ROUND Function.mp4

08:40

5. COUNT Function.mp4

07:18

6. UPPER & LOWER Function.mp4

04:17

7. MID & LENGTH Function.mp4

05:01

21. Miscellaneous Functions In SQL

1.1 Section 21.pdf

1. CONCAT Function.mp4

04:29

2. REVERSE Function.mp4

02:28

3. NOW Function.mp4

01:19

22. GROUP BY & HAVING Clause

1.1 Section 22.pdf

1. GROUP BY.mp4

21:10

2. HAVING Clause.mp4

09:14

23. Relationships Between Tables In SQL

1.1 Section 23.pdf

1. Advantages Of Multiple Table.mp4

07:10

2. Types Of Relationships.mp4

09:42

24. Data Modification Anomalies & SQL Keys

1.1 Section 24.pdf

1. Data Modification Anomalies.mp4

07:46

2. Different Types Of SQL Keys.mp4

15:28

25. Normalization In SQL

1.1 Section 25.pdf

1. Normalization.mp4

04:19

2. First normalization - 1NF.mp4

02:59

3. Second normalization - 2NF.mp4

08:45

4. Third normalization - 3NF.mp4

04:20

5. Boyce-Codd Normal Form - BCNF.mp4

05:19

26. FOREIGN Key

1.1 Section 26.pdf

1. FOREIGN Key.mp4

05:16

2. Creating Table Using Foreign Key.mp4

17:28

3. How To Find Constraint Name In SQL.mp4

04:07

4. Drop FOREIGN Key.mp4

03:29

5. ADD FOREIGN Key.mp4

11:05

6. Deleting Parent Table or Records From Parent Table.mp4

06:49

27. ON DELETE & ON UPDATE Clause

1.1 Section 27.pdf

1. ON DELETE CASCADE Clause.mp4

08:56

2. ON DELETE SET NULL Clause.mp4

11:56

3. ON DELETE NO ACTION Clause.mp4

08:12

4. ON UPDATE CASCADE Clause.mp4

07:39

5. ON UPDATE SET NULL Clause.mp4

06:58

6. ON UPDATE NO ACTION Clause.mp4

07:59

28. JOIN & UNION In SQL

1.1 Section 28.pdf

1. SQL JOIN.mp4

03:38

2. CROSS JOIN.mp4

13:18

3. INNER JOIN.mp4

08:35

4. LEFT JOIN.mp4

04:59

5. RIGHT JOIN.mp4

05:43

6. UNION.mp4

07:30

7. UNION ALL.mp4

03:36

8. FULL JOIN.mp4

07:07

Description

Structured Query Language

What You'll Learn?

To create, update and modify database
To create, update and modify tables
To write data retrieval queries and evaluate the result set
To write data updation and modification queries
To convert data to the best form using normalization techniques
To establish relations and get desired output with multiple tables by using SQL JOINS & UNION
Creating relationships in tables using foreign key and primary key

Who is this for?

Learners looking to launch their career in Data Science

More details

Description
SQL is the most in demand language for professionals working in data science or data analysis field. SQL help to communicate with database and organise raw data in the structured form. SQL also helps to run queries through the data to bring meaningful insights which contributes to decision making.
This course will start from basic concepts of SQL. After basics, concepts of SQL, we have covered different types of operators in SQL and their usage with practical sessions.
Then the course will move to constraints in SQL. Every constraint and SQL keys are covered with the practical example. Then the learners will get to learn the concept of relationships and normalisation in SQL.

In this course, you will get:
Â· 137 videos to master SQL for data science
Â· 13+ hours of recorded lectures
Â· Study materials covering the theory, syntax and practical examples
Â· Every session covers the theory and practical of each theory

In this course, you will learn:
Â· To create, update and modify database
Â· To create, update and modify tables
Â· To write data retrieval queries and evaluate the result set
Â· To write data updation and modification queries
Â· Normalization in SQL
Â· Creating joins in SQL
Â· Creating relationships in tables using foreign key and primary key
Â· AND a lot more concepts
Who this course is for:
Learners looking to launch their career in Data Science

User Reviews

Rating

average 0

Total votes0

Focused display

I hold a total of 8+ years of experience in the field of operations management, people management, product development, process optimization.I have worked with banks, chartered firms and educational institutions which gave me an opportunity to learn from different types of industries.My areas of expertise are data science, process development, product management, operations management, process optimization.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.