Web Content Display Web Content Display

Breadcrumb Breadcrumb


Training Schedule Training Schedule

(6556) Developing Microsoft SQL Server 2014 Databases
Code: 6556
Type: null
Tuition (USD): $3095
Length: 5 Days
Have a question?

Get In Touch

Have an idea for your next great application development or analytics project?
Let us know so we can make it happen!

Tell Us Your Name

Enter Your Company Information

Write Us a Message

character(s) remaining

Contact us for upcoming dates.
Skills Gained:
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
Who Should Attend?
IT professionals who want to become skilled on SQL Server 2014 product features and technologies for implementing a database Developers from other product platforms or previous versions of SQL Server who want to become skilled in implementing a SQL Server 2014 database
  • Knowledge of writing T-SQL queries
  • Knowledge of basic relational database concepts
  • Querying Microsoft SQL Server 2014 (M20461)
What You Will Learn:
  • Classroom Live Outline
  • 1. Database Development Introduction
  • SQL Server Platform
  • SQL Server Tools
  • Configure SQL Server Services
  • 2. Design and Implement Tables
  • Design Tables
  • Work with Schemas
  • Create and Alter Tables
  • Partition and Compress Data
  • 3. Ensure Data Integrity through Constraints
  • Data Integrity Enforcement
  • Implement Domain Integrity
  • Implement Entity and Referential Integrity
  • 4. Introduction to Indexing
  • Core Indexing Concepts
  • Single Column and Composite Indexes
  • SQL Server Table Structures and Clustered Indexes
  • 5. Design Optimized Index Strategies
  • Execution Plan Concepts and Elements
  • INCLUDE Clause, Padding, Hints, and Statistics
  • Design Effective Non-Clustered Indexes
  • Performance Monitoring and the Database Engine Tuning Advisor
  • 6. Columnstore Indexes
  • Clustered and Non-Clustered Columnstore Indexes
  • 7. Design and Implement Views
  • Views
  • Creating and Managing Views
  • Performance Considerations for Views
  • 8. Design and Implement Stored Procedures
  • Stored Procedures
  • Implement Parameterized Stored Procedures
  • Control the Execution Context
  • 9. Design and Implement User-Defined Functions
  • Functions
  • Design and Implement Scalar Functions and Table-Valued Functions
  • Considerations for Implementing Functions
  • Alternatives to Functions
  • 10. Respond to Data Manipulation via Triggers
  • Design and Implement DML Triggers
  • Advanced Trigger Concepts
  • 11. In-Memory Tables
  • Memory-Optimized Tables
  • Native Stored Procedures
  • 12. Implement Managed Code in SQL Server 2014
  • SQL CLR Integration and Implementation
  • Import and Configure Assemblies
  • Implement Objects created within .NET Assemblies
  • 13. Store and Query XML Data in SQL Server
  • XML and XML Schemas
  • Store XML Data and Schemas in SQL Server
  • Implement the XML Data Type within SQL Server
  • Use the T-SQL for XML Statement
  • XQuery Language
  • Shred XML to a Relational Form
  • 14. SQL Server 2014 Spatial Data
  • Spatial Data Introduction
  • SQL Server Spatial Data Types
  • Spatial Data in Applications
Course Info:
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.

MCSE: Data Management and Analytics

Follow-On Courses:
Implementing a Data Warehouse with Microsoft SQL Server 2014 (M20463)
Designing a Data Solution with Microsoft SQL Server 2014 (M20465)
Implementing Data Models and Reports with Microsoft SQL Server 2014 (M20466)

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Retakes
Digital Courseware

* Terms and conditions may apply. Learn more about our Microsoft training exclusives by contacting training@dunnsolutions.com

Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.

Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.

Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.

Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Learn to design and develop SQL Server 2012 or 2014 databases.