Loading...
SQL Course
Learn SQL start from Beginner
Course Features
- Duaration : 11 Weeks
- Leactures : Online / Offline
- Assignments : 3
SQL Course
Syllabus
Week - 1
- Overview of SQL Server and its components
- Installing SQL Server and Management Studio
- SQL Server database architecture
Week - 2
- Creating and managing databases
- Basic SQL queries (SELECT, INSERT, UPDATE, DELETE)
- Working with data types and constraints
Week - 3
- JOINs, UNION, and INTERSECT
- Grouping data and aggregate functions
- Using subqueries and common table expressions (CTEs)
Week - 4
- Principles of database design
- Normalization and denormalization techniques
- Designing efficient database schemas
Week - 5
- Writing and using stored procedures
- Creating and using user-defined functions
- Managing triggers
Week - 6
- Understanding transactions and ACID properties
- Implementing locking and isolation levels
- Handling deadlocks and blocking
Week - 7
- Creating and managing indexes
- Analyzing query performance with execution plans
- Techniques for optimizing query performance
Week - 8
- Implementing authentication and authorization
- Managing roles and permissions
- Securing data with encryption
Week - 9
- Performing database backups
- Restoring databases from backups
- Disaster recovery planning
Week - 10
- Connecting SQL Server with other applications (e.g., Power BI, SSIS)
- Creating and deploying reports with SQL Server Reporting Services (SSRS)
- Building a simple ETL process
Week - 11
- Applying learned concepts to a real-world project
- Building and deploying a database-driven application