A database must be designed according to your company’s needs, but not every design is created equal. We can show you the proper way of designing a normalised database intended for the day-to-day running of a business. This can also involve changing your existing database to one which is more suited to your needs. The entire process is explored from the initial sketch to the database plan (Entity Relationship Diagram – ERD), and finally to the actual implementation in SQL.
Having designed the database, we can also show you how to populate it using your own data and retrieve data based on your business needs.
While we will typically work with you to tailor the training to your needs, some key topics may include:
- Introduction to databases – Understanding the basic terminology. Installing a DBMS and setting up a database.
- Database planning – Understanding the need for normalisation in a relational database. Planning a normalised relational database using ERD (entity-relationship diagrams).
- Database creation and manipulation – Using SQL to create a database based on an existing design. Using SQL to modify an existing database structure.
- Database constraints – Understanding the need for different constraints such as primary keys, foreign keys, and others. Implementing constraints.
- Data manipulation – Inserting, updating and deleting data.
- Database Querying – Retrieving data from a database. Retrieval from a single table, retrieval from multiple tables, filtering, grouping, and use of existing functions.