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.
We follow a blended learning methodology with case-based hands-on training. The course coverage is given below-
| Course Coverage |
|
Trainer's Profile |
- 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
- 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
|
|
 |
|
Having 18 years of experiences on Conducted IT consultancy and training in the core area of SQL, SQL Server, C, C++, Python, MS Excel, Power BI, Data Science & Machine learning using Python, Machine learning algorithm, UML with proven skill.
Also have the experiences on Business Analysis, Project Management, User Engagement, Service Operation, Systems Management and IT Innovation. Large ERP, with proven records for success of delivering service into robust IT infrastructure, ERP Systems Operations like Hospital Information Management System (HIMS).
I like to strive to position myself further with leadership and management challenges in a leading role through working in different cultural or business environment. More over a lots of experience in software coding, planning, designing, customization, implementation, technical support and training. Specialized in C# .Net, SQL Server, PHP, MySQL, HTML5 for web based application. Also experienced in networking installation, maintenance, security and administration. |
| Course Schedule |
|
Friday & Saturday
3PM - 6 PM
Starting On: 5th Aug 2022 (Weekend Batch)
Duration: 24 Hours( 1 Month )
|
| Course Fee & Payment Mode |
Fee:
BDT 5,700+VAT
Payment Options: 1. bKash: 01738442377
2. Bank:
MEEK Technologies Ltd.,
A/C: 7022-0212000985,
Trust Bank Ltd,
Millennium Corporate Branch,
Dhaka.
|
| Contact Us |
Phone: 01910607050, 01873361245, 01738442377
email: meektechnologies@gmail.com
|
| Register Now |
| |
|