CBT Nugget 70-433 SQL Server 2008 Database Development

Aug

20

CBT Nugget 70-433 SQL Server 2008 Database Development

edit 20084aeca5cbtnuggetsecuritypn0.gif CBT Nugget 70 433 SQL Server 2008 Database Development
Exam-Pack 70-433: Microsoft SQL Server 2008, Database Development

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.
Size = 594.87 MB in 2 file(s)
download