Library

Course: A Practical Guide to Database Design and Access SQL

A Practical Guide to Database Design and Access SQL

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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
Basic knowledge
  • An interest in computer information systems. Copy of MS Access 2016 software is optional


What you will learn
  • Build relational database solutions for home and business, including lots of practical examples, "best practice" guidelines, Access SQL design and implementation, templates that work
Curriculum
Number of Lectures: 36
Total Duration: 02:07:39
Objectives
  • Objectives  
Introduction
  • Introduction  
  • In the Beginning  
Fundamentals
  • Fundamentals Objectives  
  • Overview  
  • Anomalies  
  • Vet Office Exercise  
  • Timesheet Exercise  
  • MS Access Workbench Exercise  
  • Additional Resources  
Relational Model
  • Relational Model Objectives  
  • Keys & Normalization  
  • Referential Integrity  
  • Solution Set  
  • Putting it Together  
MS Access
  • MS Access Objectives  
  • Access Workbench  
  • Student-Dorms & CRM Question  
  • Doctor & Lawn Service Question  
  • MS Access Exercise  
  • MS Access Additional Resources  
Adding Data
  • Adding Data Objectives  
  • Populating the Database  
  • Solution Set 1  
  • Solution Set 2  
  • Exercise MS Access  
  • Adding Data Additional Resources  
  • Section Summary  
Access SQL
  • Access SQL Objectives  
  • SQL Basics  
  • SQL DDL & DML  
  • Access SQL Solution Set  
  • Query Wizard, Query Design  
  • Pet-Owner Question  
  • Summary  
  • Conclusion  
Reviews (0)