This instructor-led course is intended for Microsoft® SQL Server® database developers who are responsible for implementing a database on SQL Server 2014.
What Will I Learn?
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.
Am I Ready For This Course?
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
Your SQL Training Day
Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practice more in your own time.
✔ A snazzy Certificate of Attendance to show that you trained with the best.
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
- Introduction to Database Development
- Using Data Types
- Working with Character Data
- Designing Tables
- Working with Schemas
- Creating and Altering Tables
- Designing and Implementing Tables
- Enforcing Data Integrity
- Implementing Domain Integrity
- Implementing Entity and Referential Integrity
- Ensuring Data Integrity through Constraints
- 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
- Core Concepts of Execution Plans
- Common Execution Plan Elements
- Working with Execution Plans
- Designing Effective Nonclustered Indexes
- Performance Monitoring
- Advanced Indexing
- The Buffer Pool Extension
- Columnstore Indexes
- Using In-Memory Database Capabilities
- Introduction to Views
- Creating and Managing Views
- Performance Considerations for Views
- Designing and Implementing Views
- Introduction to Stored Procedures
- Working with Stored Procedures
- Implementing Parameterized Stored Procedures
- Controlling Execution Context
- Designing and Implementing Stored Procedures
- 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
- Designing DML Triggers
- Implementing DML Triggers
- Advanced Trigger Concepts
- Responding to Data Manipulation by Using Triggers
- Memory-Optimized Tables
- Natively Compiled Stored Procedures
- Using In-Memory Database Capabilities
- Introduction to CLR Integration in SQL Server
- Importing and Cataloging Assemblies
- Implementing CLR Integration in SQL Server
- Implementing Managed Code 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
- Introduction to Spatial Data
- Working with Spatial Data Types in SQL Server
- Using Spatial Data in Applications
- Working with Spatial Data in SQL Server
- Considerations for Working with Data Files in SQL Server 2014
- Implementing FILESTREAM and FileTables
- Searching Data Files
- Implementing a Solution for Storing Data Files