SQL Server Course
Course: SQL Server
Level: Beginner to Advanced
Technology & Tools: SQL Server, T-SQL, SSMS, Azure SQL Database, Database Management, Stored Procedures, Functions, Triggers, Cursors, Views and Indexes
Level: Beginner to Advanced
Technology & Tools: SQL Server, T-SQL, SSMS, Azure SQL Database, Database Management, Stored Procedures, Functions, Triggers, Cursors, Views and Indexes
What will I learn in this course?
- Getting Started with SQL Server
- T-SQL Fundamentals with SQL Server
- SQL Server Views and Indexes
- SQL Server Stored Procedures and Functions
- SQL Server Triggers and Cursors
- Understanding and Managing Azure SQL Database
Session 1: SQL Server Fundamentals
- Introduction to Database
- Introduction to SQL Server
- Installing SQL Server and Components
- SQL Server Database and Tables
- SQL Keys
- SQL Commands
- SQL Constraints
- Types of Database
Practical: Install SQL Server and create your first database and tables.
Session 2: T-SQL Fundamentals
- Data Types
- Variables and Operators
- SQL Server Control Of Flow
- SQL Query and Sub Query
- SQL Clauses
- SQL Predicates
- SQL Joins
- SQL Exceptions
- Try..Catch
Practical: Write T-SQL queries using variables, operators, joins, subqueries and error handling.
Session 3: Views and Indexes
- SQL Server Views
- Types of Views
- SQL Server Indexes
- Types of Indexes
Practical: Create SQL Server views and indexes and understand their use in database performance.
Session 4: Stored Procedures and Functions
- Introduction to Stored Procedure
- Types of Stored Procedure
- Creating Stored Procedures for Insert, Update and Delete
- Stored Procedures Parameters
- SQL Server Functions
- Scalar Functions
- Table Valued Functions
Practical: Create stored procedures and functions for common database operations.
Session 5: Triggers and Cursors
- SQL Server Triggers
- Types of Triggers
- SQL Server Cursors
- Types of Cursors
- Cursor Alternatives
Practical: Create and test triggers and understand cursor-based database operations.
Session 6: Azure SQL Database
- Introduction to Azure SQL Database
- Database Deployment Models
- Azure SQL Database Server
- Creating and Managing Single Database
- Purchasing Models: DTU and vCore
- Azure SQL Database Tools
- Database Migration Using DMA
- Creating and Managing Elastic Pool
- Creating Managed Instance
Practical: Create and manage an Azure SQL Database and explore deployment, migration and management options.
Course Outcomes
After completing this course, students will be able to:
- Understand database and SQL Server fundamentals.
- Create and manage SQL Server databases and tables.
- Write T-SQL queries and subqueries.
- Work with SQL clauses, predicates and joins.
- Handle SQL Server exceptions using Try..Catch.
- Create and manage SQL Server views.
- Understand and implement SQL Server indexes.
- Create stored procedures for database operations.
- Create scalar and table-valued functions.
- Understand SQL Server triggers and cursors.
- Understand Azure SQL Database.
- Work with Azure SQL Database deployment models.
- Understand DTU and vCore purchasing models.
- Perform database migration using DMA.
- Create and manage Azure SQL Elastic Pools and Managed Instances.
Suggested Practical Projects
- Student Management Database
- Employee Management Database
- Sales and Billing Database
- Customer Management System
- Stored Procedure Based CRUD Application
- SQL Server Views and Index Optimization
- Trigger-Based Database Project
- Azure SQL Database Deployment
- Database Migration Using DMA
- Complete SQL Server Database Project
Tools & Technologies
- Microsoft SQL Server
- SQL Server Management Studio (SSMS)
- T-SQL
- Azure SQL Database
- Azure SQL Database Tools
- Database Migration Assistant (DMA)
- Azure Elastic Pool
- Azure Managed Instance
Professional Skills
- Database design fundamentals
- SQL query development
- Database administration fundamentals
- Stored procedure development
- Database performance fundamentals
- Error handling in SQL Server
- Azure SQL Database management
- Database migration fundamentals
- Real-world database project development
Recent Post
