Data Modelling, Database Design, Data Normalisation Course

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.Terms and Conditions:B﻿y booking a course with us, you agree to the terms and conditions specified on our website:https://pcworkshopslondon.co.uk/termsandconditions.html

PCWorkshops

This excellent database course summarizes data terminology and concepts and cover practical exercise in design the structure of database.

<h1>DATABASE DESIGN AND DATA NORMALIZATION COURSE</h1><h3>Database Design and Data Normalization Course Summary</h3><h3>Relational Databases &amp; Data Normalisation .</h3><p>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.</p><p>Database Design and Data Normalization Course Description</p><h4>Session 1:</h4><ul><li>Introduction to Relational Databases</li><li>The Database Approach</li><li>Database Management Systems</li><li>The function of a Database Management System</li><li>The Processing Architecture</li><li>The Schema Architecture</li><li>The Storage Architecture</li><li>An overview of Database System Development</li><li>An overview of general database principles</li></ul><h4>Session 2:</h4><ul><li>Conceptual Data Models</li><li>Overview of Entity Models</li><li>Entities and how to identify them</li><li>Attributes and how to identify them</li><li>Relationships and their qualities</li></ul><ul><li>Building an Entity Relationship Diagram</li><li>Resolving many-to-many relationships</li><li>Sub-type and Super-type Relationships</li><li>Arc Relationships</li><li>Recursive Relationships</li><li>Constraints and Assumptions</li></ul><h4>Session 3: Demos</h4><ul><li>Normalization to the First Normal Form (1NF)</li><li>Normalization to the Second Normal Form (2NF)</li><li>Normalization to the Third Normal Form (3NF)</li></ul><h4>Session 4: Exercises</h4><ul><li>Exercises: Analyzing a specification and Creating an Entity Relationship Diagram</li></ul><h4>Session 5:</h4><ul><li>The Relational Model</li><li>Relational Structure</li><li>Relational Terminology</li><li>Domains</li><li>A Relational schema</li><li>Candidate keys and Primary Keys</li><li>Foreign Keys</li><li>Key Constraints</li><li>Attribute Constraints</li><li>Implementing Sub-type/Super-type Relationships</li><li>Views</li><li>Denormalization using Pre-joined Tables</li><li>Denormalization using Derived Data</li><li>An Introduction to Structured Query Language (SQL)</li><li>Simple Queries</li><li>Simple Updates of the Data</li></ul><p><br></p><h3>WHAT IS INCLUDED IN THE DATABASE DESIGN AND DATA NORMALIZATION COURSES:</h3><ul><li>Certificate on completion</li><li>Course notes</li><li>Course exercises, Worked examples, Sample Data Sets</li><li>After the course, 1 free session for questions </li><li>Max group size on this Database Course is 4.</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Data Modelling, Database Design, Data Normalisation Course

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Data Modelling, Database Design, Data Normalisation Course

More Science & Tech events

Browse more Science & Tech events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.