SQL Server 2008 Database Development (70-433) Part 2

Pluralsight

Course Summary

+
Course Description

Part 2 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.

Course Description

Part 2 of 2 in the SQL Server 2008 Database Development (70-433) series. This SQL Server 2008 Database Development course is designed to teach you how to design databases and applications, and build the functionality. In this course you'll learn, T-SQL, .NET/CLR development, data partitioning, and advanced query techniques. If you have done any type of distributed application development, taken our SQL Server 2008 Administration Training course, or have experience installing SQL Server and setting up user accounts, you'll benefit from this in-depth course.

+
Course Syllabus

.NET/CLR Development
- 43m 28s

—Introduction 1m 43s
—Common Language Runtime (CLR) 2m 9s
—CLR vs. T-SQL 2m 22s
—SQL-CLR Types Mapping 1m 52s
—Steps for Using SQLCRL 13m 35s
—Re-creating a Table 8m 10s
—CLR Permission Sets 4m 1s
—Execution Plans 6m 54s
—Terminology 1m 33s
—What We Covered 1m 9s

Data Partitioning
- 27m 41s

—Introduction 1m 44s
—Data Partitioning Diagram 2m 47s
—Re-Creating Our Database 4m 15s
—Creating and Using Data Partitions 7m 46s
—Steps for Creating Partitioned Tables 9m 18s
—Terminology 0m 46s
—What We Covered 1m 5s

Application Performance
- 24m 33s

—Introduction 0m 40s
—Database Engine Tuning Advisor Tuning Capabilities 3m 41s
—Analyzing Query in Database Engine Tuning Advisor 5m 11s
—DTA Requires a Workload 4m 45s
—Creating a Trace with SQL Server Profiler 2m 59s
—SHOWPLAN Statements 4m 30s
—SET STATISTICS Statements 0m 58s
—Terminology 0m 42s
—What We Covered 1m 7s

Working with XML Data
- 36m 53s

—Introduction 1m 7s
—Markup Languages 2m 22s
—Why XML and SQL Server? 1m 4s
—Some XML Basics 1m 50s
—XML Support in SQL Server 2008 1m 11s
—The 4 'FOR XML' Modes 10m 40s
—XML Data Type 5m 38s
—OpenXML Statement 10m 15s
—Terminology 1m 20s
—What We Covered 1m 26s

Database Mail
- 25m 14s

—Introduction 7m 33s
—Database Mail Profiles and Accounts 1m 50s
—Public vs. Private Profiles 1m 6s
—Configuring Database Mail 6m 51s
—Stored Procedures 4m 2s
—Database Mail SMTP Authentication 2m 23s
—What We Covered and Terminology 1m 29s

Full-Text Search
- 24m 44s

—Introduction 0m 40s
—Basic Setup of a Full-Text Search 7m 35s
—Configuring Full-Text Searches 1m 42s
—WHERE CONTAINS Statement 4m 6s
—Performing Full-Text Search in Spanish 3m 54s
—Writing Full-Text Queries 3m 52s
—Stop Words 1m 37s
—Terminology 1m 18s

PowerShell in SQL Server 2008
- 28m 41s

—Microsoft's Common Engineering Criteria 2m 28s
—SQL Server 2008 PowerShell Extensions 7m 9s
—The Hierarchy 1m 17s
—SQL Server Specific PowerShell cmdlets 5m 32s
—Using SQL Server PowerShell Provider 5m 6s
—Microsoft.SQLServer.Management.Smo 0m 39s
—A Developers Top 'n' cmdlets 3m 57s
—Terminology 0m 57s
—What We Covered 1m 36s

Service Broker
- 21m 43s

—Introduction 0m 43s
—What Does Service Broker Do? 1m 8s
—Service Broker - aka Service-Oriented Architecture (SOA) - Terms 5m 3s
—Creating Objects for Service Broker Communication 4m 27s
—Sending Messages with Service Broker 7m 7s
—Terminology 0m 50s
—What We Covered 2m 25s

Introduction to Integration Services
- 22m 6s

—Introduction 2m 32s
—Business Intelligence Development Studio 0m 37s
—Installing BI Environment and Integration Services (SSIS) 3m 36s
—Building SSIS Package 5m 1s
—Creating OLE DB Connection 1m 31s
—Connecting Controls Using Data Manager 4m 2s
—Running Transformation 1m 46s
—Microsoft Integration Services 2m 5s
—Terminology 0m 56s

Introduction to Reporting Services
- 23m 35s

—Introduction 0m 43s
—Business Intelligence Development Studio 3m 3s
—Building a Report Using Report Designer 9m 40s
—Report Builder 3.0 0m 48s
—Building a Report Using Report Builder 3.0 8m 25s
—What We Covered 0m 56s

Certification 101
- 5m 31s

—The Certification Hierarchy 1m 25s
—Microsoft Certified Technology Specialist (MCTS) 1m 5s
—Microsoft Certified IT Professional (MCITP) 1m 31s
—Microsoft Certified Master (MCM) 1m 30s

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

This course is listed under Development & Implementations , Data & Information Management , Networks & IT Infrastructure , Digital Media & Games , Server & Storage Management and E-Commerce Community

Attended this course? Write a Review

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

IT Career Development Platform

SQL Server 2008 Database Development (70-433) Part 2

Pluralsight

Course Summary

Course Description

Course Description

Course Syllabus

Course Type:

Course Status:

Workload:

SQL (Structured Query Language)

Common Language Runtime (CLR)

XML (eXtensible Markup Language)

PowerShell

SQL Server Integration Services (SSIS)

Business Intelligence (BI)

Social Media Optimization (SMO)

Simple Mail Transfer Protocol (SMTP)

Object Linking and Embedding Database (OLE DB)

Object Linking and Embedding (OLE)

Attended this course? Write a Review

Course Type:

Course Status:

Workload: