Programming language is an artificial language designed to express computations that can be performed by a machine, particularly a computer.
Computer networking is the engineering discipline concerned with communication between different computer systems or devices.
Telecommunication is communication at a distance by technological means, particularly through electrical signals or electromagnetic waves.

Implementing and Maintaining Business Intelligence

  • Course Information

  • Code: 6233A
  • Title: Implementing and Maintaining Business Intelligence
  • Course Fee: 160 $ (Student) - 224 $ (Corporate)
  • Duration: 40 Hours
  • Available Time: Monday to Saturday: 8:00AM to 11:00AM, 2:00PM to 5:00PM and 5:30PM to 8:30PM
  • Course Outline

  • 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