Sql Server
Welcome to Divine Tech Skills! Our SQL Server – 30 Hours course is designed for anyone who wants to learn how to manage and work with databases using Microsoft SQL Server.
In this course, you will learn:
- What SQL Server is and how it works
- How to write SQL queries to insert, update, delete, and read data
- How to create and manage tables, views, stored procedures, and functions
- How to use joins, filters, and sorting to get the data you need
- Basics of database security, backup, and recovery
- Real-life examples and hands-on practice
Whether you are a beginner or looking to improve your database skills, this course will help you become confident in using SQL Server.
Introduction to SQL Server
Session 1: (1 hours)
Introduction to SQL Server
1. Overview of SQL Server
- What is SQL Server?
- SQL Server editions and their differences
- SQL Server architecture
2. Installing SQL Server
- Installation process
- SQL Server Management Studio (SSMS)
- SQL Server Configuration Manager
SQL Server Basics
Session 2: (2 hours)
SQL Server Basics
1. Understanding Databases and Tables
- What is a database?
- Creating and managing databases
- Creating tables and defining data types
- Altering and dropping tables
2. Data Types in SQL Server
- Numeric types (INT, DECIMAL, etc.)
- Character and String types (VARCHAR, CHAR, etc.)
- Date and Time types (DATE, DATETIME, etc.)
- Binary types (VARBINARY, BINARY)
Basic SQL Queries
Session 3: (2 hours)
Basic SQL Queries
1. SELECT Statement
- Retrieving data from tables
- Using WHERE clause to filter data
- Sorting data using ORDER BY
- Selecting specific columns
- DISTINCT keyword to remove duplicates
2. Aggregate Functions
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
- HAVING clause to filter aggregated results
Data Manipulation (DML)
Session 4: (3 hours)
Data Manipulation (DML)
1. INSERT Statement
- Inserting data into a table
- Inserting multiple rows
2. UPDATE Statement
- Updating existing data
- Using WHERE to update specific rows
3. DELETE Statement
- Deleting records from a table
- Using WHERE to delete specific rows
- Truncating a table
Joins and Relationships
Session 5: (3 hours)
Joins and Relationships
1. Types of Joins
- INNER JOIN
- LEFT JOIN (LEFT OUTER JOIN)
- RIGHT JOIN (RIGHT OUTER JOIN)
- FULL OUTER JOIN
- CROSS JOIN
2. Understanding Relationships
- Primary Keys
- Foreign Keys
- Referential Integrity
SQL Server Functions
Session 6: (2 hours)
SQL Server Functions
1. Scalar Functions
- Built-in functions (e.g., LEN(), GETDATE(), UPPER())
2. Aggregate Functions
- SUM, COUNT, AVG, MAX, MIN
3. String Functions
- CONCAT, SUBSTRING, REPLACE, TRIM
4. Date Functions
- GETDATE(), DATEADD(), DATEDIFF(), YEAR(), MONTH(), DAY()
Subqueries and Nested Queries
Session 7: (2 hours)
Subqueries and Nested Queries
1. Writing Subqueries
- In SELECT, WHERE, and FROM clauses
- Correlated Subqueries
2. Using EXISTS and IN
- EXISTS vs IN in subqueries
SQL Server Constraints
Session 8: (2 hours)
SQL Server Constraints
1. What are Constraints?
- PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT
- Using Constraints while creating and altering tables
- Managing Constraints
Indexing and Optimization
Session 9: (2 hours)
Indexing and Optimization
1. Introduction to Indexes
- Clustered vs Non-clustered indexes
- Creating, altering, and dropping indexes
2. Query Optimization
- Analyzing query execution plans
- Using indexes to improve query performance
- Index fragmentation and rebuilding indexes
SQL Server Views
Session 10: (2 hours)
SQL Server Views
1. Creating Views
- Syntax of creating a view
- Benefits of using views
2. Modifying Views
- Altering and dropping views
3. Using Views in Queries
SQL Server Stored Procedures
Session 11: (3 hours)
SQL Server Stored Procedures
1. What are Stored Procedures?
- Creating stored procedures
- Executing stored procedures
2. Parameters in Stored Procedures
- Input, output, and default parameters
3. Modifying and Dropping Stored Procedures
4. Error handling in Stored Procedures
SQL Server Triggers
Session 12: (2 hours)
SQL Server Triggers
1. What are Triggers?
- AFTER, INSTEAD OF triggers
2. Creating triggers for Insert, Update, and Delete operations
3. Managing triggers (modifying, dropping)
4. Trigger limitations and best practices
Transactions and Locking
Session 13: (2 hours)
Transactions and Locking
1. Introduction to Transactions
- COMMIT and ROLLBACK
- Managing transactions with BEGIN TRANSACTION
2. Isolation Levels
- Read Uncommitted, Read Committed, Repeatable Read, Serializable
3. Deadlocks and Locking
- Types of locks in SQL Server
- Managing deadlocks
Advanced SQL Server Topics
Session 14: (2 hours)
Advanced SQL Server Topics
1. Common Table Expressions (CTEs)
2. Window Functions
- ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE()
3. Pivoting and Unpivoting Data
4. Recursive Queries
5. Working with XML Data in SQL Server
Duration: 30 hours
- 30 Hours of Expert-Led Training: Our training is led by experienced professionals who guide you step by step with real-world knowledge.
- Covers Everything from Basics to Advanced: You’ll start with the fundamentals and move on to advanced topics like complex queries, stored procedures, and triggers.
- Real-Time Projects and Case Studies: Work on practical examples and real-time projects to gain skills you can use on the job.
- Easy-to-Follow Video Lessons and Practice Exercises: Learn through simple video lessons, do hands-on exercises, and test your understanding with quizzes.
- Corporate Training Options Available: We also offer customized training programs for teams and companies.
- Learn the Way That Suits You: Choose between online or in-person classes based on what works best for you.
- Certificate After Completion: Get a certificate that adds value to your resume and shows your SQL Server skills.
- Help with Jobs and Interviews: We support you with resume writing, interview practice, and job search guidance after the course.
