About The Course

The main benefits of SQL Server over Access are improved reliability, better performance, reduced network traffic and increased scalability. Drawbacks are an increased deployment cost and a more complex support environment. For small workgroups of up to a dozen users on a Local Area Network with modest data requirements (no more than 50,000 records) and without ultra-high reliability requirements then Access is probably your best bet. Outside of these parameters you should probably look to a client/server solution such as SQL Server.

Course Objectives :

SQL Server: Report Builder

SQL Server: Tuning & Optimising

SQL Server: Administration - Advanced

Extending Data Compression in SQL Server 2008 with Fixed Length Data Types

Hot add CPU and Hot add Memory

Performance Data Collector

Data Auditing

Risk & Compliance Analysis

SQL Server: Extended Events

Streamlined Installations

Backup Compressions

Resource Governance

Policy-Based Management

Course Content :

Error Handling and Transactions on Critical Data

Data Integrity & Reliability

Performance Analysis

SQL Server: Administration - Fundamentals

Implementing SQL Data Warehouse

Network Traffic Analysis

ALow Bandwidth

IT Risk Management