Goals
- Knowing how to create databases and database files
- Knowing how to create stored procedures and functions
- Knowing how to implement managed code in the database
- Knowing how to implement data integrity in Microsoft SQL Server 2016
- Understand how to use indexes to guarantee the performance of the database
- Knowing how to use Transact SQL to handle exceptions, create triggers
- Learn to use SQL Server’s specialized data types to manipulate hierarchical XML data or to manage spatial location data
Program
SQL Server Platform Architecture SQL Server
Database Development Tasks
Workshop – Server installation and discovery of the management tool
Designing databases
Tables and data types
Managing schemas
Editing tables
Partitioning data Data
compression
Temporal tables
Workshop – Creation of a database and partitioning of tables
Data
integrity Implement domain
integrity Referential and entity integrity
Workshop – Adding data constraints
Indexing: basic concepts and data types
Simple or composite
indexes Optimizing indexing and execution plans
Columnstore index: creation, manipulation
Workshop – Index creation and optimization
Views: presentation, interests / uses
Creation and management of views
Performance considerations
Workshop – Creation and interrogation of views
Stored procedures: presentation, interests / uses
Implementation of stored procedures with parameters
Query and passing of parameters
Control of the execution context
Workshop – Using stored procedures
Overview of functions
Scalar functions
Table functions
Alternatives to functions
Workshop – Design and implementation of functions
Duration
5 days
Price
£ 2599
Audience
Database administrators and developers
Prerequisites
Have taken the course "SQL Server 2016: Writing Transact-SQL queries" or equivalent knowledge
Knowledge of fundamental concepts of relational databases
Reference
BAS100743-F
Triggers: design, triggers
Implementing DML triggers Advanced
concepts on triggers
Workshop – Using triggers
In-memory tables
Native stored procedures
Workshop – Using tables in memory
Introduction to SQL
Import CLR Integration and Bundle Configuration
Lab – Using Managed Code in SQL Server
XML: structure of a document, schemas Data storage and XML schemas in SQL Server
Implementation of the XML data type
T-SQL FOR XML
xQuery: presentation, basic queries
Shredding: splitting XML data into relational data
Workshop – XML data manipulation and queries
Discovering Spatial Data in SQL Server
Manipulating Data
Workshop – Using spatial data in applications
FileStream BLOB Data
Full-Text Search
Workshop – Manipulation of binary and textual data
Competition management strategy Competition and transactions
Internal lockdown
Workshop – Management of concurrent access to data
Extended events
Real-time query statistics
Optimization of the configuration
Metrics
Workshop – Performance optimization and monitoring
Passing of the certification (if foreseen in the financing)
Sessions
Contact us for more informations about session date