70 461 CBT Nuggets SQL 2012 | 266C64325D742ADF5A4469EBF08F3E4E68702774

70 461 CBT Nuggets SQL 2012

Name	70-461 CBT Nuggets SQL 2012	DOWNLOAD Copy Link
Total Size	1.7 GB
Total Files	216
Last Seen	2024-11-15 23:34
Hash	266C64325D742ADF5A4469EBF08F3E4E68702774

/70-461 Querying SQL2012/
AdventureWorks_Data.mdf	192.7 MB
AdventureWorksDW_Data.mdf	151.8 MB
milky-way.jpg	5.2 MB
NuggetDemoDB_9_11_2013.bak	2.9 MB
70-461 Querying SQL2012.ssms_suo	34.8 KB
70-461 Quering SQL2012.ssms_suo	9.7 KB
70-461 Querying SQL2012.ssmssln	5.1 KB
Employees.xml	2.1 KB
EmployeeBio.xsd	1.1 KB
70-461 Quering SQL2012.ssmssln	1.0 KB
EmployeesImport.xml	0.7 KB
EmployeeBio.xml	0.4 KB
/
7 Querying Data using SELECT.mp4	114.4 MB
6 Creating and Modifying DML Triggers.mp4	88.4 MB
10 Implementing Aggregates.mp4	85.4 MB
11 Querying and Managing XML Data.mp4	84.4 MB
3 Creating and Altering Views with T-SQL.mp4	83.7 MB
5 Creating and Modifying Constraints.mp4	82.4 MB
15 Working with Functions.mp4	82.1 MB
9 Implementing Data Types.mp4	74.0 MB
16 Optimizing Queries.mp4	70.6 MB
1 Querying Microsoft SQL Server 2012 .mp4	68.7 MB
2 Creating and Altering Tables with T-SQL.mp4	66.6 MB
8 Implementing Sub Queries.mp4	65.7 MB
13 Modifying Data with T-SQL.mp4	63.9 MB
12 Creating and Altering Stored Procedures.mp4	62.0 MB
4 Designing Views.mp4	61.8 MB
17 Managing Transactions.mp4	50.2 MB
18 Row-based vs. Set-based Operations.mp4	41.3 MB
14 Combining Datasets.mp4	41.0 MB
19 Implementing Error Handling.mp4	28.3 MB
/Backup/
NuggetDemoDB_20131117.bak	40.9 MB
/.../TM_WORLD_BORDERS-0.3/
TM_WORLD_BORDERS-0.3.shp	6.5 MB
TM_WORLD_BORDERS-0.3.dbf	24.7 KB
Readme.txt	3.0 KB
TM_WORLD_BORDERS-0.3.shx	2.1 KB
TM_WORLD_BORDERS-0.3.prj	0.1 KB
/World Borders/
TM_WORLD_BORDERS-0.3.shp	6.5 MB
TM_WORLD_BORDERS-0.3.dbf	24.7 KB
Readme.txt	3.0 KB
TM_WORLD_BORDERS-0.3.shx	2.1 KB
TM_WORLD_BORDERS-0.3.prj	0.1 KB
/TSQLFundamentals20130525/
TSQL2012.sql	1.3 MB
Chapter 08 - Data Modification.sql	53.6 KB
Chapter 07 - Beyond the Fundamentals of Querying.sql	21.6 KB
Chapter 10 - Programmable Objects.sql	19.8 KB
Chapter 02 - Single-Table Queries.sql	17.7 KB
Chapter 09 - Transactions and Concurrency - Exercises.sql	14.3 KB
Chapter 05 - Table Expressions.sql	14.2 KB
Chapter 09 - Transactions and Concurrency.sql	11.4 KB
Chapter 03 - Joins - Solutions.sql	11.0 KB
Chapter 05 - Table Expressions - Solutions.sql	10.9 KB
Chapter 02 - Single-Table Queries - Solutions.sql	9.6 KB
Chapter 08 - Data Modification - Solutions.sql	9.4 KB
Chapter 03 - Joins - Exercises.sql	9.4 KB
Chapter 05 - Table Expressions - Exercises.sql	8.7 KB
Chapter 04 - Subqueries - Solutions.sql	8.6 KB
Chapter 07 - Beyond the Fundamentals of Querying - Solutions.sql	8.5 KB
Chapter 04 - Subqueries.sql	8.2 KB
Chapter 02 - Single-Table Queries - Exercises.sql	7.6 KB
Chapter 03 - Joins.sql	7.4 KB
Chapter 04 - Subqueries - Exercises.sql	6.8 KB
Chapter 07 - Beyond the Fundamentals of Querying - Exercises.sql	6.5 KB
Chapter 08 - Data Modification - Exercises.sql	6.2 KB
Chapter 06 - Set Operators - Solutions.sql	6.2 KB
Chapter 06 - Set Operators.sql	4.9 KB
Chapter 06 - Set Operators - Exercises.sql	4.4 KB
Chapter 01 - Background to T-SQL Querying and Programming.sql	2.1 KB
orders.txt	0.2 KB
/TK70461-20130524/
TSQL2012.sql	1.3 MB
/Shape2Sql/
SharpGIS.Gis.dll	80.4 KB
Shape2Sql.exe	41.5 KB
/TK70461-20130524/Chapter 06/
ColumnstoreIndicesAndBatchProcessing.docx	19.6 KB
AdditivityOfMeasures.docx	19.1 KB
IntroductionToDataMining.docx	19.0 KB
WhyIsBleedingEdgeADifferentConference.docx	17.0 KB
Chapter 06 - Exercises.sql	11.6 KB
Chapter 06 - Code.sql	1.4 KB
/TK70461-20130524/Chapter 13/
Chapter 13 - Exercises.sql	17.9 KB
Chapter 13 - Code.sql	11.7 KB
/TK70461-20130524/Chapter 12/
Chapter 12 - Exercises.sql	16.9 KB
Chapter 12 - Code.sql	6.6 KB
/.../Code Samples - Final/
Chap11.sql	16.0 KB
Chap12.sql	12.1 KB
Chap07.sql	9.4 KB
Chap16.sql	8.2 KB
Chap04.sql	7.6 KB
Chap11Accounting.sql	7.6 KB
Chap10.sql	7.6 KB
Chap10AccountingDBCreate.sql	7.3 KB
Chap06.sql	7.0 KB
Chap13.sql	6.2 KB
Chap03.sql	6.2 KB
Chap18.sql	4.2 KB
Chap05.sql	2.7 KB
Chap15.sql	2.2 KB
Chapter4DB.sql	1.8 KB
Chap09.sql	1.5 KB
Chap06AccountingDB.sql	1.5 KB
BuildAndPopulateEmployee2.sql	1.0 KB
Chap3UseTableVariable.sql	1.0 KB
Chap3CreateExampleTables.sql	0.7 KB
Chap17.sql	0.7 KB
Chap08.sql	0.1 KB
Chap01.sql	0.1 KB
Chap02.sql	0.0 KB
/TK70461-20130524/Chapter 15/
Chapter 15 - Code.sql	15.8 KB
Chapter 15 - Exercises.sql	7.2 KB
/TK70461-20130524/Chapter 07/
Chapter 07 - Code.sql	13.1 KB
Chapter 07 - Exercises.sql	7.9 KB
/TK70461-20130524/Chapter 10/
Chapter 10 - Code.sql	12.5 KB
Chapter 10 - Exercises.sql	9.7 KB
/TK70461-20130524/Chapter 17/
Chapter 17 - Code.sql	12.4 KB
Chapter 17 - Exercises.sql	3.3 KB
/TK70461-20130524/Chapter 11/
Chapter 11 - Code.sql	12.3 KB
Chapter 11 - Exercises.sql	9.4 KB
/TK70461-20130524/Chapter 04/
Chapter 04 - Code.sql	11.4 KB
Chapter 04 - Exercises.sql	5.7 KB
/TK70461-20130524/Chapter 09/
Chapter 09 - Exercises.sql	11.2 KB
Chapter 09 - Code.sql	6.9 KB
/TK70461-20130524/Chapter 16/
Chapter 16 - Code.sql	10.0 KB
Chapter 16 - Exercises.sql	4.6 KB
/TK70461-20130524/Chapter 08/
Chapter 08 - Exercises.sql	9.6 KB
Chapter 08 - Code.sql	5.7 KB
/TK70461-20130524/Chapter 05/
Chapter 05 - Code.sql	8.9 KB
Chapter 05 - Exercises.sql	6.2 KB
/TK70461-20130524/Chapter 03/
Chapter 03 - Code.sql	8.0 KB
Chapter 03 - Exercises.sql	4.6 KB
/TK70461-20130524/Chapter 02/
Chapter 02 - Code.sql	7.5 KB
Chapter 02 - Exercises.sql	3.0 KB
/TK70461-20130524/Chapter 14/
Chapter 14 - Code.sql	5.0 KB
Chapter 14 - Exercises.sql	4.9 KB
/09- DataTypes/
All-DataTypes.sql	3.8 KB
09- DataTypes.ssmssqlproj	1.6 KB
/.../05-Constraints_TSQL/
05-Constraints_TSQL.ssmssqlproj	3.7 KB
FOREIGN KEY.sql	2.8 KB
PRIMARY KEY.sql	2.3 KB
CHECK.sql	2.1 KB
DEFAULTS.sql	1.9 KB
NULL.sql	1.6 KB
UNIQUE.sql	1.6 KB
SampleData2.sql	1.1 KB
/07-SELECT/
SELECT-Basics.sql	3.2 KB
07-SELECT.ssmssqlproj	3.0 KB
TSQL-Functions.sql	2.7 KB
_SampleData.sql	2.1 KB
System-Metadata.sql	1.0 KB
DynamicSQL.sql	0.8 KB
/.../03-Views_TSQL/
03-Views_TSQL.ssmssqlproj	3.2 KB
Encryption_MetaData.sql	1.4 KB
SampleData.sql	1.1 KB
ALTER-View.sql	1.0 KB
Indexed_Views.sql	0.8 KB
CREATE-Views.sql	0.4 KB
DROP-Views.sql	0.1 KB
/.../12-StoredProcedures_TSQL/
CREATE-Sprocs.sql	3.1 KB
12-StoredProcedures_TSQL.ssmssqlproj	2.3 KB
DataAccessLayer.sql	1.6 KB
OUTPUT-Params.sql	1.2 KB
/.../06-Triggers_TSQL/
06-Triggers_TSQL.ssmssqlproj	3.0 KB
Nested-Triggers.sql	1.5 KB
_MailSetup.sql	1.1 KB
UPDATE.sql	0.8 KB
DELETE-INSTEADOF.sql	0.7 KB
INSERT.sql	0.6 KB
/10-Aggregates/
10-Aggregates.ssmssqlproj	2.7 KB
Aggregate-Basics.sql	2.3 KB
Analytic-Functions.sql	2.1 KB
Spatial-Aggregates.sql	1.5 KB
Ranking-Functions.sql	1.0 KB
/.../13-ModifyingData_TSQL/
13-ModifyingData_TSQL.ssmssqlproj	2.6 KB
Data-OUTPUT.sql	1.0 KB
CREATE-Sprocs.sql	1.0 KB
INSERT.sql	0.7 KB
DELETE.sql	0.7 KB
/TK70461-20130524/Chapter 01/
Chapter 01 - Exercises.sql	2.5 KB
Chapter 01 - Code.sql	2.0 KB
/.../18-Row_vs_Set-Ops/
Row-based.sql	2.5 KB
18-Row_vs_Set-Ops.ssmssqlproj	1.9 KB
Set-based.sql	1.2 KB
/08-Subqueries/
CTEs.sql	2.5 KB
08-Subqueries.ssmssqlproj	2.3 KB
Subquery-Basics.sql	2.0 KB
PIVOT.sql	1.0 KB
/.../15-Functions_TSQL/
Scalar.sql	2.4 KB
15-Functions_TSQL.ssmssqlproj	2.3 KB
System.sql	1.9 KB
TableValued.sql	1.4 KB
/17-Transactions/
17-Transactions.ssmssqlproj	2.3 KB
Transactions.sql	1.3 KB
Locking.sql	1.1 KB
LockingConcurrent.sql	0.5 KB
/.../02-Tables_TSQL/
02-Tables_TSQL.ssmssqlproj	2.3 KB
CREATE-Tables.sql	0.7 KB
ALTER-Tables.sql	0.7 KB
DROP-Tables.sql	0.1 KB
SQLQuery1.sql	0.0 KB
/11-XML/
11-XML.ssmssqlproj	2.3 KB
XML-Basics.sql	2.2 KB
Schemas.sql	1.9 KB
Importing-Exporting.sql	1.2 KB
/16-OptimizingQueries/
QueryPerformance.sql	2.2 KB
16-OptimizingQueries.ssmssqlproj	2.0 KB
QueryPlans.sql	1.1 KB
/19-ErrorHandling/
HandlingErrors.sql	2.1 KB
19-ErrorHandling.ssmssqlproj	2.0 KB
ThrowingErrors.sql	0.0 KB
/.../14-CombiningData_TSQL/
14-CombiningData_TSQL.ssmssqlproj	2.0 KB
MERGE.sql	1.6 KB
UNION.sql	1.1 KB
EXCEPT-INTERSECT.sql	1.0 KB
/.../04-View_Design/
04-View_Design.ssmssqlproj	1.8 KB
View_Security.sql	1.7 KB
Encryption_MetaData.sql	1.4 KB
Query_Designer.sql	0.3 KB
/StoredProcedures_TSQL/
StoredProcedures_TSQL.ssmssqlproj	0.4 KB
Total files 216