Price: EGP 450
- Location: 28 A El Zahra St. | Suite 12 A | New Nerco, New Maadi, Cairo ,Egypt
- Duration: 5 Days
Course details
Overview:
This instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses 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. Also this course helps you prepare for the Exam 70-464.
Audience Profile
The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.
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
Course Location
About IT & Business Consulting Group
Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.
ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.
We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.
See all IT & Business Consulting Group courses Are you from IT & Business Consulting Group ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- EGP 2,286
EGP 15,813Duration: Upto 14 Hours - MCSA Windows Server 2016 (70-740) Lead AcademyEGP 1,306
EGP 19,683Duration: Upto 6 Hours
