Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Database System Designs Tools and Techniques Course; MySQL

By: Alpha Partners

Lagos State, Nigeria

30 Oct - 02 Nov, 2018  4 days

Follow Event

  

NGN 125,000

Relational databases often drive company-critical and web-enabled applications; therefore, creating a database design that accurately captures user requirements is vital for success.  This course provides a foundation for designing, building and working with relational databases, enabling you to effectively develop and use relational databases in your environment.

CONTENTS:

  • Introduction
  • An overview of DBMS technology
  • DBMS and related user tools
  • How a relational DBMS works
  • Relation technology fundamentals
  • Components of a relational DBMS
  • Designing Relational database 
  • A step by step approach and techniques
  • Entity relationship modeling
  • Normalizing data to design tables
  • Working with a case tool
  • Physical database design
  • Building and Querying a Relational Database
  • Fundamentals of SQL
  • Creating a relational database
  • Accessing the database with SQL
  • Constructing and using views
  • The future of database design
  • Enforcing business rules for data integrity
  • Current trends

FOR WHOM:   Database Administrators, System Administrators, IT Supervisors/Managers,  Chief Information Officers, IT Personnel and those who require knowledge in Database System Design,  Implementation and Management.

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor) Opposite Adekunle BRT Bus-stop, Yaba, Lagos. Oct 30 - 02 Nov, 2018
NGN 125,000.00(Workshop fee is N125,000.00 (One Hundred and Twenty-Five Thousand Naira) only per participant to cover workshop literature and materials, executive bag, tea/coffee, lunch, photograph and certificate.)
(Convert Currency)

Chris Onwuasigwe, FCA – 08033045484 08033045484

3-5 Participants – 5% Discount allowed 5 and above number of Participants – 10% Discount allowed
A distinguished team of facilitators who are eminently qualified professionals has been assembled to lead discussions in course of the workshop.
NST PPC Advert
Related Courses
Best Practice in Procurement Processes and Management Course Best Practice in Procurement Processes and Management Course

4 days, 22 - 25 Oct, 2019 

2019-10-22 12:10:00
Lagos State, Nigeria

Alpha Partners

Procurement is the acquisition of goods, services and works by a public authority or body. Transactions of this nature are undertaken and therefore government has a procurement Act and Regulations. ...

Generator Testing, Inspection and Maintenance Course Generator Testing, Inspection and Maintenance Course

4 days, 23 - 26 Jul, 2019 

2019-07-23 12:07:00
Lagos State, Nigeria

Alpha Partners

This workshop is designed to give comprehensive knowledge on generator testing, inspecting and maintenance in order to give best output. · The effective maintenance of power generators is very ...

Reliability and Operational Performance of Electric Power Systems Course Reliability and Operational Performance of Electric Power Systems Course

4 days, 18 - 21 Jun, 2019 

2019-06-18 12:06:00
Lagos State, Nigeria

Alpha Partners

By the end of this training course, participants will be able to: Determine the most important areas of power systems that need probabilistic modeling and evaluation assessment Understand the main ...

Managing Human Resources in the Digital World Course Managing Human Resources in the Digital World Course

4 days, 17 - 20 Sep, 2019 

2019-09-17 12:09:00
Lagos State, Nigeria

Alpha Partners

With technologies evolving every day, the management of HR has become more challenging. This workshop is designed to help professionals in HR optimize their use of today’s technologies in order ...