• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2445 Courses delivered Online

Origami Online - Make Four Items Of Clothing For Greetings Cards

By Crafty Team Building

Origami online with Art By Vanessa.

Origami Online - Make Four Items Of Clothing For Greetings Cards
Delivered OnlineFlexible Dates
£25

Certified Data Centre Professional (CDCP)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and who has the responsibility to achieve and improve the availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Choose an optimum site for mission-critical data centre based on current and future needs? Describe all components that are important for high availability in a data centre and how to effectively setup the data centre? Name and apply the various industry standards? Describe the various technologies for UPS, fire suppression, cooling, monitoring systems, cabling standards, etc, and to select and apply them effectively to cost-efficiently enhance the high-availability of the data centre.? Review the electrical distribution system to avoid costly downtime? Enhance cooling capabilities and efficiency in the data centre by using existing and new techniques and technologies for the increased cooling requirements of the future? Design a highly reliable and scalable network architecture and learn how to ensure installers apply proper testing techniques? Create effective maintenance contracts with equipment suppliers ensuring the best return on investment? Setup effective data centre monitoring ensuring the right people get the right message? Ensure proper security measures, both procedural and technical, are established to safeguard your company's valuable information in the data centre The course will address how to setup and improve key aspects such as power, cooling, security, cabling, safety, etc., to ensure a high available data centre. It will also address key operations and maintenance aspects. The Data Centre, it?s Importance and Causes for DowntimeData Centre Standards and Best PracticesData Centre Location, Building and Construction Selecting appropriate sites and buildings and how to avoid pitfalls Various components of an effective data centre and supporting facilities setup Raised Floor/Suspended Ceiling Uniform, concentrated and rolling load definitions Applicable standards Raised Floor guidelines Signal Reference Grid, grounding of racks Disability act and regulations Suspended ceiling usage and requirements Light Standards Light fixture types and placement Emergency lighting, Emergency Power Supply (EPS) Power Infrastructure Power infrastructure layout from generation to rack level ATS and STS systems Redundancy levels and techniques Three-phase and single-phase usage Power distribution options within the computer room Power cabling versus bus bar trunking Bonding versus grounding Common Mode Noise and isolation transformers Distribution boards, form factors and IP-protection grades Power quality guidelines Real power versus apparent power How to size and calculate load in the data centre Generators Static and dynamic UPS systems, selection criteria, how they operate and energy efficiency option Battery types, correct selection and testing Thermo-graphics Electro Magnetic Fields Electrical fields and magnetic fields definitions and units of measurements Sources of EMF Effects of EMF on human health and equipment (H)EMP Standards EMF shielding solutions Equipment Racks Rack standards, properties and selection criteria Security considerations Power rail/strip options Cooling Infrastructure Temperature and humidity recommendations Cooling measurement units and conversion rates Sensible and latent heat definitions Differences between comfort and precision cooling Overview of different air conditioner technologies Raised floor versus non-raised floor cooling Placement of air conditioner units and limitations to be observed Supplemental cooling options Cold aisle/hot aisle containment Water Supply Importance of water supply and application areas Backup water supply techniques Designing a Scalable Network Infrastructure The importance of a Structured Cabling System Planning considerations Copper and Fiber cable technology and standards ANSI/TIA-942 Cabling hierarchy and recommendations Testing and verification SAN storage cabling Network redundancy Building-to-building connectivity Network monitoring system requirements Fire Suppression Standards for fire suppression Detection systems Various total flooding fire suppression techniques and systems, their benefits and disadvantages Handheld extinguishers Signage and safety Regulatory requirements and best practices Data Centre Monitoring Data centre monitoring requirements EMS versus BMS Water leak detection systems Notification options and considerations Operational Security and Safety Practices Data centre security layers Physical, infrastructure and organisational security Safety measures and essential signage Labelling Choosing a labelling scheme Recommended labelling practices Network labelling Documentation How to setup proper documentation Document management policies and procedures Cleaning Cleaning practices for the data centre MTBF/MTTR Standards and definitions Calculation models The ?real? value Maintenance Contracts/SLA/OLAEXAM: Certified Data Centre Professional Additional course details: Nexus Humans Certified Data Centre Professional (CDCP) 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 Certified Data Centre Professional (CDCP) 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.

Certified Data Centre Professional (CDCP)
Delivered OnlineFlexible Dates
£1,500

DP-300T00 Administering Microsoft Azure SQL Solutions

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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.

DP-300T00 Administering Microsoft Azure SQL Solutions
Delivered OnlineFlexible Dates
£2,380

The Quiet Magic of Noticing

By Happy Human Training

Wanna learn something simple yet so amazing that it's going to blow your mind? Good, because this little workshop's a gem. Join Happy Human Training's Cami Rose as she shares her decades of experience as a counsellor and coach with an introduction to the power of noticing and the crucial role it can play in helping us better manage our day to day stresses, challenges and relationships.

The Quiet Magic of Noticing
Delivered OnlineFlexible Dates
£5

Obsessive Compulsive Disorder

By Human Givens College

Join Dr Andrew Morrice for a deep dive into what the latest mind-body research tells us about the impact of sleep, the microbiome, nutrition, culinary practices and more on our mental and physical health, and recovery … Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Excellent content and practical applications for treating OCDPETA DUNN, GP Live training delivered online – Join Miriam Chachamu on Tuesday 13th February 2024 for this live online OCD course workshop via Zoom. The content covered is the same as our original attended workshop, with some modifications to the exercises – you will have plenty of opportunities to ask Miriam questions. We will send details of how to join the Zoom workshop by email the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course Obsessive compulsive disorder (OCD) is not only distressing for sufferers but for their family members and friends too. Contrary to the popular view of OCD being harmless over-cleanliness or simply checking things over and over again, people living with OCD experience a high level of anxiety – and the condition can damage their relationships, social and work lives, and physical health. Many sufferers are ashamed of their problem and hide it. Sometimes therapists fail to recognise the rarer forms of OCD and therefore fail to offer effective treatment. And many people with milder forms of OCD do not realise that they can be helped, and do not seek help until their condition becomes much more severe. This accredited live online course offers an in-depth look at OCD in all its guises and focuses on practical and effective methods of treatment – OCD recovery is possible in most cases. The day is interactive and includes demonstration videos of therapy sessions, short video clips, in-depth discussions and case studies. The films of the therapy sessions and the video of dealing with intrusive thoughts were particularly usefulSCHOOL NURSE What will you learn New information that will enable you to help OCD sufferers more effectively A better understanding of OCD, what it is and how it develops The ability to recognise the less familiar types of OCD – these are often missed by both client and therapist An effective 4-step method for treating OCD New ways to help people overcome their compulsive tendencies Illuminating video clips of OCD sufferers describing their experience Helpful ways parents and educators can prevent signs of OCD in children and teenagers from developing further The important role of guided imagery in treatment and why it improves success rates How to separate the person from their OCD ‘Pure O’ – we look at ‘purely obsessional’ OCD, where people experience distressing intrusive thoughts without any external signs of compulsions The chance to observe effective therapy for OCD and discuss case studies How obsessive compulsive disorder fits with other psychological conditions – and with autism What to do when OCD symptoms are firmly entrenched The opportunity to discuss some of your own cases with a highly knowledgeable tutor How to handle challenging cases successfully and more… Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding OCD 11.00am Comfort break and discussion 11.30am How to treat OCD successfully and quickly 1.00pm Lunch break 1.45pm OCD treatment – what to do when symptoms persist 2.45pm Comfort break and discussion 3.00pm Dealing with unusual or challenging cases 4.00pm Day ends Who is this online course suitable for? Anyone who works with, lives with, teaches or treats people suffering from OCD, or who thinks they may have OCD but isn’t sure Psychotherapists, counsellors, health and social care professionals, mental health and wellbeing professionals, educators, school counsellors, individuals working in a variety of capacities in any number of organisations who are looking for OCD training for professionals Anyone who has family members or friends who suffer from OCD would also benefit from this live online course – it contains essential, practical information about how to help OCD sufferers The day is also valuable for anyone struggling to deal with their own obsessive thoughts or actions Please Note: This course is not a substitute for individual therapy This course looks at a range of OCD behaviours, including: Compulsive checkingContamination / Mental ContaminationSymmetry and orderingRuminations / Intrusive thoughts (Pure O)HOCD – Homosexual OCDPOCD – Paedophile OCD / Prenatal and postpartum OCDand more This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Obsessive Compulsive Disorder
Delivered OnlineFlexible Dates
£145

How To Eradicate Stress From Your Life - Using The Abraham-Hicks Philosophy

By Mr Happiness 2000

You've heard the term 'Success Mindset' your entire life. But what does it mean exactly? Have you got it? And how do you apply it? Not only will it teach you practical mental tips to begin moving towards your life goals, it will also teach you how to eliminate stress from your life. By teaching you 'conscious thinking'.

How To Eradicate Stress From Your Life - Using The Abraham-Hicks Philosophy
Delivered Online On Demand
£9.99

WREATH MAKING WORKSHOPS Choice of Dried, Artificial or Fresh Flowers Private group Seasonal Wreath Making Workshops for hen parties, corporate days, birthday celebrations, Christmas and other occasions.

5.0(11)

By Jenni Wren Creative - Floristry Arts & Crafts

Seasonal Wreath Making Workshops for every occasion in Oxfordshire area for hen parties, corporate days, birthdays etc. Get in touch to find out

WREATH MAKING WORKSHOPS 
Choice of Dried, Artificial or Fresh Flowers 
Private group Seasonal Wreath Making Workshops  for hen parties, corporate days, birthday celebrations, Christmas and other occasions.
Delivered in Didcot + 2 more or OnlineFlexible Dates
£40 to £50

Certified Network Cabling Design Professional (CNCDP)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional, consultant and/or those who work in network cabling system design, implementation and operation. Overview With few exceptions, enterprises today rely on IT for the delivery of business-critical services - often directly to the end consumer. It is therefore vital that the mission-critical data centre is designed, maintained and operated with high-availability and efficiency in mind. Among all the facilities, network cabling is the foundation for the network and one of the major contributors to the availability of the data center.CNCDP© is a 2-day course designed to expose participants to in-depth knowledge in designing and installing the data network cabling system which includes key subject matters such as; technical standards, designing of different cabling sub-systems, calculation of material requirements, architecture, installation, testing and acceptance. Introduction to Structured Cabling System (SCS) Brief history of SCS Basic copper and fibre transmission Copper and fibre cabling Single and multimode fibre Step/graded index multimode fibre Difference between Commercial Wiring and data centre cabling Development of standards Role of standards ANSI/TIA 568 standard Common standards The new usage of cabling to support Smart building Horizontal and Administration - Commercial Building Standard diagram recap: ANSI/TIA-568 Functional elements and example Scenario A: Determine the number of work areas Scenario B: Determine the number of user locations Zone wiring Administration: Interconnect and cross-connect Angled and flat panels Creating a cabling schematic design Convert schematic into physical layout Calculating the material list Horizontal and Administration - Data Centre Standard diagram recap: TIA-942 Basic/Reduced/Typical data centre setup Traditional 3 layers network design/ Spine and Leaf network design Select termination hardware Administration design ToR/EoR/Spine & Leaf cabling design Network and cabling resiliency Create cabling schematic design for ToR/EoR Convert into patch panel/rack layout Calculate the material list for ToR/EoR Building Backbone - Commercial Building Backbone diagram Calculate the copper backbone requirements per Telecom Room (TR) Calculate the fibre backbone requirements per Telecom Room Summarize the building backbone requirements Recognised cables Backbone Patch panels The maximum backbone distances Create cabling schematic design Converting the schematic design into patch panel/ rack layout Building Backbone - Data Centre TIA-942 based backbone topology TIA-942 backbone requirements Recognised backbone cable ToR/EoR/Spine and Leaf Backbone distance estimation Resiliency of backbone cable routes Creating cabling schematic design Converting the schematic design into patch panel/ rack layout Field and Fusion Termination for fibre connectors Pre-terminated fibre trunk and copper cables Architectural Considerations ANSI/TIA569-D Cable pathway and spaces Common requirements for the rooms Definition of the rooms Entrance Room/Demarcation Ceiling and floor pathways types Cable trays/basket/ladder/conduit Inner duct/sleeve/slot Calculating of pathway size Cable run best practices Cable management/AIM Grounding and bonding Separation distance requirements for copper cabling to power cabling Fire stopping Fire rated barrier Fire rated jacket cable Campus / Outdoor Backbone Common campus cable installation and cable types : Aerial cable / Direct-buried / Underground in-conduit Outdoor cable installation planning Lightning / surge protection Approved ground for surge protector Creating a schematic diagram Converting a schematic into a physical layout Site Inspection and Testing Visual site inspection notes Installation common issues Copper testing standard Permanent link / Channel / Patch cord / MPTL testing configuration Fibre connectors Fibre testing standard Tier 1 & 2 certification Fibre link definition Fibre testing steps Fibre inspection and cleaning Calibrating the test sets - 3 methods Setting up mandrel for testing Fibre loss budget calculation G.657 Bend insensitive fibre Optical Time-Domain Reflectometer (OTDR) Exam - Certified Network Cabling Design Professional (CNCDP©) The exam is a 60-minute closed book exam, with 40 multiple-choice questions. The candidate requires a minimum of 27 correct answers to pass the exam. Additional course details: Nexus Humans Certified Network Cabling Design Professional (CNCDP) 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 Certified Network Cabling Design Professional (CNCDP) 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.

Certified Network Cabling Design Professional (CNCDP)
Delivered OnlineFlexible Dates
£1,250

Strategic Business Forecasting: Mapping Your Path to Expansion

By Compete High

🚀 Unlock Your Business Potential with 'Strategic Business Forecasting: Mapping Your Path to Expansion' 🚀   Are you ready to elevate your business to new heights? Introducing our comprehensive online course designed to empower you with the skills and knowledge needed to strategically forecast and map out your path to expansion.   🌐 MODULE 1: Introduction Dive into the fundamentals of strategic business forecasting. Understand the importance of foresight in the business world and learn how effective forecasting can be a game-changer for your organization. Lay the foundation for the exciting journey ahead. 📈 MODULE 2: Determine Your Growth Projections Discover the art and science behind growth projections. Uncover the methodologies and tools used by successful businesses to forecast their expansion. From market analysis to trend identification, this module equips you with the skills to make informed decisions and set realistic growth targets. 🛠️ MODULE 3: Workshop Put theory into practice with our hands-on workshop. Work through real-world scenarios and apply the strategic forecasting techniques you've learned. Receive personalized feedback from industry experts to fine-tune your approach. This module is your opportunity to refine your skills and gain confidence in your forecasting abilities.   🔥 Key Course Highlights: ✅ In-depth exploration of strategic forecasting principles. ✅ Practical techniques for growth projection and risk assessment. ✅ Interactive workshop for hands-on application. ✅ Expert insights and industry best practices. ✅ Networking opportunities with like-minded professionals.   🎓 Who Should Enroll: Business Owners Entrepreneurs Managers and Executives Decision-Makers Anyone aspiring to lead business expansion efforts   🌟 Why Choose 'Strategic Business Forecasting'?: In today's dynamic business landscape, the ability to anticipate and plan for the future is a key differentiator. This course not only provides you with the theoretical knowledge but also ensures that you can apply these concepts in a practical setting. Join us on this transformative journey and take control of your business's destiny.   🚨 Limited Seats Available! Secure Your Spot Today. Don't miss out on this opportunity to revolutionize your business strategy. Enroll now and gain the skills you need to confidently map your path to expansion.   🔗 [Enroll Now] - Your Future Awaits: [Course Link]   🌐 Strategic Business Forecasting: Mapping Your Path to Expansion - Because Success Favors the Strategically Prepared! 🚀   Course Curriculum Module 1- Introduction Market Growth Explained 08:42 Module 1- Determine Your Growth Projections Determining Your Growth Projections 01:06 Step 1 - Research Growth Rates 10:01 Step 2 - Position Your Business for Growth 04:19 Step 3 - Telling the Growth Story 01:00 Step 4 - Calculating Your CAGR 04:28 Drone Market Case Study (Optional) 05:41 Troubleshooting 00:53 Module 3- Workshop Workshop - Growth Projections in Action 03:45

Strategic Business Forecasting: Mapping Your Path to Expansion
Delivered Online On Demand1 hour
£4.99

DP-203T00 Data Engineering on Microsoft Azure

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure. In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage. Prerequisites Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Introduction to data engineering on Azure What is data engineering Important data engineering concepts Data engineering in Microsoft Azure 2 - Introduction to Azure Data Lake Storage Gen2 Understand Azure Data Lake Storage Gen2 Enable Azure Data Lake Storage Gen2 in Azure Storage Compare Azure Data Lake Store to Azure Blob storage Understand the stages for processing big data Use Azure Data Lake Storage Gen2 in data analytics workloads 3 - Introduction to Azure Synapse Analytics What is Azure Synapse Analytics How Azure Synapse Analytics works When to use Azure Synapse Analytics 4 - Use Azure Synapse serverless SQL pool to query files in a data lake Understand Azure Synapse serverless SQL pool capabilities and use cases Query files using a serverless SQL pool Create external database objects 5 - Use Azure Synapse serverless SQL pools to transform data in a data lake Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement Encapsulate data transformations in a stored procedure Include a data transformation stored procedure in a pipeline 6 - Create a lake database in Azure Synapse Analytics Understand lake database concepts Explore database templates Create a lake database Use a lake database 7 - Analyze data with Apache Spark in Azure Synapse Analytics Get to know Apache Spark Use Spark in Azure Synapse Analytics Analyze data with Spark Visualize data with Spark 8 - Transform data with Spark in Azure Synapse Analytics Modify and save dataframes Partition data files Transform data with SQL 9 - Use Delta Lake in Azure Synapse Analytics Understand Delta Lake Create Delta Lake tables Create catalog tables Use Delta Lake with streaming data Use Delta Lake in a SQL pool 10 - Analyze data in a relational data warehouse Design a data warehouse schema Create data warehouse tables Load data warehouse tables Query a data warehouse 11 - Load data into a relational data warehouse Load staging tables Load dimension tables Load time dimension tables Load slowly changing dimensions Load fact tables Perform post load optimization 12 - Build a data pipeline in Azure Synapse Analytics Understand pipelines in Azure Synapse Analytics Create a pipeline in Azure Synapse Studio Define data flows Run a pipeline 13 - Use Spark Notebooks in an Azure Synapse Pipeline Understand Synapse Notebooks and Pipelines Use a Synapse notebook activity in a pipeline Use parameters in a notebook 14 - Plan hybrid transactional and analytical processing using Azure Synapse Analytics Understand hybrid transactional and analytical processing patterns Describe Azure Synapse Link 15 - Implement Azure Synapse Link with Azure Cosmos DB Enable Cosmos DB account to use Azure Synapse Link Create an analytical store enabled container Create a linked service for Cosmos DB Query Cosmos DB data with Spark Query Cosmos DB with Synapse SQL 16 - Implement Azure Synapse Link for SQL What is Azure Synapse Link for SQL? Configure Azure Synapse Link for Azure SQL Database Configure Azure Synapse Link for SQL Server 2022 17 - Get started with Azure Stream Analytics Understand data streams Understand event processing Understand window functions 18 - Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics Stream ingestion scenarios Configure inputs and outputs Define a query to select, filter, and aggregate data Run a job to ingest data 19 - Visualize real-time data with Azure Stream Analytics and Power BI Use a Power BI output in Azure Stream Analytics Create a query for real-time visualization Create real-time data visualizations in Power BI 20 - Introduction to Microsoft Purview What is Microsoft Purview? How Microsoft Purview works When to use Microsoft Purview 21 - Integrate Microsoft Purview and Azure Synapse Analytics Catalog Azure Synapse Analytics data assets in Microsoft Purview Connect Microsoft Purview to an Azure Synapse Analytics workspace Search a Purview catalog in Synapse Studio Track data lineage in pipelines 22 - Explore Azure Databricks Get started with Azure Databricks Identify Azure Databricks workloads Understand key concepts 23 - Use Apache Spark in Azure Databricks Get to know Spark Create a Spark cluster Use Spark in notebooks Use Spark to work with data files Visualize data 24 - Run Azure Databricks Notebooks with Azure Data Factory Understand Azure Databricks notebooks and pipelines Create a linked service for Azure Databricks Use a Notebook activity in a pipeline Use parameters in a notebook Additional course details: Nexus Humans DP-203T00 Data Engineering on Microsoft Azure 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 DP-203T00 Data Engineering on Microsoft Azure 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.

DP-203T00 Data Engineering on Microsoft Azure
Delivered OnlineFlexible Dates
£2,380