35841 Design courses in Solihull delivered Online

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.

ICA Specialist Certificate in Corporate Governance - Course Overview Corporate governance is a key driver in delivering the right outcomes for organisations and helping them to meet corporate objectives. Regulators view effective corporate governance mechanisms as good indicators of a firm's culture of compliance because good governance is likely to indicate good internal culture. This online course will help you: get to grips with the purpose, key success factors and risks associated with governance understand the impact of good governance on the success of organisational strategies assess and design frameworks that serve your firm's objectives and improve performance evaluate the impact of the digital revolution on governance and future developments ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. Upon successful completion of this course, students will be awarded the ICA Certificate in Corporate Governance and will be entitled to use the designation -Spec.Cert(CorpGov) The function and purpose of the organisation The governance of regulated enterprise and the purpose of the Board of Directors The importance, impact and opportunity of organisational culture Conflict management in the organisation Organisational structure, hierarchy and policy frameworks Communication strategy Internal control and influence power Broad-base governance - beyond the balance sheet The digital revolution and its influence on governance Governance - a never ending story

***24 Hour Limited Time Flash Sale*** Construction Management and Construction Safety - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter The construction industry employs over 2.3 million people in the UK, contributing significantly to the economy. But did you know that construction also carries inherent risks? Ensuring safety on site is crucial, not only for workers but also for the project's success. Are you interested in becoming part of this dynamic industry while prioritising safety? If so, this comprehensive Construction Management and Construction Safety bundle is for you! With this Construction Management and Construction Safety course you will get 30 CPD Accredited PDF Certificates, Hard Copy Certificate Construction Management - Course and our exclusive student ID card absolutely free. Courses Are Included In This Construction Management and Construction Safety Bundle: Course 01: Construction Management - Course Course 02: Site Management Safety Training Course 03: Diploma in Construction Industry Scheme (CIS) Course 04: LEED V4 - Building Design and Construction Course 05: Revit Architecture Ultimate Interior Design Course Course 06: Building Surveying Practice Course 07: Architectural Studies Course 08: Complete Lean Six Sigma Green Belt Course for Service Industry Course 09: Solidworks: Beginner to Advanced Course 10: Construction Cost Estimation Course 11: Introduction to Xactimate: Construction Cost Estimation Course 12: Construction Site Management Course 13: Facilities Management Certificate (FMC) Course 14: CDM Regulations Training Course 15: Property Law Course 16: Advanced Property Development Training Course 17: Property Management Training Course 18: Residential Property Sales Course 19: Security Management Course 20: Construction Safety Course 21: Lone Worker Safety Course 22: Risk Management : Risk Assessment Diploma Course 23: Warehouse Safety Training Course 24: Working in Confined Spaces Course 25: Health and Safety at Workplace Course 26: Ladder Safety Course 27: Fire Safety Awareness Course 28: Gas Safety Course 29: Electrical Safety Course 30: BASIC ELECTRICITY COURSE Embarking on Construction Management and Construction Safety is more than just taking an online course; it's an investment in your future. By completing this Construction Management and Construction Safety bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Don't miss this chance to elevate your career and skillset. Enrol in Construction Management and Construction Safety today and take the first step towards achieving your goals and dreams. Start your learning journey straightaway! Certification You have to complete the assignment given at the end of the Construction Management and Construction Safety course and score a minimum of 60% to pass each exam. After passing the Construction Management and Construction Safety exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 450 CPD hours / points Accredited by CPD Quality Standards Requirements This doesn't require prior experience and is suitable for diverse learners. Career path This bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Digital certificate CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

In this series we invite globally respected studios to walk us through the processes and methods they employ when working with clients.

Level 7 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Embark on a journey to become a MySQL Database Development master! Our course equips you with the skills to design, optimize, and manage databases flawlessly.

Discover the zenith of gastronomy with our comprehensive course bundle: "Food Manager, Restaurant and Catering Management - QLS Endorsed". Unlock a world of theoretical knowledge across eight diverse yet interrelated courses, all primed to sculpt you into a formidable figure in the Food & Hospitality industry. This bundle includes three prestigious QLS-endorsed courses: Food and Beverage Manager, Hospitality & Restaurant Management, and Catering & Food Safety. Each course is accompanied by a tangible hardcopy certificate, validating your mastery in these areas. In addition to these, we've incorporated five relevant CPD QS accredited courses to further bolster your theoretical comprehension. These courses weave together a tapestry of understanding that will set you apart in any professional kitchen or catering venture. Key Features of the Food Manager, Restaurant and Catering Management - QLS Endorsed Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Food Manager, Restaurant and Catering Management - 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: Food and Beverage Manager QLS Course 02: Hospitality & Restaurant Management QLS Course 03: Catering & Food Safety 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: Food Labelling Regulations Training Course 02: HACCP Training Course 03: Food Allergen Awareness Level 3 Course 04: How to Improve Your Food Hygiene Rating Course 05: Immunity Boosting Food 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 Food Manager, Restaurant and Catering Management - QLS Endorsed courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Embrace this rare opportunity to delve into an all-encompassing study of food management and catering. Take the first step towards a fulfilling career by arming yourself with an enriched understanding of food, its safety, and the dynamic world of restaurant and hospitality management. Learning Outcomes: Understand the responsibilities of a Food and Beverage Manager. Comprehend the intricacies of Restaurant and Hospitality Management. Develop knowledge of safe catering and food safety practices. Understand Food Labelling Regulations and HACCP Training. Be aware of food allergens and methods to boost food hygiene ratings. Understand the role of Immunity Boosting Food in the hospitality sector. Apply principles of design and graphic design using Canva in your professional pursuits. Unearth a treasure trove of knowledge with our "Food Manager, Restaurant and Catering Management - QLS Endorsed" course bundle. This comprehensive package provides an in-depth theoretical understanding of eight crucial areas in the food and hospitality industry. With QLS endorsed and CPD QS accredited courses, it's an immersive educational journey that promises an enriching learning experience. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking to build a career in food and beverage management. Professionals looking to enhance their knowledge in hospitality and restaurant management. Those interested in catering and food safety. Anyone interested in understanding food labelling, allergen awareness, and health-oriented food concepts. Career path Food and Beverage Manager (Salary Range: £28,000-£40,000) Restaurant Manager (Salary Range: £25,000-£38,000) Catering Manager (Salary Range: £25,000-£35,000) Food Safety Officer (Salary Range: £20,000-£32,000) Health and Safety Coordinator in Food Sector (Salary Range: £22,000-£30,000) Nutritional Advisor (Salary Range: £20,000-£35,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Our Cardiorespiratory Training for Fitness course will show you how to perform basic cardiorespiratory assessments and design unique cardiorespiratory training programs through the use of stage training. These programs will cater to individuals who want to reduce weight to the special population’s clientele.

With NASM’s Guide to Bodybuilding, you’ll reach a larger client base. This continuing education course explains the foundational concept of muscle hypertrophy as it relates to bodybuilding. Learn how to maximize hypertrophy gains in your clients, and how to effectively design hypertrophy training programs for the bodybuilding clientele.

Our Cardiorespiratory Training for Sports Performance course will show you how to perform basic cardiorespiratory assessments and design unique performance enhancement cardiorespiratory training programs through the use of stage training. These programs can be utilized to improve performance for both recreational and competitive sports.