VTC Microsoft SQL Server 2008 Development | DD418346E03E4B14743043FD0E22119CB4DCCEFF

VTC Microsoft SQL Server 2008 Development

Name	VTC Microsoft SQL Server 2008 Development	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	358.0 MB
Total Files	70
Hash	DD418346E03E4B14743043FD0E22119CB4DCCEFF

/01 Introduction/
0103 SQL Server Basics.mov	4.6 MB
0105 Microsoft SQL Certifications.mov	4.4 MB
0106 SQL Server Editions.mov	4.0 MB
0102 Course Overview.mov	3.3 MB
0104 Getting Hands On.mov	2.9 MB
0107 SQL Server Developer.mov	2.8 MB
0101 Welcome.mov	1.3 MB
/02 Getting Set Up/
02 05. Installing SQL Server 2008 pt. 1.mov	5.5 MB
02 09. Installing Sample Databases pt. 1.mov	5.1 MB
02 06. Installing SQL Server 2008 pt. 2.mov	4.8 MB
02 04. Service Accounts.mov	4.2 MB
02 07. Installing SQL Server 2008 pt. 3.mov	3.9 MB
02 08. SQL Authentication Modes.mov	3.6 MB
02 03. SQL Server Components.mov	3.2 MB
02 02. SQL Server Instances.mov	3.2 MB
02 10. Installing Sample Databases pt. 2.mov	2.8 MB
02 01. Hardware Requirements.mov	2.7 MB
/03 Database Design/
03 04. Database Diagrams.mov	5.1 MB
03 05. Systematic Database Design.mov	4.9 MB
03 02. Normalization.mov	4.8 MB
03 01. Database Types.mov	4.4 MB
03 03. Normalization Benefits.mov	3.8 MB
03 06. Designing Database Objects.mov	3.8 MB
/04 Tables & Views/
04 03. Creating a Table pt. 2.mov	10.2 MB
04 04. Creating a Table pt. 3.mov	4.4 MB
04 08. Character Types.mov	4.2 MB
04 06. Unicode Basics.mov	4.1 MB
04 09. Exact Numerics.mov	3.9 MB
04 11. Date & Time.mov	3.7 MB
04 12. Null or Not Null.mov	3.7 MB
04 05. Data Types.mov	3.7 MB
04 14. Foreign Key.mov	3.6 MB
04 01. Table Basics.mov	3.4 MB
04 13. Primary Key.mov	3.3 MB
04 07. New Data Types In 2008.mov	3.2 MB
04 02. Creating a Table pt. 1.mov	2.6 MB
04 15. Candidate Key.mov	2.5 MB
04 10. Approximate Numeric Types.mov	2.0 MB
/05 Retrieving Data/
05 01. The Select Statement.mov	6.7 MB
05 06. UDF.mov	5.6 MB
05 05. Scalar Functions.mov	5.0 MB
05 03. Joining Tables pt. 1.mov	4.7 MB
05 04. Joining Tables pt. 2.mov	3.8 MB
05 02. Column Aliases.mov	3.1 MB
/06 Modifying Data/
06 04. Output Clause.mov	4.8 MB
06 01. Inserting Data.mov	4.2 MB
06 02. Updating Data.mov	1.9 MB
06 05. Merge Clause.mov	1.9 MB
06 03. Deleting Data.mov	1.7 MB
/07 Managing Transactions/
07 01. Understanding Transactions.mov	5.6 MB
07 03. Transaction Isolation Levels.mov	4.8 MB
07 02. Explicit Transactions.mov	2.9 MB
/08 Programming Objects/
08 05. Using Parameters.mov	5.9 MB
08 07. Common Table Expressions.mov	5.6 MB
08 08. Table Variables.mov	5.2 MB
08 01. Understanding Views.mov	4.9 MB
08 03. Understanding Stored Procs.mov	4.9 MB
08 06. Temporary Tables.mov	4.9 MB
08 04. Creating Stored Procs.mov	4.6 MB
08 09. Temp Common or Table.mov	4.5 MB
08 10. Dynamic SQL.mov	4.3 MB
08 02. Indexed Views.mov	3.6 MB
/09 Indexes/
09 04. Creating Indexes.mov	6.8 MB
09 05. Monitoring Indexes.mov	6.4 MB
09 01. Understanding Indexes.mov	4.3 MB
09 03. Clustered or Non-Clustered.mov	3.8 MB
09 02. Indexing Guidelines.mov	3.5 MB
/10 Course Wrap-Up/
10 01. Course Wrap-Up.mov	3.5 MB
/11 Credits/
11 01. About The Author.mov	1.8 MB
/Work Files/
sqlserver2008dev.zip	75.3 MB
Total files 70