08039356492 xplorerscomputer.training@gmail.com

Administering MySQL Database

Discover how to use MySQL, a popular choice of database for use in powerful web applications! During this 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics. learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.

Prerequisite:

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

The courses that are covered in this program include:

  • Introduction to Database & MySQL
  • Database Design
  • Database Administration
  • Indexing for Performance
  • SQL for Developers
  • Query Analysis and Optimization
  • Data Replication
  • Conclusion
  • Computer Science Students
  • Web Developers
  • Software Developers
  • Data Analyst/Modelers
Training Sessions
Session Days Periods
Daytime Mon-Fri (2hrs) 9am-11am, 11am-1pm, 1pm-3pm, 3pm-5pm
Evening Mon-Fri (2hrs) 6pm-8pm
Weekends Sat (3hrs) 10am-1pm, 1pm-4pm
Duration: 2 Months

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 cash or through the bank using the following details

Account Number: 0111553951

Account Name: Xplorers Computer Training School

Bank: GTBank

Full Payment (Attracts 5% discount of Course Fee)

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

Course Fee: ₦60,000

Microsoft Access Database Course

Every one of us, whether we know it or not, are surrounded by data. Some of it we keep track of on paper or in spreadsheets. Some of it is really important, like tasks that are part of our daily work. BUT, unfortunately, very few of us use the one tool that was built to handle all of our data needs - the Microsoft Access database.

Should you take the time to learn Microsoft Access?
Many people do not use the Microsoft Access database program for 2 reasons:

  • They think it is too complex
  • They do not realize how incredibly powerful it is.
Build a Strong Foundation in Microsoft Access!
  • Understand the structure of the database file and its advantages.
  • Become comfortable with how the menus and ribbons work.
  • Learn how you can save all your data in one place.
  • Learn how to extract only the information you want.
  • See how to relate tables together and resolve the "1 to Many" problem.
  • Discover how having separate report formats reduces report prep time.
  • Learn how to easily create subtotals and do calculations.
  • View demonstrations of how Macros can be used to automate tasks.
  • See examples of how the VBA Programming Language can be used.
  • Learn how Access can work with Other Microsoft Office programs.

Prerequisite:

Students just need to have a general knowledge of working with Windows

The courses that are covered in this program include:

  • Introduction to Database abd Microsoft Access
  • ThREE Major Problems Microsoft Access Solves
  • Learning the Parts of Microsoft Access Window
  • TABLE Objects - The Basics
  • REPORT Objects - The Basics
  • QUERY Objects - The Basics
  • PROPERTIES: Making Thousand of Choices Manageable
  • FORM Objects - The Basics
  • Advanced TABLES
  • Advanced QUERIES
  • Advanced REPORTS
  • Advanced FORMS
  • Automating Things in your Forms
  • More FORM Autoomation: BUTTONS and MACROS
  • Creating a Multipage Invoice
  • Microsoft Access and Networking
  • Conclusion
  • Computer Science Students
  • Database Administrators/Analyst/Modelers
  • Software Developers
  • Individuals who are interested in about Database
Training Sessions
Session Days Periods
Daytime Mon-Fri (2hrs) 9am-11am, 11am-1pm, 1pm-3pm, 3pm-5pm
Evening Mon-Fri (2hrs) 6pm-8pm
Weekends Sat (3hrs) 10am-1pm, 1pm-4pm
Duration: 1 Month

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 90% practical.

Interested individuals can pay using the following methods:

Pay cash or through the bank using the following details

Account Number: 0111553951

Account Name: Xplorers Computer Training School

Bank: GTBank

Full Payment (Attracts 5% discount of Course Fee)

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

Course Fee: ₦25,000

© Xplorers Computer Training School 2019
Designed by Emmatech Digital World