CBT Nuggets: Exam Microsoft SQLServer 2008 Database Development

Every database administrator dreams about zero downtime. With SQL Server 2008 that dream can be yours. SQL’s self-management features eliminate much of your database busy work, giving you the time you need to keep your databases secure and running smoothly.

Get the most from SQL Server 2008 while you’re becoming become a database star. Regardless of whether you’re brand new to SQL or already experienced with SQL Server 2005, this video series delivers the training you need. Database expert Julie Johnson thoroughly prepares you for database administration by carefully walking you through SQL Server 2008′s powerful features and capabilities.

SQL Server 2008′s storage capabilities cover many different data types — including XML, email, files and documents — as well as a wide variety of search, query and analysis functions. Really cool features include:
# Variable parameters

# MERGE statement

# Change data capture

# Full-text search integration

By the time you’ve finished Julie’s training you’ll be managing database tables, views, procedures, functions, and other objects. In no time, you’ll be:
# Monitoring database performance

# Manipulating and inspecting XML

# Sending mail from T-SQL

# Implementing asynchronous messaging

# Integrating with .NET

# Harnessing Windows PowerShell

# Tracking data changes

Julie’s training maps to Microsoft MCTS certification exam 70-433 while it readies you for your on-the-job database tasks. Following her step-by-step instruction gives you the database skills and solid exam prep you need to advance your career.

By the time you’re done you’ll understand the following topics about Microsoft 70-433: SQL Server 2008, Database Development:

* SQL Server Tables

* SQL Server Views

* Selecting and Changing Data

* SQL Server 2008 Indexes

* Partitioned Tables and Indexes (free video!)

* Procedures and Functions

* Advanced SQL

* Triggers

* XML Basics

* Advanced XML

* SQL Server 2008 Database Mail

* SQL Server Performance

* SQL Server 2008 Service Broker

* SQL Server .NET Integration

* Managing Text and Data Changes (International Consideration)

Here’s what you’ll learn in each video of the 70-433: SQL Server 2008, Database Development:

Video 1 – “SQL Server Tables” – SQL Server tables, SQL Server data types, SQL Server computed and persisted columns.

Video 2 – “SQL Server Views” – SQL Server 2008 views, SQL Server WITH CHECK OPTION, SQL Server view encryption, SQL Server schema binding.

Video 3 – “Selecting and Changing Data” – SQL Server 2008 Selecting data, inserting, updating, transactions.

Video 4 – “SQL Server 2008 Indexes” – SQL Server 2008 index overview, index types, implementing indexes.

Video 5 – “Partitioned Tables and Indexes” – SQL Server 2008 partitioning tables, partitioning indexes, range and list partitions.

Video 6 – “Procedures and Functions” – SQL Server 2008 procedures, functions, parameters, procedure and function options.

Video 7 – “Advanced SQL” – SQL Server 2008 subqueries, CTEs, MERGE statement, aggregate queries, combining datasets.

Video 8 – “Triggers” – SQL Server 2008 DML triggers, DDL triggers, INSTEAD OF triggers, recursive triggers.

Video 9 – “XML Basics” – SQL Server 2008 XML syntax, XML data type, FOR XML clause, XPATH, XQUERY.

Video 10 – “Advanced XML” – SQL Server 2008 namespaces, XML Schema, openxml(), xml indexes.

Video 11 – “SQL Server 2008 Database Mail” – SQL Server 2008 database mail architecture, mail profiles, sending email, email logs.

Video 12 – “SQL Server Performance” – SQL Server 2008 execution plans, profiler traces, templates, database engine tuning advisor, query hints, catalog views.

Video 13 – “SQL Server 2008 Service Broker” – SQL Server 2008 service broker, asynchronous and transactional messaging, implementing service broker.

Video 14 – “SQL Server .NET Integration” – SQL Server 2008 CLR integration, CLR vs. T-SQL, CLR restriction categories, Windows PowerShell, SMOs.

Video 15 – “Managing Text and Data Changes (International Consideration)” – SQL Server 2008 international considerations, full text search, tracking data changes.

Download:
http://www.fileserve.com/file/gr7NM4j/CBT70.part1.rar
http://www.fileserve.com/file/Tr5WnMH/CBT70.part2.rar
http://www.fileserve.com/file/WQ3BSJ8/CBT70.part3.rar
http://www.fileserve.com/file/YrURqJJ/CBT70.part4.rar
http://www.fileserve.com/file/D6fZnUZ/CBT70.part5.rar
http://www.fileserve.com/file/eNbAvJA/CBT70.part6.rar
OR
http://hotfile.com/dl/57903795/5e5b749/CBT70.part1.rar
http://hotfile.com/dl/57903811/03ca271/CBT70.part2.rar
http://hotfile.com/dl/57903807/4e338a0/CBT70.part3.rar
http://hotfile.com/dl/57903851/22228cf/CBT70.part4.rar
http://hotfile.com/dl/57903855/cf973df/CBT70.part5.rar
http://hotfile.com/dl/57903850/7c5e9cf/CBT70.part6.rar
OR
http://rapidshare.com/files/409437369/CBT70.part1.rar
http://rapidshare.com/files/409437345/CBT70.part2.rar
http://rapidshare.com/files/409437319/CBT70.part3.rar
http://rapidshare.com/files/409437486/CBT70.part4.rar
http://rapidshare.com/files/409437495/CBT70.part5.rar
http://rapidshare.com/files/409438244/CBT70.part6.rar