sql square

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