Menu

Querying Microsoft SQL Server at HiiT - ₦

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.

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

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

Contacts:
27 Obafemi Awolowo Way, Beside Obafemi Awolowo House, Ikeja, Lagos.
Phone: 0816-1660-043, 0802-270-5992
Email: [email protected]