43550 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.

Overview This comprehensive course on Leadership & Management: Interpersonal Skills will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Leadership & Management: Interpersonal Skills comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Leadership & Management: Interpersonal Skills. It is available to all students, of all academic backgrounds. Requirements Our Leadership & Management: Interpersonal Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 12 sections • 12 lectures • 01:41:00 total length •What are Soft Skills?: 00:09:00 •Communication: 00:06:00 •Teamwork: 00:06:00 •Problem-Solving: 00:06:00 •Time Management: 00:07:00 •Attitude and Work Ethic: 00:07:00 •Adaptability/Flexibility: 00:06:00 •Self-Confidence (Owning It): 00:08:00 •Ability to Learn From: 00:06:00 •Networking: 00:06:00 •Employee Relations: 00:15:00 •Motivation and Counselling: 00:19:00

Learn the English Speaking and Presentation Skills you need to rise to the Advanced/Proficiency Level and get the English-language job you want.

The demand for highly skilled educators has never been higher in the United Kingdom. To excel in the dynamic world of education, teachers need more than just subject knowledge – they require a holistic set of management skills to foster an enriching learning environment. That's where our Management Skills Bundle Course for Teachers comes into play!

Register on the Observation Skills for Carers today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as proof of your course completion. The Observation Skills for Carers is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Observation Skills for Carers Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Observation Skills for Carers, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Observation Skill Introduction to Observation Skill 00:30:00 Module 02: Child Observation Child Observation 00:18:00 Module 03: Child Observation Plan and Documentation Child Observation Plan and Documentation 00:13:00 Module 04: Observational Methods and Studies Observational Methods and Studies 00:21:00 Module 05: Social Policy and Social Work Observation Social Policy and Social Work Observation 00:19:00 Module 06: Basic Health Observation Basic Health Observation 00:21:00 Module 07: Clinical Management Observation Clinical Management Observation 00:15:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Learn up-to-date skills | CPD UK & IPHM Accredited | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training | Instant Result | Lifetime Access This course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Master the skills you need to propel your career forward in job interviewing. Equip yourself with the essential knowledge and skillset that make you a confident job interviewer and take your career to the next level. This comprehensive the complete job interviewing skills masterclass course is designed to help you reach your professional goals. The skills and knowledge that you will gain through studying this the complete job interviewing skills masterclass course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive the complete job interviewing skills masterclass course will teach you the theory of effective job interviewing practice and equip you with the essential skills, confidence and competence to assist you in the job interviewing industry. You'll gain a solid understanding of the core competencies required to drive a successful career in job interviewing. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive the complete job interviewing skills masterclass course is designed for job interviewing professionals who are aspiring to specialise in job interviewing. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Supplementary Resources Supplementary Resources - The Complete Job Interviewing Skills Masterclass 00:00:00 Introduction to Career Hacking and Job Interview Introduction To Recruitment And Interview Process 00:06:00 Understanding Job Advertisements 00:05:00 Practical - Extracting Information from Job Advert 00:17:00 The Complete Resume Resume Writing / CV Writing 00:07:00 Practical - Resume Writing 00:06:00 Resume writing difference between Fresher vs Experienced Job Seekers 00:02:00 Cover Letter 00:01:00 Resume and Cover Letter Proofreading Techniques 00:02:00 Job Search Job Hunting Methods 00:02:00 Job Search through Informational Interview 00:08:00 Building Network 00:09:00 Mastering Technology for Job Search Leveraging Technology for Job Search 00:03:00 Boolean Technology for Job Search 00:06:00 Use LinkedIn like a Pro 00:03:00 Monster Masterclass 00:14:00 Dice Masterclass 00:09:00 Interview Preparation Hacks Research the Company 00:06:00 Handling Interview Flutter 00:02:00 Body Language and Non-Verbal Communication 00:08:00 Interview Etiquette Face-to-Face Interview Etiquette 00:02:00 Video Interview Etiquette 00:05:00 Telephone Interview Etiquette 00:02:00 Ace Interview Questions What NOT To Say. 00:06:00 Tell Us About Yourself 00:03:00 Why Do You Want This Job. 00:03:00 What Are Your Strengths. 00:02:00 What Are Your Weaknesses. 00:02:00 What Is Your Work Style. 00:04:00 Why Are You Leaving Your Present Job. 00:02:00 What Did You Like Least About Your Last Job. 00:01:00 What Do You Think Of Your Previous Boss. 00:01:00 What's Your Ideal Company. 00:01:00 Why Do You Want To Work At This Company. 00:02:00 Why Should We Hire You. 00:03:00 Where Do You See Yourself In Next Five Years. 00:02:00 How Do You Deal With People Who Irritate You At Work. 00:02:00 How Did You Handle a Mistake. 00:02:00 How Do You Handle Disagreement With You Supervisor. 00:04:00 One Thing You Wouldn't Want Me To Know 00:02:00 Sell Me This Pen 00:02:00 What If You Can't Answer a Question. 00:03:00 Advanced Techniques to Answer Questions Answering Questions Using the S.W.O.T. Analysis 00:03:00 Answering Questions Using the B.C.G. Analysis 00:05:00 Turning the Tables Do You Have Any Questions For Us. 00:02:00 Salary Negotiation 00:02:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview Two skills which are vital to an administration specialist are Touch Typing and Shorthand. Master these abilities and stand out in any organisation. This popular Touch Typing Essential Skills Level 3 course will teach you the techniques that make these two essential abilities achievable and boost your CV's contents. Both Touch Typing (Keyboard) and Shorthand (Writing) allow an individual to increase the accuracy and productivity of the work they produce. When you pass this certified course and assessments, you will be able to set yourself up for numerous career opportunities. From journalist to a stenographer, and from Personal Assistant to Bookkeeper, all career paths will be possible. How will I get my certificate? At the end of the course there will be an online MCQ test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Touch Typing Essential Skills Level 3. It is available to all students, of all academic backgrounds. Requirements Our Touch Typing Essential Skills Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 12 lectures • 01:00:00 total length •Module 01: Getting Started: 00:05:00 •Module 02: DRILL 1 The home keys: 00:05:00 •Module 03: DRILL 2 e and i, g and h: 00:05:00 •Module 04: DRILL 3 o and n, shift keys and t: 00:05:00 •Module 05: DRILL 4 extra practice . and y: 00:05:00 •Module 06: DRILL 5 , and w: 00:05:00 •Module 07: DRILL 6 m and u: 00:05:00 •Module 08: DRILL 7 v and x: 00:05:00 •Module 09: DRILL 8 sentence drills: 00:05:00 •Module 10: DRILL 9 figures: 00:05:00 •Module 11: DRILL 10 alphabetical paragraphs: 00:05:00 •Module 12: Recap: 00:05:00

Duration 4 Days 24 CPD hours This course is intended for If you're a developer with a keen interest in providing automated solutions for your organization, this certification could be a great fit for you. You automate time-consuming and repetitive tasks by using Microsoft Power Automate. You review solution requirements, create process documentation, and design, develop, deploy, integrate, troubleshoot, and evaluate solutions. Working with business stakeholders, you help to improve and automate business workflows. Overview After completing this course, students will be able to: Design RPA solutions Develop RPA solutions Deploy and manage RPA solutions Candidates for this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions. Module 1: Get started with Power Automate for desktop Get started with Power Automate for desktop by learning about flows, creating automated steps, and flow development essentials. Module 2: Automate processes with Robotic Process Automation and Power Automate for desktop Work with Power Automate for desktop to record Windows and Web applications, but also use out of box actions such as manipulating Excel documents as part of an end to end invoice processing solution. Module 3: Work with Power Automate for desktop Work with Power Automate for desktop options, flows, recording features, conditions, loops, variables, images, and error and exception handling. Module 4: Work with different technologies in Power Automate for desktop Learn how to automate email handling, Excel, user interface, and system services with Power Automate for desktop. Module 5: Implement advanced logic in Power Automate for desktop Learn how to work with system flows, control flows, mimic mouse actions, as well as operations used to manipulate text, date, and time in Power Automate for desktop. Module 6: Build expertise with Power Automate for desktop Learn how to use Power Automate for desktop to work with Power Automate, OCR technologies, and scripting. Module 7: Build custom connectors for Power Automate This Learning Path explores custom connectors and explains how to configure them and use them with Microsoft Power Automate Module 8: Use best practices to secure and govern Microsoft Power Platform environments This module focuses on introducing Microsoft Power Platform environments and their role in creating Data Loss Prevention (DLP) policies by using examples and use cases. A brief introduction and overview of tools will also be discussed, including Microsoft Power Platform and Power Automate Admin experiences and Microsoft Power Platform Center of Excellence (COE) toolkit. Additional course details: Nexus Humans PL-500T00 Microsoft Power Automate RPA Developer 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 PL-500T00 Microsoft Power Automate RPA Developer 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.

***24 Hour Limited Time Flash Sale*** Pharmacology, Pharmacy Skills & Administration QLS Endorsed Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Presenting our "Pharmacology, Pharmacy Skills & Administration QLS Endorsed" course bundle, your key to unlocking a wealth of knowledge in the field of pharmacology and medical administration. This bundle includes three QLS-endorsed courses: 'Pharmacology', 'Diploma in Pharmacy Skills', and 'Medical & Clinical Administration Diploma', each awarding a hardcopy certificate upon completion. Supplementing this robust learning pathway, our bundle features five CPD QS-accredited courses. These courses are meticulously designed to enhance your theoretical understanding and broaden your knowledge horizon in the medical field. Elevate your learning journey by diving into the multifaceted world of pharmacology and clinical administration. Equip yourself with our comprehensive course bundle today! Key Features of the Pharmacology, Pharmacy Skills & Administration QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Pharmacology, Pharmacy Skills & Administration QLS Endorsed bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Pharmacology QLS Course 02: Diploma in Pharmacy Skills QLS Course 03: Medical & Clinical Administration Diploma 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Medical Terminology Training Course 02: Urine Catheterisation Training Course 03: Paediatric First Aid & Medical Emergencies Course 04: Phlebotomy Technician Training Course 05: Emergency Medicine - Paramedicine In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Pharmacology, Pharmacy Skills & Administration QLS Endorsed courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the fundamental principles of pharmacology. Gain theoretical insights into pharmacy skills and procedures. Acquire knowledge on medical and clinical administration. Grasp the nuances of medical terminologies. Learn about urine catheterisation and phlebotomy procedures. Understand paediatric first aid and medical emergencies. Gain insights into the field of emergency medicine and paramedicine. The 'Pharmacology, Pharmacy Skills & Administration QLS Endorsed bundle offers a comprehensive exploration into the theoretical aspects of pharmacology, pharmacy practices, and clinical administration. The bundle combines three QLS-endorsed courses and five CPD QS-accredited courses, creating a well-rounded learning experience. By delving into the intricacies of pharmacology, medical terminologies, clinical emergencies, and more, you prepare yourself for an enriched understanding of the medical field. Start this transformative journey with us today! CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring professionals eager to enter the medical or pharmaceutical fields. Current medical or pharmaceutical professionals seeking to enhance their theoretical knowledge. Anyone interested in gaining an in-depth theoretical understanding of pharmacology and medical administration. Career path Pharmacologist - £26,000 - £60,000 Pharmacy Technician - £20,000 - £30,000 Clinical Administrator - £18,000 - £28,000 Emergency Medical Technician - £22,000 - £35,000 Phlebotomy Technician - £15,000 - £25,000 Medical Secretary - £20,000 - £35,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

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.