Lynda - Developing Microsoft SQL Server 2016 Databases 收录时间:2018-02-25 22:13:15 文件大小:543MB 下载次数:183 最近下载:2021-01-23 09:43:25 磁力链接: magnet:?xt=urn:btih:aab6874c14795a7f60c465c7bcea255ea87c37fe 立即下载 复制链接 文件列表 018 Create a view of the data.mp4 21MB 010 Partition large data tables.mp4 19MB 044 Single column and composite indexes.mp4 16MB 007 Create and alter tables.mp4 16MB 019 Enhance view performance.mp4 15MB 032 Implement FILESTREAM access.mp4 15MB 013 Understand column collation.mp4 15MB 035 Write a stored procedure with T-SQL.mp4 15MB 009 Calculate table columns.mp4 14MB 008 Implement table schemas.mp4 14MB 033 Implicit and explicit data conversions.mp4 14MB 046 Improve queries with covering indexes.mp4 14MB 056 Return values with scalar functions.mp4 14MB 039 Create a memory-optimized table.mp4 14MB 059 Record extended event sessions.mp4 13MB 030 Implement the XML data type.mp4 12MB 026 Create loginless and contained users.mp4 12MB 028 Store spatial data.mp4 12MB 040 Write a native compiled stored procedure.mp4 12MB 015 Compress data tables.mp4 12MB 052 Defragment indexes.mp4 12MB 025 Add a user to a role with T-SQL.mp4 12MB 036 Add parameters to a stored procedure.mp4 11MB 053 Analyze execution plans and tune queries.mp4 11MB 023 Use DML triggers to verify data.mp4 11MB 016 Go back in time with temporal tables.mp4 11MB 011 Create temporary tables.mp4 11MB 047 Obtain index statistics.mp4 10MB 012 Use table variables.mp4 10MB 027 Implement schema security.mp4 10MB 048 Filtered indexes.mp4 9MB 029 Add GUID data to a table.mp4 9MB 004 Install the sample database.mp4 8MB 054 Leverage the SQL Tuning Advisor.mp4 7MB 051 Implement sparse columns.mp4 7MB 005 Table design in SQL Server.mp4 7MB 057 Create a table-valued function.mp4 7MB 031 Store BLOB data in a table.mp4 7MB 001 Welcome.mp4 6MB 014 Data compression fundamentals.mp4 6MB 024 Define user roles and permissions.mp4 6MB 060 Find bottlenecks with Activity Monitor.mp4 5MB 006 Data types.mp4 5MB 034 Introduction to stored procedures.mp4 4MB 021 Implement domain integrity.mp4 4MB 041 Table index fundamentals.mp4 4MB 045 Design spatial and XML indexes.mp4 4MB 058 Use Dynamic Management Views.mp4 4MB 022 Enforce referential integrity.mp4 4MB 042 Clustered indexes.mp4 3MB 037 Recompile a stored procedure.mp4 3MB 017 What are views_.mp4 3MB 043 Non-clustered indexes.mp4 3MB 050 Introduction to sparse columns.mp4 3MB 049 Create columnstore indexes.mp4 3MB 020 Understand data integrity.mp4 3MB 038 Why use in-memory tables_.mp4 3MB 055 SQL Server function overview.mp4 2MB 061 Next steps.mp4 2MB 002 Using the exercise files.mp4 1MB 003 What you should know.mp4 834KB Exercise Files/Chapter 06/CompanyHistory.pdf 618KB Exercise Files/Chapter 06/CompanyLogo.jpg 15KB Exercise Files/Chapter 06/06_01_Spatial.sql 4KB Exercise Files/Chapter 03/03_02_CreateView.sql 3KB Exercise Files/Chapter 03/03_03_ViewPerformance.sql 3KB Exercise Files/Chapter 14/14_02_EventSessions.sql 2KB Exercise Files/Chapter 01/01_03_CreateAlter.sql 2KB Exercise Files/Chapter 07/07_03_Parameters.sql 2KB Exercise Files/Chapter 04/04_04_DMLTrigger.sql 2KB Exercise Files/Chapter 01/01_05_CalculateColumns.sql 2KB Exercise Files/Chapter 06/06_03_XML.sql 2KB Exercise Files/Chapter 06/06_05_Filestream.sql 2KB Exercise Files/Chapter 02/02_04_Collation.sql 2KB Exercise Files/Chapter 02/02_07_TemporalTables.sql 1KB Exercise Files/Chapter 07/07_02_StoredProcedureTSQL.sql 1KB Exercise Files/Chapter 06/06_06_DataConversions.sql 1KB Exercise Files/Chapter 08/08_03_CompiledStoredProcedure.sql 1KB Exercise Files/Chapter 05/05_03_LoginlessUser.sql 1KB Exercise Files/Chapter 08/08_02_CreateMemoryOptimized.sql 1KB Exercise Files/Chapter 13/13_02_ScalarFunctions.sql 1KB Exercise Files/Chapter 11/11_02_ImplementSparseColumns.sql 1KB Exercise Files/Chapter 02/02_03_TableVariables.sql 1KB Exercise Files/Chapter 05/05_02_AddUser.sql 1KB Exercise Files/Chapter 01/01_04_Schemas.sql 1KB Exercise Files/Chapter 06/06_02_GUID.sql 1KB Exercise Files/Chapter 10/10_03_FilteredIndexes.sql 1KB Exercise Files/Chapter 02/02_01_PartitionTables.sql 1KB Exercise Files/Chapter 02/02_06_CompressTables.sql 1KB Exercise Files/Chapter 13/13_03_TableValuedFunction.sql 1KB Exercise Files/Chapter 05/05_04_SchemaSecurity.sql 983B Exercise Files/Chapter 02/02_02_TemporaryTables.sql 879B Exercise Files/Chapter 12/12_01_DefragIndexes.sql 867B Exercise Files/Chapter 09/09_04_CompositeIndexes.sql 842B Exercise Files/Chapter 06/06_04_BLOB.sql 825B Exercise Files/Chapter 12/12_03_TuningAdvisor.sql 807B Exercise Files/Chapter 12/12_02_ExecutionPlans.sql 801B Exercise Files/Chapter 10/10_01_CoveringIndex.sql 754B Exercise Files/Chapter 14/14_03_ActivityMonitor.sql 550B Exercise Files/Chapter 10/10_02_IndexStats.sql 264B