I created a full database with Sql-server for e-learning organisation.
The skill in this project are;
- Design the tables for a data scalability and integrity
- Creation of the database & tables from scratch
- Establish the relation between the table
- Inserting the data into the tables
- Function that insert, update and delete record
- Veification that the record exist
- Sql injection security (firstname & lastname between 3 and 20 characters)
- Custom error message where error occurred
- Monthly report with many table join