| 1. Course Introdution.mp4 | 18.4 MB | ||
| 1. Course Introdution.srt | 4.5 KB | ||
| 1. Download and Install SQL Server Express.mp4 | 32.1 MB | ||
| 1. Download and Install SQL Server Express.srt | 6.2 KB | ||
| 1. SELECT clause - Introduction and Demonstration.mp4 | 34.7 MB | ||
| 1. SELECT clause - Introduction and Demonstration.srt | 9.2 KB | ||
| 1. SELECT course final summary.mp4 | 21.3 MB | ||
| 1. SELECT course final summary.srt | 9.2 KB | ||
| 1. SSMS Layout and Connecting to a Database.mp4 | 26.3 MB | ||
| 1. SSMS Layout and Connecting to a Database.srt | 11.1 KB | ||
| 1.1 01 - the SELECT clause.sql | 2.6 KB | ||
| 1.1 SQL Clause overview.pdf | 171.6 KB | ||
| 1.1 SQL Server Management Studio Overview 15.0.18384.pdf | 1.2 MB | ||
| 10. WHERE Clause - Part 2 - LIKE operator - Demonstration.mp4 | 21.2 MB | ||
| 10. WHERE Clause - Part 2 - LIKE operator - Demonstration.srt | 3.2 KB | ||
| 10.1 05 - the WHERE clause part 2.sql | 2.6 KB | ||
| 11. A note about NULLs.mp4 | 27.3 MB | ||
| 11. A note about NULLs.srt | 6.4 KB | ||
| 11.1 06 - a note about NULLs.sql | 2.3 KB | ||
| 11.2 NULL values.pdf | 39.3 KB | ||
| 12. WHERE Clause - Part 3 - Combining clauses - Demonstration.mp4 | 35.7 MB | ||
| 12. WHERE Clause - Part 3 - Combining clauses - Demonstration.srt | 8.4 KB | ||
| 12.1 07 - the WHERE clause part 3.sql | 2.9 KB | ||
| 13. WHERE Clause - Test Answers.mp4 | 51.6 MB | ||
| 13. WHERE Clause - Test Answers.srt | 8 KB | ||
| 13.1 07 - the WHERE clause part 3 test.sql | 3 KB | ||
| 14. ORDER BY Clause - Introduction.mp4 | 8 MB | ||
| 14. ORDER BY Clause - Introduction.srt | 4.6 KB | ||
| 15. ORDER BY Clause - Demonstration.mp4 | 32 MB | ||
| 15. ORDER BY Clause - Demonstration.srt | 4.5 KB | ||
| 15.1 08 - the ORDER BY clause.sql | 3.8 KB | ||
| 16. ORDER BY Clause - Test Answers.mp4 | 35.3 MB | ||
| 16. ORDER BY Clause - Test Answers.srt | 5.7 KB | ||
| 16.1 08 - the ORDER BY clause test.sql | 2.6 KB | ||
| 17. JOIN Clause - Part 1 - Introduction.mp4 | 31.4 MB | ||
| 17. JOIN Clause - Part 1 - Introduction.srt | 9.9 KB | ||
| 17.1 Table JOINs.pdf | 235.1 KB | ||
| 18. JOIN Clause - Part 1 - Demonstration.mp4 | 43.5 MB | ||
| 18. JOIN Clause - Part 1 - Demonstration.srt | 8.6 KB | ||
| 18.1 09 - table JOINS part 1.sql | 3.3 KB | ||
| 19. JOIN Clause - Part 1 - Test Answers.mp4 | 39 MB | ||
| 19. JOIN Clause - Part 1 - Test Answers.srt | 6.2 KB | ||
| 19.1 09 - table JOINS part 1 test.sql | 2.8 KB | ||
| 19.2 Table Joins part 1 test - table relationships.pdf | 10 KB | ||
| 2. Download and Install SQL Server Management Studio (SSMS).mp4 | 33.2 MB | ||
| 2. Download and Install SQL Server Management Studio (SSMS).srt | 6.4 KB | ||
| 2. FROM clause - Introduction.mp4 | 4.4 MB | ||
| 2. FROM clause - Introduction.srt | 2.5 KB | ||
| 2. SELECT course final test answers.mp4 | 156.1 MB | ||
| 2. SELECT course final test answers.srt | 23 KB | ||
| 2. Tree view, Menus and Editing code.mp4 | 22.2 MB | ||
| 2. Tree view, Menus and Editing code.srt | 8.8 KB | ||
| 2.1 15 - Final Test.sql | 4.8 KB | ||
| 2.2 final test - table relationships.pdf | 17.2 KB | ||
| 20. JOIN Clause - Part 2 - Joining multiple tables - Introduction.mp4 | 21.6 MB | ||
| 20. JOIN Clause - Part 2 - Joining multiple tables - Introduction.srt | 7.4 KB | ||
| 21. JOIN Clause - Part 2 - Joining multiple tables - Demonstration.mp4 | 19.3 MB | ||
| 21. JOIN Clause - Part 2 - Joining multiple tables - Demonstration.srt | 3.2 KB | ||
| 21.1 10 - table JOINS part 2.sql | 1.7 KB | ||
| 22. JOIN Clause - Part 2 - Joining multiple tables - Test Answers.mp4 | 56.3 MB | ||
| 22. JOIN Clause - Part 2 - Joining multiple tables - Test Answers.srt | 6.7 KB | ||
| 22.1 10 - table JOINS part 2 test.sql | 5.1 KB | ||
| 22.2 Table Joins part 2 test - table relationships.pdf | 12.8 KB | ||
| 23. Aggregates and Grouping - Introduction.mp4 | 7.5 MB | ||
| 23. Aggregates and Grouping - Introduction.srt | 2.9 KB | ||
| 24. Aggregate Functions - Demonstration.mp4 | 18.5 MB | ||
| 24. Aggregate Functions - Demonstration.srt | 3.3 KB | ||
| 24.1 11 - Agregate functions.sql | 2.7 KB | ||
| 24.2 Aggregate functions-.pdf | 169.8 KB | ||
| 25. GROUP BY Clause - Introduction.mp4 | 7.7 MB | ||
| 25. GROUP BY Clause - Introduction.srt | 1.7 KB | ||
| 26. GROUP BY Clause - Demonstration.mp4 | 20.1 MB | ||
| 26. GROUP BY Clause - Demonstration.srt | 4.4 KB | ||
| 26.1 12 - the GROUP BY clause.sql | 1.9 KB | ||
| 27. GROUP BY Clause - Test Answers.mp4 | 71.9 MB | ||
| 27. GROUP BY Clause - Test Answers.srt | 9.3 KB | ||
| 27.1 12 - the GROUP BY clause test.sql | 3.2 KB | ||
| 27.2 GROUP BY clause test - table relationships.pdf | 10.4 KB | ||
| 28. HAVING Clause - Introduction.mp4 | 6.4 MB | ||
| 28. HAVING Clause - Introduction.srt | 2.5 KB | ||
| 29. HAVING Clause - Demonstration.mp4 | 19.5 MB | ||
| 29. HAVING Clause - Demonstration.srt | 3.7 KB | ||
| 29.1 13 - the HAVING clause.sql | 1.7 KB | ||
| 3. AdventureWorks Database - Introduction.mp4 | 18.1 MB | ||
| 3. AdventureWorks Database - Introduction.srt | 3.5 KB | ||
| 3. Course Outro.mp4 | 1.4 MB | ||
| 3. Course Outro.srt | 921.6 B | ||
| 3. FROM clause - Demonstration.mp4 | 64 MB | ||
| 3. FROM clause - Demonstration.srt | 11.2 KB | ||
| 3.1 02 - the FROM clause.sql | 3.3 KB | ||
| 3.1 AdventureWorks2016 data dictionary.pdf | 600.1 KB | ||
| 30. HAVING Clause - Test Answers.mp4 | 30.6 MB | ||
| 30. HAVING Clause - Test Answers.srt | 4.5 KB | ||
| 30.1 13 - the HAVING clause test.sql | 2.4 KB | ||
| 30.2 HAVING clause test - table relationships.pdf | 10.1 KB | ||
| 4. FROM Clause - Test Answers.mp4 | 77.4 MB | ||
| 4. FROM Clause - Test Answers.srt | 8.5 KB | ||
| 4. Option 1 - Install AdventureWorks from a backup.mp4 | 81.7 MB | ||
| 4. Option 1 - Install AdventureWorks from a backup.srt | 11.7 KB | ||
| 4.1 02 - the FROM clause test.sql | 3.1 KB | ||
| 5. A note about Data Types.mp4 | 24.8 MB | ||
| 5. A note about Data Types.srt | 11.4 KB | ||
| 5. Option 2 - Install AdventureWorks from a script file.mp4 | 19.7 MB | ||
| 5. Option 2 - Install AdventureWorks from a script file.srt | 3 KB | ||
| 5.1 00 - create database and tables V1.sql | 42.1 MB | ||
| 5.1 SQL server basic data types.pdf | 303 KB | ||
| 6. WHERE Clause - Part 1 - Introduction.mp4 | 15.5 MB | ||
| 6. WHERE Clause - Part 1 - Introduction.srt | 3.4 KB | ||
| 6.1 WHERE clause operators.pdf | 61.3 KB | ||
| 7. WHERE Clause - Part 1 - Demonstration.mp4 | 57.8 MB | ||
| 7. WHERE Clause - Part 1 - Demonstration.srt | 8.7 KB | ||
| 7.1 03 - the WHERE clause part 1.sql | 3.3 KB | ||
| 8. A Note about Dates.mp4 | 37.7 MB | ||
| 8. A Note about Dates.srt | 10 KB | ||
| 8.1 04 - a note about DATES.sql | 2.8 KB | ||
| 8.2 DATES datatype.pdf | 104.7 KB | ||
| 9. WHERE Clause - Part 2 - LIKE operator - Introduction.mp4 | 15.7 MB | ||
| 9. WHERE Clause - Part 2 - LIKE operator - Introduction.srt | 8.1 KB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 120 total files | |||
SQL Server Developer : SELECT query foundations
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (3h 20m) | Size: 1.19 GB
Beginner querying and data analysis of Microsoft SQL server databases using the SELECT statement
What you'll learn:
Querying SQL server databases using the SELECT clause
Joining multiple tables in different ways to combine information
Filtering data to retrieve only the information you need
Using aggregation functions and processes to find totals and averages for reports
Requirements
Some knowledge of data reporting advantageous, but not necessary.
Description
SQL Server SELECT query foundations aims to teach you the basics of retrieving data from the Microsoft SQL server database engine.
the course contains details on how to use the SELECT clause in the SQL server environment to query database tables and bring back data to present in reports or applications
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 1 month | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments