Create Tool:ruTorrent (PHP Class - Adrien Gibrat)
Create Time:2020-12-11 13:47:39
File Size:15.59 GB
File Count:618
File Hash:4c4286f23055109c86862e8a2c91a411999c7642
| 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.srt |
| 1. Session 1 - Let's begin, and let's download SQL Server/2. Welcome to Udemy.html |
| 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.srt |
| 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.srt |
| 1. Session 1 - Let's begin, and let's download SQL Server/4.1 Exam 70-461.pptx |
| 1. Session 1 - Let's begin, and let's download SQL Server/5. Do you have Windows 7 or Windows Vista.html |
| 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.srt |
| 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.srt |
| 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.mp4 |
| 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.srt |
| 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.mp4 |
| 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.srt |
| 10. Session 2 - Summarising and ordering data/2. Summarising and ordering data.html |
| 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.mp4 |
| 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.srt |
| 10. Session 2 - Summarising and ordering data/4. Criteria on summarised data.html |
| 10. Session 2 - Summarising and ordering data/5. Changing blank strings to NULLs.html |
| 10. Session 2 - Summarising and ordering data/6. Exercise.mp4 |
| 10. Session 2 - Summarising and ordering data/6. Exercise.srt |
| 11. Session 2 - Adding a second table/1. Adding a second table.mp4 |
| 11. Session 2 - Adding a second table/1. Adding a second table.srt |
| 11. Session 2 - Adding a second table/10. Creating a third table.mp4 |
| 11. Session 2 - Adding a second table/10. Creating a third table.srt |
| 11. Session 2 - Adding a second table/11. JOINing three tables.mp4 |
| 11. Session 2 - Adding a second table/11. JOINing three tables.srt |
| 11. Session 2 - Adding a second table/12. JOINing three tables.html |
| 11. Session 2 - Adding a second table/2. Designing a connection.mp4 |
| 11. Session 2 - Adding a second table/2. Designing a connection.srt |
| 11. Session 2 - Adding a second table/3. New spreadsheet data.html |
| 11. Session 2 - Adding a second table/3.1 tblTransaction150707.xlsx |
| 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.mp4 |
| 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.srt |
| 11. Session 2 - Adding a second table/5. Writing a JOIN query.mp4 |
| 11. Session 2 - Adding a second table/5. Writing a JOIN query.srt |
| 11. Session 2 - Adding a second table/6. Writing a JOIN query.html |
| 11. Session 2 - Adding a second table/7. The FROM clause - connecting to two tables.html |
| 11. Session 2 - Adding a second table/8. Different types of JOIN.mp4 |
| 11. Session 2 - Adding a second table/8. Different types of JOIN.srt |
| 11. Session 2 - Adding a second table/9. Different types of JOIN.html |
| 12. Session 2 - Find missing data, and delete and update data/1. Missing data.mp4 |
| 12. Session 2 - Find missing data, and delete and update data/1. Missing data.srt |
| 12. Session 2 - Find missing data, and delete and update data/2. Missing data.html |
| 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.mp4 |
| 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.srt |
| 12. Session 2 - Find missing data, and delete and update data/4. Deleting data.html |
| 12. Session 2 - Find missing data, and delete and update data/5. Updating data.mp4 |
| 12. Session 2 - Find missing data, and delete and update data/5. Updating data.srt |
| 12. Session 2 - Find missing data, and delete and update data/6. Updating data.html |
| 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.mp4 |
| 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.srt |
| 13. End of Session 2/2. Thank you.mp4 |
| 13. End of Session 2/2. Thank you.srt |
| 14. Session 3 - Introduction/1. Introduction.mp4 |
| 14. Session 3 - Introduction/1. Introduction.srt |
| 14. Session 3 - Introduction/2. Is this your first session.html |
| 14. Session 3 - Introduction/2.1 CreateDatabaseSession3.sql |
| 14. Session 3 - Introduction/3. Resources.html |
| 14. Session 3 - Introduction/3.1 70-461-Session-3-150707.docx |
| 14. Session 3 - Introduction/4. Objectives.mp4 |
| 14. Session 3 - Introduction/4. Objectives.srt |
| 14. Session 3 - Introduction/5. Summary of and problems with our existing database.mp4 |
| 14. Session 3 - Introduction/5. Summary of and problems with our existing database.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/10. Check constraints.html |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/13. Primary Keys.html |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/16. Foreign Keys.html |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/4. Unique constraints.html |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/7. Default constraints.html |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.srt |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.mp4 |
| 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.srt |
| 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.srt |
| 16. Session 3 - Objectives 2 and 3 Views/10. Adding and deleting rows in views.html |
| 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.srt |
| 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.srt |
| 16. Session 3 - Objectives 2 and 3 Views/13. Creating an indexed view.html |
| 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.srt |
| 16. Session 3 - Objectives 2 and 3 Views/3. CREATE OR ALTER VIEW.html |
| 16. Session 3 - Objectives 2 and 3 Views/4. Creating views.html |
| 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.srt |
| 16. Session 3 - Objectives 2 and 3 Views/6. Security.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/6. Security.srt |
| 16. Session 3 - Objectives 2 and 3 Views/7. Security.html |
| 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.srt |
| 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.mp4 |
| 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/4. Triggers.html |
| 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/7. Nested triggers and update functions.html |
| 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.srt |
| 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.mp4 |
| 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.srt |
| 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.mp4 |
| 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.srt |
| 18. Session 3 - Conclusion/2. Well done!.mp4 |
| 18. Session 3 - Conclusion/2. Well done!.srt |
| 19. Session 4 - Introduction/1. Introduction.mp4 |
| 19. Session 4 - Introduction/1. Introduction.srt |
| 19. Session 4 - Introduction/2. Is this your first session.html |
| 19. Session 4 - Introduction/2.1 CreateDatabaseSession3.sql |
| 19. Session 4 - Introduction/3. Session 4 - Resources.html |
| 19. Session 4 - Introduction/3.1 70-461Session4-150721.docx |
| 2. Session 1 - Starting SQL Server/1. Opening SQL Server.mp4 |
| 2. Session 1 - Starting SQL Server/1. Opening SQL Server.srt |
| 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.mp4 |
| 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.srt |
| 2. Session 1 - Starting SQL Server/3. Create a database.mp4 |
| 2. Session 1 - Starting SQL Server/3. Create a database.srt |
| 2. Session 1 - Starting SQL Server/4. Creating our first queries.mp4 |
| 2. Session 1 - Starting SQL Server/4. Creating our first queries.srt |
| 2. Session 1 - Starting SQL Server/5. Practice Activity Number 1 - Writing mathematical queries.html |
| 2. Session 1 - Starting SQL Server/6. Coding Exercises.html |
| 2. Session 1 - Starting SQL Server/7. Writing mathematical queries.html |
| 2. Session 1 - Starting SQL Server/8. Databases and Queries.html |
| 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.srt |
| 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.srt |
| 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.srt |
| 20. Session 4 - Objective 13 Combine datasets/12. MERGE.html |
| 20. Session 4 - Objective 13 Combine datasets/13. Summary.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/13. Summary.srt |
| 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.srt |
| 20. Session 4 - Objective 13 Combine datasets/3. UNION, UNION ALL, INTERSECT and EXCEPT.html |
| 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.srt |
| 20. Session 4 - Objective 13 Combine datasets/5. CASE.html |
| 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.srt |
| 20. Session 4 - Objective 13 Combine datasets/7. IsNull and Coalesce.html |
| 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.srt |
| 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.mp4 |
| 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/3. Creating procedures.html |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.srt |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/8. While and Return.html |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.mp4 |
| 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.srt |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.mp4 |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.srt |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.mp4 |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.srt |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.mp4 |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.srt |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.mp4 |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.srt |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/5. Trycatchthrow.html |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.mp4 |
| 22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.srt |
| 23. End of Session 4!/1. BONUS - Recap, Look ahead.mp4 |
| 23. End of Session 4!/1. BONUS - Recap, Look ahead.srt |
| 23. End of Session 4!/2. Well done!.mp4 |
| 23. End of Session 4!/2. Well done!.srt |
| 24. Session 5 - Introduction/1. Introduction.mp4 |
| 24. Session 5 - Introduction/1. Introduction.srt |
| 24. Session 5 - Introduction/2. Is this your first session.html |
| 24. Session 5 - Introduction/2.1 CreateDatabaseSession5.zip |
| 24. Session 5 - Introduction/3. Session 5 Resources.html |
| 24. Session 5 - Introduction/3.1 70-461Session5-150717.docx |
| 24. Session 5 - Introduction/3.2 Session5Start.sql.zip |
| 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/1.1 Session5Start.zip |
| 25. Session 5 - Objective 9 Implement aggregate queries/10. Row and Range.html |
| 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/3. OVER.html |
| 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/5. PARTITION BY and ORDER BY.html |
| 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.srt |
| 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.mp4 |
| 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.srt |
| 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.mp4 |
| 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.srt |
| 26. Session 5 - Objective 9d Ranking functions/2. NTILE.mp4 |
| 26. Session 5 - Objective 9d Ranking functions/2. NTILE.srt |
| 26. Session 5 - Objective 9d Ranking functions/3. Ranking functions.html |
| 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.mp4 |
| 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.srt |
| 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.mp4 |
| 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.srt |
| 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.mp4 |
| 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.srt |
| 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.mp4 |
| 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.srt |
| 27. Session 5 - Objective 9a New analytic functions/5. New analytic functions.html |
| 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.mp4 |
| 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.srt |
| 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.mp4 |
| 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.srt |
| 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.mp4 |
| 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.srt |
| 28. Section 5 - Objective 9b Grouping sets/4. Grouping sets.html |
| 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/11. Geography and Spatial Aggregates.html |
| 29. Session 5 - Objective 9c Spatial aggregates/12. Summary.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/12. Summary.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/4. Point.html |
| 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/6. Lines and Circles.html |
| 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.srt |
| 29. Session 5 - Objective 9c Spatial aggregates/8. Line queries.html |
| 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.mp4 |
| 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.srt |
| 3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.mp4 |
| 3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.srt |
| 3. Session 1 - Creating tables - First pass/10. How do you like these coding exercises.html |
| 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.mp4 |
| 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.srt |
| 3. Session 1 - Creating tables - First pass/12. Deleting data using T-SQL.html |
| 3. Session 1 - Creating tables - First pass/13. Practice Activity Number 2.html |
| 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.mp4 |
| 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.srt |
| 3. Session 1 - Creating tables - First pass/3. New Tables.html |
| 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.mp4 |
| 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.srt |
| 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.mp4 |
| 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.srt |
| 3. Session 1 - Creating tables - First pass/6. Entering data using T-SQL.html |
| 3. Session 1 - Creating tables - First pass/7. Retrieving data.mp4 |
| 3. Session 1 - Creating tables - First pass/7. Retrieving data.srt |
| 3. Session 1 - Creating tables - First pass/8. Retrieving data.html |
| 3. Session 1 - Creating tables - First pass/9. The FROM clause - connecting to one table.html |
| 30. End of Session 5/1. End of Session 5.mp4 |
| 30. End of Session 5/1. End of Session 5.srt |
| 30. End of Session 5/2. Well done!.mp4 |
| 30. End of Session 5/2. Well done!.srt |
| 31. Session 6 - Introduction/1. Introduction.mp4 |
| 31. Session 6 - Introduction/1. Introduction.srt |
| 31. Session 6 - Introduction/2. Objectives.mp4 |
| 31. Session 6 - Introduction/2. Objectives.srt |
| 31. Session 6 - Introduction/3. Session 6 Resources.html |
| 31. Session 6 - Introduction/3.1 Session6Start.sql |
| 31. Session 6 - Introduction/3.2 JSON190304.docx |
| 31. Session 6 - Introduction/3.3 70-461Session6-180501.docx |
| 31. Session 6 - Introduction/3.4 Temporal Tables190519.docx |
| 32. Session 6 - Objective 7 Sub-queries/1. Table structure.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/1. Table structure.srt |
| 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.srt |
| 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.srt |
| 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.srt |
| 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.srt |
| 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.srt |
| 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.srt |
| 32. Session 6 - Objective 7 Sub-queries/8. Sub-query.html |
| 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.mp4 |
| 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.srt |
| 33. Session 6 - Objective 7e WITH statement/1. WITH statement.mp4 |
| 33. Session 6 - Objective 7e WITH statement/1. WITH statement.srt |
| 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.mp4 |
| 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.srt |
| 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.mp4 |
| 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.srt |
| 33. Session 6 - Objective 7e WITH statement/4. WITH statement.html |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.mp4 |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.srt |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..mp4 |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..srt |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.mp4 |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.srt |
| 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/4. Pivotting and Unpivotting.html |
| 35. Session 6 - Objective 7d CTE statement/1. Self-Join.mp4 |
| 35. Session 6 - Objective 7d CTE statement/1. Self-Join.srt |
| 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.mp4 |
| 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.srt |
| 35. Session 6 - Objective 7d CTE statement/3. Recursive CTE.html |
| 36. Session 6 - Objective 14 Functions/1. Introduction.mp4 |
| 36. Session 6 - Objective 14 Functions/1. Introduction.srt |
| 36. Session 6 - Objective 14 Functions/2. Scalar Functions.mp4 |
| 36. Session 6 - Objective 14 Functions/2. Scalar Functions.srt |
| 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.mp4 |
| 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.srt |
| 36. Session 6 - Objective 14 Functions/4. Inline Table Function.mp4 |
| 36. Session 6 - Objective 14 Functions/4. Inline Table Function.srt |
| 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.mp4 |
| 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.srt |
| 36. Session 6 - Objective 14 Functions/6. APPLY.mp4 |
| 36. Session 6 - Objective 14 Functions/6. APPLY.srt |
| 36. Session 6 - Objective 14 Functions/7. Functions.html |
| 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.mp4 |
| 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.srt |
| 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.mp4 |
| 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.srt |
| 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/3. Dynamic SQL.html |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.mp4 |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.srt |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.mp4 |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.srt |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.mp4 |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.srt |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.mp4 |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.srt |
| 38. Session 6 - Objectives 8c GUIDs; and Sequences/5. GUIDs and SEQUENCEs.html |
| 39/1. Introduction to XML - Let's make a shopping list.mp4 |
| 39/1. Introduction to XML - Let's make a shopping list.srt |
| 39/2. Attributes.mp4 |
| 39/2. Attributes.srt |
| 39/3. Creating XML variable and XML field.mp4 |
| 39/3. Creating XML variable and XML field.srt |
| 39/4. FOR XML RAW.mp4 |
| 39/4. FOR XML RAW.srt |
| 39/5. FOR XML AUTO.mp4 |
| 39/5. FOR XML AUTO.srt |
| 39/6. FOR XML PATH.mp4 |
| 39/6. FOR XML PATH.srt |
| 39/7. FOR XML EXPLICIT.mp4 |
| 39/7. FOR XML EXPLICIT.srt |
| 4. Session 1 - Number types and functions/1. Creating an Employee table.mp4 |
| 4. Session 1 - Number types and functions/1. Creating an Employee table.srt |
| 4. Session 1 - Number types and functions/10. Mathematical functions.mp4 |
| 4. Session 1 - Number types and functions/10. Mathematical functions.srt |
| 4. Session 1 - Number types and functions/11. Mathematical functions.html |
| 4. Session 1 - Number types and functions/12. Converting between number types.mp4 |
| 4. Session 1 - Number types and functions/12. Converting between number types.srt |
| 4. Session 1 - Number types and functions/13. Converting between number types.html |
| 4. Session 1 - Number types and functions/14. Practice Activity Number 4.html |
| 4. Session 1 - Number types and functions/14.1 Practice-Activity-Number-4-Hints.txt |
| 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.mp4 |
| 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.srt |
| 4. Session 1 - Number types and functions/2. Session 1 Resources.html |
| 4. Session 1 - Number types and functions/2.1 70-461-Session-1-200902.docx |
| 4. Session 1 - Number types and functions/3. Creating temporary variables.mp4 |
| 4. Session 1 - Number types and functions/3. Creating temporary variables.srt |
| 4. Session 1 - Number types and functions/4. Integer numbers.mp4 |
| 4. Session 1 - Number types and functions/4. Integer numbers.srt |
| 4. Session 1 - Number types and functions/5. Integer numbers.html |
| 4. Session 1 - Number types and functions/6. Practice Activity Number 3.html |
| 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.mp4 |
| 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.srt |
| 4. Session 1 - Number types and functions/8. Non-integer numbers.mp4 |
| 4. Session 1 - Number types and functions/8. Non-integer numbers.srt |
| 4. Session 1 - Number types and functions/9. Non-integer numbers.html |
| 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.srt |
| 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.srt |
| 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.srt |
| 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).srt |
| 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.srt |
| 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.mp4 |
| 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.srt |
| 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.mp4 |
| 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.srt |
| 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.mp4 |
| 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.srt |
| 41. Session 6 - Objective 10 Other XML considerations/2.1 SampleDataBulkInsert.txt |
| 41. Session 6 - Objective 10 Other XML considerations/2.2 SampleDataOpenRowset.txt |
| 41. Session 6 - Objective 10 Other XML considerations/3. Schema.mp4 |
| 41. Session 6 - Objective 10 Other XML considerations/3. Schema.srt |
| 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.mp4 |
| 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.srt |
| 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.mp4 |
| 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.srt |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/1. These next two sections require SQL Server 2016 or later.html |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.mp4 |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.srt |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.mp4 |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.srt |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.mp4 |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.srt |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.mp4 |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.srt |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.mp4 |
| 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.srt |
| 43. Session 6 - Temporal Tables/1. What are temporal tables.mp4 |
| 43. Session 6 - Temporal Tables/1. What are temporal tables.srt |
| 43. Session 6 - Temporal Tables/2. Creating temporal tables.mp4 |
| 43. Session 6 - Temporal Tables/2. Creating temporal tables.srt |
| 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.mp4 |
| 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.srt |
| 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.mp4 |
| 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.srt |
| 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.mp4 |
| 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.srt |
| 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.mp4 |
| 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.srt |
| 44. Session 6 - Conclusion/1. Bonus lecture.mp4 |
| 44. Session 6 - Conclusion/1. Bonus lecture.srt |
| 44. Session 6 - Conclusion/2. Well done!.mp4 |
| 44. Session 6 - Conclusion/2. Well done!.srt |
| 45. Session 7 - Introduction/1. Introduction.mp4 |
| 45. Session 7 - Introduction/1. Introduction.srt |
| 45. Session 7 - Introduction/2. Curriculum.mp4 |
| 45. Session 7 - Introduction/2. Curriculum.srt |
| 45. Session 7 - Introduction/3. Session 7 Resources.mp4 |
| 45. Session 7 - Introduction/3. Session 7 Resources.srt |
| 45. Session 7 - Introduction/3.1 70-461Session7.181025.docx |
| 45. Session 7 - Introduction/3.2 CreateDatabaseSession7.sql |
| 46. Session 7 - Manage transactions/1. Introduction - What are transactions.mp4 |
| 46. Session 7 - Manage transactions/1. Introduction - What are transactions.srt |
| 46. Session 7 - Manage transactions/10. Isolation Levels in Action.mp4 |
| 46. Session 7 - Manage transactions/10. Isolation Levels in Action.srt |
| 46. Session 7 - Manage transactions/11. Conclusion.mp4 |
| 46. Session 7 - Manage transactions/11. Conclusion.srt |
| 46. Session 7 - Manage transactions/2. Implicit transactions.mp4 |
| 46. Session 7 - Manage transactions/2. Implicit transactions.srt |
| 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.mp4 |
| 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.srt |
| 46. Session 7 - Manage transactions/4. Mark a transaction.mp4 |
| 46. Session 7 - Manage transactions/4. Mark a transaction.srt |
| 46. Session 7 - Manage transactions/5. Trancount.mp4 |
| 46. Session 7 - Manage transactions/5. Trancount.srt |
| 46. Session 7 - Manage transactions/6. Scope and type of locks.mp4 |
| 46. Session 7 - Manage transactions/6. Scope and type of locks.srt |
| 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.mp4 |
| 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.srt |
| 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.mp4 |
| 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.srt |
| 46. Session 7 - Manage transactions/9. What are Isolation levels.mp4 |
| 46. Session 7 - Manage transactions/9. What are Isolation levels.srt |
| 47. Session 7 - Indexes/1. Re-introducing Query plans.mp4 |
| 47. Session 7 - Indexes/1. Re-introducing Query plans.srt |
| 47. Session 7 - Indexes/2. Heaps, and scans.mp4 |
| 47. Session 7 - Indexes/2. Heaps, and scans.srt |
| 47. Session 7 - Indexes/3. B-Tree.mp4 |
| 47. Session 7 - Indexes/3. B-Tree.srt |
| 47. Session 7 - Indexes/4. Clustered indexes.mp4 |
| 47. Session 7 - Indexes/4. Clustered indexes.srt |
| 47. Session 7 - Indexes/5. Quiz - Clustered Indexes.html |
| 47. Session 7 - Indexes/6. Non-clustered indexes.mp4 |
| 47. Session 7 - Indexes/6. Non-clustered indexes.srt |
| 47. Session 7 - Indexes/7. Filtered Indices.mp4 |
| 47. Session 7 - Indexes/7. Filtered Indices.srt |
| 47. Session 7 - Indexes/8. Include.mp4 |
| 47. Session 7 - Indexes/8. Include.srt |
| 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.mp4 |
| 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.srt |
| 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.mp4 |
| 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.srt |
| 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.mp4 |
| 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.srt |
| 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.mp4 |
| 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.srt |
| 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.mp4 |
| 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.srt |
| 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.mp4 |
| 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.srt |
| 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.mp4 |
| 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.srt |
| 48. Session 7 - Optimise queries/6. A more advanced query plan.mp4 |
| 48. Session 7 - Optimise queries/6. A more advanced query plan.srt |
| 48. Session 7 - Optimise queries/7. Plan guides.mp4 |
| 48. Session 7 - Optimise queries/7. Plan guides.srt |
| 48. Session 7 - Optimise queries/8. Hints.mp4 |
| 48. Session 7 - Optimise queries/8. Hints.srt |
| 48. Session 7 - Optimise queries/9. Statistics IO.mp4 |
| 48. Session 7 - Optimise queries/9. Statistics IO.srt |
| 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.mp4 |
| 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.srt |
| 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.mp4 |
| 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.srt |
| 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.mp4 |
| 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.srt |
| 49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.mp4 |
| 49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.srt |
| 5. Session 1 - String data types and functions/1. Strings.mp4 |
| 5. Session 1 - String data types and functions/1. Strings.srt |
| 5. Session 1 - String data types and functions/10. Joining numbers to strings.html |
| 5. Session 1 - String data types and functions/11. Practice Activity Number 5.html |
| 5. Session 1 - String data types and functions/11.1 Practice-Activity-Number-5-Hints.txt |
| 5. Session 1 - String data types and functions/12. Practice Activity Number 5 - The Solution.html |
| 5. Session 1 - String data types and functions/2. Strings.html |
| 5. Session 1 - String data types and functions/3. String Functions - extraction.mp4 |
| 5. Session 1 - String data types and functions/3. String Functions - extraction.srt |
| 5. Session 1 - String data types and functions/4. TRIM.html |
| 5. Session 1 - String data types and functions/5. String Functions - extraction.html |
| 5. Session 1 - String data types and functions/6. NULL - an introduction.mp4 |
| 5. Session 1 - String data types and functions/6. NULL - an introduction.srt |
| 5. Session 1 - String data types and functions/7. Joining two strings together.mp4 |
| 5. Session 1 - String data types and functions/7. Joining two strings together.srt |
| 5. Session 1 - String data types and functions/8. NULL.html |
| 5. Session 1 - String data types and functions/9. Joining a string to a number.mp4 |
| 5. Session 1 - String data types and functions/9. Joining a string to a number.srt |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.mp4 |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.srt |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.mp4 |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.srt |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.mp4 |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.srt |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.mp4 |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.srt |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.mp4 |
| 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.srt |
| 51. Congratulations/1. You have finished this course - now what.mp4 |
| 51. Congratulations/1. You have finished this course - now what.srt |
| 51. Congratulations/2. Bonus Lecture.mp4 |
| 51. Congratulations/2. Bonus Lecture.srt |
| 51. Congratulations/3. Thank you, and goodbye.mp4 |
| 51. Congratulations/3. Thank you, and goodbye.srt |
| 52/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 |
| 52/1. Downloading SQL Server back engine - the Developer edition - for free!.srt |
| 52/2. Installing SQL Server back engine.mp4 |
| 52/2. Installing SQL Server back engine.srt |
| 52/3. Installing SQL Server Front Engine.mp4 |
| 52/3. Installing SQL Server Front Engine.srt |
| 52/4. The next step.html |
| 53/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 |
| 53/1. Downloading SQL Server back engine - the Developer edition - for free!.srt |
| 53/2. Mount an ISO.html |
| 53/3. Installing SQL Server 2014.mp4 |
| 53/3. Installing SQL Server 2014.srt |
| 6. Session 1 - Date data types and functions/1. Date data types.mp4 |
| 6. Session 1 - Date data types and functions/1. Date data types.srt |
| 6. Session 1 - Date data types and functions/2. Using a computer language other than English.html |
| 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.mp4 |
| 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.srt |
| 6. Session 1 - Date data types and functions/4. Date data types.html |
| 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.mp4 |
| 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.srt |
| 6. Session 1 - Date data types and functions/6. Today's date and more date functions.html |
| 6. Session 1 - Date data types and functions/7. Date offset.mp4 |
| 6. Session 1 - Date data types and functions/7. Date offset.srt |
| 6. Session 1 - Date data types and functions/8. Converting from date to strings.mp4 |
| 6. Session 1 - Date data types and functions/8. Converting from date to strings.srt |
| 6. Session 1 - Date data types and functions/9. Converting from date to strings.html |
| 7. Session 1 - Conclusion/1. BONUS - Review what you have learnt (PDF).html |
| 7. Session 1 - Conclusion/1.1 70-461-Session-1-190819.docx |
| 7. Session 1 - Conclusion/2. Well done!.mp4 |
| 7. Session 1 - Conclusion/2. Well done!.srt |
| 8. Welcome to Session 2/1. Introduction.mp4 |
| 8. Welcome to Session 2/1. Introduction.srt |
| 8. Welcome to Session 2/2. Spreadsheet Data.html |
| 8. Welcome to Session 2/2.1 70 461data.xlsx |
| 8. Welcome to Session 2/2.2 70-461dataZIPFile.zip |
| 8. Welcome to Session 2/2.3 70-461datau.xlsx |
| 8. Welcome to Session 2/3. Session 2 Resources.html |
| 8. Welcome to Session 2/3.1 70-461-Session-2-150703 ZIPFile.zip |
| 8. Welcome to Session 2/3.2 70 461 Session 2 150703.docx |
| 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.mp4 |
| 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.srt |
| 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.mp4 |
| 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.srt |
| 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.mp4 |
| 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.srt |
| 9. Session 2 - Creating and querying part of a table/4. SELECTing only part of a table - strings.html |
| 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.mp4 |
| 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.srt |
| 9. Session 2 - Creating and querying part of a table/6. SELECTing only part of a table - numbers.html |
| [Tutorialsplanet.NET].url |
| ahttp://0d.kebhana.mx:443/announce |
| ahttp://0d.kebhana.mx:443/announce |
TorrentBank
Copyright © 2024