MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

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

Course Summary

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, .


  • +

    Course Syllabus


    Course Fee:
    USD 29
    ● .NET/CLR Development
        ◦ Introduction
        ◦ Common Language Runtime (CLR)
        ◦ CLR vs. T-SQL
        ◦ SQL-CLR Types Mapping
        ◦ Steps for Using SQLCRL
        ◦ Re-creating a Table
        ◦ CLR Permission Sets
        ◦ Execution Plans
        ◦ Terminology
        ◦ What We Covered
    ● Data Partitioning
        ◦ Introduction
        ◦ Data Partitioning Diagram
        ◦ Re-Creating Our Database
        ◦ Creating and Using Data Partitions
        ◦ Steps for Creating Partitioned Tables
        ◦ Terminology
        ◦ What We Covered
    ● Application Performance
        ◦ Introduction
        ◦ Database Engine Tuning Advisor Tuning Capabilities
        ◦ Analyzing Query in Database Engine Tuning Advisor
        ◦ DTA Requires a Workload
        ◦ Creating a Trace with SQL Server Profiler
        ◦ SHOWPLAN Statements
        ◦ SET STATISTICS Statements
        ◦ Terminology
        ◦ What We Covered
    ● Working with XML Data
        ◦ Introduction
        ◦ Markup Languages
        ◦ Why XML and SQL Server?
        ◦ Some XML Basics
        ◦ XML Support in SQL Server 2008
        ◦ The 4 'FOR XML' Modes
        ◦ XML Data Type
        ◦ OpenXML Statement
        ◦ Terminology
        ◦ What We Covered
    ● Database Mail
        ◦ Introduction
        ◦ Database Mail Profiles and Accounts
        ◦ Public vs. Private Profiles
        ◦ Configuring Database Mail
        ◦ Stored Procedures
        ◦ Database Mail SMTP Authentication
        ◦ What We Covered and Terminology
    ● Full-Text Search
        ◦ Introduction
        ◦ Basic Setup of a Full-Text Search
        ◦ Configuring Full-Text Searches
        ◦ WHERE CONTAINS Statement
        ◦ Performing Full-Text Search in Spanish
        ◦ Writing Full-Text Queries
        ◦ Stop Words
        ◦ Terminology
    ● PowerShell in SQL Server 2008
        ◦ Microsoft's Common Engineering Criteria
        ◦ SQL Server 2008 PowerShell Extensions
        ◦ The Hierarchy
        ◦ SQL Server Specific PowerShell cmdlets
        ◦ Using SQL Server PowerShell Provider
        ◦ Microsoft.SQLServer.Management.Smo
        ◦ A Developers Top 'n' cmdlets
        ◦ Terminology
        ◦ What We Covered
    ● Service Broker
        ◦ Introduction
        ◦ What Does Service Broker Do?
        ◦ Service Broker - aka Service-Oriented Architecture (SOA) - Terms
        ◦ Creating Objects for Service Broker Communication
        ◦ Sending Messages with Service Broker
        ◦ Terminology
        ◦ What We Covered
    ● Introduction to Integration Services
        ◦ Introduction
        ◦ Business Intelligence Development Studio
        ◦ Installing BI Environment and Integration Services (SSIS)
        ◦ Building SSIS Package
        ◦ Creating OLE DB Connection
        ◦ Connecting Controls Using Data Manager
        ◦ Running Transformation
        ◦ Microsoft Integration Services
        ◦ Terminology
    ● Introduction to Reporting Services
        ◦ Introduction
        ◦ Business Intelligence Development Studio
        ◦ Building a Report Using Report Designer
        ◦ Report Builder 3.0
        ◦ Building a Report Using Report Builder 3.0
        ◦ What We Covered
    ● Certification 101
      

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top