DEVELOPING MICROSOFT SQL SERVER DATABASES (COURSE #20464) Training Course Course: Introduction

This course introduces database development and the key tasks that a database developer would typically perform. We will discuss how to design, create, and alter tables. Also it focuses on working with schemas. The course also covers how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focuses on implementing Entity and Referential Integrity. As you can see from the course specifics, we cover all topics about server databases, not least of which is the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.

DEVELOPING MICROSOFT SQL SERVER DATABASES (COURSE #20464) Training Course Course :Course Outline

1. Introduction to Database Development
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services
Start SQL Server Management Studio

2. Designing and Implementing Tables
Designing Tables
Working with Schemas
Creating and Altering Tables
Improving the Design of Tables
Creating a Schema
Creating the Tables

3. Ensuring Data Integrity through Constraints
Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity
Designing Constraints
Testing the constraints

4. Introduction to Indexing
Core Indexing Concepts
Single Column and Composite Indexes
SQL Server Table Structures
Working with Clustered Indexes
Creating Indexes
Creating Tables with Clustered Indexes
Improving Performance through No clustered Indexes

5. Advanced Indexing
Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans
Designing Effective No clustered Indexes
Performance Monitoring
Planning for SQL Server 2014 Indexing
Exploring Existing Index Statistics
Creating Covering Indexes

6. Column store Indexes
Column store Indexes
Best Practices for Column store Indexes
Using In-Memory Database Capabilities
Creating Column store Indexes

7. Designing and Implementing Views
Introduction to Views
Creating and Managing Views
Performance Considerations for Views
Designing, Implementing and Testing the WebStock Views
Designing and Implementing the Contacts View
Modifying the AvailableModels View

8. Designing and Implementing Stored Procedures
Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Creating stored procedures
Creating a parameterized stored procedure
Altering the execution context of stored procedures

9. Designing and Implementing User-Defined Functions
Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table-Valued Functions
Implementation Considerations for Functions
Alternatives to Functions
Formatting Phone Numbers
Modifying an Existing Function
Resolving a Function-Related Performance Issue

10. Responding to Data Manipulation via Triggers
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Creating and Testing the Audit Trigger
Improving the Audit Trigger

11. Using In-Memory Tables
Memory-Optimized Tables
Native Stored Procedures
Using In-Memory Database Capabilities
Working with Memory Optimized Tables
Working with Natively Compiled Stored Procedures

12. Implementing Managed Code in SQL Server
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration

DEVELOPING MICROSOFT SQL SERVER DATABASES (COURSE #20464) Training Course Course: Course Duration

3 day/s

Who should attend: DEVELOPING MICROSOFT SQL SERVER DATABASES (COURSE #20464) Training Course Course

This course is intended for programmers, SQL Server.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal