SQL Server Databases
Overview
This course teaches you how to work with Microsoft SQL Server, one of the most widely used database platforms in the profession. You will learn how to write SQL statements to retrieve, insert, update, and delete data, how to design well-structured databases with proper relationships and indexes, and how to use stored procedures, functions, and triggers to encapsulate business logic. The course also introduces performance tuning, security, and high availability so you understand how databases are kept fast, safe, and reliable in real environments.
The course requires basic computer skills and runs 15 to 20 hours, ending with a hands-on project where you design and build your own database solution.
What You Will Learn
- Write SQL statements to select, insert, update, and delete data in SQL Server
- Design database tables, define relationships, and create indexes for better performance
- Retrieve data from multiple tables using joins, filtering, sorting, and grouping
- Manage transactions to keep data consistent and accurate
- Build stored procedures, functions, and triggers to automate database logic
- Apply query optimization techniques and read execution plans
- Understand SQL Server security, access control, and high availability options
Course Curriculum
| Module | What you cover |
|---|---|
| Introduction to SQL Server | Overview of SQL Server, its editions, and setting up the environment |
| SQL Basics | Core SQL syntax including SELECT, INSERT, UPDATE, and DELETE statements and basic data types |
| Database Design and Modeling | Designing tables, defining relationships, and creating indexes for performance |
| Data Retrieval and Modification | Joins, filtering with WHERE, sorting and grouping, and managing transactions |
| Stored Procedures, Functions, and Triggers | Encapsulating business logic and automatically responding to database events |
| Performance, Security, and Reliability | Query optimization, access control and encryption, and high availability and disaster recovery options |
| Real-World Database Project | Applying everything learned to design and implement a database solution for a business scenario |
Requirements
- Basic computer skills
You May Like
Upcoming Intake
Contact us to hear when new training sessions and official majors open for registration.
About us
CIS College delivers practical, career-focused technical and vocational education in Lebanon. We turn hands-on training into real employment outcomes.
Useful Links
Contact us
Follow us
© 2026 CISCollege. All Rights Reserved.