Introduction to database and Intermediate database training

Course details

The “Web Based Database Training” course proposed will provide an introduction to data entry

and management of databases through web interfaces such that multi-user environments are

enabled. An intermediate training course will be provided to users who have already completed

the basic course.

• Intro to on line database principles
• The concept of back end and front end
• Logging in and security settings
• Structure, Model & Fields
• Relationship tables
• Data storage
• Searching and entering contacts
• Manually inputting data
• Creating records
• Merging data
• Processing Postal Enrolments
• Creating courses
• Allocating courses
• Accepting Online bookings
• Payments and Worldnet
• Integration with Accounts packages
• Sorting data
• Basic queries
• Generating reports
• Creating and Allocating Accommodation
• Creating and allocating classes and groups
• Detecting whether allocated students to groups/classes match in age range/ school
• Creating advanced queries- SQL Query builder
• Exporting data to Excel
• Backing up the data.
• Generating reports
• Creating courses
• Logging tasks
• Administrator rights