SQL Database Example 2 (Doctor's Appointment with Patients)
Hi guys, Today we will create a simple Database of Doctor Appointment.
What we will learn?
1. Create database
2. Create Tables
3. Relationships
4. Database diagram
5. Constraints (Primary key, foreign key, Null, Check)
6. Queries (Create, Select, Insert, Update, Delete)
7. Stored Procedures
8. Functions Triggers
Database:
SQL SERVER Management Studio 2017
SQL SERVER 2017