Complete SQL Server Database Management and T-SQL Training Course

Master SQL Server with our tailored training program! From basic database concepts to advanced SQL features—learn to model data effectively with E-R diagrams, normalize tables for efficiency, write powerful SQL statements and manage data integrity through constraints. Boost your database skills with practical insights on stored procedures, triggers, indexing strategies, backup protocols and more.

Online Jan 26-28, 2026 9:00 AM - 5:00 PM Mohammad Mehdi Lotfinejad
updated
intermediate
SQL Server
We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
21 intakes
2 enrolled
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers
executives

Methodologies

lecture
slides
labs
case studies

Subsidies

HRDC Claimable logo

What you'll learn

  • Understand core database concepts including DBMS advantages.
  • Administer transactions using Transaction Control Language (TCL).
  • Perform database backups/restores & explore advanced SQL Server features.
  • Construct complex queries with aggregate functions and various joins.
  • Develop E-R models and convert them into normalized tables.
  • Execute SQL statements: DDL, DML, DQL, DCL & TCL.
  • Implement data integrity through entity, domain & referential constraints.
  • Operate SQL Server instances effectively using Management Studio.

Why should you attend?

Dive into the world of databases with our comprehensive SQL Server course, designed to equip you with a strong foundation in database management systems (DBMS). Understand the intricacies of data, fields, records, and how they culminate into an organized database. Explore the limitations of traditional file management systems and uncover the benefits DBMS offers for data handling and storage. Delve into database models and levels of abstraction, setting the stage for mastering relational DBMS. Learn to create robust E-R models and transform them into efficient tables through normalization processes. Gain hands-on experience with SQL Server, including its history, editions, and essential features. Discover how to manage databases using SQL statements such as DDL, DML, DQL, DCL, and TCL. Enhance your skills further by writing complex queries, implementing aggregate functions, and understanding joins and set operations. The course also covers crucial aspects like data integrity implementation through constraints and views management. Learn about Data Control Language for user roles and security management. Advance your knowledge with indexing techniques, T-SQL scripting, stored procedures, triggers, cursors, transaction controls, backup-restoration methods, and utilizing advanced features like pivot tables and XML data types.

Course Syllabus

Day 1 - Database Fundamentals and SQL
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Queries and Security
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - T-SQL and Administration
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor

Loading...
Mayur Patil Senior Software Architect & Cloud Solutions Expert
Trainer Profile
Trainer Profile
Mayur Patil is a highly accomplished Software Architect and Tech Head with over 16 years of comprehensive programming experience across diverse technology stacks and platforms. Currently serving as Technology Head at Aurelia Innovatives Pvt. Ltd., he brings a wealth of expertise in designing and implementing scalable, secure enterprise solutions for financial institutions, medical organizations, and large-scale enterprises. As a Microsoft Certified Professional holding MCP, MCAD, and MCSD.Net certifications, Mayur specializes in modern application architecture, microservices development, and cloud solutions. His technical proficiency spans full-stack development with NodeJS, ASP.Net Core 6, and Angular 14, alongside deep expertise in microservice architecture using RabbitMQ and KAFKA with CQRS and DDD patterns. He excels in containerization solutions using Docker and Kubernetes, with extensive experience in deployment strategies across IIS, Nginx, and Apache web servers. Mayur's mobile development credentials are equally impressive, with over 11 years of iOS development experience using Swift and XCode, complemented by enterprise Android development expertise. He has successfully deployed over 30 live applications across Apple App Store and Google Play Store. His innovative work extends to Unity3D development for Virtual Reality and Augmented Reality applications, demonstrating his ability to work at the cutting edge of immersive technologies. As an AWS Solution Architect Consultant, Mayur designs and executes multi-cluster, multi-region cloud architectures optimized for high scalability, low latency, and fault tolerance. His DevOps expertise encompasses Docker, Kubernetes, Jenkins automation, GitOps with GitHub Actions, Ansible, and Terraform for infrastructure provisioning across AWS, Azure, and GCP platforms. Beyond his technical capabilities, Mayur is a distinguished corporate trainer who has successfully trained hundreds of experienced developers in transitioning from legacy systems to modern frameworks, including VUE 2 to VUE 3 migrations and Angular enterprise application development. His teaching approach combines real-world architectural insights with hands-on implementation strategies, making complex concepts accessible to development teams across multinational corporations. His commitment to research and innovation is evident through his custom solutions, including dynamic form generation engines, real-time collaboration tools, and customized OCR engines, positioning him as both a technical leader and an educator who drives organizational transformation through technology excellence.
1 Student
17 Courses
20 Years

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years

Instructor

Loading...
Tasmeea Rahman Data Analytics & Engineering Training Specialist
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Tasmeea Rahman is a highly accomplished corporate trainer and academic professional with a unique blend of technical expertise and pedagogical excellence. Currently pursuing her PhD in Project Management with a focus on Energy Management in the electrical power industry at Universiti Putra Malaysia, she maintains an exceptional 4.00/4.00 CGPA while actively contributing to the professional training landscape. With extensive experience as a Freelance Corporate Trainer since 2023, Tasmeea specializes in delivering comprehensive training programs across multiple domains. Her training portfolio encompasses advanced data analytics tools including Python, Power BI, Minitab, Jaspersoft, Apache Superset, and TIBCO Spotfire, as well as machine learning applications. She also excels in teaching engineering design software such as AutoCAD, Autodesk Fusion 360, Solid Edge, and Autodesk 3Ds Max for both 2D and 3D electrical and mechanical designs. Her project management training capabilities further complement her diverse skill set. Her academic credentials are impressive, holding a Master of Engineering Management from Universiti Putra Malaysia (CGPA: 3.713/4.00), an MBA in Marketing from the University of Dhaka (CGPA: 3.61/4.00), and a Bachelor's degree in Electrical and Electronics Engineering. This multidisciplinary educational background enables her to bridge technical concepts with business applications effectively. As an Adjunct Lecturer at Leading University, she demonstrated her ability to develop curricula and deliver engaging lectures on complex electrical and electronics subjects, including VLSI design, digital signal processing, and microprocessor systems. Tasmeea's research contributions are noteworthy, with publications in high-impact journals including a first-author paper in Renewable and Sustainable Energy Reviews (Q1, Impact Factor: 15.9) and co-authored works in IEEE Access. She holds a Train the Trainer Certification from HRD Corp Malaysia and is certified in Agile Project Management by Google. Her technical proficiency spans programming languages like Python and C++, engineering software including MATLAB and CISCO Packet Tracer, and various data analytics platforms. With her combination of industry experience, academic rigor, and certified training expertise, Tasmeea delivers practical, industry-relevant training that empowers professionals to excel in their respective fields.
8 Students
87 Courses
8 Years

Instructor Reviews

MP

Mayur Patil

Senior Software Architect & Cloud Solutions Expert

"Excellent instructor and adore his pleasant demeanor towards audiences. In reality, the instruction had assisted me with a piece of work I had to complete on the day of the course. In my profession, I can already envision several use cases and time-saving situations."

"The instruction was excellent. I've attended several web/mobile development trainings, but this was by far the finest. Excellent explanation, structure, and the Mr. Mayur made monolithics and microservices simple to grasp. Thank you!"

"Mayur was very helpful in answering queries and explaining complex ideas in simpler words."

ML

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

TR

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

FAQ

Frequently Asked Questions About This Course

Why should you attend?

Dive into the world of databases with our comprehensive SQL Server course, designed to equip you with a strong foundation in database management systems (DBMS). Understand the intricacies of data, fields, records, and how they culminate into an organized database. Explore the limitations of traditional file management systems and uncover the benefits DBMS offers for data handling and storage. Delve into database models and levels of abstraction, setting the stage for mastering relational DBMS. Learn to create robust E-R models and transform them into efficient tables through normalization processes. Gain hands-on experience with SQL Server, including its history, editions, and essential features. Discover how to manage databases using SQL statements such as DDL, DML, DQL, DCL, and TCL. Enhance your skills further by writing complex queries, implementing aggregate functions, and understanding joins and set operations. The course also covers crucial aspects like data integrity implementation through constraints and views management. Learn about Data Control Language for user roles and security management. Advance your knowledge with indexing techniques, T-SQL scripting, stored procedures, triggers, cursors, transaction controls, backup-restoration methods, and utilizing advanced features like pivot tables and XML data types.


What you'll learn

  • Understand core database concepts including DBMS advantages.
  • Administer transactions using Transaction Control Language (TCL).
  • Perform database backups/restores & explore advanced SQL Server features.
  • Construct complex queries with aggregate functions and various joins.
  • Develop E-R models and convert them into normalized tables.
  • Execute SQL statements: DDL, DML, DQL, DCL & TCL.
  • Implement data integrity through entity, domain & referential constraints.
  • Operate SQL Server instances effectively using Management Studio.

Course Syllabus

Day 1 - Database Fundamentals and SQL
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Queries and Security
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - T-SQL and Administration
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor Reviews

Mayur Patil

Mayur Patil

Senior Software Architect & Cloud Solutions Expert

"Excellent instructor and adore his pleasant demeanor towards audiences. In reality, the instruction had assisted me with a piece of work I had to complete on the day of the course. In my profession, I can already envision several use cases and time-saving situations."

"The instruction was excellent. I've attended several web/mobile development trainings, but this was by far the finest. Excellent explanation, structure, and the Mr. Mayur made monolithics and microservices simple to grasp. Thank you!"

"Mayur was very helpful in answering queries and explaining complex ideas in simpler words."

Mohammad Mehdi Lotfinejad

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

Tasmeea Rahman

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
21 intakes
2 enrolled
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers
executives

Methodologies

lecture
slides
labs
case studies

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mayur Patil Senior Software Architect & Cloud Solutions Expert
Trainer Profile
Trainer Profile
Mayur Patil is a highly accomplished Software Architect and Tech Head with over 16 years of comprehensive programming experience across diverse technology stacks and platforms. Currently serving as Technology Head at Aurelia Innovatives Pvt. Ltd., he brings a wealth of expertise in designing and implementing scalable, secure enterprise solutions for financial institutions, medical organizations, and large-scale enterprises. As a Microsoft Certified Professional holding MCP, MCAD, and MCSD.Net certifications, Mayur specializes in modern application architecture, microservices development, and cloud solutions. His technical proficiency spans full-stack development with NodeJS, ASP.Net Core 6, and Angular 14, alongside deep expertise in microservice architecture using RabbitMQ and KAFKA with CQRS and DDD patterns. He excels in containerization solutions using Docker and Kubernetes, with extensive experience in deployment strategies across IIS, Nginx, and Apache web servers. Mayur's mobile development credentials are equally impressive, with over 11 years of iOS development experience using Swift and XCode, complemented by enterprise Android development expertise. He has successfully deployed over 30 live applications across Apple App Store and Google Play Store. His innovative work extends to Unity3D development for Virtual Reality and Augmented Reality applications, demonstrating his ability to work at the cutting edge of immersive technologies. As an AWS Solution Architect Consultant, Mayur designs and executes multi-cluster, multi-region cloud architectures optimized for high scalability, low latency, and fault tolerance. His DevOps expertise encompasses Docker, Kubernetes, Jenkins automation, GitOps with GitHub Actions, Ansible, and Terraform for infrastructure provisioning across AWS, Azure, and GCP platforms. Beyond his technical capabilities, Mayur is a distinguished corporate trainer who has successfully trained hundreds of experienced developers in transitioning from legacy systems to modern frameworks, including VUE 2 to VUE 3 migrations and Angular enterprise application development. His teaching approach combines real-world architectural insights with hands-on implementation strategies, making complex concepts accessible to development teams across multinational corporations. His commitment to research and innovation is evident through his custom solutions, including dynamic form generation engines, real-time collaboration tools, and customized OCR engines, positioning him as both a technical leader and an educator who drives organizational transformation through technology excellence.
1 Student
17 Courses
20 Years
Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years
Loading...
Tasmeea Rahman Data Analytics & Engineering Training Specialist
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Tasmeea Rahman is a highly accomplished corporate trainer and academic professional with a unique blend of technical expertise and pedagogical excellence. Currently pursuing her PhD in Project Management with a focus on Energy Management in the electrical power industry at Universiti Putra Malaysia, she maintains an exceptional 4.00/4.00 CGPA while actively contributing to the professional training landscape. With extensive experience as a Freelance Corporate Trainer since 2023, Tasmeea specializes in delivering comprehensive training programs across multiple domains. Her training portfolio encompasses advanced data analytics tools including Python, Power BI, Minitab, Jaspersoft, Apache Superset, and TIBCO Spotfire, as well as machine learning applications. She also excels in teaching engineering design software such as AutoCAD, Autodesk Fusion 360, Solid Edge, and Autodesk 3Ds Max for both 2D and 3D electrical and mechanical designs. Her project management training capabilities further complement her diverse skill set. Her academic credentials are impressive, holding a Master of Engineering Management from Universiti Putra Malaysia (CGPA: 3.713/4.00), an MBA in Marketing from the University of Dhaka (CGPA: 3.61/4.00), and a Bachelor's degree in Electrical and Electronics Engineering. This multidisciplinary educational background enables her to bridge technical concepts with business applications effectively. As an Adjunct Lecturer at Leading University, she demonstrated her ability to develop curricula and deliver engaging lectures on complex electrical and electronics subjects, including VLSI design, digital signal processing, and microprocessor systems. Tasmeea's research contributions are noteworthy, with publications in high-impact journals including a first-author paper in Renewable and Sustainable Energy Reviews (Q1, Impact Factor: 15.9) and co-authored works in IEEE Access. She holds a Train the Trainer Certification from HRD Corp Malaysia and is certified in Agile Project Management by Google. Her technical proficiency spans programming languages like Python and C++, engineering software including MATLAB and CISCO Packet Tracer, and various data analytics platforms. With her combination of industry experience, academic rigor, and certified training expertise, Tasmeea delivers practical, industry-relevant training that empowers professionals to excel in their respective fields.
8 Students
87 Courses
8 Years

FAQ

Frequently Asked Questions About This Course

Close menu