Goals
- Present the SQL server platform and its major tools
- Read and interpret details of common elements from execution plans
- Design and implement views and stored procedures
Program
Introduction to the SQL Server Platform
Working with SQL Server Tools
Configure SQL Server Services
Practical workshops: Introduction to the development of a database
Designing tables
Working with schemas
Creating and modifying tables
Practical workshops: Design and implement tables
Strengthen data
integrity
Implement domain integrity Implement referential integrity
Practical workshops: Ensuring data integrity with constraints
Basic Indexing Concepts
Simple Columns and Composite Indexes
SQL Server Table Structures
Working with Cluster Indexes
Practical workshops: Running indexes
Core Execution Plan Concepts Core
Elements of the Execution Plan
Working with Execution Plans
Designing Efficient Non-Cluster Indexes
Monitoring Performance
Practical workshops: Design of optimized index strategies
Technology Overview
Best Practices for Columnstore Indexes
Practical Workshops: Using Columnstore Indexes
Introduction to Views
Creating and Managing Views
Performance Requirements for Views
Practical Workshops: Designing and Implementing Views
Introduction to stored procedures
Working with stored procedures
Implementing parameterized stored procedures
Controlling the execution context
Practical workshops: Design and implement stored procedures
Duration
5 days
Price
£ 2134
Audience
Professionals who want to know the features to implement a SQL Server database
Prerequisites
Basic knowledge of relational databases
Knowledge of writing queries with TSQL
Reference
BAS1122-F
Overview of functions
Design and implement scalar functions
Design and implement table
functions Alternatives to functions
Practical workshops: Design and implement user functions
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Practical workshops: Responding to data manipulation via triggers
Memory-optimized tables
Native stored procedures
Practical workshops: « In-Memory » OLTP
Introduction to SQL CLR Integration
Import and Configure Assemblies
Implement SQL CLR Integration
Practical Workshops: Implementing Managed Code in SQL Server
Introduction to XML and XML Schemas
Store XML Data and Schemas in SQL Server
Implement XML Data Types
Use T-SQL for XML
Get Started with XQuery
XML Pre-load
Practical Workshops: Store and Query XML Data in SQL Server
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Practical workshops: Working with spatial data
Sessions
Contact us for more informations about session date