Course details
Course Objectives
After completing this course, you will be able to:
- Describe design considerations of Microsoft SQL Server databases.
- Describe design considerations of Microsoft SQL Server tables.
- Describe table structures such as heap and cluster.
- Describe indexing types: Rowstore and Columnstore.
- Describe how to use and maintain indexes.
- Describe statistics and why they are important.
- Describe how to handle locks and blocks.
- Describe concurreny issues and how to handle them.
- Describe how to use memory-optimized tables and natively compiled procedures.
Course Outline
The following items describe the outline of the course:
- Database deisgn considerations
- Table design considerations
- Table strcutures
- Rowstore index
- Columnstore index
- Index maintenance
- Statistics
- Locks and blocks
- Isolation Levels
- Memory-optimized tables
Eligibility / Requirements
This course requires that you meet the following prerequisites:
- Working knowledge of data related solutions
- Working knowledge on Microsoft SQL Server database
- Working knowledge on T-SQL
Job roles this course is suitable for:
Database Administrator , Database Engineer , Software EngineerAbout InnoventSys
InnoventSys (Pvt) Ltd was established in 2019 and formed by professionals who have over decade of experience and expertise in Education domain, IT and non-IT training, Consultancies and Solution selling to the Corporate and Government sectors.
Integrating industry experience with sound professional skills, we are nurturing the next generation
of versatile independent experts in the Information Technology domain. With its vast experience and focus InnoventSys enables customers to operate more innovatively, efficiently and successfully in the markets they serve.
InnoventSys currently provides training solutions on Microsoft, ITIL, AWS, Data Science, Big Data, IoT, Software Testing, DevOps, Business Process Analysis & Design, Google, Mobile App Development (iOS, Android, Xamarin), Citrix, PMP, Prince2, TOGAF, VMware, Agile, SAP, Adobe, Oracle for the betterment of IT Professionals. While moving forward, we’re expanding our product & service portfolio to uplift our customer’s skills to win challenges globally.
Enquire about this course
You may add more courses here,
your list will be saved.
