[Tutorialsplanet.NET] Udemy - 70-461, 761 Querying Microsoft SQL Server with Transact-SQL

Creation Time	Jan. 3, 2024, 3:16 a.m.
Last Access Time	Nov. 30, 2024, 7:31 p.m.
File Size	15.6 GB
Keywords	Tutorialsplanet Querying 70-461 761 - Udemy Transact-SQL SQL NET Server with Microsoft
Total Requests	25
Total Files	618
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.mp4 165.1 MB
10. Session 2 - Summarising and ordering data/6. Exercise.mp4 153.5 MB
29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.mp4 152.7 MB
10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.mp4 151.8 MB
11. Session 2 - Adding a second table/10. Creating a third table.mp4 147.6 MB
11. Session 2 - Adding a second table/11. JOINing three tables.mp4 139.8 MB
10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.mp4 136.9 MB
20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.mp4 132.9 MB
20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.mp4 128.4 MB
17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.mp4 127.3 MB
20. Session 4 - Objective 13 Combine datasets/4. CASE statement.mp4 127.2 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.mp4 123.3 MB
5. Session 1 - String data types and functions/1. Strings.mp4 123.3 MB
4. Session 1 - Number types and functions/8. Non-integer numbers.mp4 121.4 MB
29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.mp4 120.1 MB
12. Session 2 - Find missing data, and delete and update data/1. Missing data.mp4 118.3 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.mp4 114.8 MB
16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.mp4 114.5 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.srt 112.5 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.mp4 112.5 MB
11. Session 2 - Adding a second table/2. Designing a connection.mp4 112.2 MB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.mp4 111.0 MB
17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.mp4 111.0 MB
49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.mp4 110.9 MB
4. Session 1 - Number types and functions/3. Creating temporary variables.mp4 108.7 MB
35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.mp4 107.7 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.mp4 107.4 MB
29. Session 5 - Objective 9c Spatial aggregates/9. Geography.mp4 106.9 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.mp4 106.4 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.mp4 105.8 MB
28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.mp4 104.5 MB
9. Session 2 - Creating and querying part of a table/2. Adding additional columns.mp4 104.0 MB
9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.mp4 103.7 MB
20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.mp4 103.7 MB
51. Congratulations/1. You have finished this course - now what.mp4 102.8 MB
39/6. FOR XML PATH.mp4 102.7 MB
22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.mp4 102.0 MB
6. Session 1 - Date data types and functions/8. Converting from date to strings.mp4 100.1 MB
20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.mp4 99.9 MB
4. Session 1 - Number types and functions/10. Mathematical functions.mp4 99.7 MB
22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.mp4 98.9 MB
32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.mp4 98.7 MB
5. Session 1 - String data types and functions/7. Joining two strings together.mp4 97.3 MB
20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.mp4 96.4 MB
11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.mp4 95.5 MB
9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.mp4 94.7 MB
32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.mp4 94.3 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.mp4 94.0 MB
12. Session 2 - Find missing data, and delete and update data/3. Deleting data.mp4 92.9 MB
46. Session 7 - Manage transactions/10. Isolation Levels in Action.mp4 92.5 MB
41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.mp4 91.7 MB
22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.mp4 90.5 MB
28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.mp4 90.1 MB
47. Session 7 - Indexes/4. Clustered indexes.mp4 89.9 MB
20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.mp4 89.5 MB
25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.mp4 89.4 MB
1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.mp4 88.7 MB
17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.mp4 88.6 MB
35. Session 6 - Objective 7d CTE statement/1. Self-Join.mp4 88.1 MB
48. Session 7 - Optimise queries/8. Hints.mp4 88.0 MB
20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.mp4 87.4 MB
43. Session 6 - Temporal Tables/1. What are temporal tables.mp4 87.3 MB
25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.mp4 86.9 MB
6. Session 1 - Date data types and functions/7. Date offset.mp4 86.6 MB
11. Session 2 - Adding a second table/5. Writing a JOIN query.mp4 85.6 MB
33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.mp4 85.5 MB
43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.mp4 84.6 MB
33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.mp4 84.3 MB
22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.mp4 84.0 MB
16. Session 3 - Objectives 2 and 3 Views/1. Creating views.srt 83.6 MB
16. Session 3 - Objectives 2 and 3 Views/1. Creating views.mp4 83.6 MB
36. Session 6 - Objective 14 Functions/6. APPLY.mp4 83.6 MB
12. Session 2 - Find missing data, and delete and update data/5. Updating data.mp4 80.3 MB
53/3. Installing SQL Server 2014.mp4 79.9 MB
38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.mp4 79.8 MB
39/7. FOR XML EXPLICIT.mp4 79.5 MB
16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.mp4 79.3 MB
25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().mp4 78.9 MB
48. Session 7 - Optimise queries/7. Plan guides.mp4 78.4 MB
29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.mp4 76.1 MB
27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.mp4 76.0 MB
39/4. FOR XML RAW.mp4 76.0 MB
48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.mp4 75.0 MB
46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.mp4 74.9 MB
41. Session 6 - Objective 10 Other XML considerations/3. Schema.mp4 74.6 MB
36. Session 6 - Objective 14 Functions/2. Scalar Functions.mp4 74.6 MB
13. End of Session 2/2. Thank you.mp4 74.3 MB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.mp4 73.4 MB
29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.mp4 72.8 MB
8. Welcome to Session 2/1. Introduction.mp4 72.4 MB
38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.mp4 72.2 MB
25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.mp4 71.8 MB
27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.mp4 71.7 MB
5. Session 1 - String data types and functions/9. Joining a string to a number.mp4 70.5 MB
16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.mp4 70.4 MB
27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.mp4 70.1 MB
43. Session 6 - Temporal Tables/2. Creating temporal tables.mp4 70.0 MB
47. Session 7 - Indexes/8. Include.mp4 69.5 MB
4. Session 1 - Number types and functions/4. Integer numbers.mp4 69.4 MB
29. Session 5 - Objective 9c Spatial aggregates/2. POINT.mp4 69.3 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.mp4 68.8 MB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.mp4 68.7 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.mp4 68.1 MB
32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.mp4 67.9 MB
5. Session 1 - String data types and functions/6. NULL - an introduction.mp4 67.7 MB
31. Session 6 - Introduction/1. Introduction.mp4 66.1 MB
46. Session 7 - Manage transactions/5. Trancount.mp4 65.6 MB
1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.mp4 65.1 MB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.mp4 64.5 MB
6. Session 1 - Date data types and functions/1. Date data types.mp4 64.1 MB
6. Session 1 - Date data types and functions/5. Today's date, and more date functions.mp4 64.1 MB
11. Session 2 - Adding a second table/1. Adding a second table.mp4 64.0 MB
36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.mp4 63.9 MB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.mp4 63.9 MB
4. Session 1 - Number types and functions/12. Converting between number types.mp4 63.4 MB
25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.mp4 62.5 MB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.mp4 61.5 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.mp4 61.0 MB
40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.mp4 61.0 MB
17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.mp4 60.9 MB
37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.mp4 60.9 MB
49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.mp4 60.4 MB
53/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 60.3 MB
26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.mp4 59.9 MB
40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.mp4 59.2 MB
32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.mp4 58.6 MB
40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.mp4 57.9 MB
5. Session 1 - String data types and functions/3. String Functions - extraction.mp4 57.6 MB
40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.mp4 57.5 MB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..mp4 56.9 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.mp4 56.7 MB
49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.mp4 56.3 MB
23. End of Session 4!/2. Well done!.mp4 55.8 MB
32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.mp4 55.7 MB
27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.mp4 55.5 MB
32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.mp4 55.5 MB
4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.mp4 55.1 MB
6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.mp4 54.9 MB
40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).mp4 54.9 MB
37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.mp4 54.3 MB
2. Session 1 - Starting SQL Server/4. Creating our first queries.mp4 53.8 MB
24. Session 5 - Introduction/1. Introduction.mp4 53.8 MB
47. Session 7 - Indexes/6. Non-clustered indexes.mp4 53.4 MB
39/3. Creating XML variable and XML field.mp4 53.3 MB
26. Session 5 - Objective 9d Ranking functions/2. NTILE.mp4 53.2 MB
14. Session 3 - Introduction/1. Introduction.mp4 52.9 MB
32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.mp4 52.7 MB
40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.mp4 52.1 MB
48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.mp4 52.0 MB
17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.mp4 51.8 MB
2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.mp4 51.5 MB
1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.mp4 51.4 MB
16. Session 3 - Objectives 2 and 3 Views/5. Securing views.mp4 50.9 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.mp4 50.9 MB
16. Session 3 - Objectives 2 and 3 Views/11. What is an index.mp4 50.2 MB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.srt 50.1 MB
36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.mp4 50.0 MB
45. Session 7 - Introduction/1. Introduction.mp4 49.8 MB
48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.mp4 49.5 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.mp4 49.4 MB
48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.mp4 48.7 MB
48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.mp4 48.4 MB
19. Session 4 - Introduction/1. Introduction.srt 48.2 MB
19. Session 4 - Introduction/1. Introduction.mp4 48.2 MB
36. Session 6 - Objective 14 Functions/4. Inline Table Function.mp4 47.8 MB
33. Session 6 - Objective 7e WITH statement/1. WITH statement.mp4 47.8 MB
14. Session 3 - Introduction/5. Summary of and problems with our existing database.mp4 47.4 MB
16. Session 3 - Objectives 2 and 3 Views/6. Security.mp4 47.3 MB
48. Session 7 - Optimise queries/9. Statistics IO.mp4 47.1 MB
41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.mp4 47.1 MB
41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.mp4 45.8 MB
38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.mp4 45.6 MB
28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.mp4 45.6 MB
30. End of Session 5/2. Well done!.mp4 44.7 MB
3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.mp4 44.6 MB
25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.mp4 43.8 MB
39/5. FOR XML AUTO.mp4 43.4 MB
18. Session 3 - Conclusion/2. Well done!.mp4 42.7 MB
43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.mp4 41.7 MB
41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.mp4 41.2 MB
1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.mp4 41.1 MB
3. Session 1 - Creating tables - First pass/7. Retrieving data.mp4 41.0 MB
48. Session 7 - Optimise queries/6. A more advanced query plan.mp4 40.4 MB
25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.mp4 40.1 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.mp4 40.0 MB
7. Session 1 - Conclusion/2. Well done!.mp4 40.0 MB
48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.mp4 39.3 MB
39/2. Attributes.mp4 39.0 MB
39/1. Introduction to XML - Let's make a shopping list.mp4 39.0 MB
45. Session 7 - Introduction/3. Session 7 Resources.mp4 38.5 MB
46. Session 7 - Manage transactions/6. Scope and type of locks.mp4 38.2 MB
4. Session 1 - Number types and functions/1. Creating an Employee table.mp4 37.6 MB
47. Session 7 - Indexes/2. Heaps, and scans.mp4 37.2 MB
1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.mp4 36.7 MB
4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.mp4 36.1 MB
43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.mp4 35.7 MB
32. Session 6 - Objective 7 Sub-queries/1. Table structure.mp4 35.7 MB
46. Session 7 - Manage transactions/4. Mark a transaction.mp4 35.6 MB
47. Session 7 - Indexes/3. B-Tree.mp4 35.2 MB
43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.mp4 35.0 MB
17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.mp4 34.3 MB
47. Session 7 - Indexes/7. Filtered Indices.mp4 32.7 MB
2. Session 1 - Starting SQL Server/1. Opening SQL Server.mp4 32.7 MB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.mp4 32.1 MB
46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.mp4 32.0 MB
52/2. Installing SQL Server back engine.mp4 31.6 MB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.mp4 31.1 MB
46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.mp4 30.1 MB
52/3. Installing SQL Server Front Engine.mp4 29.7 MB
11. Session 2 - Adding a second table/8. Different types of JOIN.mp4 28.9 MB
36. Session 6 - Objective 14 Functions/1. Introduction.mp4 28.8 MB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.mp4 28.5 MB
3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.mp4 28.4 MB
47. Session 7 - Indexes/1. Re-introducing Query plans.mp4 27.1 MB
48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.mp4 27.0 MB
29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.mp4 26.5 MB
3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.srt 26.0 MB
44. Session 6 - Conclusion/2. Well done!.mp4 25.4 MB
3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.mp4 25.3 MB
51. Congratulations/2. Bonus Lecture.mp4 24.7 MB
16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.mp4 23.9 MB
38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.mp4 23.9 MB
46. Session 7 - Manage transactions/2. Implicit transactions.mp4 23.6 MB
46. Session 7 - Manage transactions/9. What are Isolation levels.mp4 23.2 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.mp4 22.7 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.mp4 22.5 MB
51. Congratulations/3. Thank you, and goodbye.mp4 22.1 MB
1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.mp4 21.3 MB
3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.mp4 21.0 MB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.mp4 20.5 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.mp4 19.6 MB
3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.mp4 18.5 MB
46. Session 7 - Manage transactions/1. Introduction - What are transactions.mp4 17.1 MB
2. Session 1 - Starting SQL Server/3. Create a database.mp4 17.0 MB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.mp4 16.7 MB
45. Session 7 - Introduction/2. Curriculum.mp4 16.4 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.srt 16.0 MB
18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.mp4 15.8 MB
52/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 15.6 MB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.mp4 14.2 MB
23. End of Session 4!/1. BONUS - Recap, Look ahead.mp4 13.6 MB
14. Session 3 - Introduction/4. Objectives.mp4 13.1 MB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.mp4 12.4 MB
31. Session 6 - Introduction/2. Objectives.srt 11.8 MB
31. Session 6 - Introduction/2. Objectives.mp4 11.8 MB
44. Session 6 - Conclusion/1. Bonus lecture.mp4 11.7 MB
29. Session 5 - Objective 9c Spatial aggregates/12. Summary.mp4 11.3 MB
30. End of Session 5/1. End of Session 5.mp4 9.7 MB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.mp4 9.5 MB
49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.mp4 9.5 MB
20. Session 4 - Objective 13 Combine datasets/13. Summary.mp4 9.2 MB
17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.mp4 7.4 MB
22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.mp4 7.3 MB
46. Session 7 - Manage transactions/11. Conclusion.mp4 5.5 MB
13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.mp4 5.1 MB
11. Session 2 - Adding a second table/3.1 tblTransaction150707.xlsx 294.9 KB
14. Session 3 - Introduction/2.1 CreateDatabaseSession3.sql 147.8 KB
19. Session 4 - Introduction/2.1 CreateDatabaseSession3.sql 147.8 KB
45. Session 7 - Introduction/3.2 CreateDatabaseSession7.sql 147.8 KB
1. Session 1 - Let's begin, and let's download SQL Server/4.1 Exam 70-461.pptx 111.3 KB
8. Welcome to Session 2/2.1 70 461data.xlsx 81.5 KB
8. Welcome to Session 2/2.3 70-461datau.xlsx 81.5 KB
8. Welcome to Session 2/2.2 70-461dataZIPFile.zip 74.4 KB
31. Session 6 - Introduction/3.3 70-461Session6-180501.docx 58.1 KB
45. Session 7 - Introduction/3.1 70-461Session7.181025.docx 49.5 KB
31. Session 6 - Introduction/3.1 Session6Start.sql 47.5 KB
24. Session 5 - Introduction/2.1 CreateDatabaseSession5.zip 47.1 KB
24. Session 5 - Introduction/3.1 70-461Session5-150717.docx 45.0 KB
14. Session 3 - Introduction/3.1 70-461-Session-3-150707.docx 44.2 KB
19. Session 4 - Introduction/3.1 70-461Session4-150721.docx 34.2 KB
8. Welcome to Session 2/3.2 70 461 Session 2 150703.docx 31.6 KB
8. Welcome to Session 2/3.1 70-461-Session-2-150703 ZIPFile.zip 28.5 KB
7. Session 1 - Conclusion/1.1 70-461-Session-1-190819.docx 25.9 KB
4. Session 1 - Number types and functions/2.1 70-461-Session-1-200902.docx 25.5 KB
4. Session 1 - Number types and functions/8. Non-integer numbers.srt 23.1 KB
20. Session 4 - Objective 13 Combine datasets/4. CASE statement.srt 20.2 KB
52/2. Installing SQL Server back engine.srt 20.1 KB
11. Session 2 - Adding a second table/11. JOINing three tables.srt 19.9 KB
29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.srt 19.7 KB
11. Session 2 - Adding a second table/10. Creating a third table.srt 19.2 KB
10. Session 2 - Summarising and ordering data/6. Exercise.srt 19.1 KB
5. Session 1 - String data types and functions/1. Strings.srt 18.8 KB
10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.srt 18.7 KB
20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.srt 18.4 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.srt 18.3 KB
9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.srt 18.0 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.srt 17.9 KB
49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.srt 17.7 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.srt 17.6 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.srt 17.5 KB
20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.srt 17.2 KB
9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.srt 17.2 KB
11. Session 2 - Adding a second table/2. Designing a connection.srt 17.1 KB
20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.srt 17.0 KB
46. Session 7 - Manage transactions/10. Isolation Levels in Action.srt 17.0 KB
20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.srt 16.8 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.srt 16.8 KB
10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.srt 16.6 KB
32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.srt 16.4 KB
22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.srt 16.4 KB
1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.srt 16.3 KB
35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.srt 16.2 KB
52/3. Installing SQL Server Front Engine.srt 15.9 KB
5. Session 1 - String data types and functions/7. Joining two strings together.srt 15.9 KB
1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.srt 15.9 KB
28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.srt 15.9 KB
33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.srt 15.8 KB
9. Session 2 - Creating and querying part of a table/2. Adding additional columns.srt 15.7 KB
17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.srt 15.7 KB
48. Session 7 - Optimise queries/8. Hints.srt 15.6 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.srt 15.5 KB
20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.srt 15.4 KB
51. Congratulations/1. You have finished this course - now what.srt 15.4 KB
31. Session 6 - Introduction/3.4 Temporal Tables190519.docx 15.2 KB
47. Session 7 - Indexes/4. Clustered indexes.srt 15.1 KB
4. Session 1 - Number types and functions/3. Creating temporary variables.srt 15.0 KB
32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.srt 14.9 KB
17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.srt 14.8 KB
11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.srt 14.7 KB
46. Session 7 - Manage transactions/6. Scope and type of locks.srt 14.7 KB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.srt 14.7 KB
17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.srt 14.6 KB
41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.srt 14.5 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.srt 14.5 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.srt 14.4 KB
6. Session 1 - Date data types and functions/8. Converting from date to strings.srt 14.3 KB
43. Session 6 - Temporal Tables/1. What are temporal tables.srt 14.2 KB
29. Session 5 - Objective 9c Spatial aggregates/2. POINT.srt 14.1 KB
20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.srt 14.1 KB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.srt 14.1 KB
31. Session 6 - Introduction/3.2 JSON190304.docx 14.0 KB
12. Session 2 - Find missing data, and delete and update data/1. Missing data.srt 14.0 KB
20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.srt 14.0 KB
29. Session 5 - Objective 9c Spatial aggregates/9. Geography.srt 14.0 KB
22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.srt 13.9 KB
53/3. Installing SQL Server 2014.srt 13.9 KB
46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.srt 13.7 KB
22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.srt 13.6 KB
39/6. FOR XML PATH.srt 13.6 KB
52/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 13.6 KB
4. Session 1 - Number types and functions/10. Mathematical functions.srt 13.5 KB
6. Session 1 - Date data types and functions/7. Date offset.srt 13.4 KB
48. Session 7 - Optimise queries/7. Plan guides.srt 13.4 KB
27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.srt 13.3 KB
28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.srt 13.1 KB
27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.srt 13.0 KB
29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.srt 12.9 KB
11. Session 2 - Adding a second table/1. Adding a second table.srt 12.8 KB
25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.srt 12.8 KB
35. Session 6 - Objective 7d CTE statement/1. Self-Join.srt 12.7 KB
33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.srt 12.6 KB
16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.srt 12.5 KB
32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.srt 12.4 KB
36. Session 6 - Objective 14 Functions/2. Scalar Functions.srt 12.2 KB
12. Session 2 - Find missing data, and delete and update data/5. Updating data.srt 12.1 KB
39/2. Attributes.srt 12.1 KB
9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.srt 12.1 KB
25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().srt 12.0 KB
22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.srt 12.0 KB
38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.srt 12.0 KB
46. Session 7 - Manage transactions/1. Introduction - What are transactions.srt 11.9 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.srt 11.7 KB
11. Session 2 - Adding a second table/5. Writing a JOIN query.srt 11.7 KB
36. Session 6 - Objective 14 Functions/6. APPLY.srt 11.6 KB
49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.srt 11.6 KB
47. Session 7 - Indexes/8. Include.srt 11.5 KB
48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.srt 11.4 KB
27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.srt 11.3 KB
5. Session 1 - String data types and functions/6. NULL - an introduction.srt 11.3 KB
46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.srt 11.2 KB
29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.srt 11.2 KB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.srt 10.9 KB
41. Session 6 - Objective 10 Other XML considerations/3. Schema.srt 10.9 KB
12. Session 2 - Find missing data, and delete and update data/3. Deleting data.srt 10.9 KB
25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.srt 10.8 KB
6. Session 1 - Date data types and functions/1. Date data types.srt 10.8 KB
25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.srt 10.7 KB
5. Session 1 - String data types and functions/9. Joining a string to a number.srt 10.7 KB
4. Session 1 - Number types and functions/12. Converting between number types.srt 10.6 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.srt 10.6 KB
36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.srt 10.6 KB
39/7. FOR XML EXPLICIT.srt 10.5 KB
6. Session 1 - Date data types and functions/5. Today's date, and more date functions.srt 10.4 KB
4. Session 1 - Number types and functions/4. Integer numbers.srt 10.4 KB
40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.srt 10.3 KB
32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.srt 10.3 KB
40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.srt 10.3 KB
53/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 10.3 KB
25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.srt 10.1 KB
43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.srt 10.1 KB
38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.srt 10.0 KB
32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.srt 9.9 KB
26. Session 5 - Objective 9d Ranking functions/2. NTILE.srt 9.9 KB
32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.srt 9.9 KB
16. Session 3 - Objectives 2 and 3 Views/6. Security.srt 9.9 KB
46. Session 7 - Manage transactions/5. Trancount.srt 9.9 KB
1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.srt 9.8 KB
37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.srt 9.8 KB
26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.srt 9.7 KB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..srt 9.7 KB
47. Session 7 - Indexes/2. Heaps, and scans.srt 9.5 KB
49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.srt 9.4 KB
39/4. FOR XML RAW.srt 9.4 KB
16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.srt 9.4 KB
39/3. Creating XML variable and XML field.srt 9.3 KB
5. Session 1 - String data types and functions/3. String Functions - extraction.srt 9.3 KB
27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.srt 9.3 KB
37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.srt 9.2 KB
41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.srt 9.1 KB
43. Session 6 - Temporal Tables/2. Creating temporal tables.srt 8.8 KB
48. Session 7 - Optimise queries/9. Statistics IO.srt 8.7 KB
40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).srt 8.7 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.srt 8.6 KB
48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.srt 8.6 KB
40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.srt 8.6 KB
36. Session 6 - Objective 14 Functions/1. Introduction.srt 8.5 KB
48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.srt 8.5 KB
40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.srt 8.3 KB
29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.srt 8.3 KB
14. Session 3 - Introduction/5. Summary of and problems with our existing database.srt 8.3 KB
16. Session 3 - Objectives 2 and 3 Views/11. What is an index.srt 8.2 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.srt 8.2 KB
38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.srt 8.2 KB
40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.srt 8.1 KB
48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.srt 8.1 KB
11. Session 2 - Adding a second table/8. Different types of JOIN.srt 8.1 KB
6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.srt 8.0 KB
47. Session 7 - Indexes/3. B-Tree.srt 7.9 KB
1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.srt 7.8 KB
2. Session 1 - Starting SQL Server/4. Creating our first queries.srt 7.7 KB
36. Session 6 - Objective 14 Functions/4. Inline Table Function.srt 7.7 KB
17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.srt 7.7 KB
17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.srt 7.6 KB
36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.srt 7.6 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.srt 7.6 KB
39/1. Introduction to XML - Let's make a shopping list.srt 7.5 KB
32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.srt 7.4 KB
45. Session 7 - Introduction/3. Session 7 Resources.srt 7.4 KB
32. Session 6 - Objective 7 Sub-queries/1. Table structure.srt 7.4 KB
4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.srt 7.4 KB
41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.srt 7.3 KB
47. Session 7 - Indexes/6. Non-clustered indexes.srt 7.3 KB
43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.srt 7.3 KB
16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.srt 7.2 KB
48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.srt 7.2 KB
28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.srt 7.2 KB
48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.srt 7.2 KB
24. Session 5 - Introduction/3.2 Session5Start.sql.zip 7.2 KB
48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.srt 7.1 KB
16. Session 3 - Objectives 2 and 3 Views/5. Securing views.srt 7.0 KB
17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.srt 7.0 KB
3. Session 1 - Creating tables - First pass/7. Retrieving data.srt 6.8 KB
25. Session 5 - Objective 9 Implement aggregate queries/1.1 Session5Start.zip 6.7 KB
46. Session 7 - Manage transactions/9. What are Isolation levels.srt 6.6 KB
25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.srt 6.5 KB
47. Session 7 - Indexes/7. Filtered Indices.srt 6.5 KB
25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.srt 6.5 KB
33. Session 6 - Objective 7e WITH statement/1. WITH statement.srt 6.5 KB
47. Session 7 - Indexes/1. Re-introducing Query plans.srt 6.4 KB
39/5. FOR XML AUTO.srt 6.4 KB
48. Session 7 - Optimise queries/6. A more advanced query plan.srt 6.4 KB
41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.srt 6.3 KB
13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.srt 6.2 KB
2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.srt 6.0 KB
45. Session 7 - Introduction/2. Curriculum.srt 5.8 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.srt 5.8 KB
18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.srt 5.8 KB
3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.srt 5.7 KB
4. Session 1 - Number types and functions/1. Creating an Employee table.srt 5.7 KB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.srt 5.7 KB
46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.srt 5.6 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.srt 5.4 KB
51. Congratulations/2. Bonus Lecture.srt 5.4 KB
23. End of Session 4!/1. BONUS - Recap, Look ahead.srt 5.2 KB
50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.srt 5.0 KB
46. Session 7 - Manage transactions/4. Mark a transaction.srt 5.0 KB
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.srt 4.9 KB
43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.srt 4.8 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.srt 4.7 KB
29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.srt 4.7 KB
14. Session 3 - Introduction/4. Objectives.srt 4.7 KB
4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.srt 4.6 KB
46. Session 7 - Manage transactions/2. Implicit transactions.srt 4.4 KB
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.srt 4.3 KB
16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.srt 4.3 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.srt 4.2 KB
3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.srt 4.2 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.srt 4.2 KB
31. Session 6 - Introduction/1. Introduction.srt 4.0 KB
23. End of Session 4!/2. Well done!.srt 4.0 KB
38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.srt 4.0 KB
24. Session 5 - Introduction/1. Introduction.srt 4.0 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.srt 3.9 KB
43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.srt 3.9 KB
44. Session 6 - Conclusion/1. Bonus lecture.srt 3.9 KB
1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.srt 3.9 KB
14. Session 3 - Introduction/1. Introduction.srt 3.8 KB
29. Session 5 - Objective 9c Spatial aggregates/12. Summary.srt 3.8 KB
2. Session 1 - Starting SQL Server/1. Opening SQL Server.srt 3.7 KB
1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.srt 3.7 KB
45. Session 7 - Introduction/1. Introduction.srt 3.7 KB
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.srt 3.5 KB
20. Session 4 - Objective 13 Combine datasets/13. Summary.srt 3.4 KB
3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.srt 3.4 KB
8. Welcome to Session 2/1. Introduction.srt 3.4 KB
18. Session 3 - Conclusion/2. Well done!.srt 3.3 KB
7. Session 1 - Conclusion/2. Well done!.srt 3.2 KB
13. End of Session 2/2. Thank you.srt 3.2 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.srt 3.1 KB
30. End of Session 5/1. End of Session 5.srt 3.0 KB
30. End of Session 5/2. Well done!.srt 3.0 KB
3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.srt 3.0 KB
49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.srt 2.9 KB
17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.srt 2.4 KB
2. Session 1 - Starting SQL Server/3. Create a database.srt 2.4 KB
22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.srt 2.3 KB
46. Session 7 - Manage transactions/11. Conclusion.srt 2.0 KB
44. Session 6 - Conclusion/2. Well done!.srt 1.8 KB
51. Congratulations/3. Thank you, and goodbye.srt 1.7 KB
1. Session 1 - Let's begin, and let's download SQL Server/5. Do you have Windows 7 or Windows Vista.html 1.4 KB
42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/1. These next two sections require SQL Server 2016 or later.html 1.2 KB
4. Session 1 - Number types and functions/6. Practice Activity Number 3.html 1.1 KB
4. Session 1 - Number types and functions/14. Practice Activity Number 4.html 1016 bytes
6. Session 1 - Date data types and functions/2. Using a computer language other than English.html 1012 bytes
1. Session 1 - Let's begin, and let's download SQL Server/2. Welcome to Udemy.html 886 bytes
3. Session 1 - Creating tables - First pass/10. How do you like these coding exercises.html 829 bytes
8. Welcome to Session 2/3. Session 2 Resources.html 722 bytes
3. Session 1 - Creating tables - First pass/13. Practice Activity Number 2.html 669 bytes
5. Session 1 - String data types and functions/11. Practice Activity Number 5.html 620 bytes
4. Session 1 - Number types and functions/2. Session 1 Resources.html 587 bytes
2. Session 1 - Starting SQL Server/5. Practice Activity Number 1 - Writing mathematical queries.html 511 bytes
5. Session 1 - String data types and functions/12. Practice Activity Number 5 - The Solution.html 504 bytes
4. Session 1 - Number types and functions/14.1 Practice-Activity-Number-4-Hints.txt 480 bytes
8. Welcome to Session 2/2. Spreadsheet Data.html 427 bytes
19. Session 4 - Introduction/2. Is this your first session.html 380 bytes
24. Session 5 - Introduction/2. Is this your first session.html 368 bytes
14. Session 3 - Introduction/2. Is this your first session.html 367 bytes
24. Session 5 - Introduction/3. Session 5 Resources.html 330 bytes
16. Session 3 - Objectives 2 and 3 Views/3. CREATE OR ALTER VIEW.html 326 bytes
53/2. Mount an ISO.html 325 bytes
11. Session 2 - Adding a second table/3. New spreadsheet data.html 319 bytes
5. Session 1 - String data types and functions/11.1 Practice-Activity-Number-5-Hints.txt 296 bytes
10. Session 2 - Summarising and ordering data/5. Changing blank strings to NULLs.html 292 bytes
5. Session 1 - String data types and functions/4. TRIM.html 287 bytes
2. Session 1 - Starting SQL Server/6. Coding Exercises.html 263 bytes
41. Session 6 - Objective 10 Other XML considerations/2.1 SampleDataBulkInsert.txt 260 bytes
7. Session 1 - Conclusion/1. BONUS - Review what you have learnt (PDF).html 240 bytes
14. Session 3 - Introduction/3. Resources.html 239 bytes
19. Session 4 - Introduction/3. Session 4 - Resources.html 239 bytes
31. Session 6 - Introduction/3. Session 6 Resources.html 239 bytes
41. Session 6 - Objective 10 Other XML considerations/2.2 SampleDataOpenRowset.txt 187 bytes
11. Session 2 - Adding a second table/7. The FROM clause - connecting to two tables.html 162 bytes
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/10. Check constraints.html 162 bytes
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/13. Primary Keys.html 162 bytes
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/16. Foreign Keys.html 162 bytes
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/4. Unique constraints.html 162 bytes
15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/7. Default constraints.html 162 bytes
16. Session 3 - Objectives 2 and 3 Views/10. Adding and deleting rows in views.html 162 bytes
16. Session 3 - Objectives 2 and 3 Views/13. Creating an indexed view.html 162 bytes
16. Session 3 - Objectives 2 and 3 Views/4. Creating views.html 162 bytes
16. Session 3 - Objectives 2 and 3 Views/7. Security.html 162 bytes
17. Session 3 - Objective 5 Create and alter DML triggers/4. Triggers.html 162 bytes
17. Session 3 - Objective 5 Create and alter DML triggers/7. Nested triggers and update functions.html 162 bytes
2. Session 1 - Starting SQL Server/7. Writing mathematical queries.html 162 bytes
2. Session 1 - Starting SQL Server/8. Databases and Queries.html 162 bytes
20. Session 4 - Objective 13 Combine datasets/12. MERGE.html 162 bytes
20. Session 4 - Objective 13 Combine datasets/3. UNION, UNION ALL, INTERSECT and EXCEPT.html 162 bytes
20. Session 4 - Objective 13 Combine datasets/5. CASE.html 162 bytes
20. Session 4 - Objective 13 Combine datasets/7. IsNull and Coalesce.html 162 bytes
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/3. Creating procedures.html 162 bytes
21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/8. While and Return.html 162 bytes
22. Session 4 - Objective 18a - Implement trycatchthrow/5. Trycatchthrow.html 162 bytes
25. Session 5 - Objective 9 Implement aggregate queries/10. Row and Range.html 162 bytes
25. Session 5 - Objective 9 Implement aggregate queries/3. OVER.html 162 bytes
25. Session 5 - Objective 9 Implement aggregate queries/5. PARTITION BY and ORDER BY.html 162 bytes
26. Session 5 - Objective 9d Ranking functions/3. Ranking functions.html 162 bytes
27. Session 5 - Objective 9a New analytic functions/5. New analytic functions.html 162 bytes
28. Section 5 - Objective 9b Grouping sets/4. Grouping sets.html 162 bytes
29. Session 5 - Objective 9c Spatial aggregates/11. Geography and Spatial Aggregates.html 162 bytes
29. Session 5 - Objective 9c Spatial aggregates/4. Point.html 162 bytes
29. Session 5 - Objective 9c Spatial aggregates/6. Lines and Circles.html 162 bytes
29. Session 5 - Objective 9c Spatial aggregates/8. Line queries.html 162 bytes
3. Session 1 - Creating tables - First pass/12. Deleting data using T-SQL.html 162 bytes
3. Session 1 - Creating tables - First pass/3. New Tables.html 162 bytes
3. Session 1 - Creating tables - First pass/6. Entering data using T-SQL.html 162 bytes
3. Session 1 - Creating tables - First pass/8. Retrieving data.html 162 bytes
3. Session 1 - Creating tables - First pass/9. The FROM clause - connecting to one table.html 162 bytes
32. Session 6 - Objective 7 Sub-queries/8. Sub-query.html 162 bytes
33. Session 6 - Objective 7e WITH statement/4. WITH statement.html 162 bytes
34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/4. Pivotting and Unpivotting.html 162 bytes
35. Session 6 - Objective 7d CTE statement/3. Recursive CTE.html 162 bytes
36. Session 6 - Objective 14 Functions/7. Functions.html 162 bytes
37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/3. Dynamic SQL.html 162 bytes
38. Session 6 - Objectives 8c GUIDs; and Sequences/5. GUIDs and SEQUENCEs.html 162 bytes
4. Session 1 - Number types and functions/11. Mathematical functions.html 162 bytes
4. Session 1 - Number types and functions/13. Converting between number types.html 162 bytes
4. Session 1 - Number types and functions/5. Integer numbers.html 162 bytes
4. Session 1 - Number types and functions/9. Non-integer numbers.html 162 bytes
47. Session 7 - Indexes/5. Quiz - Clustered Indexes.html 162 bytes
5. Session 1 - String data types and functions/10. Joining numbers to strings.html 162 bytes
5. Session 1 - String data types and functions/2. Strings.html 162 bytes
5. Session 1 - String data types and functions/5. String Functions - extraction.html 162 bytes
5. Session 1 - String data types and functions/8. NULL.html 162 bytes
6. Session 1 - Date data types and functions/4. Date data types.html 162 bytes
6. Session 1 - Date data types and functions/6. Today's date and more date functions.html 162 bytes
6. Session 1 - Date data types and functions/9. Converting from date to strings.html 162 bytes
10. Session 2 - Summarising and ordering data/2. Summarising and ordering data.html 161 bytes
10. Session 2 - Summarising and ordering data/4. Criteria on summarised data.html 161 bytes
11. Session 2 - Adding a second table/12. JOINing three tables.html 161 bytes
11. Session 2 - Adding a second table/6. Writing a JOIN query.html 161 bytes
11. Session 2 - Adding a second table/9. Different types of JOIN.html 161 bytes
12. Session 2 - Find missing data, and delete and update data/2. Missing data.html 161 bytes
12. Session 2 - Find missing data, and delete and update data/4. Deleting data.html 161 bytes
12. Session 2 - Find missing data, and delete and update data/6. Updating data.html 161 bytes
9. Session 2 - Creating and querying part of a table/4. SELECTing only part of a table - strings.html 161 bytes
9. Session 2 - Creating and querying part of a table/6. SELECTing only part of a table - numbers.html 161 bytes
[Tutorialsplanet.NET].url 128 bytes
52/4. The next step.html 125 bytes

[Tutorialsplanet.NET] Udemy - 70-461, 761 Querying Microsoft SQL Server with Transact-SQL

File List

Download Torrent

Related Resources

Copyright Infringement