Course details
This instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.
Course Objectives :
This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.
Course Topics:
- Module 1: Introduction to SQL Server and its Toolset
- Module 2: Working with Data Types
- Module 3: Designing and Implementing Tables
- Module 4: Designing and Implementing Views
- Module 5: Planning for SQL Server Indexing
- Module 6: Implementing Table Structures in SQL Server
- Module 7: Reading SQL Server Execution Plans
- Module 8: Improving Performance through Nonclustered Indexes
- Module 9: Designing and Implementing Stored Procedures
- Module 10: Merging Data and Passing Tables
- Module 11: Creating Highly Concurrent SQL Server Applications
- Module 12: Handling Errors in T-SQL Code
- Module 13: Designing and Implementing User-Defined Functions
- Module 14: Ensuring Data Integrity through Constraints
- Module 15: Responding to Data Manipulation via Triggers
- Module 16: Implementing Managed Code in SQL Server
- Module 17: Storing XML Data in SQL Server
- Module 18: Querying XML Data in SQL Server
- Module 19: Working with SQL Server Spatial Data
- Module 20: Working with Full-Text Indexes and Queries
Course Location
About Egabi Learn
egabi Learn is a Professional Authorized Training Services and solutions provider covering a wide range of technical and management specializations. In addition, egabi Learn provides Rollout services covering end-to-end implementation to facilitate the entire rollout process as Theyll as outsTheircing services. egabi Learn offers various advanced learning solutions provided by experienced partners.
Since its establishment in 2007, egabi Learn has demonstrated remarkable growth, and is considered as one of the leading training services providers across MEA Region.
egabi Learn has acquired an impressive client base encompassing top multinational companies and key regional businesses from a wide range of business sectors covering government, telecommunication, banking and private sector companies.
See all Egabi Learn courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL – Master SQL Database Queries Course CentralEGP 1,074
EGP 6,705Duration: Upto 2 Hours - Data and Web Analytics CPD Certificate NextGen LearningEGP 2,595Duration: Upto 20 Hours
