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 2012 Querying (70-461) Part 2

Course Summary

Part 2 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database. Skills gained will include querying a database using joins and data aggregations and query optimization. This


  • +

    Course Syllabus

    ● Managing Transactions
        ◦ Introduction
        ◦ Transactions
        ◦ Concurrency
        ◦ Concurrency Issues
        ◦ Read Noncommitted
        ◦ Read Committed
        ◦ Repeatable Read
        ◦ Serializable
        ◦ Snapshot
    ● Implementing Error Handling
        ◦ Try/Catch
        ◦ Raising Errors
        ◦ Using THROW
    ● XML Basics
        ◦ Introduction
        ◦ XML Concepts
        ◦ Well-Formed Documents
        ◦ Validation
    ● Retrieving XML
        ◦ Using FOR XML
        ◦ FOR XML AUTO
        ◦ Controlling XML Creation
    ● Importing XML
        ◦ XML Datatype
        ◦ Using OPENXML
        ◦ OPENXML Demo
    ● Creating and Altering Tables
        ◦ Designing Tables
        ◦ Managing Tables
        ◦ Altering Tables
    ● Data Validation with Constraints
        ◦ Introduction
        ◦ Data Validation Concepts
        ◦ Implementing Constraints
        ◦ Identity Columns
        ◦ Primary Key Constraints
        ◦ Foreign Key Cascade Options
        ◦ Foreign Key Cascade Demo
    ● Creating and Modifying Triggers
        ◦ Introduction
        ◦ Trigger Concepts
        ◦ Creating Triggers
        ◦ Triggers Demo
    ● Creating and Modifying Views
        ◦ View Concepts
        ◦ View Syntax
        ◦ View Demo
    ● Creating and Modifying Stored Procedures
        ◦ Stored Procedure Concepts
        ◦ Creating Stored Procedures
        ◦ Stored Procedure Demo
    ● Creating and Modifying User Defined Functions
        ◦ Introduction
        ◦ User Defined Function Concepts
        ◦ Creating User Defined Functions
        ◦ Apply Operators

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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