Name Lynda - Developing Microsoft SQL Server 2016 Databases

File Type video

Size 542.78MB

UpdateDate 2024-11-6

hash *****74C14795A7F60C465C7BCEA255EA87C37F

Hot 1

Files Exercise Files/Chapter 01/01_03_CreateAlter.sql | 1.94KB Exercise Files/Chapter 01/01_05_CalculateColumns.sql | 1.78KB Exercise Files/Chapter 01/01_04_Schemas.sql | 1.23KB Exercise Files/Chapter 02/02_04_Collation.sql | 1.52KB Exercise Files/Chapter 02/02_07_TemporalTables.sql | 1.49KB Exercise Files/Chapter 02/02_03_TableVariables.sql | 1.32KB Exercise Files/Chapter 02/02_01_PartitionTables.sql | 1.13KB Exercise Files/Chapter 02/02_06_CompressTables.sql | 1.04KB Exercise Files/Chapter 02/02_02_TemporaryTables.sql | 879B Exercise Files/Chapter 03/03_02_CreateView.sql | 3.21KB Exercise Files/Chapter 03/03_03_ViewPerformance.sql | 2.94KB Exercise Files/Chapter 04/04_04_DMLTrigger.sql | 1.82KB Exercise Files/Chapter 05/05_03_LoginlessUser.sql | 1.43KB Exercise Files/Chapter 05/05_02_AddUser.sql | 1.29KB Exercise Files/Chapter 05/05_04_SchemaSecurity.sql | 983B Exercise Files/Chapter 06/CompanyHistory.pdf | 618.30KB Exercise Files/Chapter 06/CompanyLogo.jpg | 15.12KB Exercise Files/Chapter 06/06_01_Spatial.sql | 3.55KB Exercise Files/Chapter 06/06_03_XML.sql | 1.69KB Exercise Files/Chapter 06/06_05_Filestream.sql | 1.68KB Exercise Files/Chapter 06/06_06_DataConversions.sql | 1.47KB Exercise Files/Chapter 06/06_02_GUID.sql | 1.23KB Exercise Files/Chapter 06/06_04_BLOB.sql | 825B Exercise Files/Chapter 07/07_03_Parameters.sql | 1.82KB Exercise Files/Chapter 07/07_02_StoredProcedureTSQL.sql | 1.48KB Exercise Files/Chapter 08/08_03_CompiledStoredProcedure.sql | 1.46KB Exercise Files/Chapter 08/08_02_CreateMemoryOptimized.sql | 1.37KB Exercise Files/Chapter 09/09_04_CompositeIndexes.sql | 842B Exercise Files/Chapter 10/10_03_FilteredIndexes.sql | 1.19KB Exercise Files/Chapter 10/10_01_CoveringIndex.sql | 754B Exercise Files/Chapter 10/10_02_IndexStats.sql | 264B Exercise Files/Chapter 11/11_02_ImplementSparseColumns.sql | 1.32KB Exercise Files/Chapter 12/12_01_DefragIndexes.sql | 867B Exercise Files/Chapter 12/12_03_TuningAdvisor.sql | 807B Exercise Files/Chapter 12/12_02_ExecutionPlans.sql | 801B Exercise Files/Chapter 13/13_02_ScalarFunctions.sql | 1.33KB Exercise Files/Chapter 13/13_03_TableValuedFunction.sql | 1.02KB Exercise Files/Chapter 14/14_02_EventSessions.sql | 2.00KB Exercise Files/Chapter 14/14_03_ActivityMonitor.sql | 550B 018 Create a view of the data.mp4 | 20.69MB 010 Partition large data tables.mp4 | 19.37MB 044 Single column and composite indexes.mp4 | 15.87MB 007 Create and alter tables.mp4 | 15.56MB 019 Enhance view performance.mp4 | 15.03MB 032 Implement FILESTREAM access.mp4 | 14.71MB 013 Understand column collation.mp4 | 14.61MB 035 Write a stored procedure with T-SQL.mp4 | 14.51MB 009 Calculate table columns.mp4 | 14.34MB 008 Implement table schemas.mp4 | 14.27MB 033 Implicit and explicit data conversions.mp4 | 13.99MB 046 Improve queries with covering indexes.mp4 | 13.92MB 056 Return values with scalar functions.mp4 | 13.64MB 039 Create a memory-optimized table.mp4 | 13.64MB 059 Record extended event sessions.mp4 | 13.02MB 030 Implement the XML data type.mp4 | 12.34MB 026 Create loginless and contained users.mp4 | 12.19MB 028 Store spatial data.mp4 | 12.02MB 040 Write a native compiled stored procedure.mp4 | 11.95MB 015 Compress data tables.mp4 | 11.84MB 052 Defragment indexes.mp4 | 11.77MB 025 Add a user to a role with T-SQL.mp4 | 11.71MB 036 Add parameters to a stored procedure.mp4 | 11.05MB 053 Analyze execution plans and tune queries.mp4 | 11.02MB 023 Use DML triggers to verify data.mp4 | 10.91MB 016 Go back in time with temporal tables.mp4 | 10.81MB 011 Create temporary tables.mp4 | 10.53MB 047 Obtain index statistics.mp4 | 10.50MB 012 Use table variables.mp4 | 10.24MB 027 Implement schema security.mp4 | 10.12MB 048 Filtered indexes.mp4 | 8.79MB 029 Add GUID data to a table.mp4 | 8.72MB 004 Install the sample database.mp4 | 7.90MB 054 Leverage the SQL Tuning Advisor.mp4 | 7.46MB 051 Implement sparse columns.mp4 | 7.36MB 005 Table design in SQL Server.mp4 | 7.16MB 057 Create a table-valued function.mp4 | 7.07MB 031 Store BLOB data in a table.mp4 | 6.90MB 001 Welcome.mp4 | 6.26MB 014 Data compression fundamentals.mp4 | 6.08MB 024 Define user roles and permissions.mp4 | 5.85MB 060 Find bottlenecks with Activity Monitor.mp4 | 5.24MB 006 Data types.mp4 | 4.71MB 034 Introduction to stored procedures.mp4 | 4.46MB 021 Implement domain integrity.mp4 | 4.36MB 041 Table index fundamentals.mp4 | 4.19MB 045 Design spatial and XML indexes.mp4 | 4.15MB 058 Use Dynamic Management Views.mp4 | 3.88MB 022 Enforce referential integrity.mp4 | 3.53MB 042 Clustered indexes.mp4 | 3.44MB 037 Recompile a stored procedure.mp4 | 3.43MB 017 What are views_.mp4 | 3.37MB 043 Non-clustered indexes.mp4 | 3.16MB 050 Introduction to sparse columns.mp4 | 3.12MB 049 Create columnstore indexes.mp4 | 3.12MB 020 Understand data integrity.mp4 | 3.03MB 038 Why use in-memory tables_.mp4 | 3.02MB 055 SQL Server function overview.mp4 | 2.28MB 061 Next steps.mp4 | 1.91MB 002 Using the exercise files.mp4 | 1.21MB 003 What you should know.mp4 | 833.56KB