A Practical Guide to Database Design and Access SQL
.MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .VTT | Duration: 2 hours | Size: 1.08 GB

The importance of Data and how it can be Effectively Used and Managed Efficiently
What you'll 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.
Requirements
An interest in computer information systems. Copy of MS Access 2016 software is optional.
Description
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 is the target audience?
IT staff and business employees who would like an understanding of how to organize, access and report data effectively and efficiently.