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