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