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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：4c4286f23055109c86862e8a2c91a411999c7642
文件大小： 15.59G
已经下载：1034次
下载速度：极快
收录时间：2021-03-20
最近下载：2025-05-13

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:4C4286F23055109C86862E8A2C91A411999C7642
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 世界之窗 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 极乐禁地 91短视频 她趣 TikTok成人版 PornHub 听泉鉴鲍 草榴社区 哆哔涩漫 呦乐园 萝莉岛

最近搜索

文件列表

  • 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.mp4 173.1 MB
  • 10. Session 2 - Summarising and ordering data/6. Exercise.mp4 161.0 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.mp4 160.1 MB
  • 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.mp4 159.2 MB
  • 11. Session 2 - Adding a second table/10. Creating a third table.mp4 154.7 MB
  • 11. Session 2 - Adding a second table/11. JOINing three tables.mp4 146.6 MB
  • 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.mp4 143.6 MB
  • 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.mp4 139.4 MB
  • 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.mp4 134.6 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.mp4 133.5 MB
  • 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.mp4 133.4 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.mp4 129.3 MB
  • 5. Session 1 - String data types and functions/1. Strings.mp4 129.3 MB
  • 4. Session 1 - Number types and functions/8. Non-integer numbers.mp4 127.3 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.mp4 125.9 MB
  • 12. Session 2 - Find missing data, and delete and update data/1. Missing data.mp4 124.0 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.mp4 120.3 MB
  • 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.mp4 120.0 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.srt 118.0 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.mp4 118.0 MB
  • 11. Session 2 - Adding a second table/2. Designing a connection.mp4 117.7 MB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.mp4 116.4 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.mp4 116.3 MB
  • 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.mp4 116.3 MB
  • 4. Session 1 - Number types and functions/3. Creating temporary variables.mp4 114.0 MB
  • 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.mp4 112.9 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.mp4 112.6 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.mp4 112.1 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.mp4 111.5 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.mp4 110.9 MB
  • 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.mp4 109.6 MB
  • 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.mp4 109.1 MB
  • 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.mp4 108.8 MB
  • 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.mp4 108.7 MB
  • 51. Congratulations/1. You have finished this course - now what.mp4 107.8 MB
  • 39/6. FOR XML PATH.mp4 107.7 MB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.mp4 107.0 MB
  • 6. Session 1 - Date data types and functions/8. Converting from date to strings.mp4 105.0 MB
  • 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.mp4 104.8 MB
  • 4. Session 1 - Number types and functions/10. Mathematical functions.mp4 104.5 MB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.mp4 103.7 MB
  • 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.mp4 103.5 MB
  • 5. Session 1 - String data types and functions/7. Joining two strings together.mp4 102.0 MB
  • 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.mp4 101.0 MB
  • 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.mp4 100.1 MB
  • 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.mp4 99.3 MB
  • 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.mp4 98.8 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.mp4 98.6 MB
  • 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.mp4 97.4 MB
  • 46. Session 7 - Manage transactions/10. Isolation Levels in Action.mp4 97.0 MB
  • 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.mp4 96.1 MB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.mp4 94.9 MB
  • 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.mp4 94.5 MB
  • 47. Session 7 - Indexes/4. Clustered indexes.mp4 94.3 MB
  • 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.mp4 93.8 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.mp4 93.7 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.mp4 93.0 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.mp4 92.9 MB
  • 35. Session 6 - Objective 7d CTE statement/1. Self-Join.mp4 92.4 MB
  • 48. Session 7 - Optimise queries/8. Hints.mp4 92.2 MB
  • 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.mp4 91.6 MB
  • 43. Session 6 - Temporal Tables/1. What are temporal tables.mp4 91.5 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.mp4 91.2 MB
  • 6. Session 1 - Date data types and functions/7. Date offset.mp4 90.8 MB
  • 11. Session 2 - Adding a second table/5. Writing a JOIN query.mp4 89.8 MB
  • 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.mp4 89.7 MB
  • 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.mp4 88.7 MB
  • 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.mp4 88.4 MB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.mp4 88.1 MB
  • 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.srt 87.7 MB
  • 16. Session 3 - Objectives 2 and 3 Views/1. Creating views.mp4 87.7 MB
  • 36. Session 6 - Objective 14 Functions/6. APPLY.mp4 87.6 MB
  • 12. Session 2 - Find missing data, and delete and update data/5. Updating data.mp4 84.2 MB
  • 53/3. Installing SQL Server 2014.mp4 83.8 MB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.mp4 83.7 MB
  • 39/7. FOR XML EXPLICIT.mp4 83.3 MB
  • 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.mp4 83.1 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().mp4 82.7 MB
  • 48. Session 7 - Optimise queries/7. Plan guides.mp4 82.2 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.mp4 79.8 MB
  • 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.mp4 79.7 MB
  • 39/4. FOR XML RAW.mp4 79.6 MB
  • 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.mp4 78.7 MB
  • 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.mp4 78.5 MB
  • 41. Session 6 - Objective 10 Other XML considerations/3. Schema.mp4 78.2 MB
  • 36. Session 6 - Objective 14 Functions/2. Scalar Functions.mp4 78.2 MB
  • 13. End of Session 2/2. Thank you.mp4 77.9 MB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.mp4 77.0 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.mp4 76.4 MB
  • 8. Welcome to Session 2/1. Introduction.mp4 75.9 MB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.mp4 75.7 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.mp4 75.3 MB
  • 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.mp4 75.2 MB
  • 5. Session 1 - String data types and functions/9. Joining a string to a number.mp4 73.9 MB
  • 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.mp4 73.8 MB
  • 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.mp4 73.5 MB
  • 43. Session 6 - Temporal Tables/2. Creating temporal tables.mp4 73.4 MB
  • 47. Session 7 - Indexes/8. Include.mp4 72.9 MB
  • 4. Session 1 - Number types and functions/4. Integer numbers.mp4 72.8 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.mp4 72.6 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.mp4 72.1 MB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.mp4 72.1 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.mp4 71.4 MB
  • 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.mp4 71.2 MB
  • 5. Session 1 - String data types and functions/6. NULL - an introduction.mp4 71.0 MB
  • 31. Session 6 - Introduction/1. Introduction.mp4 69.3 MB
  • 46. Session 7 - Manage transactions/5. Trancount.mp4 68.7 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.mp4 68.2 MB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.mp4 67.6 MB
  • 6. Session 1 - Date data types and functions/1. Date data types.mp4 67.2 MB
  • 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.mp4 67.2 MB
  • 11. Session 2 - Adding a second table/1. Adding a second table.mp4 67.1 MB
  • 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.mp4 67.0 MB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.mp4 67.0 MB
  • 4. Session 1 - Number types and functions/12. Converting between number types.mp4 66.5 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.mp4 65.5 MB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.mp4 64.4 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.mp4 64.0 MB
  • 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.mp4 63.9 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.mp4 63.9 MB
  • 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.mp4 63.9 MB
  • 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.mp4 63.4 MB
  • 53/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 63.2 MB
  • 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.mp4 62.8 MB
  • 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.mp4 62.1 MB
  • 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.mp4 61.5 MB
  • 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.mp4 60.8 MB
  • 5. Session 1 - String data types and functions/3. String Functions - extraction.mp4 60.4 MB
  • 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.mp4 60.3 MB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..mp4 59.6 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.mp4 59.5 MB
  • 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.mp4 59.1 MB
  • 23. End of Session 4!/2. Well done!.mp4 58.5 MB
  • 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.mp4 58.4 MB
  • 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.mp4 58.2 MB
  • 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.mp4 58.1 MB
  • 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.mp4 57.8 MB
  • 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.mp4 57.5 MB
  • 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).mp4 57.5 MB
  • 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.mp4 57.0 MB
  • 2. Session 1 - Starting SQL Server/4. Creating our first queries.mp4 56.5 MB
  • 24. Session 5 - Introduction/1. Introduction.mp4 56.4 MB
  • 47. Session 7 - Indexes/6. Non-clustered indexes.mp4 56.0 MB
  • 39/3. Creating XML variable and XML field.mp4 55.9 MB
  • 26. Session 5 - Objective 9d Ranking functions/2. NTILE.mp4 55.8 MB
  • 14. Session 3 - Introduction/1. Introduction.mp4 55.5 MB
  • 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.mp4 55.3 MB
  • 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.mp4 54.6 MB
  • 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.mp4 54.5 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.mp4 54.3 MB
  • 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.mp4 54.0 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.mp4 53.9 MB
  • 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.mp4 53.4 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.mp4 53.3 MB
  • 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.mp4 52.6 MB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.srt 52.5 MB
  • 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.mp4 52.4 MB
  • 45. Session 7 - Introduction/1. Introduction.mp4 52.2 MB
  • 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.mp4 51.9 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.mp4 51.8 MB
  • 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.mp4 51.1 MB
  • 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.mp4 50.7 MB
  • 19. Session 4 - Introduction/1. Introduction.srt 50.6 MB
  • 19. Session 4 - Introduction/1. Introduction.mp4 50.6 MB
  • 36. Session 6 - Objective 14 Functions/4. Inline Table Function.mp4 50.1 MB
  • 33. Session 6 - Objective 7e WITH statement/1. WITH statement.mp4 50.1 MB
  • 14. Session 3 - Introduction/5. Summary of and problems with our existing database.mp4 49.7 MB
  • 16. Session 3 - Objectives 2 and 3 Views/6. Security.mp4 49.6 MB
  • 48. Session 7 - Optimise queries/9. Statistics IO.mp4 49.4 MB
  • 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.mp4 49.4 MB
  • 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.mp4 48.1 MB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.mp4 47.8 MB
  • 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.mp4 47.8 MB
  • 30. End of Session 5/2. Well done!.mp4 46.8 MB
  • 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.mp4 46.7 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.mp4 45.9 MB
  • 39/5. FOR XML AUTO.mp4 45.5 MB
  • 18. Session 3 - Conclusion/2. Well done!.mp4 44.7 MB
  • 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.mp4 43.7 MB
  • 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.mp4 43.2 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.mp4 43.1 MB
  • 3. Session 1 - Creating tables - First pass/7. Retrieving data.mp4 42.9 MB
  • 48. Session 7 - Optimise queries/6. A more advanced query plan.mp4 42.4 MB
  • 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.mp4 42.0 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.mp4 42.0 MB
  • 7. Session 1 - Conclusion/2. Well done!.mp4 41.9 MB
  • 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.mp4 41.2 MB
  • 39/2. Attributes.mp4 40.9 MB
  • 39/1. Introduction to XML - Let's make a shopping list.mp4 40.8 MB
  • 45. Session 7 - Introduction/3. Session 7 Resources.mp4 40.4 MB
  • 46. Session 7 - Manage transactions/6. Scope and type of locks.mp4 40.1 MB
  • 4. Session 1 - Number types and functions/1. Creating an Employee table.mp4 39.4 MB
  • 47. Session 7 - Indexes/2. Heaps, and scans.mp4 39.0 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.mp4 38.5 MB
  • 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.mp4 37.8 MB
  • 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.mp4 37.4 MB
  • 32. Session 6 - Objective 7 Sub-queries/1. Table structure.mp4 37.4 MB
  • 46. Session 7 - Manage transactions/4. Mark a transaction.mp4 37.3 MB
  • 47. Session 7 - Indexes/3. B-Tree.mp4 36.9 MB
  • 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.mp4 36.7 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.mp4 36.0 MB
  • 47. Session 7 - Indexes/7. Filtered Indices.mp4 34.3 MB
  • 2. Session 1 - Starting SQL Server/1. Opening SQL Server.mp4 34.3 MB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.mp4 33.6 MB
  • 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.mp4 33.5 MB
  • 52/2. Installing SQL Server back engine.mp4 33.1 MB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.mp4 32.6 MB
  • 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.mp4 31.6 MB
  • 52/3. Installing SQL Server Front Engine.mp4 31.1 MB
  • 11. Session 2 - Adding a second table/8. Different types of JOIN.mp4 30.3 MB
  • 36. Session 6 - Objective 14 Functions/1. Introduction.mp4 30.2 MB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.mp4 29.9 MB
  • 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.mp4 29.8 MB
  • 47. Session 7 - Indexes/1. Re-introducing Query plans.mp4 28.4 MB
  • 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.mp4 28.3 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.mp4 27.8 MB
  • 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.srt 27.3 MB
  • 44. Session 6 - Conclusion/2. Well done!.mp4 26.7 MB
  • 3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.mp4 26.5 MB
  • 51. Congratulations/2. Bonus Lecture.mp4 25.9 MB
  • 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.mp4 25.1 MB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.mp4 25.1 MB
  • 46. Session 7 - Manage transactions/2. Implicit transactions.mp4 24.8 MB
  • 46. Session 7 - Manage transactions/9. What are Isolation levels.mp4 24.3 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.mp4 23.8 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.mp4 23.6 MB
  • 51. Congratulations/3. Thank you, and goodbye.mp4 23.1 MB
  • 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.mp4 22.3 MB
  • 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.mp4 22.0 MB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.mp4 21.5 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.mp4 20.5 MB
  • 3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.mp4 19.4 MB
  • 46. Session 7 - Manage transactions/1. Introduction - What are transactions.mp4 17.9 MB
  • 2. Session 1 - Starting SQL Server/3. Create a database.mp4 17.8 MB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.mp4 17.5 MB
  • 45. Session 7 - Introduction/2. Curriculum.mp4 17.2 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.srt 16.8 MB
  • 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.mp4 16.6 MB
  • 52/1. Downloading SQL Server back engine - the Developer edition - for free!.mp4 16.3 MB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.mp4 14.9 MB
  • 23. End of Session 4!/1. BONUS - Recap, Look ahead.mp4 14.3 MB
  • 14. Session 3 - Introduction/4. Objectives.mp4 13.7 MB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.mp4 13.0 MB
  • 31. Session 6 - Introduction/2. Objectives.srt 12.4 MB
  • 31. Session 6 - Introduction/2. Objectives.mp4 12.3 MB
  • 44. Session 6 - Conclusion/1. Bonus lecture.mp4 12.3 MB
  • 29. Session 5 - Objective 9c Spatial aggregates/12. Summary.mp4 11.9 MB
  • 30. End of Session 5/1. End of Session 5.mp4 10.2 MB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.mp4 10.0 MB
  • 49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.mp4 9.9 MB
  • 20. Session 4 - Objective 13 Combine datasets/13. Summary.mp4 9.7 MB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.mp4 7.7 MB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.mp4 7.7 MB
  • 46. Session 7 - Manage transactions/11. Conclusion.mp4 5.7 MB
  • 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.mp4 5.3 MB
  • 11. Session 2 - Adding a second table/3.1 tblTransaction150707.xlsx 301.9 kB
  • 14. Session 3 - Introduction/2.1 CreateDatabaseSession3.sql 151.4 kB
  • 19. Session 4 - Introduction/2.1 CreateDatabaseSession3.sql 151.4 kB
  • 45. Session 7 - Introduction/3.2 CreateDatabaseSession7.sql 151.4 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/4.1 Exam 70-461.pptx 113.9 kB
  • 8. Welcome to Session 2/2.1 70 461data.xlsx 83.4 kB
  • 8. Welcome to Session 2/2.3 70-461datau.xlsx 83.4 kB
  • 8. Welcome to Session 2/2.2 70-461dataZIPFile.zip 76.2 kB
  • 31. Session 6 - Introduction/3.3 70-461Session6-180501.docx 59.5 kB
  • 45. Session 7 - Introduction/3.1 70-461Session7.181025.docx 50.7 kB
  • 31. Session 6 - Introduction/3.1 Session6Start.sql 48.6 kB
  • 24. Session 5 - Introduction/2.1 CreateDatabaseSession5.zip 48.2 kB
  • 24. Session 5 - Introduction/3.1 70-461Session5-150717.docx 46.1 kB
  • 14. Session 3 - Introduction/3.1 70-461-Session-3-150707.docx 45.2 kB
  • 19. Session 4 - Introduction/3.1 70-461Session4-150721.docx 35.1 kB
  • 8. Welcome to Session 2/3.2 70 461 Session 2 150703.docx 32.4 kB
  • 8. Welcome to Session 2/3.1 70-461-Session-2-150703 ZIPFile.zip 29.2 kB
  • 7. Session 1 - Conclusion/1.1 70-461-Session-1-190819.docx 26.5 kB
  • 4. Session 1 - Number types and functions/2.1 70-461-Session-1-200902.docx 26.1 kB
  • 4. Session 1 - Number types and functions/8. Non-integer numbers.srt 23.6 kB
  • 20. Session 4 - Objective 13 Combine datasets/4. CASE statement.srt 20.7 kB
  • 52/2. Installing SQL Server back engine.srt 20.6 kB
  • 11. Session 2 - Adding a second table/11. JOINing three tables.srt 20.4 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.srt 20.2 kB
  • 11. Session 2 - Adding a second table/10. Creating a third table.srt 19.7 kB
  • 10. Session 2 - Summarising and ordering data/6. Exercise.srt 19.5 kB
  • 5. Session 1 - String data types and functions/1. Strings.srt 19.2 kB
  • 10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.srt 19.2 kB
  • 20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.srt 18.9 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.srt 18.8 kB
  • 9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.srt 18.4 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.srt 18.3 kB
  • 49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.srt 18.1 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.srt 18.0 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.srt 17.9 kB
  • 20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.srt 17.6 kB
  • 9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.srt 17.6 kB
  • 11. Session 2 - Adding a second table/2. Designing a connection.srt 17.5 kB
  • 20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.srt 17.4 kB
  • 46. Session 7 - Manage transactions/10. Isolation Levels in Action.srt 17.4 kB
  • 20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.srt 17.2 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.srt 17.2 kB
  • 10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.srt 17.0 kB
  • 32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.srt 16.8 kB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.srt 16.8 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.srt 16.7 kB
  • 35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.srt 16.6 kB
  • 52/3. Installing SQL Server Front Engine.srt 16.3 kB
  • 5. Session 1 - String data types and functions/7. Joining two strings together.srt 16.3 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.srt 16.3 kB
  • 28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.srt 16.3 kB
  • 33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.srt 16.2 kB
  • 9. Session 2 - Creating and querying part of a table/2. Adding additional columns.srt 16.1 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.srt 16.1 kB
  • 48. Session 7 - Optimise queries/8. Hints.srt 16.0 kB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.srt 15.8 kB
  • 20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.srt 15.8 kB
  • 51. Congratulations/1. You have finished this course - now what.srt 15.8 kB
  • 31. Session 6 - Introduction/3.4 Temporal Tables190519.docx 15.6 kB
  • 47. Session 7 - Indexes/4. Clustered indexes.srt 15.4 kB
  • 4. Session 1 - Number types and functions/3. Creating temporary variables.srt 15.3 kB
  • 32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.srt 15.3 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.srt 15.2 kB
  • 11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.srt 15.1 kB
  • 46. Session 7 - Manage transactions/6. Scope and type of locks.srt 15.1 kB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.srt 15.1 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.srt 14.9 kB
  • 41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.srt 14.9 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.srt 14.8 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.srt 14.7 kB
  • 6. Session 1 - Date data types and functions/8. Converting from date to strings.srt 14.6 kB
  • 43. Session 6 - Temporal Tables/1. What are temporal tables.srt 14.5 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/2. POINT.srt 14.5 kB
  • 20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.srt 14.5 kB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.srt 14.4 kB
  • 31. Session 6 - Introduction/3.2 JSON190304.docx 14.3 kB
  • 12. Session 2 - Find missing data, and delete and update data/1. Missing data.srt 14.3 kB
  • 20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.srt 14.3 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/9. Geography.srt 14.3 kB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.srt 14.2 kB
  • 53/3. Installing SQL Server 2014.srt 14.2 kB
  • 46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.srt 14.0 kB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.srt 14.0 kB
  • 39/6. FOR XML PATH.srt 13.9 kB
  • 52/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 13.9 kB
  • 4. Session 1 - Number types and functions/10. Mathematical functions.srt 13.8 kB
  • 6. Session 1 - Date data types and functions/7. Date offset.srt 13.7 kB
  • 48. Session 7 - Optimise queries/7. Plan guides.srt 13.7 kB
  • 27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.srt 13.6 kB
  • 28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.srt 13.4 kB
  • 27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.srt 13.3 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.srt 13.2 kB
  • 11. Session 2 - Adding a second table/1. Adding a second table.srt 13.2 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.srt 13.1 kB
  • 35. Session 6 - Objective 7d CTE statement/1. Self-Join.srt 13.0 kB
  • 33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.srt 12.9 kB
  • 16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.srt 12.8 kB
  • 32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.srt 12.7 kB
  • 36. Session 6 - Objective 14 Functions/2. Scalar Functions.srt 12.5 kB
  • 12. Session 2 - Find missing data, and delete and update data/5. Updating data.srt 12.4 kB
  • 39/2. Attributes.srt 12.4 kB
  • 9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.srt 12.4 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().srt 12.3 kB
  • 22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.srt 12.3 kB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.srt 12.3 kB
  • 46. Session 7 - Manage transactions/1. Introduction - What are transactions.srt 12.2 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.srt 12.0 kB
  • 11. Session 2 - Adding a second table/5. Writing a JOIN query.srt 12.0 kB
  • 36. Session 6 - Objective 14 Functions/6. APPLY.srt 11.9 kB
  • 49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.srt 11.9 kB
  • 47. Session 7 - Indexes/8. Include.srt 11.8 kB
  • 48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.srt 11.7 kB
  • 27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.srt 11.6 kB
  • 5. Session 1 - String data types and functions/6. NULL - an introduction.srt 11.5 kB
  • 46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.srt 11.5 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.srt 11.5 kB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.srt 11.2 kB
  • 41. Session 6 - Objective 10 Other XML considerations/3. Schema.srt 11.1 kB
  • 12. Session 2 - Find missing data, and delete and update data/3. Deleting data.srt 11.1 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.srt 11.0 kB
  • 6. Session 1 - Date data types and functions/1. Date data types.srt 11.0 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.srt 11.0 kB
  • 5. Session 1 - String data types and functions/9. Joining a string to a number.srt 10.9 kB
  • 4. Session 1 - Number types and functions/12. Converting between number types.srt 10.9 kB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.srt 10.9 kB
  • 36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.srt 10.8 kB
  • 39/7. FOR XML EXPLICIT.srt 10.7 kB
  • 6. Session 1 - Date data types and functions/5. Today's date, and more date functions.srt 10.7 kB
  • 4. Session 1 - Number types and functions/4. Integer numbers.srt 10.6 kB
  • 40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.srt 10.6 kB
  • 32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.srt 10.6 kB
  • 40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.srt 10.6 kB
  • 53/1. Downloading SQL Server back engine - the Developer edition - for free!.srt 10.5 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.srt 10.3 kB
  • 43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.srt 10.3 kB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.srt 10.3 kB
  • 32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.srt 10.2 kB
  • 26. Session 5 - Objective 9d Ranking functions/2. NTILE.srt 10.2 kB
  • 32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.srt 10.1 kB
  • 16. Session 3 - Objectives 2 and 3 Views/6. Security.srt 10.1 kB
  • 46. Session 7 - Manage transactions/5. Trancount.srt 10.1 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.srt 10.1 kB
  • 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.srt 10.0 kB
  • 26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.srt 9.9 kB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..srt 9.9 kB
  • 47. Session 7 - Indexes/2. Heaps, and scans.srt 9.7 kB
  • 49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.srt 9.7 kB
  • 39/4. FOR XML RAW.srt 9.6 kB
  • 16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.srt 9.6 kB
  • 39/3. Creating XML variable and XML field.srt 9.6 kB
  • 5. Session 1 - String data types and functions/3. String Functions - extraction.srt 9.5 kB
  • 27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.srt 9.5 kB
  • 37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.srt 9.4 kB
  • 41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.srt 9.3 kB
  • 43. Session 6 - Temporal Tables/2. Creating temporal tables.srt 9.0 kB
  • 48. Session 7 - Optimise queries/9. Statistics IO.srt 8.9 kB
  • 40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).srt 8.9 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.srt 8.9 kB
  • 48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.srt 8.8 kB
  • 40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.srt 8.8 kB
  • 36. Session 6 - Objective 14 Functions/1. Introduction.srt 8.7 kB
  • 48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.srt 8.7 kB
  • 40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.srt 8.5 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.srt 8.5 kB
  • 14. Session 3 - Introduction/5. Summary of and problems with our existing database.srt 8.5 kB
  • 16. Session 3 - Objectives 2 and 3 Views/11. What is an index.srt 8.4 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.srt 8.4 kB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.srt 8.4 kB
  • 40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.srt 8.3 kB
  • 48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.srt 8.3 kB
  • 11. Session 2 - Adding a second table/8. Different types of JOIN.srt 8.3 kB
  • 6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.srt 8.2 kB
  • 47. Session 7 - Indexes/3. B-Tree.srt 8.1 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.srt 8.0 kB
  • 2. Session 1 - Starting SQL Server/4. Creating our first queries.srt 7.9 kB
  • 36. Session 6 - Objective 14 Functions/4. Inline Table Function.srt 7.9 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.srt 7.9 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.srt 7.8 kB
  • 36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.srt 7.8 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.srt 7.7 kB
  • 39/1. Introduction to XML - Let's make a shopping list.srt 7.6 kB
  • 32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.srt 7.6 kB
  • 45. Session 7 - Introduction/3. Session 7 Resources.srt 7.6 kB
  • 32. Session 6 - Objective 7 Sub-queries/1. Table structure.srt 7.6 kB
  • 4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.srt 7.5 kB
  • 41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.srt 7.5 kB
  • 47. Session 7 - Indexes/6. Non-clustered indexes.srt 7.5 kB
  • 43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.srt 7.4 kB
  • 16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.srt 7.4 kB
  • 48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.srt 7.4 kB
  • 28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.srt 7.4 kB
  • 48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.srt 7.4 kB
  • 24. Session 5 - Introduction/3.2 Session5Start.sql.zip 7.3 kB
  • 48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.srt 7.3 kB
  • 16. Session 3 - Objectives 2 and 3 Views/5. Securing views.srt 7.2 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.srt 7.1 kB
  • 3. Session 1 - Creating tables - First pass/7. Retrieving data.srt 6.9 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/1.1 Session5Start.zip 6.9 kB
  • 46. Session 7 - Manage transactions/9. What are Isolation levels.srt 6.8 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.srt 6.7 kB
  • 47. Session 7 - Indexes/7. Filtered Indices.srt 6.7 kB
  • 25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.srt 6.6 kB
  • 33. Session 6 - Objective 7e WITH statement/1. WITH statement.srt 6.6 kB
  • 47. Session 7 - Indexes/1. Re-introducing Query plans.srt 6.6 kB
  • 39/5. FOR XML AUTO.srt 6.6 kB
  • 48. Session 7 - Optimise queries/6. A more advanced query plan.srt 6.6 kB
  • 41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.srt 6.4 kB
  • 13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.srt 6.3 kB
  • 2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.srt 6.1 kB
  • 45. Session 7 - Introduction/2. Curriculum.srt 5.9 kB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.srt 5.9 kB
  • 18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.srt 5.9 kB
  • 3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.srt 5.9 kB
  • 4. Session 1 - Number types and functions/1. Creating an Employee table.srt 5.8 kB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.srt 5.8 kB
  • 46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.srt 5.7 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.srt 5.6 kB
  • 51. Congratulations/2. Bonus Lecture.srt 5.5 kB
  • 23. End of Session 4!/1. BONUS - Recap, Look ahead.srt 5.3 kB
  • 50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.srt 5.1 kB
  • 46. Session 7 - Manage transactions/4. Mark a transaction.srt 5.1 kB
  • 21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.srt 5.0 kB
  • 43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.srt 4.9 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.srt 4.8 kB
  • 29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.srt 4.8 kB
  • 14. Session 3 - Introduction/4. Objectives.srt 4.8 kB
  • 4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.srt 4.8 kB
  • 46. Session 7 - Manage transactions/2. Implicit transactions.srt 4.5 kB
  • 34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.srt 4.5 kB
  • 16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.srt 4.4 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.srt 4.3 kB
  • 3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.srt 4.3 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.srt 4.3 kB
  • 31. Session 6 - Introduction/1. Introduction.srt 4.1 kB
  • 23. End of Session 4!/2. Well done!.srt 4.1 kB
  • 38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.srt 4.1 kB
  • 24. Session 5 - Introduction/1. Introduction.srt 4.1 kB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.srt 4.0 kB
  • 43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.srt 4.0 kB
  • 44. Session 6 - Conclusion/1. Bonus lecture.srt 4.0 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.srt 4.0 kB
  • 14. Session 3 - Introduction/1. Introduction.srt 3.9 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.8 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.srt 3.8 kB
  • 45. Session 7 - Introduction/1. Introduction.srt 3.8 kB
  • 15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.srt 3.6 kB
  • 20. Session 4 - Objective 13 Combine datasets/13. Summary.srt 3.5 kB
  • 3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.srt 3.5 kB
  • 8. Welcome to Session 2/1. Introduction.srt 3.4 kB
  • 18. Session 3 - Conclusion/2. Well done!.srt 3.4 kB
  • 7. Session 1 - Conclusion/2. Well done!.srt 3.3 kB
  • 13. End of Session 2/2. Thank you.srt 3.3 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.1 kB
  • 30. End of Session 5/2. Well done!.srt 3.1 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 3.0 kB
  • 17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.srt 2.5 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.1 kB
  • 44. Session 6 - Conclusion/2. Well done!.srt 1.9 kB
  • 51. Congratulations/3. Thank you, and goodbye.srt 1.8 kB
  • 1. Session 1 - Let's begin, and let's download SQL Server/5. Do you have Windows 7 or Windows Vista.html 1.5 kB
  • 42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/1. These next two sections require SQL Server 2016 or later.html 1.3 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 1.0 kB
  • 6. Session 1 - Date data types and functions/2. Using a computer language other than English.html 1.0 kB
  • 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

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！