Database Design, Tools & Techniques with SQL Server

Date Format Fees  
28 May - 31 May, 2024 Classroom ₦350,000 Register
12 Nov - 15 Nov, 2024 Classroom ₦350,000 Register
28 May - 31 May, 2024 Classroom ₦350,000 Register

Event Details

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.


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



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



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.



  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course