In this 1.5-hour long guided project, you will learn how to design a database using Microsoft SQL Server. You will also learn how to use SQL, structured query language to retrieve, insert, update, and delete data in the database. We will do this by analyzing the business requirements and create the database. Then, we will write the SQL statements that are necessary and plug them into an already completed web application frontend. Relational databases and SQL are industry standards and this will allow you to transfer what you have learned in other relational database system as well. This course is aimed at learners who are new to relational database and SQL. JavaScript experience with variables and function calls are optional but helpful.
What you'll learn
Understanding of database design principles
Ability to write SQL queries for CRUD operations
Familiarity with Microsoft SQL Server
Experience analyzing business requirements
Course objectives
Design a relational database using Microsoft SQL Server
Implement SQL statements for data management
Synthesize database design with a web application frontend