种子简介

种子名称： [Tutorialsplanet.NET] Udemy - 70-461, 761 Querying Microsoft SQL Server with Transact-SQL
文件类型： 视频
文件数目： 248个文件
文件大小： 15.25 GB
收录时间： 2021-3-8 22:39
已经下载： 3次
资源热度： 346
最近下载： 2024-5-17 01:50

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:4c4286f23055109c86862e8a2c91a411999c7642&dn=[Tutorialsplanet.NET] Udemy - 70-461, 761 Querying Microsoft SQL Server with Transact-SQL 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

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

1. Session 1 - Let's begin, and let's download SQL Server/1. Introduction.mp451.43MB

1. Session 1 - Let's begin, and let's download SQL Server/3. The Udemy Interface.mp421.25MB

1. Session 1 - Let's begin, and let's download SQL Server/4. Curriculum.mp488.74MB

1. Session 1 - Let's begin, and let's download SQL Server/6. Downloading SQL Server.mp441.11MB

1. Session 1 - Let's begin, and let's download SQL Server/7. Installing SQL Server Back Engine.mp465.07MB

1. Session 1 - Let's begin, and let's download SQL Server/8. Installing SSMS.mp436.7MB

10. Session 2 - Summarising and ordering data/1. Summarising and ordering data.mp4136.93MB

10. Session 2 - Summarising and ordering data/3. Criteria on summarised data.mp4151.78MB

10. Session 2 - Summarising and ordering data/6. Exercise.mp4153.53MB

11. Session 2 - Adding a second table/1. Adding a second table.mp463.96MB

11. Session 2 - Adding a second table/10. Creating a third table.mp4147.56MB

11. Session 2 - Adding a second table/11. JOINing three tables.mp4139.77MB

11. Session 2 - Adding a second table/2. Designing a connection.mp4112.21MB

11. Session 2 - Adding a second table/4. Importing data and showing tables graphically.mp495.51MB

11. Session 2 - Adding a second table/5. Writing a JOIN query.mp485.64MB

11. Session 2 - Adding a second table/8. Different types of JOIN.mp428.87MB

12. Session 2 - Find missing data, and delete and update data/1. Missing data.mp4118.26MB

12. Session 2 - Find missing data, and delete and update data/3. Deleting data.mp492.86MB

12. Session 2 - Find missing data, and delete and update data/5. Updating data.mp480.29MB

13. End of Session 2/1. BONUS - Recap, Look ahead and Voucher Code.mp45.08MB

13. End of Session 2/2. Thank you.mp474.28MB

14. Session 3 - Introduction/1. Introduction.mp452.94MB

14. Session 3 - Introduction/4. Objectives.mp413.08MB

14. Session 3 - Introduction/5. Summary of and problems with our existing database.mp447.4MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/1. What are constraints.mp456.72MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/11. Primary key.mp468.06MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/12. Primary key - in practice.mp4105.76MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/14. Foreign key - what is it.mp468.77MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/15. Foreign key - in practice.mp4112.51MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/17. Summary.mp49.5MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/2. Unique constraints - what are they.mp422.66MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/3. Unique constraints in action.mp419.56MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/5. Default constraints - what are they.mp422.51MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/6. Default constraints in action.mp494.04MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/8. Check constraint - what are they.mp440.03MB

15. Session 3 - Objective 4 - Create and modify constraints (simple statements)/9. Check constraints - in practice.mp4106.38MB

16. Session 3 - Objectives 2 and 3 Views/1. Creating views.mp483.63MB

16. Session 3 - Objectives 2 and 3 Views/11. What is an index.mp450.18MB

16. Session 3 - Objectives 2 and 3 Views/12. Creating an indexed view.mp479.29MB

16. Session 3 - Objectives 2 and 3 Views/2. Altering and dropping views.mp470.43MB

16. Session 3 - Objectives 2 and 3 Views/5. Securing views.mp450.89MB

16. Session 3 - Objectives 2 and 3 Views/6. Security.mp447.33MB

16. Session 3 - Objectives 2 and 3 Views/8. Adding new rows to views.mp4114.47MB

16. Session 3 - Objectives 2 and 3 Views/9. Deleting rows in views.mp423.93MB

17. Session 3 - Objective 5 Create and alter DML triggers/1. What are triggers.mp434.3MB

17. Session 3 - Objective 5 Create and alter DML triggers/2. Creating an AFTER trigger.mp451.77MB

17. Session 3 - Objective 5 Create and alter DML triggers/3. Creating an INSTEAD OF trigger.mp4127.28MB

17. Session 3 - Objective 5 Create and alter DML triggers/5. Nested triggers.mp488.64MB

17. Session 3 - Objective 5 Create and alter DML triggers/6. Update functions.mp4110.95MB

17. Session 3 - Objective 5 Create and alter DML triggers/8. Handling multiple rows in a session.mp460.95MB

17. Session 3 - Objective 5 Create and alter DML triggers/9. Summary.mp47.36MB

18. Session 3 - Conclusion/1. BONUS - Recap, Look ahead and Voucher Code.mp415.84MB

18. Session 3 - Conclusion/2. Well done!.mp442.65MB

19. Session 4 - Introduction/1. Introduction.mp448.21MB

2. Session 1 - Starting SQL Server/1. Opening SQL Server.mp432.71MB

2. Session 1 - Starting SQL Server/2. Looking at SQL Server Management Studio.mp451.46MB

2. Session 1 - Starting SQL Server/3. Create a database.mp416.98MB

2. Session 1 - Starting SQL Server/4. Creating our first queries.mp453.85MB

20. Session 4 - Objective 13 Combine datasets/1. UNION and UNION ALL.mp487.4MB

20. Session 4 - Objective 13 Combine datasets/10. Let's expand our MERGE statement.mp496.37MB

20. Session 4 - Objective 13 Combine datasets/11. Merge with additional columns.mp4128.4MB

20. Session 4 - Objective 13 Combine datasets/13. Summary.mp49.23MB

20. Session 4 - Objective 13 Combine datasets/2. Intersect and Except.mp499.92MB

20. Session 4 - Objective 13 Combine datasets/4. CASE statement.mp4127.22MB

20. Session 4 - Objective 13 Combine datasets/6. IsNull and Coalesce.mp4132.9MB

20. Session 4 - Objective 13 Combine datasets/8. MERGE statement - in theory.mp489.49MB

20. Session 4 - Objective 13 Combine datasets/9. Let's Build our MERGE statement.mp4103.68MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/1. Let's create our first procedure.mp461MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/2. Ask for a specific employee.mp4107.38MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/4. Exercise with IF.mp450.87MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/5. Multiple arguments.mp449.43MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/6. While.mp4123.33MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/7. Return.mp4114.76MB

21. Session 4 - Objective 11 - Create and alter stored procedures (simple statements/9. Summary.mp414.16MB

22. Session 4 - Objective 18a - Implement trycatchthrow/1. Procedure Exercise.mp4102MB

22. Session 4 - Objective 18a - Implement trycatchthrow/2. TRYCATCH.mp490.49MB

22. Session 4 - Objective 18a - Implement trycatchthrow/3. THROW and RAISERROR.mp498.86MB

22. Session 4 - Objective 18a - Implement trycatchthrow/4. PRINT.mp484.01MB

22. Session 4 - Objective 18a - Implement trycatchthrow/6. Summary.mp47.32MB

23. End of Session 4!/1. BONUS - Recap, Look ahead.mp413.64MB

23. End of Session 4!/2. Well done!.mp455.78MB

24. Session 5 - Introduction/1. Introduction.mp453.83MB

25. Session 5 - Objective 9 Implement aggregate queries/1. Introduction.mp462.49MB

25. Session 5 - Objective 9 Implement aggregate queries/2. OVER().mp478.9MB

25. Session 5 - Objective 9 Implement aggregate queries/4. PARTITION BY and ORDER BY.mp486.93MB

25. Session 5 - Objective 9 Implement aggregate queries/6. ROWS BETWEEN.mp440.06MB

25. Session 5 - Objective 9 Implement aggregate queries/7. CURRENT ROW and UNBOUNDED.mp443.75MB

25. Session 5 - Objective 9 Implement aggregate queries/8. RANGE versus ROWS.mp489.37MB

25. Session 5 - Objective 9 Implement aggregate queries/9. Omitting RANGEROW.mp471.85MB

26. Session 5 - Objective 9d Ranking functions/1. ROW_NUMBER, RANK and DENSE_RANK.mp459.87MB

26. Session 5 - Objective 9d Ranking functions/2. NTILE.mp453.23MB

27. Session 5 - Objective 9a New analytic functions/1. FIRST_VALUE and LAST_VALUE.mp471.69MB

27. Session 5 - Objective 9a New analytic functions/2. LAG and LEAD.mp455.49MB

27. Session 5 - Objective 9a New analytic functions/3. CUME_DIST and PERCENT_RANK.mp470.1MB

27. Session 5 - Objective 9a New analytic functions/4. PERCENTILE_CONT and PERCENTILE_DISC.mp476.04MB

28. Section 5 - Objective 9b Grouping sets/1. Adding Totals.mp490.12MB

28. Section 5 - Objective 9b Grouping sets/2. ROLLUP, GROUPING and GROUPING_ID.mp445.56MB

28. Section 5 - Objective 9b Grouping sets/3. GROUPING SETS.mp4104.53MB

29. Session 5 - Objective 9c Spatial aggregates/1. Introduction.mp426.52MB

29. Session 5 - Objective 9c Spatial aggregates/10. Spatial Aggregates.mp4120.06MB

29. Session 5 - Objective 9c Spatial aggregates/12. Summary.mp411.32MB

29. Session 5 - Objective 9c Spatial aggregates/2. POINT.mp469.26MB

29. Session 5 - Objective 9c Spatial aggregates/3. POINT queries.mp4152.69MB

29. Session 5 - Objective 9c Spatial aggregates/5. Line, POLYGON and Circles.mp472.84MB

29. Session 5 - Objective 9c Spatial aggregates/7. Line queries.mp476.08MB

29. Session 5 - Objective 9c Spatial aggregates/9. Geography.mp4106.93MB

3. Session 1 - Creating tables - First pass/1. Creating a table - first pass using GUI.mp418.47MB

3. Session 1 - Creating tables - First pass/11. Deleting the data, then the table.mp428.45MB

3. Session 1 - Creating tables - First pass/2. Creating a table - first pass using T-SQL.mp425.25MB

3. Session 1 - Creating tables - First pass/4. Entering data using the GUI.mp421.01MB

3. Session 1 - Creating tables - First pass/5. Entering data using T-SQL.mp444.58MB

3. Session 1 - Creating tables - First pass/7. Retrieving data.mp440.96MB

30. End of Session 5/1. End of Session 5.mp49.71MB

30. End of Session 5/2. Well done!.mp444.66MB

31. Session 6 - Introduction/1. Introduction.mp466.07MB

31. Session 6 - Introduction/2. Objectives.mp411.78MB

32. Session 6 - Objective 7 Sub-queries/1. Table structure.mp435.68MB

32. Session 6 - Objective 7 Sub-queries/2. The WHERE clause.mp455.7MB

32. Session 6 - Objective 7 Sub-queries/3. WHERE and NOT.mp452.74MB

32. Session 6 - Objective 7 Sub-queries/4. ANY, SOME and ALL.mp467.88MB

32. Session 6 - Objective 7 Sub-queries/5. The FROM clause.mp498.73MB

32. Session 6 - Objective 7 Sub-queries/6. The SELECT clause.mp494.27MB

32. Session 6 - Objective 7 Sub-queries/7. Correlated subquery - WHERE.mp458.61MB

32. Session 6 - Objective 7 Sub-queries/9. Top 5 from various categories.mp455.45MB

33. Session 6 - Objective 7e WITH statement/1. WITH statement.mp447.77MB

33. Session 6 - Objective 7e WITH statement/2. Generating a list of numbers.mp484.27MB

33. Session 6 - Objective 7e WITH statement/3. Grouping numbers.mp485.54MB

34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/1. PIVOT.mp463.86MB

34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/2. Replacing NULLs in PIVOTs..mp456.86MB

34. Session 6 - Objective 7b PIVOTing and UNPIVOTing/3. UNPIVOT.mp428.47MB

35. Session 6 - Objective 7d CTE statement/1. Self-Join.mp488.14MB

35. Session 6 - Objective 7d CTE statement/2. Recursive CTE.mp4107.67MB

36. Session 6 - Objective 14 Functions/1. Introduction.mp428.83MB

36. Session 6 - Objective 14 Functions/2. Scalar Functions.mp474.55MB

36. Session 6 - Objective 14 Functions/3. A more complicated scalar function.mp463.87MB

36. Session 6 - Objective 14 Functions/4. Inline Table Function.mp447.78MB

36. Session 6 - Objective 14 Functions/5. Multi-statement Table Function.mp450.01MB

36. Session 6 - Objective 14 Functions/6. APPLY.mp483.58MB

37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/1. Synonyms.mp454.34MB

37. Session 6 - Objectives 6b and 6c Synonyms and Dynamics/2. Dynamic SQL.mp460.93MB

38. Session 6 - Objectives 8c GUIDs; and Sequences/1. The problems about IDENTITY.mp423.93MB

38. Session 6 - Objectives 8c GUIDs; and Sequences/2. GUIDs.mp479.8MB

38. Session 6 - Objectives 8c GUIDs; and Sequences/3. Creating SEQUENCEs.mp445.62MB

38. Session 6 - Objectives 8c GUIDs; and Sequences/4. Using SEQUENCEs.mp472.22MB

39/1. Introduction to XML - Let's make a shopping list.mp438.95MB

39/2. Attributes.mp439MB

39/3. Creating XML variable and XML field.mp453.3MB

39/4. FOR XML RAW.mp475.95MB

39/5. FOR XML AUTO.mp443.44MB

39/6. FOR XML PATH.mp4102.67MB

39/7. FOR XML EXPLICIT.mp479.46MB

4. Session 1 - Number types and functions/1. Creating an Employee table.mp437.61MB

4. Session 1 - Number types and functions/10. Mathematical functions.mp499.68MB

4. Session 1 - Number types and functions/12. Converting between number types.mp463.42MB

4. Session 1 - Number types and functions/15. Practice Activity Number 4 - Solution.mp455.13MB

4. Session 1 - Number types and functions/3. Creating temporary variables.mp4108.73MB

4. Session 1 - Number types and functions/4. Integer numbers.mp469.4MB

4. Session 1 - Number types and functions/7. Practice Activity Number 3 - Solution.mp436.08MB

4. Session 1 - Number types and functions/8. Non-integer numbers.mp4121.36MB

40. Session 6 - Objective 10 Shredding XML data/1. XQuery Value and Exist methods.mp460.96MB

40. Session 6 - Objective 10 Shredding XML data/2. XQuery Modify method.mp452.09MB

40. Session 6 - Objective 10 Shredding XML data/3. XQuery Query method using for and return.mp457.94MB

40. Session 6 - Objective 10 Shredding XML data/4. XQuery Query method using let, where and order by (FLWOR).mp454.85MB

40. Session 6 - Objective 10 Shredding XML data/5. XQuery Nodes - shredding a variable.mp459.2MB

40. Session 6 - Objective 10 Shredding XML data/6. XQuery Nodes - shredding a table.mp457.47MB

41. Session 6 - Objective 10 Other XML considerations/1. Importing and exporting XML using the bcp utility.mp447.07MB

41. Session 6 - Objective 10 Other XML considerations/2. Bulk Insert and Openrowset.mp445.83MB

41. Session 6 - Objective 10 Other XML considerations/3. Schema.mp474.62MB

41. Session 6 - Objective 10 Other XML considerations/4. When should I use XML in SQL Server.mp441.2MB

41. Session 6 - Objective 10 Other XML considerations/5. Creating Primary and Secondary XML Indexes.mp491.69MB

42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/2. Creating JSON and ISJSON.mp473.4MB

42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/3. JSON_VALUE and JSON_QUERY.mp464.51MB

42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/4. JSON_MODIFY.mp431.12MB

42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/5. Converting JSON data into SQL Server tables.mp420.53MB

42. Session 6 - Manipulating JSON data (SQL Server 2016 onwards)/6. Converting SQL Server data into JSON.mp416.65MB

43. Session 6 - Temporal Tables/1. What are temporal tables.mp487.28MB

43. Session 6 - Temporal Tables/2. Creating temporal tables.mp469.95MB

43. Session 6 - Temporal Tables/3. Dropping temporal tables, and specifying the history table.mp435.7MB

43. Session 6 - Temporal Tables/4. Altering existing tables to make them temporal tables.mp441.69MB

43. Session 6 - Temporal Tables/5. Querying temporal data at a point of time.mp435.02MB

43. Session 6 - Temporal Tables/6. Querying temporal data between a range of times.mp484.62MB

44. Session 6 - Conclusion/1. Bonus lecture.mp411.71MB

44. Session 6 - Conclusion/2. Well done!.mp425.42MB

45. Session 7 - Introduction/1. Introduction.mp449.81MB

45. Session 7 - Introduction/2. Curriculum.mp416.4MB

45. Session 7 - Introduction/3. Session 7 Resources.mp438.54MB

46. Session 7 - Manage transactions/1. Introduction - What are transactions.mp417.07MB

46. Session 7 - Manage transactions/10. Isolation Levels in Action.mp492.54MB

46. Session 7 - Manage transactions/11. Conclusion.mp45.45MB

46. Session 7 - Manage transactions/2. Implicit transactions.mp423.63MB

46. Session 7 - Manage transactions/3. Explicit Transactions - Start and end transactions.mp474.9MB

46. Session 7 - Manage transactions/4. Mark a transaction.mp435.62MB

46. Session 7 - Manage transactions/5. Trancount.mp465.56MB

46. Session 7 - Manage transactions/6. Scope and type of locks.mp438.24MB

46. Session 7 - Manage transactions/7. Locks in Practice, and using the WAITFOR statement.mp430.11MB

46. Session 7 - Manage transactions/8. What would happen if locks didn't exist.mp431.96MB

46. Session 7 - Manage transactions/9. What are Isolation levels.mp423.17MB

47. Session 7 - Indexes/1. Re-introducing Query plans.mp427.06MB

47. Session 7 - Indexes/2. Heaps, and scans.mp437.24MB

47. Session 7 - Indexes/3. B-Tree.mp435.22MB

47. Session 7 - Indexes/4. Clustered indexes.mp489.94MB

47. Session 7 - Indexes/6. Non-clustered indexes.mp453.44MB

47. Session 7 - Indexes/7. Filtered Indices.mp432.74MB

47. Session 7 - Indexes/8. Include.mp469.53MB

48. Session 7 - Optimise queries/1. What are statistics - Include Client Statistics.mp448.71MB

48. Session 7 - Optimise queries/10. SET SHOWPLAN_ALL and Client Statistics.mp451.99MB

48. Session 7 - Optimise queries/11. Dynamic vs. parameterised queries.mp449.54MB

48. Session 7 - Optimise queries/2. The different join types and seeing HASH join in action.mp427.01MB

48. Session 7 - Optimise queries/3. Nested Loops and Merge Joins in action.mp475.03MB

48. Session 7 - Optimise queries/4. Even bigger savings of time when using a SARG.mp439.29MB

48. Session 7 - Optimise queries/5. Reading Query plans and the cost of Sorting.mp448.39MB

48. Session 7 - Optimise queries/6. A more advanced query plan.mp440.4MB

48. Session 7 - Optimise queries/7. Plan guides.mp478.36MB

48. Session 7 - Optimise queries/8. Hints.mp487.95MB

48. Session 7 - Optimise queries/9. Statistics IO.mp447.13MB

49. Session 7 - Dynamic Management Views and Functions/1. dm_db_index_usage_stats.mp4110.87MB

49. Session 7 - Dynamic Management Views and Functions/2. sys.dm_db_index_physical_stats.mp456.32MB

49. Session 7 - Dynamic Management Views and Functions/3. sys.dm_db_missing_index_details.mp460.43MB

49. Session 7 - Dynamic Management Views and Functions/4. Conclusion.mp49.45MB

5. Session 1 - String data types and functions/1. Strings.mp4123.32MB

5. Session 1 - String data types and functions/3. String Functions - extraction.mp457.61MB

5. Session 1 - String data types and functions/6. NULL - an introduction.mp467.71MB

5. Session 1 - String data types and functions/7. Joining two strings together.mp497.31MB

5. Session 1 - String data types and functions/9. Joining a string to a number.mp470.5MB

50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/1. How to write a cursor.mp468.73MB

50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/2. Disadvantages.mp461.46MB

50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/3. Alternatives.mp432.07MB

50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/4. Impact of scalar UDFs.mp4110.99MB

50. Session 7 - Evaluate the use of row-based operations vs. set-based operations/5. Combine multiple DML operations.mp412.35MB

51. Congratulations/1. You have finished this course - now what.mp4102.79MB

51. Congratulations/2. Bonus Lecture.mp424.66MB

51. Congratulations/3. Thank you, and goodbye.mp422.07MB

52/1. Downloading SQL Server back engine - the Developer edition - for free!.mp415.55MB

52/2. Installing SQL Server back engine.mp431.58MB

52/3. Installing SQL Server Front Engine.mp429.67MB

53/1. Downloading SQL Server back engine - the Developer edition - for free!.mp460.29MB

53/3. Installing SQL Server 2014.mp479.91MB

6. Session 1 - Date data types and functions/1. Date data types.mp464.09MB

6. Session 1 - Date data types and functions/3. Setting dates and Date extraction.mp454.87MB

6. Session 1 - Date data types and functions/5. Today's date, and more date functions.mp464.08MB

6. Session 1 - Date data types and functions/7. Date offset.mp486.6MB

6. Session 1 - Date data types and functions/8. Converting from date to strings.mp4100.09MB

7. Session 1 - Conclusion/2. Well done!.mp439.95MB

8. Welcome to Session 2/1. Introduction.mp472.42MB

9. Session 2 - Creating and querying part of a table/1. Creation of tblEmployee table.mp494.74MB

9. Session 2 - Creating and querying part of a table/2. Adding additional columns.mp4104.04MB

9. Session 2 - Creating and querying part of a table/3. SELECTing only part of a table - strings.mp4165.1MB

9. Session 2 - Creating and querying part of a table/5. SELECTing only part of a table - numbers.mp4103.72MB