- Course-End Certificate
Mastering in Database Design and Development (MS SQL SERVER)
Microsoft SQL Server is a powerful and widely used Relational Database Management System (RDBMS) that enables secure data storage, efficient data processing, and multi-user access. It offers essential database features, including tables, indexes, joins, views, stored procedures, and triggers. MEEK Technologies Limited offers SQL Server training for beginners and experienced professionals, with customized course content and flexible schedules based on participants’ skill levels. The course focuses on practical knowledge, database design, administration, query writing, and performance optimization to help learners strengthen their technical skills and build confidence in real-world workplaces.
Duration
24 Hours
Mode
Live Online (Zoom)
Certification
Course Certificate
Course Free
BDT 6,000
Why SQL Server is Crucial for Your Career
Microsoft SQL Server is one of the best database management system. It allows huge data storage, wide number of users with comprehensive functionalities i.e. index, join, view, stored procedure, trigger etc. It is a RDBMS which is widely being used across the globe. If you know SQL Server, you can work as Database Designer, Database Administrator etc.
SQL Server is easy yet secured and support multi-user environment. We conduct SQL Server training for beginners to advanced users. After analyzing the users level, we customize the content and offer flexible timing for the corporate trainees.
The course is designed for the working class who have basic knowledge in any RDBMS. It will cover most of the objects available in SQL Server within a short period of time but of course keeping the skill enhancement and development in mind. Our target is to really make people skilled and provide clear understanding on topics so that participants feel confident while working at workplace.
Database Design & Management
Learn to create, organize, and manage databases, tables, indexes, and relationships efficiently.
Advanced SQL Programming
Develop practical skills in queries, joins, views, stored procedures, and triggers.
Security & Performance Optimization
Learn database security, access control, backup, recovery, and query performance improvement.
Career & Professional Development
Build practical skills for database development, database administration, and data management roles.
Course Schedule
Orientation
25th October 2024 at 7PM
Class Starts
27th October 2024
Schedule
Friday & Saturday 3PM to 6PM
Comprehensive Course Coverage
- Day 1
- Introduction
- Download & Install SQL Server
- Connect to SQL Server
- Understanding the RDBMS
- Understanding Database Structure
- Basic idea about NoSQL
- Day 2
- Normalization
- SQL Command
- DDL Command: Create, Alter, Drop Database
- DDL Command: Create, Alter, Drop table
- DML Command: Insert, Update and Delete data in Database
- Primary key & foreign key relationship
- Default Constraint
- Cascading referential integrity constraint
- Select record from table
- Check Constraint
- Unique Key Constraint
- Summary of Constraint
- Identity column
- Project 1- Database Normalization and SQL Command
- Day 3
- Difference between Delete & Truncate command
- Last generated column value
- Select Statement
- Filtering with where clause
- Joining multiple conditions
- Order By
- Distinct
- TOP/Like/ BETWEEN
- Group by Clause
- Having Clause
- Operators in SQL
- SQL Arithmetic Operators
- SQL Comparison Operators
- SQL Logical Operators
- Project 2- Select Statement with Multiple Conditions
- Day 4
- SQL Server Join types
- Inner join
- Left Join
- Right Join
- Full Join
- Cross Join
- Merge Join
- Self-Join
- Pivot/Unpivot
- Day 5
- ISNULL/COALESCE
- Difference between COALESCE and ISNULL
- Case Statement
- Union and Union all
- Intersect/Except
- Difference between Join and Union
- Estimated Execution Plan
- String Functions
- Aggregate function
- Scalar function
- Date Functions
- Wildcards
- CAST/CONVERT
- ALIASES
- NULLIF
- IF ELSE
- WHILE LOOP
- Project 3- Joining, Functions & Others
- Day 6
- SELECT INTO
- INSERT INTO SELECT
- Temporary Table / #Table
- Clone Table
- Sub Query
- Views
- Trigger
- Day 7
- Stored Procedures
- Stored Procedures with basic parameters
- Stored Procedures with output parameters
- Stored Procedures with return values
- Advantage of Stored Procedures
- SQL – Transactions
- Data Import from Excel
- Project 4- Procedures, Views & Transaction
- Day 8
- Indexing
- Describing Index Structures
- Clustered Indexes
- Non-Clustered (NC) Indexes
- SQL Injection
- How to Prevent SQL Injection
- SQL Cursor
- SQL Cursor Implementation
- Database Backup/Restore
- Database Maintenance
- Job Scheduling
Meet Your Trainer
Md. Aksadur Rahman
Microsoft Certified Professional
Python - Book Author
- 19+ years experience in IT Industry
- Lecturer at a Private University in Bangladesh.
- Experience of Project Management, Business Analyst and Coding.
- Combined expertise in industry and classroom.
Expertise Areas:
- Business Analysis, Project Management, User Engagement, Service Operation
- Strategic Business Models
- C# .Net, SQL Server, Python, PHP, MySQL, HTML5
- Systems Management and IT Innovation
- Business Intelligence (BI) Tools
Course Fee & Payment Options
Secure and convenient payment methods available
Course Fee
BDT 6,000
Per Participant
- 24 Hours Live Training
- Course Materials Included
- Certificate of Completion
Payment Methods
Bank Transfer
Direct bank account transfer
Account Name: MEEK Technologies Ltd.
Account Number: 7022-0212000985
Bank: Trust Bank Ltd
Branch: Millennium Corporate Branch, Dhaka
Empowering businesses through innovation since 2016.
© 2026 MEEK Technologies Limited. All rights reserved.