589689.xyz

LYNDA DATABASE FUNDAMENTALS CREATING AND MANIPULATING DATA TUTORIAL

  • 收录时间:2018-02-27 22:16:35
  • 文件大小:408MB
  • 下载次数:292
  • 最近下载:2021-01-22 01:39:32
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 03. Understanding Tables and How to Create Them/03_02-Creating a table in SQL Server Management Studio.mp4 19MB
  2. 06. Creating Stored Procedures and Functions/06_05-Creating a userdefined scalar function.mp4 18MB
  3. 02. Defining Data Types/02_06-Understanding spatial data types.mp4 18MB
  4. 04. Using Queries to Select Data/04_02-Combining multiple related tables with the JOIN clause.mp4 16MB
  5. 05. Working with Views/05_04-Defining a view using TransactSQL commands.mp4 16MB
  6. 04. Using Queries to Select Data/04_01-Selecting records from the database.mp4 15MB
  7. 06. Creating Stored Procedures and Functions/06_02-Creating a stored procedure in SQL Server Management Studio.mp4 15MB
  8. 02. Defining Data Types/02_08-Converting data types in calculations.mp4 14MB
  9. 02. Defining Data Types/02_04-Storing date and time values.mp4 13MB
  10. 04. Using Queries to Select Data/04_11-Solution Making selections.mp4 13MB
  11. 06. Creating Stored Procedures and Functions/06_03-Leveraging userdefined parameters.mp4 12MB
  12. 03. Understanding Tables and How to Create Them/03_03-Creating a table using TransactSQL commands.mp4 12MB
  13. 07. Inserting and Updating Data in a Table/07_02-Inserting data using data manipulation language.mp4 11MB
  14. 02. Defining Data Types/02_07-Working with binary strings and other data types.mp4 11MB
  15. 08. Removing Data from the Database/08_05-Understanding transactions.mp4 10MB
  16. 03. Understanding Tables and How to Create Them/03_05-Using SSMS to create reusable scripts.mp4 10MB
  17. 03. Understanding Tables and How to Create Them/03_07-Solution Writing TSQL commands.mp4 10MB
  18. 04. Using Queries to Select Data/04_09-Using aggregate functions.mp4 9MB
  19. 05. Working with Views/05_03-Viewing related data from multiple tables.mp4 9MB
  20. 07. Inserting and Updating Data in a Table/07_01-Using SSMS to insert data into a table.mp4 8MB
  21. 03. Understanding Tables and How to Create Them/03_04-Applying data constraints and indexes in TSQL.mp4 8MB
  22. 05. Working with Views/05_06-Solution Creating a view.mp4 7MB
  23. 01. Introduction/01_01-Welcome.mp4 7MB
  24. 04. Using Queries to Select Data/04_06-Sorting data with ORDER BY.mp4 7MB
  25. 05. Working with Views/05_02-Creating a view in SQL Server Management Studio.mp4 7MB
  26. 04. Using Queries to Select Data/04_07-Combining returns with the UNION clause.mp4 7MB
  27. 04. Using Queries to Select Data/04_03-Combining conditions with AND and OR.mp4 7MB
  28. 04. Using Queries to Select Data/04_04-Clarifying ranges with a BETWEEN clause.mp4 6MB
  29. 08. Removing Data from the Database/08_02-Using the DELETE statement.mp4 6MB
  30. 07. Inserting and Updating Data in a Table/07_04-Modifying data using the UPDATE clause.mp4 6MB
  31. 02. Defining Data Types/02_05-Storing text as character strings.mp4 6MB
  32. 01. Introduction/01_05-What you should know Restoring your database backup.mp4 6MB
  33. Exercice Files/Chapter 1/H+Active_CMD-Start.bak 5MB
  34. 01. Introduction/01_02-Preparing for MTA 98364.mp4 5MB
  35. 07. Inserting and Updating Data in a Table/07_03-Updating data in SSMS.mp4 5MB
  36. 02. Defining Data Types/02_01-Understanding the builtin SQL Server data types.mp4 5MB
  37. 05. Working with Views/05_01-Understanding the role of SQL Server views.mp4 5MB
  38. 08. Removing Data from the Database/08_04-Deleting a table with DROP TABLE.mp4 4MB
  39. 08. Removing Data from the Database/08_01-Deleting records in SSMS.mp4 4MB
  40. 04. Using Queries to Select Data/04_08-Using the EXCEPT and INTERSECT clauses.mp4 4MB
  41. 02. Defining Data Types/02_02-Using exact numeric data types.mp4 4MB
  42. 02. Defining Data Types/02_03-Using approximate numeric data types.mp4 4MB
  43. 06. Creating Stored Procedures and Functions/06_01-Understanding the roll of stored procedures.mp4 3MB
  44. 04. Using Queries to Select Data/04_05-Specifying data you dont want with NOT.mp4 3MB
  45. 09. Conclusion/09_01-Next steps.mp4 3MB
  46. 08. Removing Data from the Database/08_03-Clearing out a table with TRUNCATE TABLE.mp4 3MB
  47. 03. Understanding Tables and How to Create Them/03_01-Defining your data needs.mp4 3MB
  48. 06. Creating Stored Procedures and Functions/06_04-Introducing userdefined functions.mp4 2MB
  49. 04. Using Queries to Select Data/04_10-Challenge Making selections.mp4 2MB
  50. 03. Understanding Tables and How to Create Them/03_06-Challenge Writing TSQL commands.mp4 2MB
  51. 05. Working with Views/05_05-Challenge Creating a view.mp4 2MB
  52. 01. Introduction/01_03-Using the exercise files.mp4 970KB
  53. 01. Introduction/01_04-Challenges explained.mp4 845KB
  54. Exercice Files/Chapter 1/ThermalVest.png 63KB
  55. Exercice Files/Chapter 5/Function.txt 1KB
  56. Exercice Files/Chapter 2/ChallengeSolution.sql 1KB
  57. Exercice Files/Chapter 2/CreateDepartments.sql 923B
  58. Exercice Files/Chapter 4/View.txt 757B
  59. Exercice Files/Chapter 2/CreateTable.txt 646B
  60. Exercice Files/Chapter 1/Spatial.txt 631B
  61. Exercice Files/Chapter 3/Aggregate.txt 583B
  62. Exercice Files/Chapter 4/ChallengeSolution.txt 464B
  63. Exercice Files/Chapter 5/StoredProcedure.txt 404B
  64. Exercice Files/Chapter 1/Binary.txt 369B
  65. Exercice Files/Chapter 3/ChallengeSolution.txt 358B
  66. Exercice Files/Chapter 6/InsertingData.txt 348B
  67. Exercice Files/Chapter 7/Transactions.txt 329B
  68. Exercice Files/Chapter 5/Parameters.txt 324B
  69. Exercice Files/Chapter 2/Constraints.txt 286B
  70. Exercice Files/Chapter 1/Convert.txt 249B
  71. Exercice Files/Chapter 3/Between.txt 234B
  72. Exercice Files/Chapter 3/AndOr.txt 232B
  73. Exercice Files/Chapter 3/Union.txt 182B
  74. Exercice Files/Chapter 3/IntersectExcept.txt 181B
  75. Exercice Files/Chapter 3/OrderBy.txt 157B
  76. Exercice Files/Chapter 3/Not.txt 149B