UVC Networks Solution

DATABASE MANAGEMENT

Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification:  Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master (OCM).

Oracle Certified Associate (OCA)
This oracle certification course is designed to identify, develop and certify individuals with requisite IT skills and knowledge for Database Management. It provides people of all ages with the means to increase their IT skills, prove their expertise and advance their professional careers.

Pre-requisite

No knowledge of computer and/or IT is required to attend this program.

Course Content

The courses that are covered in this program include:

  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing Database Instances
  • Managing ASM Instances
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support 

For whom

  • Administrative Officers/Managers
  • Accountants
  • Marketing/Sales Offices
  • Students
  • Job Seekers or anyone that is required to work with a Database.

Course Duration

Duration: 54 hours over Six (8) weeks. Saturdays and Sundays 2 hours Daily

Payment Types

Full Payment (Attracts 5% discount of Course Fee)

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

 

Courses Lagos (₦) Online (₦)
Oracle Certified Associate (OCA) (₦120,000) (₦120,000)
Oracle Certified Professional (OCP) (₦120,000) (₦120,000)
Oracle Business Intelligence Enterprise Edition (OBIEE) (₦120,000) (₦120,000)

* are compulsory
cardlogos

SQL Server offers a cutting edge platform for enterprise data management, sophisticated development and implementation of modern business intelligence solutions.The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

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 SQL Server 2014 Database Administration
  •  Installing and Configuring SQL Server 2014
  • Working with Databases and Storage
  • Planning and Implementing a Backup Strategy
  • Restoring SQL Server 2014 Databases
  • Tracing SQL Server Activity
  • Managing SQL Server Security
  • Auditing Data Access and Encrypting Data
  • Performing Ongoing Database Maintenance
  • Automating SQL Server 2014 Management
  • Monitoring SQL Server 2014 by Using Alerts and Notifications
  • 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

  • Project managers and other business professionals
  • Students
  • Graduates
  • Any other individuals interested in project management

Course Duration

 Six (4) weeks. Saturdays and Sundays 2 hours Daily

Payment Types

Full Payment (Attracts 5% discount of Course Fee)

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

 

Courses Lagos (₦) Online (₦)
Administering Microsoft SQL Server 2014 Databases (₦120,000) (₦120,000)
Querying Microsoft SQL Server (₦120,000) (₦120,000)

* are compulsory
cardlogos