| 001 Create Database user.mp4 | 27 MB | ||
| 001 Create Database user_en.vtt | 4.2 KB | ||
| 001 Create stored procedure.mp4 | 30.6 MB | ||
| 001 Create stored procedure_en.vtt | 4.8 KB | ||
| 001 Creating Views.mp4 | 26.2 MB | ||
| 001 Creating Views_en.vtt | 4.2 KB | ||
| 001 Introduction.mp4 | 43 MB | ||
| 001 Introduction_en.vtt | 2.3 KB | ||
| 001 Order By statement.mp4 | 48.1 MB | ||
| 001 Order By statement_en.vtt | 6.1 KB | ||
| 001 Overview of Joins.mp4 | 10.5 MB | ||
| 001 Overview of Joins_en.vtt | 1.9 KB | ||
| 001 SELECT WHERE Clause – theory.mp4 | 18.3 MB | ||
| 001 SELECT WHERE Clause – theory_en.vtt | 3.2 KB | ||
| 001 Section Introduction.mp4 | 8.1 MB | ||
| 001 Section Introduction_en.vtt | 1.1 KB | ||
| 001 Section introduction.mp4 | 7.8 MB | ||
| 001 Section introduction_en.vtt | 819.2 B | ||
| 001 Sum().mp4 | 71.9 MB | ||
| 001 Sum()_en.vtt | 8.2 KB | ||
| 002 CREATE table statement.mp4 | 22 MB | ||
| 002 CREATE table statement_en.vtt | 2.6 KB | ||
| 002 Check constraint.mp4 | 45.3 MB | ||
| 002 Check constraint_en.vtt | 7.3 KB | ||
| 002 Course Curriculum.mp4 | 40.2 MB | ||
| 002 Course Curriculum_en.vtt | 7.1 KB | ||
| 002 Creating Database backup.mp4 | 23.6 MB | ||
| 002 Creating Database backup_en.vtt | 4.3 KB | ||
| 002 GRANT permissions.mp4 | 47.6 MB | ||
| 002 GRANT permissions_en.vtt | 6.4 KB | ||
| 002 Group by – theory.mp4 | 17.6 MB | ||
| 002 Group by – theory_en.vtt | 3.4 KB | ||
| 002 Import Flat File.mp4 | 34.8 MB | ||
| 002 Import Flat File_en.vtt | 6.1 KB | ||
| 002 Insert statement.mp4 | 58.7 MB | ||
| 002 Insert statement_en.vtt | 9 KB | ||
| 002 Microsoft SQL Server Installation.mp4 | 151.9 MB | ||
| 002 Microsoft SQL Server Installation_en.vtt | 20.1 KB | ||
| 002 Min()-Max().mp4 | 51.2 MB | ||
| 002 Min()-Max()_en.vtt | 6.5 KB | ||
| 002 Overview of Databases.mp4 | 54.1 MB | ||
| 002 Overview of Databases_en.vtt | 11.2 KB | ||
| 002 Reporting with multiple tables.mp4 | 24.7 MB | ||
| 002 Reporting with multiple tables_en.vtt | 3.6 KB | ||
| 002 SELECT TOP clause in SQL.mp4 | 45.3 MB | ||
| 002 SELECT TOP clause in SQL_en.vtt | 4.1 KB | ||
| 002 SELECT WHERE Clause – practical.mp4 | 54.3 MB | ||
| 002 SELECT WHERE Clause – practical_en.vtt | 7.8 KB | ||
| 002 SQL Statement basic.mp4 | 19.2 MB | ||
| 002 SQL Statement basic_en.vtt | 3.2 KB | ||
| 002 Stored procedure with parameter.mp4 | 34.9 MB | ||
| 002 Stored procedure with parameter_en.vtt | 5.2 KB | ||
| 002 Timestamp.mp4 | 30.1 MB | ||
| 002 Timestamp_en.vtt | 4.4 KB | ||
| 002 What are Joins.mp4 | 11.5 MB | ||
| 002 What are Joins_en.vtt | 2.6 KB | ||
| 003 BETWEEN command.mp4 | 83.9 MB | ||
| 003 BETWEEN command_en.vtt | 8.4 KB | ||
| 003 Creating Database.mp4 | 28.2 MB | ||
| 003 Creating Database_en.vtt | 5.3 KB | ||
| 003 DROP statement.mp4 | 15.9 MB | ||
| 003 DROP statement_en.vtt | 2.2 KB | ||
| 003 Extract from timestamp.mp4 | 29.3 MB | ||
| 003 Extract from timestamp_en.vtt | 3.4 KB | ||
| 003 Group by – practical.mp4 | 49.8 MB | ||
| 003 Group by – practical_en.vtt | 5.7 KB | ||
| 003 How to get course requirements.mp4 | 9.2 MB | ||
| 003 How to get course requirements_en.vtt | 1.7 KB | ||
| 003 Import .csv or excel file.mp4 | 22.4 MB | ||
| 003 Import .csv or excel file_en.vtt | 3 KB | ||
| 003 Inner join.mp4 | 85.9 MB | ||
| 003 Inner join_en.vtt | 8.9 KB | ||
| 003 NOT NULL constraint.mp4 | 61.5 MB | ||
| 003 NOT NULL constraint_en.vtt | 8.2 KB | ||
| 003 REVOKE permissions.mp4 | 35.2 MB | ||
| 003 REVOKE permissions_en.vtt | 4.5 KB | ||
| 003 Restoring Database backup.mp4 | 22.8 MB | ||
| 003 Restoring Database backup_en.vtt | 4.3 KB | ||
| 003 SELECT Statement.mp4 | 60.7 MB | ||
| 003 SELECT Statement_en.vtt | 7.7 KB | ||
| 003 SQL Server Management Studio (SSMS) Installation.mp4 | 71.8 MB | ||
| 003 SQL Server Management Studio (SSMS) Installation_en.vtt | 8.9 KB | ||
| 003 Update statement.mp4 | 40.3 MB | ||
| 003 Update statement_en.vtt | 5.4 KB | ||
| 004 ALTER statement.mp4 | 40.9 MB | ||
| 004 ALTER statement_en.vtt | 5.1 KB | ||
| 004 Delete statement.mp4 | 26.6 MB | ||
| 004 Delete statement_en.vtt | 3.1 KB | ||
| 004 Export Data to Excel or any format.mp4 | 46.8 MB | ||
| 004 Export Data to Excel or any format_en.vtt | 7.3 KB | ||
| 004 Getting started on Windows, Linux or Docker.mp4 | 7.6 MB | ||
| 004 Getting started on Windows, Linux or Docker_en.vtt | 819.2 B | ||
| 004 HAVING statement.mp4 | 30.2 MB | ||
| 004 HAVING statement_en.vtt | 3.7 KB | ||
| 004 How to connect MS SQL (Windows Authentication).mp4 | 20.7 MB | ||
| 004 How to connect MS SQL (Windows Authentication)_en.vtt | 4.1 KB | ||
| 004 IN operator.mp4 | 40.8 MB | ||
| 004 IN operator_en.vtt | 4.3 KB | ||
| 004 Left outer join.mp4 | 26 MB | ||
| 004 Left outer join_en.vtt | 3.1 KB | ||
| 004 Mathematical scalar functions.mp4 | 29.2 MB | ||
| 004 Mathematical scalar functions_en.vtt | 3.5 KB | ||
| 004 SELECT DISTINCT.mp4 | 29.6 MB | ||
| 004 SELECT DISTINCT_en.vtt | 2.5 KB | ||
| 004 SQL Data Types.mp4 | 16.9 MB | ||
| 004 SQL Data Types_en.vtt | 3.2 KB | ||
| 004 UNIQUE constraint.mp4 | 37.4 MB | ||
| 004 UNIQUE constraint_en.vtt | 4.8 KB | ||
| 005 Column Data Types on SSMS.mp4 | 22.6 MB | ||
| 005 Column Data Types on SSMS_en.vtt | 3.7 KB | ||
| 005 How to ask great questions.mp4 | 10 MB | ||
| 005 How to ask great questions_en.vtt | 1.2 KB | ||
| 005 How to connect MS SQL (SQL Server Authentication).mp4 | 17.8 MB | ||
| 005 How to connect MS SQL (SQL Server Authentication)_en.vtt | 3.3 KB | ||
| 005 Right outer join.mp4 | 21.3 MB | ||
| 005 Right outer join_en.vtt | 2.7 KB | ||
| 005 SELECT with column headings.mp4 | 23 MB | ||
| 005 SELECT with column headings_en.vtt | 2.8 KB | ||
| 005 String functions.mp4 | 38.3 MB | ||
| 005 String functions_en.vtt | 5.3 KB | ||
| 005 TRUNCATE statement.mp4 | 26.9 MB | ||
| 005 TRUNCATE statement_en.vtt | 3.7 KB | ||
| 005 Wildcard Characters and LIKE.mp4 | 56.8 MB | ||
| 005 Wildcard Characters and LIKE_en.vtt | 5.6 KB | ||
| 006 COMMENT in query.mp4 | 8.7 MB | ||
| 006 COMMENT in query_en.vtt | 1 KB | ||
| 006 Column AS statement.mp4 | 24.6 MB | ||
| 006 Column AS statement_en.vtt | 1.8 KB | ||
| 006 Creating Table.mp4 | 57.1 MB | ||
| 006 Creating Table_en.vtt | 9.6 KB | ||
| 006 Download and Restore Sample Database.mp4 | 54.1 MB | ||
| 006 Download and Restore Sample Database_en.vtt | 8.3 KB | ||
| 006 FAQ’s.mp4 | 9.4 MB | ||
| 006 FAQ’s_en.vtt | 1.1 KB | ||
| 006 Full outer join.mp4 | 13.6 MB | ||
| 006 Full outer join_en.vtt | 1.4 KB | ||
| 006 Sub Query.mp4 | 24.3 MB | ||
| 006 Sub Query_en.vtt | 3.1 KB | ||
| 007 Overview of Primary Key and Foreign Key.mp4 | 20.8 MB | ||
| 007 Overview of Primary Key and Foreign Key_en.vtt | 4 KB | ||
| 007 RENAME.mp4 | 13.7 MB | ||
| 007 RENAME_en.vtt | 1.8 KB | ||
| 007 SELECT with calculations.mp4 | 54 MB | ||
| 007 SELECT with calculations_en.vtt | 6.1 KB | ||
| 007 Union.mp4 | 27.8 MB | ||
| 007 Union_en.vtt | 2.7 KB | ||
| 008 Cross join.mp4 | 30.8 MB | ||
| 008 Cross join_en.vtt | 3.1 KB | ||
| 008 Primary Key.mp4 | 27.4 MB | ||
| 008 Primary Key_en.vtt | 4.5 KB | ||
| 009 Foreign Key.mp4 | 51.2 MB | ||
| 009 Foreign Key_en.vtt | 7.1 KB | ||
| 009 Query Exercise.mp4 | 8.6 MB | ||
| 009 Query Exercise_en.vtt | 1.2 KB | ||
| 010 Creating Temporary tables.mp4 | 41.8 MB | ||
| 010 Creating Temporary tables_en.vtt | 7 KB | ||
| 010 Solution for Query Exercise.mp4 | 10.1 MB | ||
| 010 Solution for Query Exercise_en.vtt | 1.1 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 176 total files | |||
Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero
https://DevCourseWeb.com
Published 07/2022
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.72 GB | Duration: 87 lectures • 6h 1m
Become an Expert at Microsoft SQL!
What you'll learn
Use SQL to query a database
Get a job as a junior Database developer
Advanced SQL statements
Use SQL to perform data analysis
Be comfortable putting SQL and Microsoft SQL on their resume
Learn to perform GROUP BY statements
Replicate real-world situations and query reports
Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Using joins, return columns from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
Complete SQL statements that use aggregate functions
Import Flat, .CSV, Excel to SQL Database
Perform Secure Backup and Restore Full SQL Database task
Write SELECT on Query Calculations to get Discount and Non Discount Sales
Requirements
No prior technical experience is required! All you need a computer!
No software is required in advance of the course (all software used in the course is free)
No pre-knowledge is required - you will learn from basic
Description
Learn how to use SQL quickly and effectively with this course!
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 4 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 1 month | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
| 999.5 MB | freecoursewb | 1 month | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
All Comments