Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists

Other
Size
3.6 GB
Seeders
0
Leechers
1
Files
82
Category
Other
Added
at 10:54am GMT+1
Infohash
1fb8b310cc8428603cee5799bb57b2e18d5fa4b5
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
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.

File list
  • Udemy - The Complete SQL Bootcamp for Aspiring Data Scientists
  • ~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 122 B
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
3.2 GB30
853 MB10
633 MB02
3.3 GB01