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 1

Course Summary

Part 1 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

    ● SQL Server 2008 Database Development
        ◦ Target Audience
        ◦ Prerequisites
        ◦ About Your Instructor
        ◦ Course Topics
        ◦ The Environment
        ◦ SQL Certifications Overview
    ● Designing and Developing a SQL Server 2008 Database Application
        ◦ Designing and Developing a Database Application
        ◦ Our Scenario
        ◦ Database Schema for Veronica's Veronicas
        ◦ What We Covered
    ● Transact-Structure Query Language
        ◦ Introduction
        ◦ The SELECT Statement
        ◦ The WHERE Clause
        ◦ Nested SELECT Statement
        ◦ The UPDATE and DELETE Statements
        ◦ The MERGE Statement
        ◦ MERGE Statement Demo
        ◦ The GROUP BY and HAVING Statements
        ◦ What We Covered
    ● Constraints and Triggers
        ◦ Data Integrity
        ◦ Enforcing Data Integrity
        ◦ Primary Key Constraint Violation
        ◦ Selecting Two-Column Primary Key
        ◦ UNIQUE Constraints
        ◦ FOREIGN KEY Constraints
        ◦ CHECK Constraints
        ◦ CHECK Constraints Using GUI
        ◦ Constraints: Enabling and Disabling
        ◦ Triggers in SQL Server 2008
        ◦ DML Triggers
        ◦ Creating a Trigger
        ◦ Testing Triggers
        ◦ Constraints vs. Triggers
        ◦ Terminology
        ◦ What We Covered
    ● User Defined Functions
        ◦ User-Defined Function Basics
        ◦ Creating User-Defined Function
        ◦ User-Defined Function Benefits
        ◦ Schema Binding
    ● Advanced Query Techniques
        ◦ Introduction
        ◦ Common Table Expressions
        ◦ Recursion Example
        ◦ Rank Functions - ROW_NUMBER Function
        ◦ Rank Functions - NTILE Function
        ◦ Other Rank Functions
        ◦ Built-In Functions
        ◦ Terminology
    ● Stored Procedures
        ◦ Introduction
        ◦ Stored Procedure Basics
        ◦ Types of Stored Procedures
        ◦ Creating and Modifying a Simple Stored Procedure
        ◦ Benefits of Stored Procedures vs. Transact-SQL
        ◦ Creating a More Complicated Stored Procedure
        ◦ Modifying a More Complicated Stored Procedure
        ◦ Creating a Stored Procedure from a Template
        ◦ Stored Procedures vs. Functions
        ◦ Table Value Parameters
        ◦ Terminology
        ◦ What We Covered
    ● Handling Errors
        ◦ Introduction
        ◦ Syntax Errors
        ◦ Handling Database Engine Errors
        ◦ Retrieving Error Information
        ◦ Error Severity
        ◦ RAISERROR
        ◦ Creating a New Error Message
        ◦ sys.message Catalog View
        ◦ Transactions
        ◦ Using Debugger
        ◦ Terminology
        ◦ What We Covered

     


Course Fee:
USD 29

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