sql square

Goals


- Carry out any schemas and queries for MS-SQL

- Know the main functionalities offered by MS SQL Server

- Install, maintain, administer an MS SQL server

- Create and maintain an MS SQL server optimally

Program

History, versions and licenses of SQL Server
Roles and stakeholders of a SQL Server database
Other concurrent systems
Tools associated with SQL Server
Installation process: planning, updating
Authentication modes
Installation verification
File type:. mdf, .ndf, .ldf
Administrative objects

Lab: Installing and configuring SQL Server – Getting to know the SQL Server Management Studio tool

General organization: tables, views, constraints, indexes, procedures, …
Specification and modeling methods
Types and particular specifications of tables and fields
Creation of data structures
Management of storage spaces: files, groups of files
Inserting and importing data

Workshop: Database creation and file management

SQL language; MS SQL standards and particularities
Data definition statements
Index types
Constraint management
Data manipulation: insertion, updates, restriction, projection, calculations
Advanced structures, multiple joins, views, stored procedures
Transact SQL programming: functions, procedures
Elements of temporal optimization of requests
Documentation available

Workshop: Creation and manipulation of database data

Users and security: authentication modes, accounts, roles, permissions
Logs, possible backups and tools
Work on history and cancellations
Monitoring by alerts and triggers
Various automation of administration tasks

Workshop: User management – Backups and restores

Passing of the certification (if foreseen in the financing)

Duration

4 days

Price

£ 2148

Audience

Database administrators

Prerequisites

Notions of Windows or UNIX system administration

Reference

BAS202-F

Sessions

Contact us for more informations about session date