TorBT - Torrents and Magnet Links Search Engine

Lynda - Developing Microsoft SQL Server 2016 Databases

File Name
Size
Exercise Files/Chapter 01/01_03_CreateAlter.sql
1.9 kB
Exercise Files/Chapter 01/01_05_CalculateColumns.sql
1.8 kB
Exercise Files/Chapter 01/01_04_Schemas.sql
1.2 kB
Exercise Files/Chapter 02/02_04_Collation.sql
1.5 kB
Exercise Files/Chapter 02/02_07_TemporalTables.sql
1.5 kB
Exercise Files/Chapter 02/02_03_TableVariables.sql
1.3 kB
Exercise Files/Chapter 02/02_01_PartitionTables.sql
1.1 kB
Exercise Files/Chapter 02/02_06_CompressTables.sql
1.0 kB
Exercise Files/Chapter 02/02_02_TemporaryTables.sql
879 B
Exercise Files/Chapter 03/03_02_CreateView.sql
3.2 kB
Exercise Files/Chapter 03/03_03_ViewPerformance.sql
2.9 kB
Exercise Files/Chapter 04/04_04_DMLTrigger.sql
1.8 kB
Exercise Files/Chapter 05/05_03_LoginlessUser.sql
1.4 kB
Exercise Files/Chapter 05/05_02_AddUser.sql
1.3 kB
Exercise Files/Chapter 05/05_04_SchemaSecurity.sql
983 B
Exercise Files/Chapter 06/CompanyHistory.pdf
618 kB
Exercise Files/Chapter 06/CompanyLogo.jpg
15 kB
Exercise Files/Chapter 06/06_01_Spatial.sql
3.6 kB
Exercise Files/Chapter 06/06_03_XML.sql
1.7 kB
Exercise Files/Chapter 06/06_05_Filestream.sql
1.7 kB
Exercise Files/Chapter 06/06_06_DataConversions.sql
1.5 kB
Exercise Files/Chapter 06/06_02_GUID.sql
1.2 kB
Exercise Files/Chapter 06/06_04_BLOB.sql
825 B
Exercise Files/Chapter 07/07_03_Parameters.sql
1.8 kB
Exercise Files/Chapter 07/07_02_StoredProcedureTSQL.sql
1.5 kB
Exercise Files/Chapter 08/08_03_CompiledStoredProcedure.sql
1.5 kB
Exercise Files/Chapter 08/08_02_CreateMemoryOptimized.sql
1.4 kB
Exercise Files/Chapter 09/09_04_CompositeIndexes.sql
842 B
Exercise Files/Chapter 10/10_03_FilteredIndexes.sql
1.2 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.3 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.3 kB
Exercise Files/Chapter 13/13_03_TableValuedFunction.sql
1.0 kB
Exercise Files/Chapter 14/14_02_EventSessions.sql
2.0 kB
Exercise Files/Chapter 14/14_03_ActivityMonitor.sql
550 B
018 Create a view of the data.mp4
21 MB
010 Partition large data tables.mp4
19 MB
044 Single column and composite indexes.mp4
16 MB
007 Create and alter tables.mp4
16 MB
019 Enhance view performance.mp4
15 MB
032 Implement FILESTREAM access.mp4
15 MB
013 Understand column collation.mp4
15 MB
035 Write a stored procedure with T-SQL.mp4
14 MB
009 Calculate table columns.mp4
14 MB
008 Implement table schemas.mp4
14 MB
033 Implicit and explicit data conversions.mp4
14 MB
046 Improve queries with covering indexes.mp4
14 MB
056 Return values with scalar functions.mp4
14 MB
039 Create a memory-optimized table.mp4
14 MB
059 Record extended event sessions.mp4
13 MB
030 Implement the XML data type.mp4
12 MB
026 Create loginless and contained users.mp4
12 MB
028 Store spatial data.mp4
12 MB
040 Write a native compiled stored procedure.mp4
12 MB
015 Compress data tables.mp4
12 MB
052 Defragment indexes.mp4
12 MB
025 Add a user to a role with T-SQL.mp4
12 MB
036 Add parameters to a stored procedure.mp4
11 MB
053 Analyze execution plans and tune queries.mp4
11 MB
023 Use DML triggers to verify data.mp4
11 MB
016 Go back in time with temporal tables.mp4
11 MB
011 Create temporary tables.mp4
10 MB
047 Obtain index statistics.mp4
10 MB
012 Use table variables.mp4
10 MB
027 Implement schema security.mp4
10 MB
048 Filtered indexes.mp4
8.8 MB
029 Add GUID data to a table.mp4
8.7 MB
004 Install the sample database.mp4
7.9 MB
054 Leverage the SQL Tuning Advisor.mp4
7.5 MB
051 Implement sparse columns.mp4
7.4 MB
005 Table design in SQL Server.mp4
7.2 MB
057 Create a table-valued function.mp4
7.1 MB
031 Store BLOB data in a table.mp4
6.9 MB
001 Welcome.mp4
6.3 MB
014 Data compression fundamentals.mp4
6.1 MB
024 Define user roles and permissions.mp4
5.9 MB
060 Find bottlenecks with Activity Monitor.mp4
5.2 MB
006 Data types.mp4
4.7 MB
034 Introduction to stored procedures.mp4
4.5 MB
021 Implement domain integrity.mp4
4.4 MB
041 Table index fundamentals.mp4
4.2 MB
045 Design spatial and XML indexes.mp4
4.1 MB
058 Use Dynamic Management Views.mp4
3.9 MB
022 Enforce referential integrity.mp4
3.5 MB
042 Clustered indexes.mp4
3.4 MB
037 Recompile a stored procedure.mp4
3.4 MB
017 What are views_.mp4
3.4 MB
043 Non-clustered indexes.mp4
3.2 MB
050 Introduction to sparse columns.mp4
3.1 MB
049 Create columnstore indexes.mp4
3.1 MB
020 Understand data integrity.mp4
3.0 MB
038 Why use in-memory tables_.mp4
3.0 MB
055 SQL Server function overview.mp4
2.3 MB
061 Next steps.mp4
1.9 MB
002 Using the exercise files.mp4
1.2 MB
003 What you should know.mp4
834 kB