Torrent Downloads » Other » [ DevCourseWeb com ] Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists
Other
[ DevCourseWeb com ] Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.55 GB) (Files: 83)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Introduction
1. What all will be covered.mp4
2. What is a database.mp4
3. Understand SQL.mp4
4. Installation of SQL Server.mp4
5. Download and Restore Database.mp4
10. Views
1. Create a View.mp4
2. Alter, Join and Drop the views.mp4
11. Writing Subqueries and Common Table Expressions (CTE)
1. Subqueries 1.mp4
2. Subqueries 2.mp4
3. Subqueries 3.mp4
4. Subqueries 4.mp4
5. Subqueries 5.mp4
6. Common Table Expression 1.mp4
7. Common Table Expression 2.mp4
8. CTE Code.html
12. Stored Procedures
1. Create, Alter, Execute, Drop a Stored Procedure.mp4
2. Stored Procedure with Input Parameters.mp4
3. Stored Procedure with Output Parameters.mp4
4. Calling One Stored Procedure from Another Stored Procedure.mp4
5. Previous lecture Code.html
6. Data Analytics Courses.html
2. DDL and DML Statements
1. DDL Create Database Graphically.mp4
10. DDL Alter Table Command.mp4
11. DDL Drop the Table.mp4
12. DML Delete the Table.mp4
13. DDL Truncate the Table.mp4
14. What is Schema.mp4
15. Test your knowledge.html
2. DDL Create Database using Query.mp4
3. Add Comments.mp4
4. DDL Alter Database Command.mp4
5. DDL Delete a Database.mp4
6. Data types.mp4
7. DDL Create Table.mp4
8. DML Insert data in table.mp4
9. DDL Create table with Identity Column.mp4
3. Data Integrity
1. What is Data Integrity.mp4
2. Not Null Constraint.mp4
3. Primary Key Constraint.mp4
4. Unique Constraint.mp4
5. Foreign Key Constraint.mp4
6. Check Constraint.mp4
7. Default Constraint.mp4
4. Querying the database
1. Import data from excel.mp4
10. WHERE Clause with Update Command.mp4
11. Test your knowledge.html
2. SELECT Statement.mp4
3. SELECT with DISTINCT and TOP clause.mp4
4. WHERE Clause with Comparison Operators.mp4
5. WHERE Clause with Logical Operators.mp4
6. WHERE Clause with Range Operators.mp4
7. WHERE Clause with List Operators.mp4
8. WHERE Clause with Wildcard Operators.mp4
9. WHERE Clause with IS NULL IS NOT NULL Operators.mp4
5. Sort, Aggregate, Group and Filter the data
1. Sort the data.mp4
2. Aggregate Functions 1.mp4
3. Aggregate Functions 2.mp4
4. Group By Clause.mp4
5. Having Clause.mp4
6. Functions
1. String Functions.mp4
2. Date Functions.mp4
3. Mathematical Functions.mp4
4. Data Conversion Functions.mp4
5. COALESCE and ISNULL.mp4
6. String Aggregation function.mp4
7. Test your knowledge.html
7. Joins
1. Inner Join.mp4
2. Left Join.mp4
3. Right Join.mp4
4. Full Outer Join.mp4
5. Self Join.mp4
6. Cross Join.mp4
8. SQL Query Order of Execution
1. Order of execution 1.mp4
2. Order of execution 2.mp4
9. CASE, IF ELSE Statement and Set Operators
1. Simple CASE Expression.mp4
2. Searched CASE Expression.mp4
3. Variable and Print Statement.mp4
4. IF ELSE Statement.mp4
5. Set Operators Union and Union All.mp4
6. Set Operators Intersect and Except (Minus).mp4
7. Test your knowledge.html
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ DevCourseWeb com ] Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
