226 Microsoft Certified Trainer (MCT) courses delivered Online

Dive into the structured elegance of web development with our ASP.NET MVC Essential Training Course. Built around the fundamentals of the Model-View-Controller architecture, this course introduces the clean separation of concerns that developers admire and employers expect. Whether you're familiar with basic C# or just starting to explore structured programming, this course serves as your gateway to crafting dynamic, scalable, and organised web applications using Microsoft's popular framework. Without throwing in unnecessary jargon or fluff, we've designed the learning experience to be sharp, SEO-friendly, and laser-focused on what truly matters — learning ASP.NET MVC the right way. You'll navigate through routing, controllers, views, models, and data handling in a way that keeps the process refreshingly clear. The goal? To get you comfortable with MVC architecture and let you develop web applications that are not only efficient but logically sound and maintainable. This course speaks to the coder in you who prefers clean code over clutter and logic over guesswork. Learning Outcomes: Understand the fundamentals of ASP.NET MVC 5 framework Learn how to create and configure an ASP.NET MVC application Develop knowledge of Model, View, and Controller (MVC) architecture and its components Gain expertise in URL routing, views, filters, and areas Learn how to implement Ajax calls in an ASP.NET MVC application The ASP.NET MVC Essential Training bundle is a comprehensive package designed for individuals who want to learn how to develop web applications using the ASP.NET MVC framework. The course covers a range of topics, from the fundamentals of MVC architecture to advanced concepts such as URL routing and Ajax. Participants will learn how to create and configure an ASP.NET MVC application, understand the components of Model, View, and Controller (MVC), and develop expertise in views, filters, and areas. This course is ideal for anyone who is interested in web development, particularly those who want to learn how to create web applications using the ASP.NET MVC framework. It is suitable for beginners as well as individuals with some experience in web development. The course is also suitable for software developers who want to expand their skill set and gain expertise in ASP.NET MVC development. ASP.NET MVC Essential Training Course Curriculum Section 01: ASP.Net MVC 5 Section 02: Your First application Section 03: Controller Fundamentals Section 04: Model fundamentals Section 05: URL Routing Section 06: View Fundamentals Section 07: Filters Section 08: Controllers In Depth Section 09: Views In Depth Section 10: Areas Section 11: Ajax How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring web developers who want to learn ASP.NET MVC framework Web developers who want to expand their skill set and gain expertise in ASP.NET MVC development Professionals who want to build scalable and robust web applications Students who want to pursue a career in web development Anyone interested in learning the latest web development technologies Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path ASP.NET MVC Developer: £30,000 - £60,000 Web Developer: £22,000 - £45,000 Software Engineer: £25,000 - £65,000 Full Stack Developer: £28,000 - £75,000 Application Developer: £26,000 - £55,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

If databases were kingdoms, SQL Server would be the crown jewel—and this bootcamp helps you understand why. Whether you're a curious beginner or someone who once dabbled in database queries, this course introduces you to Microsoft SQL Server in a way that feels both structured and digestible. From creating databases to querying data with finesse, you'll gain a clear understanding of how SQL Server works—without needing to download every technical manual Microsoft ever wrote. This course doesn't drown you in jargon or drag you into a tech fog. Instead, it’s paced with clarity, peppered with useful insights, and designed to help you genuinely grasp how to manage data efficiently. You'll learn key SQL concepts, explore table relationships, get to know stored procedures, and understand the logic that powers business intelligence—all while keeping your learning screen-based and refreshingly jargon-free. Let’s face it: data isn’t going anywhere, so you might as well learn to speak its language. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Microsoft SQL Server Bootcamp 2022 Section 01: Getting Started Section 02: SQL Server setting up Section 03: SQL Database basic Section 04: SQL DML (Data Manipulation Language) Section 05: SQL DDL (Data Definition Language) Section 06: SQL DCL (Data Control Language) Section 07: SQL Statement Basic Section 08: Filtering Data rows Section 09: Aggregate functions Section 10: SQL Query statements Section 11: SQL Group by statement Section 12: JOINS Section 13: SQL Constraints Section 14: Views Section 15: Advanced SQL commands Section 16: SQL Stored procedures Section 17: Import & Export data Section 18: Backup and Restore Database Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Certification Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements. Career path Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for anybody interested in learning what is Azure Services, considering a job or career in Azure Services, or considering obtaining a Microsoft certification in Azure Services Overview Upon successful completion of this course, students will be aware of the key topics and concepts taught in the full two-day AZ-900T00 Microsoft Azure Fundamentals Course. This course is a robust introduction to key topics and concepts in the full two-day AZ-900T00: Microsoft Azure Fundamentals course.ÿ The 2-day AZ-900T00 course includes hands-on labs and is the core foundation class that many other Azure courses build off. Core Azure Concepts Introduction to Azure fundamentals Azure fundamental concepts Core Azure architectural components Overview of Core Azure Services Azure database and analytics services Azure compute services Azure Storage services Azure networking services Overview of Core Solutions and Management Tools on Azure Artificial Intelligence Monitoring service for visibility, insight, and outage mitigation Introduction to tools used to manage and configure your Azure environment Azure IoT service for your application Overview of General Security and Network Security Features Protect against security threats on Azure Secure network connectivity on Azure Overview of Identity, Governance, Privacy, and Compliance Features Examine privacy, compliance, and data protection standards on Azure Overview of Azure Cost Management and Service Level Agreements Manage your Azure costs Azure services, SLAs, and service lifecycle

Duration 3 Days 18 CPD hours This course is intended for Experienced system administrators and cloud administrators who are already familiar with vRealize Automation Overview By the end of the course, you should be able to meet the following objectives: Learn installation best practices and troubleshoot installation failures Verify the correct DNS configuration Examine main logs and collect log bundles Examine the Kubernetes pods in the vRealize Automation architecture Troubleshoot common errors that prevent successful deployments Troubleshoot YAML code errors in VMware cloud templates Troubleshoot cloudConfig code errors in VMware cloud templates Troubleshoot VMware Identity Manager™ configuration errors Troubleshoot common errors in VMware vRealize Orchestrator™ workflows Use the vRealize Orchestrator debugger Use log outputs from vRealize Orchestrator Troubleshoot problems in custom resources Troubleshoot problems in resource actions Troubleshoot action-based extensibility (ABX) actions Integrate vRealize Automation with VMware vRealize Log Insight™ Integrate vRealize Automation with VMware vRealize Operations Manager™ Use VMware vRealize Lifecycle Manager™ to troubleshoot vRealize Automation problems with licenses and certificates Configure and replace certificates This three-day, hands-on training course provides you with the advanced knowledge, skills, and tools to achieve competency in troubleshooting VMware vRealize Automation™. vRealize Automation can be used to automate the delivery of virtual machines, applications, and personalized IT services across different data centers and hybrid cloud environments. This course will enable you to troubleshoot common problems with hands-on lab problems. Course Introduction Introductions and course logistics Course objectives Troubleshooting vRealize Automation Installation Issues vRealize Automation installation overview vRealize Automation installation best practices Troubleshooting installation failures vRealize Automation General Troubleshooting Verifying the DNS configuration settings in vRealize Automation and vSphere Examining the main logs in the user interface Collecting a log bundle Using vracli commands Examining the pods in the vRealize Automation Kubernetes architecture Dumping a log from a vRealize Automation Kubernetes pod Stopping and restarting a vRealize Automation Kubernetes pod vRealize Automation Cloud Templates and Deployment Troubleshooting Overview of provisioning and placement workflows Examining a deployment history Troubleshooting deployment issues Using deployment Dev mode Troubleshooting YAML code Troubleshooting problems with cloudConfig vRealize Automation Identity Manager Architecture and Cluster Architecture Authentication workflow in vRealize Automation Connector high availability for the authentication Architecture of a VMware Identity Manager cluster Key VMware Identity Manager commands and log files Troubleshooting a VMware Identity Manager problem Key vRealize Automation components Architecture of the vRealize Automation cluster vRealize Automation node failover scenario vRealize Automation cluster shutdown and startup process Virtual machine provisioning workflow Troubleshooting vRealize Orchestrator Workflows Overview of vRealize Orchestrator and vRealize Automation communications Using the vRealize Orchestrator debugger Using vRealize Orchestrator log output Troubleshooting vRealize Orchestrator binding errors Troubleshooting vRealize Orchestrator logic errors Troubleshooting vRealize Orchestrator payload errors Troubleshooting custom resource errors Troubleshooting resource action errors Troubleshooting Action Based Extensibility (ABX) Actions Overview of ABX actions Troubleshooting ABX actions vRealize Automation Integration with vRealize Tools Integrating vRealize Automation and vRealize Log Insight Integrating vRealize Automation and vRealize Operations Manager Using vRealize Operations Manager to monitor vRealize Automation vRealize Automation Certificate Management Managing vRealize Automation certificates Creating certificate requests with vRealize Lifecycle Manager Using Microsoft Certificate Services to create vRealize Automation certificates Replacing vRealize Automation certificates Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vRealize Automation: Troubleshooting [V8.6] training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware vRealize Automation: Troubleshooting [V8.6] course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for System architects and system administrators Overview By the end of the course, you should be able to meet the following objectives: Plan a deployment for VMware Cloud Foundation Understand VMware Cloud Foundation and supporting architecture Configure VMware Cloud Foundation for VMware Cloud Connectivity Understand the VMware Cloud Foundation subscription licensing model Perform Day-Zero tasks Perform VMware Cloud Foundation platform onboarding Manage user credentials in VMware Cloud Foundation Configure NSX networking in VMware Cloud Foundation Deploy and manage Workload Domains Deploy vSphere with Tanzu on VMware Cloud Foundation Understand and implement storage solutions and related policies Perform maintenance tasks for the VMware Cloud Foundation platform Manage certificates for VMware Cloud Foundation and connected technologies Manage the lifecycle for VMware Cloud Foundation Engage with VMware Cloud Foundation Technical Support This five-day training course provides you with the knowledge, skills, and abilities to achieve competence with VMware Cloud Foundation 5.0. This course teaches you how deploy VMware Cloud Foundation, and perform the tasks required for the initial configuration and ongoing operation after deployment. Course Introduction Introductions and course logistics Course objectives VMware cloud foundation overview Describe the VMware Cloud Foundation solution Describe VMware Cloud Foundation architecture Identify VMware Cloud Foundation components Describe the VMware Cloud Foundation topology VMware Cloud Foundation+ and VMware Cloud Connectivity Describe the VMware Cloud Foundation+ architecture Identify the pre-requisites for VMware Cloud Foundation+ Describe VMware Cloud Foundation+ value added features Configure subscription-based licensing parameters Describe the vCenter Cloud Gateway functionality Identify the vCenter Cloud Gateway components Describe the vCenter Cloud Gateway architecture Connect the vCenter Cloud Gateway to VMware Cloud Describe the VMware Cloud platform Describe the VMware vSphere+ services used in VMware Cloud Foundation+ Demonstrate the capabilities of the VMware Cloud user interface for VMware Cloud Foundation+ Day Zero Tasks Identify the requirements for deploying VMware Cloud Foundation Describe the VMware Cloud Foundation bring-up process Identify the information required for the Planning and Preparation Workbook Complete the Deployment Parameter Workbook Describe how VMware Cloud Builder automates the deployment process Identify the configuration validation process performed by VMware Cloud Builder Describe the deployment of the management domain Post-Deployment Operations Complete the Onboarding Wizard Understand VMware Cloud Foundation integration with VMware Single Sign-On Configure user access to VMware Cloud Foundation Describe the importance of user roles in vSphere Configure identity sources for VMware Cloud Foundation Perform the SDDC Manager backup and restore process Identify steps in the NSX backup and restore process Manage passwords in VMware Cloud Foundation Explain the importance of using VMware Cloud Foundation to manage passwords for vSphere components Manage and secure a primary password list Describe the process for rotating passwords not managed by VMware Cloud Foundation VMware Cloud Foundation Networking with NSX Describe network virtualization with NSX Recognize NSX operational planes Identify NSX components Describe logical switching Describe NSX Data Center deployment in VMware Cloud Foundation Explain how logical routing works in NSX Identify NSX Edge functions Describe data plane preparation for NSX Edge nodes in a workload domain Recognize Tier-0 and Tier-1 gateway topologies Define application virtual networks Describe management domain rack options List NSX Edge cluster requirements for vSphere with Tanzu Discuss NSX Edge cluster placement considerations Managing Workload Domains Define workload domains List the types of workload domains Identify workload domain prerequisites Understand the scalability limits for workload domains Identify use cases for multiple clusters in a workload domain Create network pools Size network pools Commission hosts with SDDC Manager Create workload domains Scale workload domains Decommission hosts from a workload domain Remove workload domains Describe distinctive design decisions for VMware Cloud Foundation components vSphere with Tanzu in VMware Cloud Foundation Explain vSphere with Tanzu Define the role of the Spherelet Describe the supervisor cluster control plane Create vSphere with Tanzu namespaces Describe the role of NSX networking components in vSphere with Tanzu Discuss vSphere with Tanzu networking topology Describe control plane VM management networking requirements Plan appropriate IP address ranges for pod, ingress, and egress networking Describe prerequisites for vSphere with Tanzu cluster compatibility Deploy vSphere with Kubernetes Create a vSphere namespace Configure limits and permissions for a vSphere namespace VMware Cloud Foundation Storage Management Identify storage use cases in VMware Cloud Foundation Determine the most appropriate storage option for a workload domain Describe different vSphere-native storage design options Identify vSAN architecture and components Describe vSAN requirements for the management and workload domains Configure deduplication and compression Discuss how to scale vSAN clusters in VMware Cloud Foundation Configure storage policies for vSAN Explain storage policy failure tolerance rules Identify a virtual machine storage policy compliance status Explain how vSAN storage policies protect VMware Cloud Foundation components Availability and Business Continuity Explain the importance of external service availability Describe availability options native to VMware vSphere Identify stretched cluster use cases Identify stretched cluster components Recognize stretched cluster requirements in VMware Cloud Foundation Prepare and deploy a vSAN stretched cluster using APIs VMware Cloud Foundation Certificate Management Learn the basics of public key infrastructure (PKI) Describe the purpose of certificate signing requests (CSRs) Describe available options in SDDC Manager for certificate authorities View certificates for VMware Cloud Foundation components Install and replace certificates for VMware Cloud Foundation components Configure the integrated Certificate Authorities in SDDC Manager Configure a certificate template in Microsoft Certificate Authority server Configure the OpenSSL certificate authority in SDDC Manager Install certificates issued by Microsoft, OpenSSL, and third-party certificate authorities VMware Cloud Foundation Lifecycle Management Describe VMware Cloud Foundation Life Cycle Management List the products managed by VMware Cloud Foundation Lifecycle management Use online and offline bundle downloads using VMware Cloud Foundation Lifecycle management Understand the role of vSphere Lifecycle Management in VMware Cloud Foundation Understand vSphere Lifecycle Manager features Understand how and when to use cluster images Describe the importance of Hardware Support Managers Describe the upgrade prerequisites Outline the upgrade precheck process Describe the order of upgrade for VMware Cloud Foundation components VMware Cloud Foundation Troubleshooting Use the SoS command-line tool to create log bundles, perform health checks, and check password validity List VMware Cloud Foundation services Identify VMware Cloud Foundation log files Use token IDs to troubleshoot failed workflows

Duration 2 Days 12 CPD hours This course is intended for This course is ideal for users who need to replace a Windows computer with a Mac and for IT professionals who support Mac users. Overview Organizations are increasingly integrating Mac computers into Windows or other standards-based network environments. This course gives both users and the IT professionals who support them the skills necessary to make integration easy. This two day Mac Integration Basics course examines how to best use a Mac(s) in an organization that predominantly functions with a Microsoft Windows operating system and Windows Servers. Directory Services Connect a Mac to an Active Directory server Share Files Connect to file servers. Turn on personal file sharing. Configure Collaborative Services Manage Internet Accounts preferences. Connect to an Exchange Server. Connect Mail to non-Windows servers. Add accounts in Mail, Contacts, and Calendars. Secure a Mac Built-In Security features. Create strong passwords. Use two-factor authentication. Set a firmware password. Lock a Mac screen. Create user accounts. Disable automatic login. Protect start-up disk files. Ensure that the apps you download are safe. Provide network security. Printing Connect to a local printer. Connect to, share, and print from network printers. Move and Back Up Content Move content. Back up content. Run Windows on a Mac Run Windows natively or virtually. Microsoft Office for macOS. Cross-platform apps. Cross-platform files. Troubleshooting How to best troubleshoot macOS. Questions & Answers

Duration 2 Days 12 CPD hours This course is intended for This course is intended for individuals who want to gain an indepth knowledge of formatting documents using Word. Overview Upon successful completion of this course, students will be able to create and modify documents by using Microsoft Office Word 2016/365/2019. In this course, students will create, edit, and enhance technical documents using Microsoft Office Word 2016/365/2019. Formatting Text and Paragraphs Apply Character Formatting Control Paragraph Layout Aligh Text Using Tabs Display Text in Bulleted or Numbered Lists Working More Efficiently Make Repetitive Edits Apply Repetitive Formatting Use Styles to Streamline Repetitive Formatting Tasks Customize the Word Environment Managing Lists Sort a List Format a List Adding Tables Insert a Table Modify a Table Format a Table Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Controlling Page Appearance Add Headers and Footers Control Page Layout Add a Watermark Preparing to Publish Check Spelling, Grammar, and Readability Previw and Print Documents Use Research Tools Customizing Formats Using Styles and Themes Create and Modify Text Styles Cerate Custom List or Table Styles Apply Document Themes Inserting Content Using Quick Parts Insert Building Blocks Create and Modify building Blocks Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Create a Document Using a Template Create and Modify a Template Manage Templates with the Template Organizer Controlling the Flow of a Document Control Paragrpah Flow Insert Section Breaks Insert Columns Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Anchillary Table Manage Outlines Create a Master Document Manipulating Images Integrate Pictures and Text Adjust Image Appearance Adding Document References and Links Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibilography Additional course details: Nexus Humans Formatting Technical Documents Using Microsoft for Office 365 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Formatting Technical Documents Using Microsoft for Office 365 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for end users who are familiar with computers and who need to use the features and functionality of the Windows 10 operating system for personal and/or professional reasons. In this course, students will learn the features and functionality of the Windows 10 operating system for professional and personal use. Accessing Windows 10 Topic A: Navigate the Windows 10 Desktop Topic B: Manage the Start Menu Topic C: Sign In to Windows 10 Using Windows Apps and Desktop Applications Topic A: Navigate Desktop Applications Topic B: Navigate Windows Apps Features Topic C: Navigate the Cortana Virtual Assistant App Working with Files and Folders Topic A: Manage Files and Folders with File Explorer Topic B: Store and Share Files with OneDrive Topic C: Multitask with Open Apps Accessing the Internet using Microsoft Edge Topic A: Use Microsoft Edge Topic B: Customize Microsoft Edge Customizing the Windows 10 Environment Topic A: Customize the Start Screen Topic B: Customize the Desktop Installing and Removing Devices Topic A: Manage Printers Topic B: Manage Peripheral Devices Using Windows 10 Security Features Topic A: Manage Passwords and Privacy Levels Topic B: Use Windows Defender Additional course details: Nexus Humans Using Microsoft Windows 10 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Using Microsoft Windows 10 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modeling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title. 1 - Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages 2 - Data Modeling Data Modelling Designing a Database Relationship Modeling 3 - Normalization Fundamentals of Normalization Normal Form Denormalization 4 - Relationships Introduction to Relationships Planning Referential Integrity 5 - Performance Indexing Query Performance Concurrency 6 - Database Objects Tables Views Stored Procedures, Triggers and Functions Additional course details: Nexus Humans 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.