A Practical Guide to Database Design and Access SQL

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

In this course you will design and develop normalized tables, analyse table designs to avoid redundancy and anomalies, write SQL statements to extract and manipulate requests and resolve many inherent problems associated with poor database design. As you develop these skills, you will be exposed to LucidArt for diagramming ERD's; querySQL and QBE programming, to execute query statements;  MS Access Workbench, for implementing business solutions.Who this course is for:IT staff and business employees who would like an understanding of how to organize, access and report data effectively and efficiently

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Build relational database solutions for home and business, including lots of practical examples, "best practice" guidelines, Access SQL design and implementation, templates that work

IT staff and business employees who would like an understanding of how to organize, access and report data effectively and efficiently

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Ms Office
  • Doctor
  • Design
  • Database training
  • SQL
  • Database
  • Office IT
  • CRM
  • Database Design
  • Access

Course programme

Objectives 1 lecture 00:33 Objectives Objectives 1 lecture 00:33 Objectives Objectives Objectives Objectives Objectives Introduction 2 lectures 07:05 Introduction In the Beginning Introduction 2 lectures 07:05 Introduction In the Beginning Introduction Introduction Introduction Introduction In the Beginning In the Beginning In the Beginning In the Beginning Fundamentals 7 lectures 17:50 Fundamentals Objectives Overview Anomalies Vet Office Exercise Timesheet Exercise MS Access Workbench Exercise Additional Resources Fundamentals 7 lectures 17:50 Fundamentals Objectives Overview Anomalies Vet Office Exercise Timesheet Exercise MS Access Workbench Exercise Additional Resources Fundamentals Objectives Fundamentals Objectives Fundamentals Objectives Fundamentals Objectives Overview Overview Overview Overview Anomalies Anomalies Anomalies Anomalies Vet Office Exercise Vet Office Exercise Vet Office Exercise Vet Office Exercise Timesheet Exercise Timesheet Exercise Timesheet Exercise Timesheet Exercise MS Access Workbench Exercise MS Access Workbench Exercise MS Access Workbench Exercise MS Access Workbench Exercise Additional Resources Additional Resources Additional Resources Additional Resources Relational Model 5 lectures 13:27 Relational Model Objectives Keys & Normalization Referential Integrity Solution Set Putting it Together Relational Model 5 lectures 13:27 Relational Model Objectives Keys & Normalization Referential Integrity Solution Set Putting it Together Relational Model Objectives Relational Model Objectives Relational Model Objectives Relational Model Objectives Keys & Normalization Keys & Normalization Keys & Normalization Keys & Normalization Referential Integrity Referential Integrity Referential Integrity Referential Integrity Solution Set Solution Set Solution Set Solution Set Putting it Together Putting it Together Putting it Together Putting it Together MS Access 6 lectures 29:41 MS Access Objectives Access Workbench Student-Dorms & CRM Question Doctor & Lawn Service Question MS Access Exercise MS Access Additional Resources MS Access 6 lectures 29:41 MS Access Objectives Access Workbench Student-Dorms & CRM Question Doctor & Lawn Service Question MS Access Exercise MS Access Additional Resources MS Access Objectives MS Access Objectives MS Access Objectives MS Access Objectives Access Workbench Access Workbench Access Workbench Access Workbench Student-Dorms & CRM Question Student-Dorms & CRM Question Student-Dorms & CRM Question Student-Dorms & CRM Question Doctor & Lawn Service Question Doctor & Lawn Service Question Doctor & Lawn Service Question Doctor & Lawn Service Question MS Access Exercise MS Access Exercise MS Access Exercise MS Access Exercise MS Access Additional Resources MS Access Additional Resources MS Access Additional Resources MS Access Additional Resources Adding Data 7 lectures 23:10 Adding Data Objectives Populating the Database Solution Set 1 Solution Set 2 Exercise MS Access Adding Data Additional Resources Section Summary Adding Data

Additional information

An interest in computer information systems. Copy of MS Access 2016 software is optional

See related categories

A Practical Guide to Database Design and Access SQL

£ 10 VAT inc.

The best Other Education courses

See all

See all