In this course, you will build a transactional database from scratch. You will be guided in a step-by-step manner on how to build the database based on a prepared model (ERD). As a bonus, you will have access to how the ERD model was put together.

This database will keep track of products bought by clients and will keep track of the running inventory. The database will allow for transactions and access to the inventory level and its monetary value.

You will learn how to build tables, assign field and their properties, manage primary and foreign keys to establish relationships between records, all based on the ERD model.

Most importantly, you will learn how to run queries to obtain custom results that you would want the database to accomplish. As a bonus, during the design, you will also learn how to create interfaces (GUIs) that will facilitate data insertion or access.

Once the course is completed, there will be a course exercise where you will modify or redesign the database based on a shift in paradigm in terms of the nature of the products being tracked. It will be fun!

Skillshare.Building.a.Database.from.Scratch-SkilledHares

Title: Building a Database from Scratch
Publisher: Skillshare
Category: Technology
Size: 2707M
Files: 10F
Date: 2021-08-05
Course #: 1313839436
Published: Skillshare
Updated: N/A
Author: Andrew Mehri
Duration: 4h 8m
Exer/Code:

Installation:
Unpack that shit, run that shit

Description:
Insert generic comment here

NOTE: No subtitles were available at time of packing