SQL Server

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.

Face-to-Face Jul 14-16, 2025 9:00 AM - 5:00 PM Mayur Patil
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 8400
Material Fees: MYR 600
Total Fees: MYR 9000

Features

3 days
21 modules
24 intakes
2 enrolled
Full life-time access
English

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

What is Data, Field, Record and database?
Limitations of File Management System
Basic Concepts of Advantages of DBMS
Levels of Abstraction
Database Models
Exploring Relational DBMS
Understanding Client and Server
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 2
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 3

Instructor

Loading...
Mayur Patil Software Architect Teaching

Mayur Patil is a seasoned Software Architect boasting a robust 16 years of experience in the IT industry, specializing in both application architecture and training. His journey commenced as a Software Developer, escalating to leadership roles including Technology Head at Aurelia Innovatives and Five Minutes, to Director at Maurya Cravings Softwares. A Diploma in Computer Engineering and prestigious certifications like MCP, MCAD, and MCSD.Net from Microsoft lay the foundation for his expertise. His skill set spans across NodeJS, ASP.Net Core, Angular, and Vue.js, complemented by substantial experience with iOS and Android app development. Mayur's proficiency doesn't end here; he has significant knowledge in Unity3D game development and a deep understanding of AWS cloud services. He focuses on delivering scalable and secure solutions adhering to industry standards, evidenced by his work with financial and medical institutions. In addition to consulting, Mayur is an accomplished corporate trainer who has mentored hundreds of professionals in upgrading their skills. From orchestrating enterprise-level Angular applications to architecting complex systems using microservice patterns, he has been pivotal in advancing the technical prowess of numerous developers. Furthermore, his command over DevOps tools like Docker, Kubernetes, Jenkins, and Terraform showcases his versatility and forward-thinking approach. Mayur's commitment to research and adaptation is evident through his various innovative projects related to WebSocket implementations, dynamic forms creation with Angular, virtual DOM for real-time collaboration applications, augmented reality applications using UNITY & AREngine, and enhancing OCR capabilities utilizing Tesseract framework.

8 Courses
18 Years

Instructor

Loading...
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Teaching

Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.

5 Students
61 Courses

Instructor

Loading...
Tasmeea Rahman Lecturer Teaching

Tasmeea Rahman is a highly skilled and versatile professional with a rich background in both academia and industry. Currently serving as a Freelance Corporate Trainer at Abundent in Kuala Lumpur, Malaysia, Tasmeea specializes in developing content and providing training on a wide array of subjects including Machine Learning, Data Analysis with Python, MS Excel, Power BI, Minitab, Jaspersoft, Apache Superset, TIBCO Spotfire, and various electrical and mechanical 2D/3D design tools such as AutoCAD and Autodesk Fusion 360. Her role also encompasses project management training. Previously, Tasmeea worked as an Adjunct Lecturer at Leading University in Sylhet, Bangladesh where she was involved in curriculum development and delivering engaging lectures on electrical and electronics courses. She has hands-on experience in teaching subjects like electrical circuits, VLSI design, digital signal processing, and microprocessors. Before her academic stint, she served as a Design Engineer at ALCOVE in Dhaka, Bangladesh where she was responsible for providing electrical and architectural drawings along with planning and executing projects. Tasmeea holds a Ph.D. in Project Management from Universiti Putra Malaysia with a perfect CGPA of 4.00/4.00. She also earned a Master of Engineering Management from the same university and an MBA in Marketing from the University of Dhaka. Her educational foundation is built on a Bachelor's Degree in Electrical and Electronics Engineering from United International University in Bangladesh. In addition to her formal education, Tasmeea has several certifications including Train the Trainer Certification from HRD Corp and Agile Project Management Certifications from Google via Coursera. She is proficient in multiple engineering software tools and programming languages including MATLAB, AutoCAD, C++, Assembly language, and Python. Fluent in both Bengali and English, Tasmeea is committed to continuous learning and professional development.

71 Courses
7 Years

Minimum Qualification

graduate

Target Audience

engineers
mid level managers
senior managers

Methodologies

lecture
slides
case studies
labs

Instructor Reviews

Mayur Patil Software Architect
MU
Movick U
3 years ago
3 years ago

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.

RD
Rosa D
3 years ago
3 years ago

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!

BN
Bob N
3 years ago
3 years ago

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

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
MO
Michael Ogheneme
1 year ago
1 year ago

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.

AJ
Amin Jula
1 year ago
1 year ago

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

KO
Kennedy Okonkwo
1 year ago
1 year ago

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.

RR
Rohit R
3 years ago
3 years ago

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.

SA
Sam A
3 years ago
3 years ago

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.

CS
Carmen S
3 years ago
3 years ago

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.

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

What is Data, Field, Record and database?
Limitations of File Management System
Basic Concepts of Advantages of DBMS
Levels of Abstraction
Database Models
Exploring Relational DBMS
Understanding Client and Server
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 2
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 3

Instructor Reviews

Mayur Patil Software Architect
MU
Movick U
3 years ago
3 years ago

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.

RD
Rosa D
3 years ago
3 years ago

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!

BN
Bob N
3 years ago
3 years ago

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

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
MO
Michael Ogheneme
1 year ago
1 year ago

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.

AJ
Amin Jula
1 year ago
1 year ago

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

KO
Kennedy Okonkwo
1 year ago
1 year ago

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.

RR
Rohit R
3 years ago
3 years ago

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.

SA
Sam A
3 years ago
3 years ago

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.

CS
Carmen S
3 years ago
3 years ago

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 8400
Material Fees: MYR 600
Total Fees: MYR 9000

Features

3 days
21 modules
24 intakes
2 enrolled
Full life-time access
English

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mayur Patil Software Architect Teaching

Mayur Patil is a seasoned Software Architect boasting a robust 16 years of experience in the IT industry, specializing in both application architecture and training. His journey commenced as a Software Developer, escalating to leadership roles including Technology Head at Aurelia Innovatives and Five Minutes, to Director at Maurya Cravings Softwares. A Diploma in Computer Engineering and prestigious certifications like MCP, MCAD, and MCSD.Net from Microsoft lay the foundation for his expertise. His skill set spans across NodeJS, ASP.Net Core, Angular, and Vue.js, complemented by substantial experience with iOS and Android app development. Mayur's proficiency doesn't end here; he has significant knowledge in Unity3D game development and a deep understanding of AWS cloud services. He focuses on delivering scalable and secure solutions adhering to industry standards, evidenced by his work with financial and medical institutions. In addition to consulting, Mayur is an accomplished corporate trainer who has mentored hundreds of professionals in upgrading their skills. From orchestrating enterprise-level Angular applications to architecting complex systems using microservice patterns, he has been pivotal in advancing the technical prowess of numerous developers. Furthermore, his command over DevOps tools like Docker, Kubernetes, Jenkins, and Terraform showcases his versatility and forward-thinking approach. Mayur's commitment to research and adaptation is evident through his various innovative projects related to WebSocket implementations, dynamic forms creation with Angular, virtual DOM for real-time collaboration applications, augmented reality applications using UNITY & AREngine, and enhancing OCR capabilities utilizing Tesseract framework.

8 Courses
18 Years
Loading...
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Teaching

Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.

5 Students
61 Courses
Loading...
Tasmeea Rahman Lecturer Teaching

Tasmeea Rahman is a highly skilled and versatile professional with a rich background in both academia and industry. Currently serving as a Freelance Corporate Trainer at Abundent in Kuala Lumpur, Malaysia, Tasmeea specializes in developing content and providing training on a wide array of subjects including Machine Learning, Data Analysis with Python, MS Excel, Power BI, Minitab, Jaspersoft, Apache Superset, TIBCO Spotfire, and various electrical and mechanical 2D/3D design tools such as AutoCAD and Autodesk Fusion 360. Her role also encompasses project management training. Previously, Tasmeea worked as an Adjunct Lecturer at Leading University in Sylhet, Bangladesh where she was involved in curriculum development and delivering engaging lectures on electrical and electronics courses. She has hands-on experience in teaching subjects like electrical circuits, VLSI design, digital signal processing, and microprocessors. Before her academic stint, she served as a Design Engineer at ALCOVE in Dhaka, Bangladesh where she was responsible for providing electrical and architectural drawings along with planning and executing projects. Tasmeea holds a Ph.D. in Project Management from Universiti Putra Malaysia with a perfect CGPA of 4.00/4.00. She also earned a Master of Engineering Management from the same university and an MBA in Marketing from the University of Dhaka. Her educational foundation is built on a Bachelor's Degree in Electrical and Electronics Engineering from United International University in Bangladesh. In addition to her formal education, Tasmeea has several certifications including Train the Trainer Certification from HRD Corp and Agile Project Management Certifications from Google via Coursera. She is proficient in multiple engineering software tools and programming languages including MATLAB, AutoCAD, C++, Assembly language, and Python. Fluent in both Bengali and English, Tasmeea is committed to continuous learning and professional development.

71 Courses
7 Years

Minimum Qualification

graduate

Target Audience

engineers
mid level managers
senior managers

Methodologies

lecture
slides
case studies
labs
Close menu