Database Design, Tools and Techniques with SQL Server

The Database Design, Tools & Techniques with SQL Server workshop provides participants with the knowledge and skills to develop a Microsoft SQL Server database. The workshop focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

CONTENT

Design and implement database objects

• Design and implement a relational database schema
• Design and implement indexes
• Design and implement views
• Implement columnstore indexes

Implement programmability objects

• Ensure data integrity with constraints

• Create stored procedures

• Create triggers and user-defined functions
• Implement transactions
• Manage isolation levels
• Optimize concurrency and locking behavior
• Implement memory-optimized tables and native stored procedures

Optimize database objects and SQL infrastructure

• Optimize statistics and indexes
• Analyze and troubleshoot query plans
• Manage performance for database instances
• Monitor and trace SQL Server baseline performance metrics

Configure data access and auditing

• Configure encryption
• Configure data access and permissions
• Configure auditing

Manage backup and restore of databases

• Develop a backup strategy
• Restore databases
• Manage database integrity

Manage and monitor SQL Server instances

• Monitor database activity

• Monitor queries
• Manage indexes
• Manage statistics
• Monitor SQL Server instances

Manage high availability and disaster recovery

• Implement log shipping
• Implement Always On Availability Groups
• Implement failover cluster instances

FOR WHOM:

CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.