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