Level 2 – Intermediate (Database management course)
Online Group Training
Overview
Welcome to the Querying and Database Design using Microsoft SQL Server Course, it provides the students with technical skills required to write basic Transact-SQL and database programming for Microsoft SQL Server and it also covers database design concepts that is applicable in other database platforms through designing table structure with normalization techniques.
Who is this course for?
- Junior Developer, Backend Developer, Student, Data Analyst, Database Administrator
- Career shifters, Teachers and Freelancers are also welcome to join
Prerequisites:
- Basic SQL Server Querying and type
- Advanced knowledge in database concepts
- Experience in SQL Server Management Studio
- Level 1 SQL Server training.
Tools:
- SQL Server Database Engine, SQL Server Management Studio
Course Outline
Session 1: Database Design Concepts
- Database Design Process
- SQL Server Constraints
- DBMS Keys
- Normalizations
- Use cases
Session 2: SQL Server Views, Stored Procedures and Built in Functions
- Views Overview
- Stored Procedures Overview
- SQL Server Functions
- Date
- String
- System and Windows
- Use cases
Session 3: Database Programming, User Defined Functions, TCL, Triggers
- Loops in SQL Server
- User Defined Functions Overview
- Scalar
- Table Valued
- Declaring Variables
- Transactional Control Language
- COMMIT
- ROLLBACK
- SQL Triggers
- Use cases
Session 4: Sub-queries, Table Variable versus Temporary Table and CTE
- CTE (Common Table Expression)
- Using sub-queries
- Table Variable versus Temporary Table
- Use cases
Learn now
✅ Digital Badge
✅ Video Recording of All Live Sessions
✅ Learning materials from our trainer
Simeon “Jok” has 20 years of experience in the IT industry as an Azure DevOps Engineer, Web and Mobile Developer. He is a seasoned Senior full-stack developer in the information technology and services sector, proficient in Microsoft .NET Technology and Hybrid Mobile Development.
