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 After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling 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 course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions
Duration 3 Days 18 CPD hours This course is intended for This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended. Overview Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks. This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects. Prerequisites Basic Windows and Active Directory knowledge. Conceptual knowledge of Configuration Manager objects and how they interact. Basic experience performing configuration tasks in ECM using the graphical console. Experience working from a command prompt. Basic knowledge of the fundamentals of Windows PowerShell. 1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS Architecture of an System Center 2012 Configuration Manager Installation Managing Assets Content Delivery and Management Security, Monitoring, and Remote Management 2 - MANAGING RESOURCES Implementing Discovery Organizing Resources with Collections Working with Boundaries 3 - WORKING WITH CLIENTS Installing the Configuration Manager Client Managing Client Settings Managing Client Operations Monitoring Client Status 4 - DISTRIBUTING SOFTWARE Configure the Software Distribution Components Working with Distribution Points Creating Content for Distribution Deploying Software Applications 5 - UPDATING SYSTEMS WITH WSUS AND SCCM Integrating Configuration Manager and WSUS Managing Updates through Software Update Groups Creating and Deploying Update Packages Working with Automatic Deployment Rules 6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS Creating Compliance Settings Objects Deploying and Monitor the Baseline 7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS Preparing the OSD Environment Working with Task Sequences 8 - WORKING AT THE SITE LEVEL Modify the Site Adding Site System Roles Adding a Secondary Site 9 - SECURITY AND MONITORING Configuring Role Based Administration Implementing Endpoint Protection Configuring Monitoring Options 10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS Review of Scripting Constructs Introduction to the Configuration Manager WMI Classes
Game design training face to face training customised and bespoke.
Duration 4 Days 24 CPD hours This course is intended for Software engineers concerned with building, managing and deploying AI solutions that leverage Azure AI Services, Azure AI Search, and Azure OpenAI. They are familiar with C# or Python and have knowledge on using REST-based APIs to build computer vision, language analysis, knowledge mining, intelligent search, and generative AI solutions on Azure. AI-102 Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage?Azure AI Services,?Azure AI Search, and?Azure OpenAI. The course will use C# or Python as the programming language. Prerequisites Before attending this course, students must have: Knowledge of Microsoft Azure and ability to navigate the Azure portal Knowledge of either C# or Python Familiarity with JSON and REST programming semantics Recommended course prerequisites AI-900T00: Microsoft Azure AI Fundamentals course 1 - Prepare to develop AI solutions on Azure Define artificial intelligence Understand AI-related terms Understand considerations for AI Engineers Understand considerations for responsible AI Understand capabilities of Azure Machine Learning Understand capabilities of Azure AI Services Understand capabilities of the Azure Bot Service Understand capabilities of Azure Cognitive Search 2 - Create and consume Azure AI services Provision an Azure AI services resource Identify endpoints and keys Use a REST API Use an SDK 3 - Secure Azure AI services Consider authentication Implement network security 4 - Monitor Azure AI services Monitor cost Create alerts View metrics Manage diagnostic logging 5 - Deploy Azure AI services in containers Understand containers Use Azure AI services containers 6 - Analyze images Provision an Azure AI Vision resource Analyze an image Generate a smart-cropped thumbnail 7 - Classify images Provision Azure resources for Azure AI Custom Vision Understand image classification Train an image classifier 8 - Detect, analyze, and recognize faces Identify options for face detection analysis and identification Understand considerations for face analysis Detect faces with the Azure AI Vision service Understand capabilities of the face service Compare and match detected faces Implement facial recognition 9 - Read Text in images and documents with the Azure AI Vision Service Explore Azure AI Vision options for reading text Use the Read API 10 - Analyze video Understand Azure Video Indexer capabilities Extract custom insights Use Video Analyzer widgets and APIs 11 - Analyze text with Azure AI Language Provision an Azure AI Language resource Detect language Extract key phrases Analyze sentiment Extract entities Extract linked entities 12 - Build a question answering solution Understand question answering Compare question answering to Azure AI Language understanding Create a knowledge base Implement multi-turn conversation Test and publish a knowledge base Use a knowledge base Improve question answering performance 13 - Build a conversational language understanding model Understand prebuilt capabilities of the Azure AI Language service Understand resources for building a conversational language understanding model Define intents, utterances, and entities Use patterns to differentiate similar utterances Use pre-built entity components Train, test, publish, and review a conversational language understanding model 14 - Create a custom text classification solution Understand types of classification projects Understand how to build text classification projects 15 - Create a custom named entity extraction solution Understand custom named entity recognition Label your data Train and evaluate your model 16 - Translate text with Azure AI Translator service Provision an Azure AI Translator resource Specify translation options Define custom translations 17 - Create speech-enabled apps with Azure AI services Provision an Azure resource for speech Use the Azure AI Speech to Text API Use the text to speech API Configure audio format and voices Use Speech Synthesis Markup Language 18 - Translate speech with the Azure AI Speech service Provision an Azure resource for speech translation Translate speech to text Synthesize translations 19 - Create an Azure AI Search solution Manage capacity Understand search components Understand the indexing process Search an index Apply filtering and sorting Enhance the index 20 - Create a custom skill for Azure AI Search Create a custom skill Add a custom skill to a skillset 21 - Create a knowledge store with Azure AI Search Define projections Define a knowledge store 22 - Plan an Azure AI Document Intelligence solution Understand AI Document Intelligence Plan Azure AI Document Intelligence resources Choose a model type 23 - Use prebuilt Azure AI Document Intelligence models Understand prebuilt models Use the General Document, Read, and Layout models Use financial, ID, and tax models 24 - Extract data from forms with Azure Document Intelligence What is Azure Document Intelligence? Get started with Azure Document Intelligence Train custom models Use Azure Document Intelligence models Use the Azure Document Intelligence Studio 25 - Get started with Azure OpenAI Service Access Azure OpenAI Service Use Azure OpenAI Studio Explore types of generative AI models Deploy generative AI models Use prompts to get completions from models Test models in Azure OpenAI Studio's playgrounds 26 - Build natural language solutions with Azure OpenAI Service Integrate Azure OpenAI into your app Use Azure OpenAI REST API Use Azure OpenAI SDK 27 - Apply prompt engineering with Azure OpenAI Service Understand prompt engineering Write more effective prompts Provide context to improve accuracy 28 - Generate code with Azure OpenAI Service Construct code from natural language Complete code and assist the development process Fix bugs and improve your code 29 - Generate images with Azure OpenAI Service What is DALL-E? Explore DALL-E in Azure OpenAI Studio Use the Azure OpenAI REST API to consume DALL-E models 30 - Use your own data with Azure OpenAI Service Understand how to use your own data Add your own data source Chat with your model using your own data 31 - Fundamentals of Responsible Generative AI Plan a responsible generative AI solution Identify potential harms Measure potential harms Mitigate potential harms Operate a responsible generative AI solution
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
APM Project Fundamentals Qualification (PFQ): In-House Training This practical course gives Participants a solid introduction to the fundamentals of project management and to prepare them for the one-hour, multiple-choice exam held at the end of the course. The APM Project Fundamentals Qualification (PFQ) is an entry-level qualification suitable for those who are new to project management and working in a project team, and who wish to understand the standard terminology. The goal of this course is to prepare you to successfully pass the exam. What you will Learn You'll learn how to: Identify project management terminology and context Identify project management processes Identify the roles involved in project management Describe project success criteria and benefits Prepare project documentation Acquire the level of understanding needed to pass the APM PFQ examination Getting Started Introductions Course structure Course goals and objective Project Context Project characteristics Project management processes Business and project context Organizational roles Project Lifecycle Programme and portfolio management Project Concept Phase Stakeholder management Project success and benefits management Business case Benefits People in Projects Leadership and teamwork Communication Project Definition Phase Project management plan Quality management Risk management Scope management Scheduling Resource management Estimating Procurement Project Implementation Phase Change control and configuration management Issue management Information management Project Hand-over and Close-out Phase Hand-over and close-out Post-project review Revision and Exam Revision and practice questions APM PFQ examination
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
Definitive SRv6 course description This one day SRv6 training course is a condensed, intensive program designed to provide network professionals with a fast-track introduction to SRv6 (Segment Routing over IPv6). SRv6 is a revolutionary networking technology that combines the power of IPv6 with the flexibility of Segment Routing, enabling efficient and scalable network operations. In just one day, participants will gain essential knowledge and practical skills to understand, configure, and work with SRv6 in modern network environments. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Explain packet paths when implementing SLB. Explain how SRv6 works. Explain the difference between SR and SRv6. Implement SRv6. Troubleshoot SRv6. Definitive SRv6 course details Who will benefit: Network engineers, architects, and administrators who want to quickly grasp the fundamentals of SRv6 and its practical applications in their network. Prerequisites: Definitive Segment Routing for engineers Duration 1 day Definitive SRv6 course contents Introduction to SRv6 What is SRv6? Source based routing, difference between SR-MPLS and SRv6. IPv6 headers review, routing headers. SRv6 simplified solution. Hands on Enabling IPv6 in the legacy network. SRv6 transport Segment Routing Extension Header. SRv6 segment identifiers. End SID, End.X SID. ISIS distribution of SIDs. Header processing in a SRv6 topology. Locators. Hands on Configuring SRv6 transport. Analysing SRv6 operation. SRv6 services End.DT4 SID, End.DT6 SID. SRH encapsulation modes: Insert and Encap modes. SRv6 TE policy. Hands on Migrating to SRv6, TI-LFA protection. Micro loop avoidance. SRv6 integration with 'older' technologies MPLS. The role of iBGP and eBGP v6 sessions. Hands on Integration with legacy network. Troubleshooting SRv6 SRv6 ping and traceroute. Hands on: Used throughout the course during exercises.
APM Project Fundamentals Qualification (PFQ): Virtual In-House Training This practical course gives Participants a solid introduction to the fundamentals of project management and to prepare them for the one-hour, multiple-choice exam held at the end of the course. The APM Project Fundamentals Qualification (PFQ) is an entry-level qualification suitable for those who are new to project management and working in a project team, and who wish to understand the standard terminology. The goal of this course is to prepare you to successfully pass the exam. What you will Learn You'll learn how to: Identify project management terminology and context Identify project management processes Identify the roles involved in project management Describe project success criteria and benefits Prepare project documentation Acquire the level of understanding needed to pass the APM PFQ examination Getting Started Introductions Course structure Course goals and objective Project Context Project characteristics Project management processes Business and project context Organizational roles Project Lifecycle Programme and portfolio management Project Concept Phase Stakeholder management Project success and benefits management Business case Benefits People in Projects Leadership and teamwork Communication Project Definition Phase Project management plan Quality management Risk management Scope management Scheduling Resource management Estimating Procurement Project Implementation Phase Change control and configuration management Issue management Information management Project Hand-over and Close-out Phase Hand-over and close-out Post-project review Revision and Exam Revision and practice questions APM PFQ examination
SAFe® Scrum Master: In-House Training Build your skills as a high-performing team member of an Agile Release Train (ART) and prepare to support the facilitation of team and program events when you become a SAFe® 5 Scrum Master (SSM). In this course, you'll gain an understanding of the role of Scrum Master in a SAFe® enterprise. Unlike traditional Scrum Master training that focuses on the fundamentals of team-level Scrum, the SAFe® Scrum Master course explores the role of the Scrum Master in the context of the entire enterprise and prepares you to successfully plan and execute the Program Increment (PI), the primary enabler of alignment throughout all levels of a SAFe® organization. What you will Learn To perform the role of a SAFe® Scrum Master, attendees should be able to: Describe Scrum in a SAFe® enterprise Facilitate Scrum events Facilitate effective Iteration execution Support effective Program Increment execution Support relentless improvement Coach Agile teams for maximum business results Support DevOps implementation Build a high-performing ART by becoming a servant leader and coach Develop an action plan to continue your learning journey Introducing Scrum in SAFe® Characterizing the role of the Scrum Master Experiencing Program Increment planning Facilitating Iteration execution Finishing the Program Increment Coaching the Agile team