Filename | Size |
| 534417_00_01 - Welcome.en.srt | 1.6 KB |
| 534417_00_02 - Using the exercise files.en.srt | 1.7 KB |
| 534417_00_03 - What you should know.en.srt | 1.4 KB |
| 534417_00_04 - Install the sample database.en.srt | 7.7 KB |
| 534417_01_01 - Table design in SQL Server.en.srt | 10.8 KB |
| 534417_01_02 - Data types.en.srt | 7.4 KB |
| 534417_01_03 - Create and alter tables.en.srt | 17.6 KB |
| 534417_01_04 - Implement table schemas.en.srt | 14.7 KB |
| 534417_01_05 - Calculate table columns.en.srt | 14.7 KB |
| 534417_02_01 - Partition large data tables.en.srt | 19.6 KB |
| 534417_02_02 - Create temporary tables.en.srt | 10.6 KB |
| 534417_02_03 - Use table variables.en.srt | 10.2 KB |
| 534417_02_04 - Understand column collation.en.srt | 16.6 KB |
| 534417_02_05 - Data compression fundamentals.en.srt | 8.7 KB |
| 534417_02_06 - Compress data tables.en.srt | 8.4 KB |
| 534417_02_07 - Go back in time with temporal tables.en.srt | 11.2 KB |
| 534417_03_01 - What are views_.en.srt | 5.2 KB |
| 534417_03_02 - Create a view of the data.en.srt | 17.8 KB |
| 534417_03_03 - Enhance view performance.en.srt | 11.7 KB |
| 534417_04_01 - Understand data integrity.en.srt | 4.4 KB |
| 534417_04_02 - Implement domain integrity.en.srt | 6.2 KB |
| 534417_04_03 - Enforce referential integrity.en.srt | 5.5 KB |
| 534417_04_04 - Use DML triggers to verify data.en.srt | 11.3 KB |
| 534417_05_01 - Define user roles and permissions.en.srt | 8.9 KB |
| 534417_05_02 - Add a user to a role with T-SQL.en.srt | 10.9 KB |
| 534417_05_03 - Create loginless and contained users.en.srt | 13 KB |
| 534417_05_04 - Implement schema security.en.srt | 9.3 KB |
| 534417_06_01 - Store spatial data.en.srt | 14.4 KB |
| 534417_06_02 - Add GUID data to a table.en.srt | 9.1 KB |
| 534417_06_03 - Implement the XML data type.en.srt | 10.6 KB |
| 534417_06_04 - Store BLOB data in a table.en.srt | 7.1 KB |
| 534417_06_05 - Implement FILESTREAM access.en.srt | 14.7 KB |
| 534417_06_06 - Implicit and explicit data conversions.en.srt | 14.1 KB |
| 534417_07_01 - Introduction to stored procedures.en.srt | 7.5 KB |
| 534417_07_02 - Write a stored procedure with T-SQL.en.srt | 10.7 KB |
| 534417_07_03 - Add parameters to a stored procedure.en.srt | 10.6 KB |
| 534417_07_04 - Recompile a stored procedure.en.srt | 4.6 KB |
| 534417_08_01 - Why use in-memory tables_.en.srt | 4.3 KB |
| 534417_08_02 - Create a memory-optimized table.en.srt | 13.3 KB |
| 534417_08_03 - Write a native compiled stored procedure.en.srt | 11.8 KB |
| 534417_09_01 - Table index fundamentals.en.srt | 6.8 KB |
| 534417_09_02 - Clustered indexes.en.srt | 5 KB |
| 534417_09_03 - Non-clustered indexes.en.srt | 5.1 KB |
| 534417_09_04 - Single column and composite indexes.en.srt | 12.2 KB |
| 534417_09_05 - Design spatial and XML indexes.en.srt | 5.8 KB |
| 534417_10_01 - Improve queries with covering indexes.en.srt | 10.8 KB |
| 534417_10_02 - Obtain index statistics.en.srt | 8.8 KB |
| 534417_10_03 - Filtered indexes.en.srt | 7.9 KB |
| 534417_10_04 - Create columnstore indexes.en.srt | 4.6 KB |
| 534417_11_01 - Introduction to sparse columns.en.srt | 4.3 KB |
| 534417_11_02 - Implement sparse columns.en.srt | 7.3 KB |
| 534417_12_01 - Defragment indexes.en.srt | 9.2 KB |
| 534417_12_02 - Analyze execution plans and tune queries.en.srt | 9.8 KB |
| 534417_12_03 - Leverage the SQL Tuning Advisor.en.srt | 8.2 KB |
| 534417_13_01 - SQL Server function overview.en.srt | 3.8 KB |
| 534417_13_02 - Return values with scalar functions.en.srt | 13 KB |
| 534417_14_01 - Use Dynamic Management Views.en.srt | 3.6 KB |
| 534417_14_02 - Record extended event sessions.en.srt | 12.9 KB |
| 534417_14_03 - Find bottlenecks with Activity Monitor.en.srt | 5.5 KB |
| 534417_15_01 - Next steps.en.srt | 1.7 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_03_CreateAlter.sql | 1.9 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_04_Schemas.sql | 1.2 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 01/01_05_CalculateColumns.sql | 1.8 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_01_PartitionTables.sql | 1.1 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_02_TemporaryTables.sql | 879 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_03_TableVariables.sql | 1.3 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_04_Collation.sql | 1.5 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_06_CompressTables.sql | 1 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 02/02_07_TemporalTables.sql | 1.5 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 03/03_02_CreateView.sql | 3.2 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 03/03_03_ViewPerformance.sql | 2.9 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 04/04_04_DMLTrigger.sql | 1.8 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_02_AddUser.sql | 1.3 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_03_LoginlessUser.sql | 1.4 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 05/05_04_SchemaSecurity.sql | 983 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_01_Spatial.sql | 3.6 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_02_GUID.sql | 1.2 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_03_XML.sql | 1.7 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_04_BLOB.sql | 825 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_05_Filestream.sql | 1.7 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/06_06_DataConversions.sql | 1.5 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/CompanyHistory.pdf | 618.3 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 06/CompanyLogo.jpg | 15.1 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 07/07_02_StoredProcedureTSQL.sql | 1.5 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 07/07_03_Parameters.sql | 1.8 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 08/08_02_CreateMemoryOptimized.sql | 1.4 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 08/08_03_CompiledStoredProcedure.sql | 1.5 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 09/09_04_CompositeIndexes.sql | 842 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_01_CoveringIndex.sql | 754 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_02_IndexStats.sql | 264 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 10/10_03_FilteredIndexes.sql | 1.2 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 11/11_02_ImplementSparseColumns.sql | 1.3 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_01_DefragIndexes.sql | 867 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_02_ExecutionPlans.sql | 801 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 12/12_03_TuningAdvisor.sql | 807 B |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 13/13_02_ScalarFunctions.sql | 1.3 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 13/13_03_TableValuedFunction.sql | 1 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 14/14_02_EventSessions.sql | 2 KB |
| Ex_Files_Dev_SQLServer_Databases/Exercise Files/Chapter 14/14_03_ActivityMonitor.sql | 550 B |