This repo is my personal SqlServer education for my students.
- Introduction & Install & Configure
- Introduction to Database Development
- Designing and Implementing Tables
- Ensuring Data Integrity through Constraints
- Introduction to Indexes
- Data Definition
- Data Manipulation with INSERT, UPDATE, DELETE
- Data Query: SELECT, JOIN, SubQuery, Aggregate Functions,...
- Designing and Implementing Views
- Designing and Implementing Stored Procedures
- Designing and Implementing User-Defined Functions
- Responding to Data Manipulation via Triggers
- Implementing Security
- Data Transfer with Import & Export
- Backup & Restore Strategy
- Automation with Jobs & Maintenance Plan
- Monitoring