17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - The Complete SQL Bootcamp For Aspiring Data Scientists
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
The Complete SQL Bootcamp for Aspiring Data Scientists
https://DevCourseWeb.com
Published 7/2023 Created by Vivek P. MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Genre: eLearning | Language: English | Duration: 77 Lectures ( 7h 8m ) | Size: 3.54 GB
Master SQL Server for Data Science: The Ultimate SQL Bootcamp to Accelerate Your Data Science Journey!
What you'll learn Master SQL Server Fundamentals: Develop a solid understanding of SQL Server fundamentals, data types, querying, and database management. Advanced Querying Techniques: Learn advanced SQL querying techniques like joins, subqueries, and CTE for complex data retrieval and analysis. Create Database Objects: Gain hands-on experience in creating and managing essential database objects, such as schemas, tables, views to organize data Set Operations, Stored Procedures
Requirements All you need is a computer with a working internet connection. We will provide comprehensive training on SQL Server, starting from the basics, so no prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1. Introduction/1. What all will be covered.mp4
12.4 MB
~Get Your Files Here !/1. Introduction/2. What is a database.mp4
17.4 MB
~Get Your Files Here !/1. Introduction/3. Understand SQL.mp4
18.8 MB
~Get Your Files Here !/1. Introduction/4. Installation of SQL Server.mp4
23.5 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.2 MB
~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/1. Subqueries 1.mp4
77.7 MB
~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/2. Subqueries 2.mp4
58.2 MB
~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/3. Subqueries 3.mp4
74.1 MB
~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/4. Subqueries 4.mp4
53.2 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
59.7 MB
~Get Your Files Here !/11. Writing Subqueries and Common Table Expressions (CTE)/7. Common Table Expression 2.mp4
112.3 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.5 MB
~Get Your Files Here !/12. Stored Procedures/2. Stored Procedure with Input Parameters.mp4
81.3 MB
~Get Your Files Here !/12. Stored Procedures/3. Stored Procedure with Output Parameters.mp4
81.6 MB
~Get Your Files Here !/12. Stored Procedures/4. Calling One Stored Procedure from Another Stored Procedure.mp4
134.6 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.4 MB
~Get Your Files Here !/2. DDL and DML Statements/11. DDL Drop the Table.mp4
13.2 MB
~Get Your Files Here !/2. DDL and DML Statements/12. DML Delete the Table.mp4
14.8 MB
~Get Your Files Here !/2. DDL and DML Statements/13. DDL Truncate the Table.mp4
19.1 MB
~Get Your Files Here !/2. DDL and DML Statements/14. What is Schema.mp4
65.3 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
57.5 MB
~Get Your Files Here !/2. DDL and DML Statements/3. Add Comments.mp4
24.1 MB
~Get Your Files Here !/2. DDL and DML Statements/4. DDL Alter Database Command.mp4
13.9 MB
~Get Your Files Here !/2. DDL and DML Statements/5. DDL Delete a Database.mp4
10.6 MB
~Get Your Files Here !/2. DDL and DML Statements/6. Data types.mp4
18.7 MB
~Get Your Files Here !/2. DDL and DML Statements/7. DDL Create Table.mp4
54.1 MB
~Get Your Files Here !/2. DDL and DML Statements/8. DML Insert data in table.mp4
69.6 MB
~Get Your Files Here !/2. DDL and DML Statements/9. DDL Create table with Identity Column.mp4
29.5 MB
~Get Your Files Here !/3. Data Integrity/1. What is Data Integrity.mp4
15.4 MB
~Get Your Files Here !/3. Data Integrity/2. Not Null Constraint.mp4
28.3 MB
~Get Your Files Here !/3. Data Integrity/3. Primary Key Constraint.mp4
68.8 MB
~Get Your Files Here !/3. Data Integrity/4. Unique Constraint.mp4
70.3 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
75.9 MB
~Get Your Files Here !/3. Data Integrity/7. Default Constraint.mp4
32.2 MB
~Get Your Files Here !/4. Querying the database/1. Import data from excel.mp4
20.8 MB
~Get Your Files Here !/4. Querying the database/10. WHERE Clause with Update Command.mp4
33.7 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
67.8 MB
~Get Your Files Here !/4. Querying the database/4. WHERE Clause with Comparison Operators.mp4
56.4 MB
~Get Your Files Here !/4. Querying the database/5. WHERE Clause with Logical Operators.mp4
94.8 MB
~Get Your Files Here !/4. Querying the database/6. WHERE Clause with Range Operators.mp4
48.2 MB
~Get Your Files Here !/4. Querying the database/7. WHERE Clause with List Operators.mp4
52.6 MB
~Get Your Files Here !/4. Querying the database/8. WHERE Clause with Wildcard Operators.mp4
108.1 MB
~Get Your Files Here !/4. Querying the database/9. WHERE Clause with IS NULL IS NOT NULL Operators.mp4
32.5 MB
~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/1. Sort the data.mp4
60.3 MB
~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/2. Aggregate Functions 1.mp4
50.4 MB
~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/3. Aggregate Functions 2.mp4
46.1 MB
~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/4. Group By Clause.mp4
37.8 MB
~Get Your Files Here !/5. Sort, Aggregate, Group and Filter the data/5. Having Clause.mp4
37.4 MB
~Get Your Files Here !/6. Functions/1. String Functions.mp4
108.4 MB
~Get Your Files Here !/6. Functions/2. Date Functions.mp4
121.5 MB
~Get Your Files Here !/6. Functions/3. Mathematical Functions.mp4
31.7 MB
~Get Your Files Here !/6. Functions/4. Data Conversion Functions.mp4
61.1 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.5 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
33.6 MB
~Get Your Files Here !/7. Joins/3. Right Join.mp4
33.3 MB
~Get Your Files Here !/7. Joins/4. Full Outer Join.mp4
18.7 MB
~Get Your Files Here !/7. Joins/5. Self Join.mp4
33 MB
~Get Your Files Here !/7. Joins/6. Cross Join.mp4
14.6 MB
~Get Your Files Here !/8. SQL Query Order of Execution/1. Order of execution 1.mp4
41.6 MB
~Get Your Files Here !/8. SQL Query Order of Execution/2. Order of execution 2.mp4
73.6 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/1. Simple CASE Expression.mp4
57.3 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/2. Searched CASE Expression.mp4
49.5 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/3. Variable and Print Statement.mp4
30.8 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/4. IF ELSE Statement.mp4
24.7 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/5. Set Operators Union and Union All.mp4
31.7 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/6. Set Operators Intersect and Except (Minus).mp4
28.5 MB
~Get Your Files Here !/9. CASE, IF ELSE Statement and Set Operators/7. Test your knowledge.html
