NOTICE: Many events listed here have been canceled or postponed due to the Covid-19 emergency. It is best to call ahead or check with organizer's websites to verify the status of any local event.

Change Location × London, UK

    Recent Locations

      Database Design and Data Normalisation 1-Day Course, London in Covent Garden


      • Database Design and Data Normalisation 1-Day Course, London Photo #1
      1 of 1
      May 21, 2019

      Tuesday  11:00 AM (on various days)

      5 Southampton Street
      Covent Garden, Greater London WC2E 7HA

      Performers:
      • No Performers Listed
      EVENT DETAILS
      Database Design and Data Normalisation 1-Day Course, London

      Relational Databases & Data Normalisation Overview Training Course, 1-Day Course Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours Course Content Session 1: Introduction to Relational Databases The Database ApproachDatabase Management SystemsThe function of a Database Management SystemThe Processing ArchitectureThe Schema ArchitectureThe Storage ArchitectureAn overview of Database System DevelopmentAn overview of general database principles Session 2: Conceptual Data Models Overview of Entity ModelsEntities and how to identify themAttributes and how to identify themRelationships and their qualitiesBuilding an Entity Relationship DiagramResolving many-to-many relationshipsSub-type and Super-type RelationshipsArc RelationshipsRecursive RelationshipsConstraints and AssumptionsNormalization to the First Normal Form (1NF)Normalization to the Second Normal Form (2NF)Normalization to the Third Normal Form (3NF)Exercises: Analyzing a specificationCreating an Entity Relationship Diagram from it Session 2: Conceptual Data Models(continued) Normalization to the First Normal Form (1NF)Normalization to the Second Normal Form (2NF)Normalization to the Third Normal Form (3NF)Exercises: Data Normalization producing table specifications and Entity Diagrams Session 3: The Relational Model Relational StructureRelational TerminologyDomainsA Relational schemaCandidate keys and Primary KeysForeign KeysKey ConstraintsAttribute ConstraintsImplementing Sub-type/Super-type RelationshipsViewsDenormalization using Pre-joined TablesDenormalization using Derived DataAn Introduction to Structured Query Language (SQL)Simple QueriesSimple Updates of the Data

      Categories: Business & Networking

      This event repeats on various days:

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.

      Hotels and Airbnbs near Database Design and Data Normalisation 1-Day Course, London. Book your stay now!