PCN ICT Training Centre

TRAINING PROGRAMMES

Databases

Duration: 77 hours

This course is targeted at individuals who wish to build skill in designing and creating database using relational database management systems. This course will provide participants with hands-on sessions in the design and management of relational databases.

The participants will be able to :

  • Install and configure relational database management systems (MS Sql Server / Oracle)
  • Introducing MS SQL Server/Oracle
  • Create databases
  • Design table
  • Use select query
  • Create and use Indexes
  • Create and use Views
  • Write T-SQL/PL SQL codes
  • Create and use stored procedures and functions
  • Create and Manage Users
  • Backup and restore databases

Modules

  • Installation and configuration of MS SQL server /Oracle
  • Introduction to Management Studio/Apex/SQL Developer
  • Creating a Database
  • Data types
  • Creating a new table
  • Constraints
  • Insert, Update, Delete data
  • The select query
  • Create Index
  • Create view
  • Programming using T-SQL/PL SQL
  • Stored Procedures
  • Functions
  • User management and security
  • Data base availability

Examination

3 hours

Payment Information

OPTION 1

Step1 - Fill a registration form for the course

Step2 - Make cash deposit into the Bank Accounts below

  • Fidelity Bank
  • PCN TRAINING CENTER:1300616905213
  • Branch : Kwame Nkrumah Avenue

Step3 - Send payment info: name, course title and pay-in slip to admissions@pcnicttrainingcenter.com

OPTION 2

Step1 - Fill a registration form for the course

Step2 - Submit a Bankers Draft with name below at the office

PCN TRAINING CENTER

Contact Address