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.
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
- 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
Date: 8th August, 2016
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
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.
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
Full Payment (Attracts 5% discount of Course Fee)
Installmental Payments (First Payment= 60% of Course Fee)