How to Design a Database
Learn how to design a database from scratch using Microsoft Access. This course covers everything from ERD diagrams to data modeling and SQL queries. Perfect for beginners in data science, computer science, and database students. Gain the skills to build user-friendly interfaces and custom queries for efficient data management.
What you’ll learn
- Design a database from scratch
- Microsoft Access
- Queries and SQL
- ERD Diagrams
- Data Modeling
- Forms
- Tables
Ever wondered how a database is designed from an idea to an actual full blown application? This course will step you through that process.
You will learn how to transfer an idea you jot down on a napkin to a fully operational, and professional system that will satisfy your design requirements.
The course will give you the skills through hands-on demonstrations, and real world implementations of modeling an idea then converting it into entities that will make up the basis of your database.
You will then be shown how to setup the database like a professional software guru so that it will actually work. In the process, you will learn about tables, how they are related, how to setup queries and test them and how to build front end apps to interface with the database.
Some of the skills you will acquire will include but will be limited to:
Building database tables
Configuring primary and foreign keys
Implement relationships such as One-to-One, One-to-Many and Many-to-Many
Choose the appropriate data type for database fields
Build constraints and rules for data to be stored in a field, including formatting
Migrate data between databases
Build visual, user friendly interfaces to access and update records
Build custom queries to obtain meaningful results that solve business cases
Create navigation and flow with forms and buttons to enhance the database via a front application
This course, will be based on an exercise to build a transactional database with an inventory control component.
Get your new skills and practice!
Who this course is for:
- Beginner Data Science
- Beginner Computer Sciences
- Business Analysts
- Database students
- Computer Programmers
- Software Engineers
- Software Developpers
User Reviews
Be the first to review “How to Design a Database”
You must be logged in to post a review.
There are no reviews yet.