Database Design, Tools & Techniques with SQL Server
Details
Design and implement database objects
- Design and implement a relational database schema
- Design and implement indexes
- Design and implement views
- Implement columnstore indexes
Outline
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
- Manage isolation levels
- Optimize concurrency and locking behavior
- Implement memory-optimized tables and native stored procedures
- Create triggers and user-defined functions
- Implement transactions
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
- Manage indexes
- Manage statistics
- Monitor queries
- Monitor SQL Server instances
Manage high availability and disaster recovery
- Implement log shipping
- Implement Always On Availability Groups
- Implement failover cluster instances
Speaker/s
Special Offer
Schedules
| Tue, Fri | 09:00 AM — 04:00 PM |
| No. of Days: | 4 |
Alpha Partners is a reputable firm of Training and Management Consultants with many years of corporate training experience in Finance, Accounting, Auditing, Banking, Management, Information Technology, Oil and Gas Sector, Security, Engineering, Public Relations, Secretarial Studies, Leadership, Marketing and other fields of human endeavour.
We are one of the leading players in the profession. Our firm, a multi-disciplinary one with highly talented, experienced and dedicated partners and staff who have experiences in different facets of working life was established in 1996 and has branches in Lagos, Enugu and Awka.
We offer a wide range of professional services, which covers audits, accounting, finance, taxation, ICT, security, engineering, insurance, human resources management, secretarial and consultancy services in all ramifications.
Our numerous clients attest to the high quality services we offer which contribute in no small measure in ensuring sound and efficient management of their resources.
Related Courses
