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: Jun 25

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