679 PIP courses in Sheffield delivered Online

Elevate your real estate wholesaling game with this comprehensive masterclass. From property acquisition and analysis to negotiating with sellers and reducing risk, this course is a step-by-step guide to mastering every facet of the wholesaling business.

Gas Engineer: Gas Engineer Are you excited to gain the skills and knowledge needed to operate with gas systems in both residential and commercial settings? Our gas engineer course provides all the information about it, along with safety and professionalism. Our gas engineer course covers the installation process, upkeep, and repair of gas appliances, along with problem detection. Also, this gas engineer course explains both theoretical and practical training. Students of our gas engineer course may usually apply for Gas Safe registration after they graduate, which is a legal prerequisite for working as a gas engineer in the UK. In this gas engineer course, you will learn about emergency isolation controls, gas rates, and appliance pressures. Without any delay, join our gas engineer course and start a career as a commercial gas engineer! Learning Outcomes of the Gas Engineer Course This Gas Engineer Course covers: Mastering gas basics, combustion, and gas transmission through pipes. Understanding ventilation, tightness testing techniques, and metre regulators. Learning about appliance pressures and gas rates. Gaining knowledge on emergency isolation controls and valves. Exploring gas safety devices and controls. Understanding warning labels, emergency protocols, and evacuation procedures. Comprehensive insights into gas safety laws. Special Offers Of this Gas Engineer: Gas Engineer course This Gas Engineer: Gas Engineer course includes a FREE PDF Certificate. Lifetime access to this Gas Engineer: Gas Engineer course Instant access to this Gas Engineer: Gas Engineer course Get FREE Tutor Support from Monday to Friday in this Gas Engineer: Gas Engineer course. [ Note: Free Digital certificate as soon as completing the Gas Engineer: Gas Engineer course] Gas Engineer: Gas Engineer Elevate your expertise with our Gas Engineer: Gas Engineer Course, designed to take you from fundamental gas concepts to mastering advanced skills. In our Gas Engineer: Gas Engineer Course, you’ll delve into essential topics such as gas transmission through pipes, ventilation, and tightness testing techniques. This Gas Engineer: Gas Engineer Course also offers in-depth training on metre regulators, appliance pressures, and gas rates. Furthermore, our Gas Engineer: Gas Engineer Course ensures you’re fully equipped with the knowledge of emergency isolation controls and comprehensive gas safety devices and controls. Enroll now in our Gas Engineer: Gas Engineer Course to excel in the industry. Who is this course for? Gas Engineer: Gas Engineer Students interested in a career in gas installation, maintenance, and safety should enrol in the Gas Engineer course. Requirements Gas Engineer: Gas Engineer To enrol in this Gas Engineer: Gas Engineer Course Course, students must fulfil the following requirements. To join in our Gas Engineer: Gas Engineer Course, you must have a strong command of the English language. To successfully complete our Gas Engineer: Gas Engineer Course, you must be vivacious and self driven. To complete our Gas Engineer: Gas Engineer Course, you must have a basic understanding of computers. Career path Gas Engineer: Gas Engineer With the help of our gas engineer course, you may get the industrial profession you want.

Plumbing: Plumbing Training Course You can better equip yourself to pursue your ideal job by enrolling in our professional plumbing course. Are you interested in starting a career as a plumber or in acquiring more sophisticated plumbing abilities? Then this expert Professional Plumbing course will provide you with a firm foundation to help you develop into a competent plumber. With the help of our Professional Plumbing Course, you can gain more advanced abilities and increase your production and efficiency. The Professional Plumbing Course covers all of the most recent topics to keep you up to date on all the pertinent information. By enrolling in this excellent Professional Plumbing course, you can upgrade your knowledge and skills. In this professional plumbing course, all the fundamentals of plumbing are presented in detail. After finishing this Professional Plumbing course for professionals, you'll be more productive and committed at work. The Professional Plumbing Course will assist you in recognising the instruments, machinery, and supplies used or put to use in plumbing. Additionally, this Professional Plumbing Course will show you how to use the materials to boost efficiency and decrease inefficiency, as well as what they are used for. You will also receive easy-to-digest modules and learning resources in this Professional Plumbing course. This Professional Plumbing course gives you the opportunity to stand out in your future job. Also, your resume will benefit from the necessary abilities you acquire after finishing this professional plumbing course. Enrol in our Professional Plumbing Course right away to pursue your goals and acquire the knowledge, experience, and abilities necessary to progress your career. Main Course: Plumbing Training Free Courses are including with this Plumbing: Plumbing Training Course Along with The Plumbing Training Course, We Offer a free Workplace First Aid Training Course Along with Plumbing Training Course, We Offer a free Level 1 Health and Safety in a Construction Environment Course Special Offers of this Plumbing: Plumbing Training - CPD Accredited Course This Plumbing: Plumbing Training Course includes a FREE PDF Certificate. Lifetime access to this Plumbing: Plumbing Training Course Instant access to this Plumbing: Plumbing Training Course Get FREE Tutor Support to this Plumbing: Plumbing Training Course Plumbing: Plumbing Online Training Plumbing specialists install and service water systems and pipes in both residential and commercial structures. Are you looking to further your plumbing abilities or embark on a new plumbing career? Then, you may enhance your career as a professional plumber by gaining the essential information and abilities from our Plumbing: Plumbing Course. Whether you are a self-taught plumber looking to fill in the gaps for increased productivity and efficiency, or you are a skilled worker looking to expand your skills, this Plumbing: Plumbing Course will provide you a strong foundation to help you become a confident plumber. Who is this course for? Plumbing: Plumbing Online Training Anybody wishing to improve their career or increase job prospects in the plumbing business will greatly benefit from this thorough Professional Plumbing: Plumbing Training Course. Requirements Plumbing: Plumbing Training Course To enrol in this Plumbing: Plumbing Training Course, students must fulfil the following requirements. To join in our Plumbing Training Course, you must have a strong command of the English language. To successfully complete our Plumbing Training Course, you must be vivacious and self driven. To complete our Plumbing Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Plumbing Training Course. Career path Plumbing: Plumbing Training Course This professional plumbing: Plumbing Training course enables you to enter the relevant job market and add your new skills to your resume.

In today’s competitive B2B landscape, knowing how to sell and market effectively isn’t just a bonus—it’s essential. This course dives straight into the core of what makes B2B sales and marketing click. It’s designed for those who want sharper tactics, smarter communication strategies, and better client conversions. We’re talking about positioning, persuasion, and pipelines—all without the fluff or filler. Whether you're looking to fine-tune your messaging or build stronger relationships with decision-makers, this is your strategic edge. Delivered entirely online for full flexibility, this course blends marketing precision with sales finesse. You’ll explore what actually influences buyer behaviour, how to align sales efforts with marketing goals, and why timing and tone matter more than ever. Forget the jargon—this course speaks the language of results. If you're ready to think like a strategist and sell like a pro, you're in the right place. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to B2B Sales and Marketing Module 02: Understanding the B2B Buyer Module 03: Creating A B2b Marketing Strategy Module 04: Sales And Marketing Alignment Module 05: Building A B2b Sales Team Module 06: B2b Lead Generation Module 07: B2B Sales Techniques Module 08: B2b Sales Management Module 09: Customer Relationship Management Module 10: Global B2b Sales And Marketing Learning Outcomes: Analyse B2B buyer behaviour for strategic insights. Develop and execute effective B2B marketing strategies. Foster alignment between sales and marketing efforts. Build and manage a successful B2B sales team. Implement lead generation techniques for sustainable growth. Master B2B sales techniques and customer relationship management. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 21 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Sales professionals looking to enhance their B2B sales skills. Marketing specialists aiming to understand B2B marketing strategies. Business owners seeking to improve their B2B sales and marketing efforts. Recent graduates aspiring to work in the B2B sales and marketing industry. Career changers interested in transitioning to the B2B sector. Entrepreneurs wanting to grow their B2B businesses. Career path B2B Sales Manager B2B Marketing Specialist Account Executive Business Development Manager Sales Operations Analyst Customer Relationship Manager Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Overview TThe demand for skilled professionals in the plumbing industry is rapidly increasing, making it one of the most sought-after trades globally. The Professional Plumbing course is designed to equip you with essential plumbing skills and knowledge to excel in this hands-on career. From understanding pipe systems to mastering plumbing installation and maintenance, this course covers every crucial aspect of the plumbing trade. Throughout the course, you will learn about water systems, sanitation practices, and how to troubleshoot common plumbing issues. Gain expertise in plumbing regulations, safety standards, and using the latest plumbing tools and techniques to ensure efficiency and compliance. Whether you're starting your career or looking to advance in the plumbing industry, this course offers the foundation for success. Enrol today in the Professional Plumbing course and gain the practical knowledge required to excel as a plumbing technician or plumbing engineer. Start building a career in a thriving industry that offers stability and growth opportunities. So enrol in this course today to fast track your career ladder. Key Features of the Course: FREE Professional Plumbing CPD-accredited certificate Get a free student ID card with Professional Plumbing training (£10 applicable for international delivery) Lifetime access to the Professional Plumbing course materials The Professional Plumbing program comes with 24/7 tutor support Get instant access to this Professional Plumbing course Learn Professional Plumbing training from anywhere in the world The Professional Plumbing training is affordable and simple to understand The Professional Plumbing training is an entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the Professional Plumbing course. After successfully completing the Professional Plumbing 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 Professional Plumbing. It is available to all students, of all academic backgrounds. Requirements Our Professional Plumbing 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 Unlock a range of career opportunities with the Professional Plumbing course. Explore these rewarding paths: Plumbing Technician Plumbing Engineer Pipefitter Maintenance Plumber Sanitation Specialist Plumbing Supervisor Course Curriculum 12 sections • 12 lectures •Basic Components of Plumbing •Principles of Effective Plumbing Systems •Tools Used for Plumbing: •Process of Plumbing •Central Heating Systems •Domestic Cold-Water System •Hot Water System - Part 1 •Hot Water System - Part 2 •The Sanitation System and Repairs •Installation of a Domestic Rainwater System •Plumbing Projects Case Study •Plumbing Standards in the UK

The Plumbing Skills Training Course is organised into 2 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 9 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Plumbing Skills Training Course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Diploma in Cake Frosting is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Cake Frosting and looks at skills needed to improve Cake Frosting. By taking this course you will gain the necessary skills to perform effectively in this field. The Diploma in Cake Frosting is organised into 1 module and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 6hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: DevOps engineers DevOps architects Operations engineers System administrators Developers Overview In this course, you will learn to: Use DevOps best practices to develop, deliver, and maintain applications and services at high velocity on AWS List the advantages, roles and responsibilities of small autonomous DevOps teams Design and implement an infrastructure on AWS that supports DevOps development projects Leverage AWS Cloud9 to write, run and debug your code Deploy various environments with AWS CloudFormation Host secure, highly scalable, and private Git repositories with AWS CodeCommit Integrate Git repositories into CI/CD pipelines Automate build, test, and packaging code with AWS CodeBuild Securely store and leverage Docker images and integrate them into your CI/CD pipelines Build CI/CD pipelines to deploy applications on Amazon EC2, serverless applications, and container-based applications Implement common deployment strategies such as 'all at once,' 'rolling,' and 'blue/green' Integrate testing and security into CI/CD pipelines Monitor applications and environments using AWS tools and technologies DevOps Engineering on AWS teaches you how to use the combination of DevOps cultural philosophies, practices, and tools to increase your organization?s ability to develop, deliver, and maintain applications and services at high velocity on AWS. This course covers Continuous Integration (CI), Continuous Delivery (CD), infrastructure as code, microservices, monitoring and logging, and communication and collaboration. Hands-on labs give you experience building and deploying AWS CloudFormation templates and CI/CD pipelines that build and deploy applications on Amazon Elastic Compute Cloud (Amazon EC2), serverless applications, and container-based applications. Labs for multi-pipeline workflows and pipelines that deploy to multiple environments are also included. Module 0: Course overview Course objective Suggested prerequisites Course overview breakdown Module 1: Introduction to DevOps What is DevOps? The Amazon journey to DevOps Foundations for DevOps Module 2: Infrastructure automation Introduction to Infrastructure Automation Diving into the AWS CloudFormation template Modifying an AWS CloudFormation template Demonstration: AWS CloudFormation template structure, parameters, stacks, updates, importing resources, and drift detection Module 3: AWS toolkits Configuring the AWS CLI AWS Software Development Kits (AWS SDKs) AWS SAM CLI AWS Cloud Development Kit (AWS CDK) AWS Cloud9 Demonstration: AWS CLI and AWS CDK Hands-on lab: Using AWS CloudFormation to provision and manage a basic infrastructure Module 4: Continuous integration and continuous delivery (CI/CD) with development tools CI/CD Pipeline and Dev Tools Demonstration: CI/CD pipeline displaying some actions from AWS CodeCommit, AWS CodeBuild, AWS CodeDeploy and AWS CodePipeline Hands-on lab: Deploying an application to an EC2 fleet using AWS CodeDeploy AWS CodePipeline Demonstration: AWS integration with Jenkins Hands-on lab: Automating code deployments using AWS CodePipeline Module 5: Introduction to Microservices Introduction to Microservices Module 6: DevOps and containers Deploying applications with Docker Amazon Elastic Container Service and AWS Fargate Amazon Elastic Container Registry and Amazon Elastic Kubernetes service Demonstration: CI/CD pipeline deployment in a containerized application Module 7: DevOps and serverless computing AWS Lambda and AWS Fargate AWS Serverless Application Repository and AWS SAM AWS Step Functions Demonstration: AWS Lambda and characteristics Demonstration: AWS SAM quick start in AWS Cloud9 Hands-on lab: Deploying a serverless application using AWS Serverless Application Model (AWS SAM) and a CI/CD Pipeline Module 8: Deployment strategies Continuous Deployment Deployments with AWS Services Module 9: Automated testing Introduction to testing Tests: Unit, integration, fault tolerance, load, and synthetic Product and service integrations Module 10: Security automation Introduction to DevSecOps Security of the Pipeline Security in the Pipeline Threat Detection Tools Demonstration: AWS Security Hub, Amazon GuardDuty, AWS Config, and Amazon Inspector Module 11: Configuration management Introduction to the configuration management process AWS services and tooling for configuration management Hands-on lab: Performing blue/green deployments with CI/CD pipelines and Amazon Elastic Container Service (Amazon ECS) Module 12: Observability Introduction to observability AWS tools to assist with observability Hands-on lab: Using AWS DevOps tools for CI/CD pipeline automations Module 13: Reference architecture (Optional module) Reference architectures Module 14: Course summary Components of DevOps practice CI/CD pipeline review AWS Certification

Duration 4 Days 24 CPD hours This course is intended for Students in this course are interested in implementing DevOps processes or in passing the Microsoft Azure DevOps Solutions certification exam. Overview After completing this course, students will be able to: Plan for the transformation with shared goals and timelines Select a project and identify project metrics and Key Performance Indicators (KPI's) Create a team and agile organizational structure Design a tool integration strategy Design a license management strategy (e.g., Azure DevOps and GitHub users) Design a strategy for end-to-end traceability from work items to working software Design an authentication and access strategy Design a strategy for integrating on-premises and cloud resources Describe the benefits of using Source Control Describe Azure Repos and GitHub Migrate from TFVC to Git Manage code quality including technical debt SonarCloud, and other tooling solutions Build organizational knowledge on code quality Explain how to structure Git repos Describe Git branching workflows Leverage pull requests for collaboration and code reviews Leverage Git hooks for automation Use Git to foster inner source across the organization Explain the role of Azure Pipelines and its components Configure Agents for use in Azure Pipelines Explain why continuous integration matters Implement continuous integration using Azure Pipelines Define Site Reliability Engineering Design processes to measure end-user satisfaction and analyze user feedback Design processes to automate application analytics Manage alerts and reduce meaningless and non-actionable alerts Carry out blameless retrospectives and create a just culture Define an infrastructure and configuration strategy and appropriate toolset for a release pipeline and application infrastructure Implement compliance and security in your application infrastructure Describe the potential challenges with integrating open-source software Inspect open-source software packages for security and license compliance Manage organizational security and compliance policies Integrate license and vulnerability scans into build and deployment pipelines Configure build pipelines to access package security and license ratings This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms. Module 1: Get started on a DevOps transformation journey Introduction to DevOps Choose the right project Describe team structures Choose the DevOps tools Plan Agile with GitHub Projects and Azure Boards Introduction to source control Describe types of source control systems Work with Azure Repos and GitHub Module 2: Development for enterprise DevOps Structure your Git Repo Manage Git branches and workflows Collaborate with pull requests in Azure Repos Explore Git hooks Plan foster inner source Manage Git repositories Identify technical debt Module 3: Implement CI with Azure Pipelines and GitHub Actions Explore Azure Pipelines Manage Azure Pipeline agents and pools Describe pipelines and concurrency Explore Continuous integration Implement a pipeline strategy Integrate with Azure Pipelines Introduction to GitHub Actions Learn continuous integration with GitHub Actions Design a container build strategy Module 4: Design and implement a release strategy Introduction to continuous delivery Explore release strategy recommendations Build a high-quality release pipeline Introduction to deployment patterns Implement blue-green deployment and feature toggles Implement canary releases and dark launching Implement A/B testing and progressive exposure deployment Module 5: Implement a secure continuous deployment using Azure Pipelines Create a release pipeline Provision and test environments Manage and modularize tasks and templates Automate inspection of health Manage application configuration data Integrate with identity management systems Implement application configuration Module 6: Manage infrastructure as code using Azure and DSC Explore infrastructure as code and configuration management Create Azure resources using Azure Resource Manager templates Create Azure resources by using Azure CLI Explore Azure Automation with DevOps Implement Desired State Configuration (DSC) Implement Bicep Module 7: Implement security and validate code bases for compliance Introduction to Secure DevOps Implement open-source software Software Composition Analysis Static analyzers OWASP and Dynamic Analyzers Security Monitoring and Governance Module 8: Design and implement a dependency management strategy Explore package dependencies Understand package management Migrate, consolidate, and secure artifacts Implement a versioning strategy Introduction to GitHub Packages Module 9: Implement continuous feedback Implement tools to track usage and flow Develop monitor and status dashboards Share knowledge within teams Design processes to automate application analytics Manage alerts, Blameless retrospectives and a just culture Additional course details: Nexus Humans AZ-400 Designing and Implementing Microsoft DevOps 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 AZ-400 Designing and Implementing Microsoft DevOps 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.

Duration 4 Days 24 CPD hours This course is intended for This class is intended for experienced developers who are responsible for managing big data transformations including: Extracting, loading, transforming, cleaning, and validating data. Designing pipelines and architectures for data processing. Creating and maintaining machine learning and statistical models. Querying datasets, visualizing query results and creating reports Overview Design and build data processing systems on Google Cloud Platform. Leverage unstructured data using Spark and ML APIs on Cloud Dataproc. Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow. Derive business insights from extremely large datasets using Google BigQuery. Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML. Enable instant insights from streaming data Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data. Introduction to Data Engineering Explore the role of a data engineer. Analyze data engineering challenges. Intro to BigQuery. Data Lakes and Data Warehouses. Demo: Federated Queries with BigQuery. Transactional Databases vs Data Warehouses. Website Demo: Finding PII in your dataset with DLP API. Partner effectively with other data teams. Manage data access and governance. Build production-ready pipelines. Review GCP customer case study. Lab: Analyzing Data with BigQuery. Building a Data Lake Introduction to Data Lakes. Data Storage and ETL options on GCP. Building a Data Lake using Cloud Storage. Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions. Securing Cloud Storage. Storing All Sorts of Data Types. Video Demo: Running federated queries on Parquet and ORC files in BigQuery. Cloud SQL as a relational Data Lake. Lab: Loading Taxi Data into Cloud SQL. Building a Data Warehouse The modern data warehouse. Intro to BigQuery. Demo: Query TB+ of data in seconds. Getting Started. Loading Data. Video Demo: Querying Cloud SQL from BigQuery. Lab: Loading Data into BigQuery. Exploring Schemas. Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA. Schema Design. Nested and Repeated Fields. Demo: Nested and repeated fields in BigQuery. Lab: Working with JSON and Array data in BigQuery. Optimizing with Partitioning and Clustering. Demo: Partitioned and Clustered Tables in BigQuery. Preview: Transforming Batch and Streaming Data. Introduction to Building Batch Data Pipelines EL, ELT, ETL. Quality considerations. How to carry out operations in BigQuery. Demo: ELT to improve data quality in BigQuery. Shortcomings. ETL to solve data quality issues. Executing Spark on Cloud Dataproc The Hadoop ecosystem. Running Hadoop on Cloud Dataproc. GCS instead of HDFS. Optimizing Dataproc. Lab: Running Apache Spark jobs on Cloud Dataproc. Serverless Data Processing with Cloud Dataflow Cloud Dataflow. Why customers value Dataflow. Dataflow Pipelines. Lab: A Simple Dataflow Pipeline (Python/Java). Lab: MapReduce in Dataflow (Python/Java). Lab: Side Inputs (Python/Java). Dataflow Templates. Dataflow SQL. Manage Data Pipelines with Cloud Data Fusion and Cloud Composer Building Batch Data Pipelines visually with Cloud Data Fusion. Components. UI Overview. Building a Pipeline. Exploring Data using Wrangler. Lab: Building and executing a pipeline graph in Cloud Data Fusion. Orchestrating work between GCP services with Cloud Composer. Apache Airflow Environment. DAGs and Operators. Workflow Scheduling. Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery. Monitoring and Logging. Lab: An Introduction to Cloud Composer. Introduction to Processing Streaming Data Processing Streaming Data. Serverless Messaging with Cloud Pub/Sub Cloud Pub/Sub. Lab: Publish Streaming Data into Pub/Sub. Cloud Dataflow Streaming Features Cloud Dataflow Streaming Features. Lab: Streaming Data Pipelines. High-Throughput BigQuery and Bigtable Streaming Features BigQuery Streaming Features. Lab: Streaming Analytics and Dashboards. Cloud Bigtable. Lab: Streaming Data Pipelines into Bigtable. Advanced BigQuery Functionality and Performance Analytic Window Functions. Using With Clauses. GIS Functions. Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz. Performance Considerations. Lab: Optimizing your BigQuery Queries for Performance. Optional Lab: Creating Date-Partitioned Tables in BigQuery. Introduction to Analytics and AI What is AI?. From Ad-hoc Data Analysis to Data Driven Decisions. Options for ML models on GCP. Prebuilt ML model APIs for Unstructured Data Unstructured Data is Hard. ML APIs for Enriching Data. Lab: Using the Natural Language API to Classify Unstructured Text. Big Data Analytics with Cloud AI Platform Notebooks What's a Notebook. BigQuery Magic and Ties to Pandas. Lab: BigQuery in Jupyter Labs on AI Platform. Production ML Pipelines with Kubeflow Ways to do ML on GCP. Kubeflow. AI Hub. Lab: Running AI models on Kubeflow. Custom Model building with SQL in BigQuery ML BigQuery ML for Quick Model Building. Demo: Train a model with BigQuery ML to predict NYC taxi fares. Supported Models. Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML. Lab Option 2: Movie Recommendations in BigQuery ML. Custom Model building with Cloud AutoML Why Auto ML? Auto ML Vision. Auto ML NLP. Auto ML Tables.