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