Lynda Developing Microsoft SQL Server 2016 Databases | AAB6874C14795A7F60C465C7BCEA255EA87C37FE

Lynda Developing Microsoft SQL Server 2016 Databases

Name	Lynda - Developing Microsoft SQL Server 2016 Databases	DOWNLOAD Copy Link
Total Size	569.2 MB
Total Files	100
Hash	AAB6874C14795A7F60C465C7BCEA255EA87C37FE

/Exercise Files/Chapter 01/
01_03_CreateAlter.sql	2.0 KB
01_05_CalculateColumns.sql	1.8 KB
01_04_Schemas.sql	1.3 KB
/Exercise Files/Chapter 02/
02_04_Collation.sql	1.6 KB
02_07_TemporalTables.sql	1.5 KB
02_03_TableVariables.sql	1.4 KB
02_01_PartitionTables.sql	1.2 KB
02_06_CompressTables.sql	1.1 KB
02_02_TemporaryTables.sql	0.9 KB
/Exercise Files/Chapter 03/
03_02_CreateView.sql	3.3 KB
03_03_ViewPerformance.sql	3.0 KB
/Exercise Files/Chapter 04/
04_04_DMLTrigger.sql	1.9 KB
/Exercise Files/Chapter 05/
05_03_LoginlessUser.sql	1.5 KB
05_02_AddUser.sql	1.3 KB
05_04_SchemaSecurity.sql	1.0 KB
/Exercise Files/Chapter 06/
CompanyHistory.pdf	633.1 KB
CompanyLogo.jpg	15.5 KB
06_01_Spatial.sql	3.6 KB
06_03_XML.sql	1.7 KB
06_05_Filestream.sql	1.7 KB
06_06_DataConversions.sql	1.5 KB
06_02_GUID.sql	1.3 KB
06_04_BLOB.sql	0.8 KB
/Exercise Files/Chapter 07/
07_03_Parameters.sql	1.9 KB
07_02_StoredProcedureTSQL.sql	1.5 KB
/Exercise Files/Chapter 08/
08_03_CompiledStoredProcedure.sql	1.5 KB
08_02_CreateMemoryOptimized.sql	1.4 KB
/Exercise Files/Chapter 09/
09_04_CompositeIndexes.sql	0.8 KB
/Exercise Files/Chapter 10/
10_03_FilteredIndexes.sql	1.2 KB
10_01_CoveringIndex.sql	0.8 KB
10_02_IndexStats.sql	0.3 KB
/Exercise Files/Chapter 11/
11_02_ImplementSparseColumns.sql	1.4 KB
/Exercise Files/Chapter 12/
12_01_DefragIndexes.sql	0.9 KB
12_03_TuningAdvisor.sql	0.8 KB
12_02_ExecutionPlans.sql	0.8 KB
/Exercise Files/Chapter 13/
13_02_ScalarFunctions.sql	1.4 KB
13_03_TableValuedFunction.sql	1.0 KB
/Exercise Files/Chapter 14/
14_02_EventSessions.sql	2.0 KB
14_03_ActivityMonitor.sql	0.6 KB
/
018 Create a view of the data.mp4	21.7 MB
010 Partition large data tables.mp4	20.3 MB
044 Single column and composite indexes.mp4	16.6 MB
007 Create and alter tables.mp4	16.3 MB
019 Enhance view performance.mp4	15.8 MB
032 Implement FILESTREAM access.mp4	15.4 MB
013 Understand column collation.mp4	15.3 MB
035 Write a stored procedure with T-SQL.mp4	15.2 MB
009 Calculate table columns.mp4	15.0 MB
008 Implement table schemas.mp4	15.0 MB
033 Implicit and explicit data conversions.mp4	14.7 MB
046 Improve queries with covering indexes.mp4	14.6 MB
056 Return values with scalar functions.mp4	14.3 MB
039 Create a memory-optimized table.mp4	14.3 MB
059 Record extended event sessions.mp4	13.7 MB
030 Implement the XML data type.mp4	12.9 MB
026 Create loginless and contained users.mp4	12.8 MB
028 Store spatial data.mp4	12.6 MB
040 Write a native compiled stored procedure.mp4	12.5 MB
015 Compress data tables.mp4	12.4 MB
052 Defragment indexes.mp4	12.3 MB
025 Add a user to a role with T-SQL.mp4	12.3 MB
036 Add parameters to a stored procedure.mp4	11.6 MB
053 Analyze execution plans and tune queries.mp4	11.6 MB
023 Use DML triggers to verify data.mp4	11.4 MB
016 Go back in time with temporal tables.mp4	11.3 MB
011 Create temporary tables.mp4	11.0 MB
047 Obtain index statistics.mp4	11.0 MB
012 Use table variables.mp4	10.7 MB
027 Implement schema security.mp4	10.6 MB
048 Filtered indexes.mp4	9.2 MB
029 Add GUID data to a table.mp4	9.1 MB
004 Install the sample database.mp4	8.3 MB
054 Leverage the SQL Tuning Advisor.mp4	7.8 MB
051 Implement sparse columns.mp4	7.7 MB
005 Table design in SQL Server.mp4	7.5 MB
057 Create a table-valued function.mp4	7.4 MB
031 Store BLOB data in a table.mp4	7.2 MB
001 Welcome.mp4	6.6 MB
014 Data compression fundamentals.mp4	6.4 MB
024 Define user roles and permissions.mp4	6.1 MB
060 Find bottlenecks with Activity Monitor.mp4	5.5 MB
006 Data types.mp4	4.9 MB
034 Introduction to stored procedures.mp4	4.7 MB
021 Implement domain integrity.mp4	4.6 MB
041 Table index fundamentals.mp4	4.4 MB
045 Design spatial and XML indexes.mp4	4.3 MB
058 Use Dynamic Management Views.mp4	4.1 MB
022 Enforce referential integrity.mp4	3.7 MB
042 Clustered indexes.mp4	3.6 MB
037 Recompile a stored procedure.mp4	3.6 MB
017 What are views_.mp4	3.5 MB
043 Non-clustered indexes.mp4	3.3 MB
050 Introduction to sparse columns.mp4	3.3 MB
049 Create columnstore indexes.mp4	3.3 MB
020 Understand data integrity.mp4	3.2 MB
038 Why use in-memory tables_.mp4	3.2 MB
055 SQL Server function overview.mp4	2.4 MB
061 Next steps.mp4	2.0 MB
002 Using the exercise files.mp4	1.3 MB
003 What you should know.mp4	853.6 KB
Total files 100