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.
Related Courses
Competency-Based Salary Structure Design and Development Course Competency-Based Salary Structure Design and Development Course

4 days, 16 - 19 Jul, 2019 

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

Alpha Partners

Competency-Based Salary Structure Design and Development will discuss how; To learn about the elements of a competency-based salary administration program, salary surveys, and compensation policies ...

Fraud Detection, Prevention and Control Course Fraud Detection, Prevention and Control Course

4 days, 26 - 29 Mar, 2019 

2019-03-26 12:03:00
Lagos State, Nigeria

Alpha Partners

Fraud has become the bane of most business organizations especially in this difficult and inclement operating environment. Fraudsters abound both internally and externally, making it imperative for ...

Professional Image Enhancement for Administration Managers Course Professional Image Enhancement for Administration Managers Course

4 days, 02 - 05 Jul, 2019 

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

Alpha Partners

By the end of this seminar, you will be able to: Apply the same skills for your admin responsibilities that all managers use Have the confidence to succeed when your manager delegates work to you ...

 Hotel Assets Management (HAM) Course Hotel Assets Management (HAM) Course

4 days, 03 - 06 Dec, 2019 

2019-12-03 12:12:00
Lagos State, Nigeria

Alpha Partners

This course will discuss about operational savings and cost avoidance through optimization of assets. It will help you manage your assets so that you have the right assets, in the right place, at the ...