Course overview
Relational Databases & Data Normalisation Overview Training Course.
Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables.
Study method
- Online
- Blended
- In-class

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 1 Day
Course features
- SQL course certificate on completion (assessment based)
- SQL course notes
- Practical SQL course exercises, SQL course homework/SQL course revision work
- To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer
Subjects
- The database approach
- Database management systems
- The function of a database
- Management system
- The processing architecture
- The schema architecture
- The storage architecture
- An overview of a database system
- Development
- An overview of general database principles
- Overview of Entity Models
- Entities and how to identify them
- Attributes and how to identify them
- Relationships and their qualities
- Building an Entity Relationship Diagram
- Resolving many-to-many relationships
- Sub-type and Super-type Relationships
- Arc Relationships
- Recursive Relationships
- Constraints and Assumptions
- Normalisation to the First Normal Form (1NF)
- Normalisation to the Second Normal Form (2NF)
- Normalisation to the Third Normal Form (3NF)
- Exercises: analysing a specification
- Creating an Entity Relationship Diagram from it
- Normalisation to the First Normal Form (1NF)
- Normalisation to the Second Normal Form (2NF)
- Normalisation to the Third Normal Form (3NF)
- Exercises: Data Normalisation producing table specifications and Entity Diagrams
- Relational structure
- Relational terminology
domains - A relational schema
- Candidate keys and Primary Keys
- Foreign Keys
- Key Constraints
- Attribute Constraints
- Implementing Sub-type/Super-type Relationships
- Views
- Denormalisation using pre-joined tables
- Denormalisation using derived data
- An Introduction to Structured Query Language (SQL)
- Simple queries
- Simple updates of the data
About PCWorkshops
PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.
We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.
Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.