This series is designed for absolute beginners who may want to integrate a database into their development efforts. Areas of focus include anSQL Server 2005 Express Edition introduction, where databases fit into the typical application's design, relational database theory, review of major database objects like tables, columns, etc. Writing Transact SQL statements, connectivity and security issues and a full development lifecycle of a small database driven application.

Renowned professionals Alison Balter, Bruce Jones, and Alan Sugano deliver power-packed instruction in this hot new learning set. You'll learn the intricacies of database design implementation, tables, views, stored procedures and advanced topics like database mirroring, hardware sizing, visibility, and server mirroring.

Renowned professionals Alison Balter, Bruce Jones, and Alan Sugano deliver power-packed instruction in this hot new learning set. You'll learn the intricacies of database design implementation, tables, views, stored procedures and advanced topics like database mirroring, hardware sizing, visibility, and server mirroring.
Part Number: SQLSERV05S12
Instructor: Alison Balter, Bruce Jones, Alan Sugano
Running Time: Approx. 10 Hours
Includes: 12 CD's

Renowned professionals Alison Balter, Bruce Jones, and Alan Sugano deliver power-packed instruction in this hot new learning set. You'll learn the intricacies of database design implementation, tables, views, stored procedures and advanced topics like database mirroring, hardware sizing, visibility, and server mirroring.

In this series, instructor Garth Schulte shows you what's new, what's different, and what's useful about SQL Server 2005. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and -- most importantly -- how to use them. Plus you'll be preparing for MCTS certification exam 70-431 at the same time.

Passing the 70-431 exam earns you certification as a Microsoft Certified Technology Specialist (MCTS), which tells employers that you are a specialist at implementing and maintaining a SQL Server 2005 installation. A basic understanding of computers and networking, such as A+ and Network+ certification or equivalent knowledge is recommended before viewing this training.

In this series, instructor Garth Schulte shows you what's new, what's different, and what's useful about SQL Server 2005. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and -- most importantly -- how to use them. Plus you'll be preparing for MCTS certification exam 70-431 at the same time.

Passing the 70-431 exam earns you certification as a Microsoft Certified Technology Specialist (MCTS), which tells employers that you are a specialist at implementing and maintaining a SQL Server 2005 installation. A basic understanding of computers and networking, such as A+ and Network+ certification or equivalent knowledge is recommended before viewing this training.

Designer Supported EDM Customization Intermediate [02:05:13]
Entity Framework 4.0 By Example Beginner [02:18:50]
Entity Framework and Data Models Intermediate [01:31:38]
Introduction to Data Warehousing and Business Intelligence Beginner [01:13:19]
Introduction to SQL Server Beginner [02:09:28]
PowerPivot for Microsoft Excel 2010 Beginner [02:23:40]
Reporting Services Advanced Topics Advanced [02:35:02]
Reporting Services Report Development Fundamentals Beginner [04:47:28]
Reporting Services Report Development Fundamentals 2 Intermediate [02:54:09]
SQL Server - TSQL Intermediate [04:46:26]
SQL Server Business Integration Tools Beginner [03:47:24]
SQL Server Fundamentals Beginner [07:55:35]
Using XML and XQuery Effectively with SQL Server Intermediate [05:29:07]