Developing Microsoft SQL Server 2014 Databases

Acuity Training London

Course

In London

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    4 Days

This instructor-led course is intended for Microsoft® SQL Server® database developers who are responsible for implementing a database on SQL Server 2014. Students will focus on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, error handling, triggers, and SQL CLR are also covered in this course.

Facilities

Location

Start date

London
See map
99 Bishopsgate, EC2M 3XD

Start date

Different dates availableEnrolment now closed

About this course

After completing this course, students will be able to:

Describe the concepts of database development.
Design and implement tables.
Use constraints to ensure data integrity.
Describe indexes.
Implement advanced indexes.
Deploy in-memory database capabilities.
Design and implement views.
Design and implement stored procedures.
Design and implement user-defined functions.
Implement triggers to respond to data manipulation.
Deploy in-memory tables.
Implement managed code in SQL Server.
Store and query XML data in SQL Server.
Work with spatial data in SQL Server.
Incorporate data files into databases.

This course is intended for database professionals who need to fulfil a Database Developer role. Students should have knowledge of basic relational database concepts and writing T-SQL queries

This course requires that you meet the following prerequisites:

Working knowledge of Transact-SQL (ability to write Transact-SQL queries)
Working knowledge of relational databases (database design skills)
Core Windows Server skills
Writing Queries Using Microsoft® SQL Server® 2012/2014 Transact-SQL

Full colour manual or book.
Take away exercises used in the course to practice at home.
USB stick to take the exercises away (where relevant).
Freshly prepared lunch in our onsite cafeteria.
Refreshments though out the day.
Training in fully air conditioned facilities.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Database
  • XML training
  • XML
  • Server
  • SQL
  • Database training
  • SQLite
  • SQL Database
  • SQL Server
  • Sql training
  • SQLOS
  • SQL Server Scheduling

Course programme

An Introduction to Database Development
  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services
  • Introduction to Database Development
Designing and Implementing Tables
  • Using Data Types
  • Working with Character Data
  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables
  • Designing and Implementing Tables
Ensuring Data Integrity through Constraints
  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
  • Ensuring Data Integrity through Constraints
Introduction to Indexes
  • Core Indexing Concepts
  • Table Structures in SQL Server
  • Single Column and Composite Indexes
  • Planning for SQL Server Indexing
  • Working with Clustered Indexes
  • Working with Nonclustered Indexes
  • Creating Indexes
Advanced Indexing
  • Core Concepts of Execution Plans
  • Common Execution Plan Elements
  • Working with Execution Plans
  • Designing Effective Nonclustered Indexes
  • Performance Monitoring
  • Advanced Indexing
In-Memory Database Capabilities
  • The Buffer Pool Extension
  • Columnstore Indexes
  • Using In-Memory Database Capabilities
Designing and Implementing Views
  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views
  • Designing and Implementing Views
Designing and Implementing Stored Procedures
  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context
  • Designing and Implementing Stored Procedures
Designing and Implementing User-Defined Functions
  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Considerations for Implementing Functions
  • Alternatives to Functions
  • Designing and Implementing User-Defined Functions
Responding to Data Manipulation via Triggers
  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts
  • Responding to Data Manipulation by Using Triggers
Using In-Memory Tables
  • Memory-Optimized Tables
  • Natively Compiled Stored Procedures
  • Using In-Memory Database Capabilities
Implementing Managed Code in SQL Server
  • Introduction to CLR Integration in SQL Server
  • Importing and Cataloging Assemblies
  • Implementing CLR Integration in SQL Server
  • Implementing Managed Code in SQL Server
Storing and Querying XML Data in SQL Server
  • Introduction to XML and XML Schemas
  • Storing XML Data and XML Schemas in SQL Server
  • Implementing XML Indexes
  • Using the Transact-SQL FOR XML Statement
  • Getting Started with XQuery
  • Shredding XML
  • Storing and Querying XML Data in SQL Server
Working with Spatial Data in SQL Server
  • Introduction to Spatial Data
  • Working with Spatial Data Types in SQL Server
  • Using Spatial Data in Applications
  • Working with Spatial Data in SQL Server
Incorporating Data Files into Databases
  • Considerations for Working with Data Files in SQL Server 2014
  • Implementing FILESTREAM and FileTables
  • Searching Data Files
  • Implementing a Solution for Storing Data Files

See related categories

Developing Microsoft SQL Server 2014 Databases

Price on request

The best SQL Server courses

See all

See all