SQL Server A Functional Introduction)

Put into production and maintain Microsoft SQL Server. Securely manage, monitor and network one or more Microsoft SQL Server databases.

Educational Goals:

• Identify the key components and their roles;
• Adapt the configuration according to the deployment context;
• Put databases into production;
• Monitor activities;
• Automate maintenance tasks.

Methodology:

• Several learning methods and didactic tools allowing you to measure your progress and your integration of concepts by participants are used throughout the training.
• Exposed
• Demonstration
• Teamwork
• Individual work
• Simulation
• Computer exercise

Content:

• Key Components And Their Roles
• SQL Server infrastructure;
• Related services;
• Key files;
• Transactional mode;
• Differences with SQL Server Express.
• Facility:
• Configuring services;
• International characters;
• Networking;
• SQL Reporting Services.
• Management:
• Tables, views, stored procedures, functions, triggers, constraints;
• Administration in text versus graphical mode;
• Backup copies and restoration;
• Transactional logs;
• T-SQL automation scripts;
• Local and remote administration;
• Task Scheduler;
• Profiling and monitoring of internal and external database activities;
• Use of event logs;
• Importing external data;
• Management of roles and permissions;
• Connectivity: MS Office, SQL Server Reporting Services, PowerShell, VBA.