[ DevCourseWeb.com ] Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists

File Name

Size

Get Bonus Downloads Here.url

182 B

~Get Your Files Here !/1. Introduction/1. What all will be covered.mp4

12 MB

~Get Your Files Here !/1. Introduction/2. What is a database.mp4

17 MB

~Get Your Files Here !/1. Introduction/3. Understand SQL.mp4

19 MB

~Get Your Files Here !/1. Introduction/4. Installation of SQL Server.mp4

24 MB

~Get Your Files Here !/1. Introduction/5. Download and Restore Database.mp4

23 MB

~Get Your Files Here !/10. Views/1. Create a View.mp4

66 MB

~Get Your Files Here !/10. Views/2. Alter, Join and Drop the views.mp4

65 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/1. Subqueries 1.mp4

78 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/2. Subqueries 2.mp4

58 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/3. Subqueries 3.mp4

74 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/4. Subqueries 4.mp4

53 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/5. Subqueries 5.mp4

40 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/6. Common Table Expression 1.mp4

60 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/7. Common Table Expression 2.mp4

112 MB

~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/8. CTE Code.html

959 B

~Get Your Files Here !/12. Stored Procedures/1. Create, Alter, Execute, Drop a Stored Procedure.mp4

90 MB

~Get Your Files Here !/12. Stored Procedures/2. Stored Procedure with Input Parameters.mp4

81 MB

~Get Your Files Here !/12. Stored Procedures/3. Stored Procedure with Output Parameters.mp4

82 MB

~Get Your Files Here !/12. Stored Procedures/4. Calling One Stored Procedure from Another Stored Procedure.mp4

135 MB

~Get Your Files Here !/12. Stored Procedures/5. Previous lecture Code.html

1.2 kB

~Get Your Files Here !/12. Stored Procedures/6. Data Analytics Courses.html

3.6 kB

~Get Your Files Here !/2. DDL and DML Statements/1. DDL Create Database Graphically.mp4

30 MB

~Get Your Files Here !/2. DDL and DML Statements/10. DDL Alter Table Command.mp4

56 MB

~Get Your Files Here !/2. DDL and DML Statements/11. DDL Drop the Table.mp4

13 MB

~Get Your Files Here !/2. DDL and DML Statements/12. DML Delete the Table.mp4

15 MB

~Get Your Files Here !/2. DDL and DML Statements/13. DDL Truncate the Table.mp4

19 MB

~Get Your Files Here !/2. DDL and DML Statements/14. What is Schema.mp4

65 MB

~Get Your Files Here !/2. DDL and DML Statements/15. Test your knowledge.html

122 B

~Get Your Files Here !/2. DDL and DML Statements/2. DDL Create Database using Query.mp4

58 MB

~Get Your Files Here !/2. DDL and DML Statements/3. Add Comments.mp4

24 MB

~Get Your Files Here !/2. DDL and DML Statements/4. DDL Alter Database Command.mp4

14 MB

~Get Your Files Here !/2. DDL and DML Statements/5. DDL Delete a Database.mp4

11 MB

~Get Your Files Here !/2. DDL and DML Statements/6. Data types.mp4

19 MB

~Get Your Files Here !/2. DDL and DML Statements/7. DDL Create Table.mp4

54 MB

~Get Your Files Here !/2. DDL and DML Statements/8. DML Insert data in table.mp4

70 MB

~Get Your Files Here !/2. DDL and DML Statements/9. DDL Create table with Identity Column.mp4

30 MB

~Get Your Files Here !/3. Data Integrity/1. What is Data Integrity.mp4

15 MB

~Get Your Files Here !/3. Data Integrity/2. Not Null Constraint.mp4

28 MB

~Get Your Files Here !/3. Data Integrity/3. Primary Key Constraint.mp4

69 MB

~Get Your Files Here !/3. Data Integrity/4. Unique Constraint.mp4

70 MB

~Get Your Files Here !/3. Data Integrity/5. Foreign Key Constraint.mp4

52 MB

~Get Your Files Here !/3. Data Integrity/6. Check Constraint.mp4

76 MB

~Get Your Files Here !/3. Data Integrity/7. Default Constraint.mp4

32 MB

~Get Your Files Here !/4. Querying the database/1. Import data from excel.mp4

21 MB

~Get Your Files Here !/4. Querying the database/10. WHERE Clause with Update Command.mp4

34 MB

~Get Your Files Here !/4. Querying the database/11. Test your knowledge.html

122 B

~Get Your Files Here !/4. Querying the database/2. SELECT Statement.mp4

44 MB

~Get Your Files Here !/4. Querying the database/3. SELECT with DISTINCT and TOP clause.mp4

68 MB

~Get Your Files Here !/4. Querying the database/4. WHERE Clause with Comparison Operators.mp4

56 MB

~Get Your Files Here !/4. Querying the database/5. WHERE Clause with Logical Operators.mp4

95 MB

~Get Your Files Here !/4. Querying the database/6. WHERE Clause with Range Operators.mp4

48 MB

~Get Your Files Here !/4. Querying the database/7. WHERE Clause with List Operators.mp4

53 MB

~Get Your Files Here !/4. Querying the database/8. WHERE Clause with Wildcard Operators.mp4

108 MB

~Get Your Files Here !/4. Querying the database/9. WHERE Clause with IS NULL IS NOT NULL Operators.mp4

32 MB

~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/1. Sort the data.mp4

60 MB

~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/2. Aggregate Functions 1.mp4

50 MB

~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/3. Aggregate Functions 2.mp4

46 MB

~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/4. Group By Clause.mp4

38 MB

~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/5. Having Clause.mp4

37 MB

~Get Your Files Here !/6. Functions/1. String Functions.mp4

108 MB

~Get Your Files Here !/6. Functions/2. Date Functions.mp4

122 MB

~Get Your Files Here !/6. Functions/3. Mathematical Functions.mp4

32 MB

~Get Your Files Here !/6. Functions/4. Data Conversion Functions.mp4

61 MB

~Get Your Files Here !/6. Functions/5. COALESCE and ISNULL.mp4

31 MB

~Get Your Files Here !/6. Functions/6. String Aggregation function.mp4

22 MB

~Get Your Files Here !/6. Functions/7. Test your knowledge.html

122 B

~Get Your Files Here !/7. Joins/1. Inner Join.mp4

88 MB

~Get Your Files Here !/7. Joins/2. Left Join.mp4

34 MB

~Get Your Files Here !/7. Joins/3. Right Join.mp4

33 MB

~Get Your Files Here !/7. Joins/4. Full Outer Join.mp4

19 MB

~Get Your Files Here !/7. Joins/5. Self Join.mp4

33 MB

~Get Your Files Here !/7. Joins/6. Cross Join.mp4

15 MB

~Get Your Files Here !/8. SQL Query Order of Execution/1. Order of execution 1.mp4

42 MB

~Get Your Files Here !/8. SQL Query Order of Execution/2. Order of execution 2.mp4

74 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/1. Simple CASE Expression.mp4

57 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/2. Searched CASE Expression.mp4

50 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/3. Variable and Print Statement.mp4

31 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/4. IF ELSE Statement.mp4

25 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/5. Set Operators Union and Union All.mp4

32 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/6. Set Operators Intersect and Except (Minus).mp4

28 MB

~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/7. Test your knowledge.html

122 B

~Get Your Files Here !/Bonus Resources.txt

386 B