You may add more courses here,
your list will be saved.

Home Egypt Courses MCSA MCSA : Implementing a Data Warehouse with Microsoft SQL Server 2012

MCSA : Implementing a Data Warehouse with Microsoft SQL Server 2012 HeroTec

MCSA : Implementing a Data Warehouse with Microsoft SQL Server 2012

Name: MCSA : Implementing a Data Warehouse with Microsoft SQL Server 2012
Availability: InStock
Rating: 1 (1 reviews)

HeroTec

Add to wishlist

Location: 93 Mostafa Alnahas , Nasr City , Cairo, Egypt
Duration: 40 Hours

Course details

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

Updated on 08 November, 2015

Course Location

Show map Location 93 Mostafa Alnahas , Nasr City , Cairo, Egypt

About 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.

See all HeroTec courses

View more Virtual classroom training for SQL Server online courses See all MCSA Courses

See all current SQL Server and MCSA jobs in Egypt

Are you from HeroTec ? Claim your course!

Courses you can instantly connect with... Do an online course on MCSA starting now.