- الموقع: 93 Mostafa Alnahas , Nasr City , Cairo, Egypt
- مدة الدورة التدريبية: 40 Hours
تفاصيل الدورة
This course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.
Outline
- Module 1: Introduction to SQL Server 2012 and its Toolset
- Module 2: Working with Data Types
- Module 3: Designing and Implementing Tables
- Module 4: Ensuring Data Integrity through Constraints
- Module 5: Planning for SQL Server 2012 Indexing
- Module 6: Implementing Table Structures in SQL Server 2012
- Module 7: Reading SQL Server 2012 Execution Plans
- Module 8: Improving Performance through Nonclustered Indexes
- Module 9: Designing and Implementing Views
- Module 10: Designing and Implementing Stored Procedures
- Module 11: Merging Data and Passing Tables
- Module 12: Designing and Implementing User-Defined Functions
- Module 13: Creating Highly Concurrent SQL Server 2012 Applications
- Module 14: Handling Errors in T-SQL Code
- Module 15: Responding to Data Manipulation via Triggers
- Module 16: Implementing Managed Code in SQL Server 2012
- Module 17: Storing XML Data in SQL Server 2012
- Module 18: Querying XML Data in SQL Server
- Module 19: Working with SQL Server 2012 Spatial Data
- Module 20: Working with Full-Text Indexes and Queries
نبذة عن معهد HeroTec
Herotec is network professional training provider, founded 2007 to focus on IT professional training.
Herotec provides professional training programs at their premises or onsite training (client premises)
their exclusive specialization in the field of IT & network professional training with both sectors) technical & management) gives us the advantage to be the leader in identifying unique training opportunities for both corporate & individuals.
عرض الجميع دورات HeroTec Are you from HeroTec ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على MCSA ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- 2,256 جنيه مصري
15,805 جنيه مصريمدة الدورة التدريبية: Upto 14 Hours - SpeedGrade CC 1TRAINING1,096 جنيه مصري
7,734 جنيه مصريمدة الدورة التدريبية: Upto 14 Hours
