Querying Microsoft SQL Server

Querying Microsoft SQL Server

 

SQL Server offers a cutting edge platform for enterprise data management, sophisticated development and implementation of modern business intelligence solutions. SQL Server 2014 offers better functionality, performance, scalability and security over previous versions. This course provides foundation the knowledge and skills to maximize the benefits of SQL Server.

Pre-requisite

No knowledge of IT is required to attend this program.


Course Content

The topics that are covered in this program include:

  • Introduction to Microsoft SQL Server 2014
  • Introduction to T-SQL Querying
  • Writing SELECT Queries 
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2014 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Implementing Transactions

For Whom

  • Database administrators
  • Developers
  • Job Seekers
  • Undergraduates
  • Administrative Officers/Managers
  • Accountants working with Enterprise Resource Planning(ERP) Softwares e.g SAP SAGE etc.
  • Marketing/Sales Offices
  • Students interested in database Management

Commencement Date

Date: 8th August, 2016

Duration

Weekdays

36 hours over six (6) weeks. Three (3) hours on Tuesdays & Thursdays.

Weekends

6 hours over Three (3) months Three (3) hours each Saturday

Time: 10:00am – 5:00pm

Training Methodology

Multiple training delivery methods are employed including Lectures, Demonstrations, Practical, Self Practice and workshop using real life case study with particular reference to Nigerian situations. The training is at least 80% practical.

Payment Methods

Interested individuals can pay using the following methods:

  • Pay at the centre of your choice
  • Pay to the bank using the following bank details

Account Number: 2011745387

Account Name: HiiT Plc

Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)

Installmental Payments (First Payment= 60% of Course Fee)