Developing Microsoft SQL Server 2014 Databases (M20464)

Course ID

11430

Course Description

In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will also learn procedure coding, such as indexes, concurrency, error handling, triggers, and SQL Common Language Runtime (CLR).

This course incorporates material from the Official Microsoft Learning Product 20464: Developing Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-464 and along with on-the-job experience, helps you prepare for the exam.


Prerequisites


Audience

  • IT professionals who want to become skilled on SQL Server 2014 product features and technologies
  • Developers from other product platforms or previous versions of SQL Server who want to become skilled in implementing a SQL Server 2014 database

    • Course Content

    • SQL Server platform tools including editions, versions, basics of network listeners, and concepts of services and service accounts
    • Appropriate data types used when designing tables, convert data between data types, and create alias data types
    • Design practices regarding SQL Server tables and create tables using T-SQL (partitioned tables not covered in this course)
    • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK, and UNIQUE constraints
    • Investigate cascading FOREIGN KEY constraints
    • Appropriate single column and composite index strategies
    • Create tables as heaps, tables with clustered indexes, and appropriate structure for table designs
    • Common elements from execution plans
    • Design effective non-clustered indexes
    • Design and implement views and stored procedures
    • Work with table types and table-valued parameters
    • Use MERGE to create stored procedures that update data warehouses
    • Design and implement scalar and table-valued functions
    • Investigate deadlock situation and how transaction isolation levels affect application concurrency
    • T-SQL error handling code and structured exception handling
    • Design and implement data manipulation language (DML) triggers
    • SQL CLR integration and implement existing .NET assembly within SQL Server
    • Store Extensible Markup Language (XML) data and schemas in SQL Server
    • Basic queries on XML data in SQL Server
    • GEOGRAPHY and GEOMETRY data types
    • Implement and query a full-text index

    For More Information

    For training inquiries, call 850-308-1376

    or email us at eramos@gbsi.com

    Course Details

    Duration - 5 days
    Price - $3095.00 USD


    (Discounts may apply. Call for more information.)

    Course Actions

    Schedule

    Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.