| 1. Introduction to Aggregate functions.mp4 | 52.8 MB | ||
| 1. Introduction to Aggregate functions.srt | 7.8 KB | ||
| 1. Introduction to basic database concepts.mp4 | 65.3 MB | ||
| 1. Introduction to basic database concepts.srt | 11.1 KB | ||
| 1. Introduction to table joining.mp4 | 82.7 MB | ||
| 1. Introduction to table joining.srt | 12.3 KB | ||
| 1. Introduction to the GROUP BY clause.mp4 | 46 MB | ||
| 1. Introduction to the GROUP BY clause.srt | 6.9 KB | ||
| 1. Introduction to the HAVING clause.mp4 | 36.5 MB | ||
| 1. Introduction to the HAVING clause.srt | 5.7 KB | ||
| 1. Introduction to the ORDER BY clause.mp4 | 29 MB | ||
| 1. Introduction to the ORDER BY clause.srt | 4.5 KB | ||
| 1. Introduction to the SELECT statement.mp4 | 21.3 MB | ||
| 1. Introduction to the SELECT statement.srt | 3.4 KB | ||
| 1. Introduction to the WHERE clause.mp4 | 248.1 MB | ||
| 1. Introduction to the WHERE clause.srt | 31.8 KB | ||
| 1.1 01 - DB and SQL.pdf | 15.7 MB | ||
| 1.1 02 - SELECT statments.pdf | 15.7 MB | ||
| 1.1 03 - The WHERE clause.pdf | 15.8 MB | ||
| 1.1 04 - Aggregate functions.pdf | 7.8 MB | ||
| 1.1 05 - Group By.pdf | 15.7 MB | ||
| 1.1 06 - The HAVING clause.pdf | 15.8 MB | ||
| 1.1 07 - The ORDER BY clause.pdf | 15.8 MB | ||
| 1.1 08 - Introduction to joins.pdf | 15.8 MB | ||
| 2. Aggregate functions - MAX().mp4 | 37.8 MB | ||
| 2. Aggregate functions - MAX().srt | 7.1 KB | ||
| 2. Basic SELECT statements Part 1.mp4 | 41.8 MB | ||
| 2. Basic SELECT statements Part 1.srt | 9.8 KB | ||
| 2. Download & Install - SQL Express 2019.mp4 | 32.9 MB | ||
| 2. Download & Install - SQL Express 2019.srt | 6.4 KB | ||
| 2. Using the GROUP BY clause.mp4 | 61.3 MB | ||
| 2. Using the GROUP BY clause.srt | 8.9 KB | ||
| 2. Using the HAVING clause.mp4 | 64.3 MB | ||
| 2. Using the HAVING clause.srt | 9.3 KB | ||
| 2. Using the ORDER BY clause.mp4 | 80.9 MB | ||
| 2. Using the ORDER BY clause.srt | 14.4 KB | ||
| 2. WHERE clause - comparison operators - Part 1.mp4 | 61.5 MB | ||
| 2. WHERE clause - comparison operators - Part 1.srt | 7.6 KB | ||
| 2. the JOIN syntax and table aliases.mp4 | 70.6 MB | ||
| 2. the JOIN syntax and table aliases.srt | 9.7 KB | ||
| 2.1 08 - Joins - Syntax and aliases.pdf | 15.8 MB | ||
| 3. Aggregate functions - MIN().mp4 | 36.8 MB | ||
| 3. Aggregate functions - MIN().srt | 6 KB | ||
| 3. Assignments - GROUP BY.html | 204.8 B | ||
| 3. Assignments - the HAVING Clause.html | 204.8 B | ||
| 3. Assignments - the ORDER BY Clause.html | 204.8 B | ||
| 3. Basic SELECT statements Part 2.mp4 | 78.5 MB | ||
| 3. Basic SELECT statements Part 2.srt | 8.9 KB | ||
| 3. Download& Install - SSMS.mp4 | 31.3 MB | ||
| 3. Download& Install - SSMS.srt | 5.3 KB | ||
| 3. INNER JOIN.mp4 | 54.4 MB | ||
| 3. INNER JOIN.srt | 7.5 KB | ||
| 3. WHERE clause - comparison operators - Part 2.mp4 | 95.7 MB | ||
| 3. WHERE clause - comparison operators - Part 2.srt | 10.1 KB | ||
| 4. Aggregate functions - COUNT().mp4 | 61.2 MB | ||
| 4. Aggregate functions - COUNT().srt | 8.9 KB | ||
| 4. Basic SELECT statements Part 3.mp4 | 21.1 MB | ||
| 4. Basic SELECT statements Part 3.srt | 10.4 KB | ||
| 4. Download & install - AdventureWorks2019.mp4 | 51.1 MB | ||
| 4. Download & install - AdventureWorks2019.srt | 7.3 KB | ||
| 4. FULL (OUTER) JOIN.mp4 | 73.5 MB | ||
| 4. FULL (OUTER) JOIN.srt | 7.6 KB | ||
| 4. WHERE clause - logical operators.mp4 | 86.8 MB | ||
| 4. WHERE clause - logical operators.srt | 9.9 KB | ||
| 5. Aggregate functions - SUM().mp4 | 54.4 MB | ||
| 5. Aggregate functions - SUM().srt | 6.9 KB | ||
| 5. Basic SELECT statements Part 4.mp4 | 48.8 MB | ||
| 5. Basic SELECT statements Part 4.srt | 5.9 KB | ||
| 5. Basic database concepts.mp4 | 57.4 MB | ||
| 5. Basic database concepts.srt | 8.6 KB | ||
| 5. LEFT (OUTER) JOIN.mp4 | 61.1 MB | ||
| 5. LEFT (OUTER) JOIN.srt | 7.1 KB | ||
| 5. WHERE clause - the IN operator.mp4 | 38.9 MB | ||
| 5. WHERE clause - the IN operator.srt | 4.9 KB | ||
| 5.1 01 - Basic Database Concepts.pdf | 16.2 MB | ||
| 6. Aggregate functions - AVG().mp4 | 50.1 MB | ||
| 6. Aggregate functions - AVG().srt | 7.8 KB | ||
| 6. Assignments - SELECT statements.html | 204.8 B | ||
| 6. RIGHT (OUTER) JOIN.mp4 | 46.6 MB | ||
| 6. RIGHT (OUTER) JOIN.srt | 4.6 KB | ||
| 6. WHERE clause - the BETWEEN operator.mp4 | 47.2 MB | ||
| 6. WHERE clause - the BETWEEN operator.srt | 5 KB | ||
| 7. Assignments - Aggregate Functions.html | 204.8 B | ||
| 7. Introduction to CROSS JOIN.mp4 | 25.4 MB | ||
| 7. Introduction to CROSS JOIN.srt | 3.5 KB | ||
| 7. WHERE clause - the LIKE operator.mp4 | 58 MB | ||
| 7. WHERE clause - the LIKE operator.srt | 8.8 KB | ||
| 7.1 Presentation - 08 - Joins - Cross Joins.pdf | 832.6 KB | ||
| 8. CROSS JOIN.mp4 | 57.4 MB | ||
| 8. CROSS JOIN.srt | 6.2 KB | ||
| 8. WHERE clause - the IS NULL operator.mp4 | 30.9 MB | ||
| 8. WHERE clause - the IS NULL operator.srt | 3.1 KB | ||
| 9. Assignments - How to JOIN Tables.html | 204.8 B | ||
| 9. Assignments - the WHERE clause.html | 204.8 B | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 96 total files | |||
SQL Server Master Series - Beginner Course
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 39 lectures (5h 4m) | Size: 1.84 GB
The important first steps for those who are beginning their database journey.
What you'll learn:
SQL syntax - specifically Microsoft's dialect - but this course can be the basis for all SQL dialects.
How to download and install SQL Server on your computer
How to use and install SQL Server Management Studio as an interface to your SQL Server installation.
Learn to write queries to retrieve data from one or more tables or views
Requirements
No prior knowledge of SQL is necessary
Have a Windows computer available to follow along
Description
This course is for you if you are want lecture style, and hands-on experience with SQL. We start off every section with a presentation, and then we let the student go hands-on, where they follow us in the tool used to create queries and retrieve and view the returned data from the database. Each section also as tasks that the student will have to solve to reinforce the knowledge.
You will learn to fetch data from a single table, or even combine data from two or more tables to retrieve exactly what you need.
| 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