425 Engineering courses in Cheshunt delivered Live Online

Cyber Security training course description The reliance of the world on the Internet and computer systems means the protection of information systems is vitally important. This is even more important smart devices and the Internet of Things increase the number of devices. This Cyber Security provides a concise overview on the threats and attacks that can happen along with the counter measures that can be taken. What will you learn Recognise the different types of attack. Describe the attacks that can be made against information systems. Describe the counter measures available. Cyber Security training course details Who will benefit: Non-technical staff working with computers. Prerequisites: None. Duration 1 day Cyber Security training course contents What is Cyber Security? Computer security, Policies, Types of security breach, denial of service, data manipulation, data theft, data destruction, security checklists, incident response. Attacks Physical access, Social engineering, Privilege escalation, Malware, Trojans, worms, viruses, rootkits, Backdoors, Denial of Service (DOS), Distributed DOS, Eavesdropping, Spoofing, Man the middle tampering. Countermeasures Prevention, detection, response. Physical, user accounts, Firewalls, IDS, AAA, authentication, cryptography, encryption, data integrity. Cyber security standards ETSI, ISO 27001, 27002, NIST, ISA/IEC 62443.

About this Training Course Whether you are maintaining an oil rig or processing plant, good quality maintenance is critical to delivering a safe reliable product to your customers. Whatever your level of maintenance experience, this course will equip you with the valuable skills and understanding that will enhance your maintenance career. Too often the maintenance department is seen as the cause of why assets are unavailable, in poor condition yet are costing too much to maintain. By comparison, pace setting companies see maintenance as adding value to their assets and employ an integrated, holistic approach to their maintenance activities. This course will help you move towards that pace setting performance. This course is based on an integrated maintenance model that has been used by leading companies and consultants with success and recognised as best practice. Participants will learn the total impact that maintenance can have on a business, identify key elements (and value) of effective maintenance for their own plants to not only reduce costs but also improve performance. The critical types of maintenance will be covered from day-to-day activities to shutdowns and reliability improvement. The course will break down traditional functional boundaries and encourage a holistic approach to maintenance. With an organisation's maintenance process only as good as its weakest link, this course will guide participants through all the key steps of a maintenance process and its supply chain. Participants will understand what is considered a good standard for each step in the maintenance process, how to identify the weakest links and subsequently how they can accelerate their performance improvement. Participants will have the option of gaining a Bronze Level qualification from the Academy of Turnarounds Operations of Maintenance. For those who obtain a pass, they will receive a Pass certificate and for those who achieve the top quartile score, they will receive a Distinction level pass. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, participants will be able to: Explain the challenges and objectives facing maintenance organisations today Demonstrate the importance of work order systems and use techniques for time estimations and priority assignments Prepare a preventive maintenance program Apply project management techniques to effectively manage major maintenance activities and shut downs Use capital budgeting techniques to evaluate maintenance capital expenditures Demonstrate understanding of how to maintain the optimal stock levels of spare parts to ensure operational continuity Prepare the right Key Performance Indicators (KPIs) to evaluate and improve performance in maintenance Target Audience This course is not just for maintenance professionals. Maintenance teams cannot perform without effective integration with operations and supply chain functions. Availability losses are often caused by operations or design issues and pace setting companies have generated significant benefits by integrating operation and maintenance strategies and working more collaboratively. This course will help all members of the operations and maintenance teams and their supply chain better understand their respective roles in ensuring that maintenance is benefitting and not inhibiting their business. Course Level Basic or Foundation Trainer Your expert course leader is a highly experienced facilitator in maintenance improvement, change management, continuous improvement and capability development as a management coach and trainer. He has a strong focus on people with an emphasis on developing people and the practicalities of improving maintenance performance rather than just the theory. He has worked internationally across Europe, America, the Middle East and Africa with extensive experience in Oil and Gas, the Chemicals sector and manufacturing as well as working with clients in Steel and Power Generation. As a result, he can bring best practice from a wide variety of sources. He spent the first fifteen years of his career as a specialist trainer working for companies such as Lloyds British Training Services and Rolls Royce. He then went on to work as a Principal consultant for ABB consulting for 15 years. During this time, he refined some of the established improvement tools including how and when to apply them for maximum impact whilst still continuing to develop and deliver training in support of this. Recent work has included improvements to the Work Order to Work Execution processes of Engineering departments and focused on Reliability, Planning and Scheduling. This ongoing field experience has helped him test and refine specialist training in a number of areas. He has been able to use his own experience to contribute with other maintenance specialists to the Carcharodon models of excellence. Its methodologies are recognised as 'Best of the Best' standards providing the inspiration for two books, projects that have won awards such as the prodigious UK Chemical Industries annual Excellence in Engineering award and form the basis of this training. He was recently awarded a national award as coach of the year. He uses the same skills to ensure that he does not just preach maintenance best practice, he discusses it, explains it and ensures that delegates have a much more personal and flexible experience. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Autocad face to face training customised and bespoke.

About this Virtual Instructor Led Training (VILT) This 2 half-day Virtual Instructor-Led Training (VILT) course will guide participants on the technoeconomic aspects of capture, utilization and geological storage of carbon dioxide. The VILT course will address the methods and techniques used in the technoeconomic assessment of Carbon Capture, Utilization & Storage (CCUS) projects. It will explore in detail the factors that affect the cost-effectiveness of current and emerging technologies for CO2 capture, transport and geological storage, including monitoring and verification. Given that the successful deployment of CCUS may require economic incentives, technical and economic drivers such as technological innovation, optimization, source sink matching and emerging opportunities will also be discussed. In addition, using several worked examples and case studies, this VILT course will explain the principles behind the analysis of the costs and opportunities of a CCS / CCUS project from source to sink and examines the possibilities of using carbon dioxide from an economic perspective. Training Objectives Upon completion of this VILT course, participants will be able to: Describe the economic considerations for CCS / CCUS projects Measure and calculate the cost-effectiveness of CCS / CCUS Identify the economic drivers for CCS / CCUS Understand the value of source to sink matching Outline the economic and environmental opportunities as well as challenges with using carbon dioxide injection in a range of applications Recognize niche opportunities for CO2 storage (coal seams, basalts, salt and others)   Target Audience This VILT course is ideally suited for a technical audience such as geoscientists, petroleum and chemical engineers as well as professionals such as economists, regulators, legal staff and managers wishing to learn more about the details of economic aspects and the basis for techno-economic analysis of Carbon Capture, Utilization and Storage projects. The VILT course is presented in an interactive workshop format, allowing for discussions. Participants should have: Basic background knowledge of CCUS technologies Experience with oil and gas, coal or other energy projects Basic understanding of the energy industry Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 2 half-day sessions comprising 4 hours per day, with 2 breaks of 15 minutes per day. The VILT course is presented in an interactive workshop format that allows discussion. Course Duration: 2 half-day sessions, 4 hours per session (8 hours in total). Trainer Your expert course leader received his B.Eng. in Chemical and Environmental Systems in 2002 from Tecnológico de Monterrey, Mexico, and his Ph.D. in Chemical Engineering in 2008 from the University of New South Wales (UNSW), in Sydney, Australia, at the UNESCO Centre for Membrane Science and Technology. His doctoral used computational fluid dynamics (CFD) to analyse the flows within membrane modules used for water treatment and desalination. He also worked on a desalination linkage project between the UNSW and the European Union, as part of Framework Programme 6. From 2009 to 2014, he worked for the Cooperative Research Centre for Greenhouse Gas Technologies (CO2CRC), where he led the research into CO2 Transport Networks, co-led the development of a techno-economic model for the analysis of Carbon Capture and Storage (CCS) projects, and collaborated on several consultancy and feasibility studies conducted by CO2CRC for both Government and Industry. From 2014 to 2019, he held a CONACYT Research Fellowship at the Instituto Tecnológico de Sonora (ITSON) in Mexico, where he led collaborative research projects dealing with RO membrane biofouling (IHE-Delft), membrane modifications, solar energy use for desalination (CSIR-CSMCRI India) and CFD modelling of the hydrodynamics in membrane modules (UMP Malaysia). Since July 2019, he is a Research Fellow in the School of Chemical and Biomolecular Engineering at the University of Sydney, where his research focuses on finding ways to reduce the cost, energy use and environmental impact of technologies for providing clean energy and water. From 2015 to 2020, he was a Member of the Board of Directors of the Mexican Society of Membrane Science and Technology. He guest edited a special edition on CCS for the Journal 'Technologies' and is currently an Editorial Board member for the journal, 'Energies', a peer-reviewed open-access scientific journal. His research interests include improving the efficiency of osmotic membrane separation processes, modelling complex processes involving heat and mass transfer, and exploring the economic drivers of low emission technologies such as the Carbon Capture and Storage (CCS) chain. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

About this training course Artificial lift systems are an important part of production operations for the entire lifecycle of an asset. Often, oil and gas wells require artificial lift for most of the life cycle. This 5-day training course offers a thorough treatment of artificial lift techniques including design and operation for production optimization. With the increasing need to optimize dynamic production in highly constrained cost environments, opportunities and issues related to real-time measurements and optimization techniques needs to be discussed and understood. Artificial lift selection and life cycle analysis are covered. These concepts are discussed and reinforced using case studies, quizzing tools, and exercises with software. Participants solve examples and class problems throughout the course. Animations and videos reinforce the concepts under discussion. Understanding of these important production concepts is a must have to exploit the existing assets profitably. Unique Features: Hands-on usage of SNAP Software to solve gas-lift exercises Discussion on digital oil field Machine learning applications in gas-lift optimization Training Objectives After the completion of this training course, participants will be able to: Understand the basics and advanced concepts of each form of artificial lift systems including application envelope, relative strengths, and weaknesses Easily recognize the different components from downhole to the surface and their basic structural and operational features Design and analyze different components using appropriate software tools Understand challenges facing artificial lift applications and the mitigation of these challenges during selection, design, and operation Learn about the role of digital oilfield tools and techniques and their applications in artificial lift and production optimization Learn about use cases of Machine learning and artificial intelligence in the artificial lift Target Audience This training course is suitable and will greatly benefit the following specific groups: Production, reservoir, completion, drilling and facilities engineers, analysts, and operators Anyone interested in learning about selection, design, analysis and optimum operation of artificial lift and related production systems will benefit from this course. Course Level Intermediate Advanced Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Prerequisites: Understanding of petroleum production concepts. Each participant needs a laptop/PC for solving class examples using software to be provided during class. Laptop/PC needs to have a current Windows operating system and at least 500 MB free disk space. Participants should have administrator rights to install software. Trainer Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA. Highlighted Work Experience: At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe. Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements. Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics. Developed a workshop on digital oilfield approaches for production engineers. Patents: Principal inventor: 'Smarter Slug Flow Conditioning and Control' Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells' Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution' Worldwide Experience in Training / Seminar / Workshop Deliveries: Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&T, Louisiana State, U of Southern California, and U of Houston. He has conducted seminars, bespoke trainings / workshops globally for practicing professionals: Companies: Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others. Countries: USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela. Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

RF fundamentals training course description Radio Frequency engineering is an important yet often overlooked area in today's wireless world. This course provides a grounding in RF theory and practice for wireless, cellular and microwave systems. What will you learn Explain the basics of RF. Describe RF propagation and antenna principles. Calculate propagation losses and link budgets. Test RF systems. RF fundamentals training course details Who will benefit: Those working with wireless, cellular and microwave systems. Prerequisites: None. Duration 2 days RF fundamentals training course contents What is RF? Definition of RF, RF wave characteristics: Frequency, wavelength, power, phase, impedance, RF history, radio signals, frequency bands, safety issues, legal issues. RF systems Microwaves, cellular/mobile RF, WLANs, other fixed wireless networks, basic RF components. Hands on Building a basic WLAN network. RF system components Transmitters: Antennas: Isotropic, Dipole, how antennas achieve gain. Modulation Schemes, bandwidth, AM, FM, FSK, PSK, QAM, QPSK, interference, performance. Hands on Interference and performance. Multiple access schemes FDMA, CDMA, TDMA, CSMA/CA. Wireless systems Cellular (GSM, UMTS), Wifi, WiMax, others: GPS, DBS, RFID, radar, Bluetooth. Hands on cellular. Spread Spectrum technologies Spread spectrum benefits and disadvantages, how it works, Direct Sequence, Frequency Hopping, hybrids. RF propagation Models, link budget, Smith chart, RF matching with the Smith chart. cell capacity, tradeoffs: power vs. bandwidth, free space, reflection, diffraction, multipath cancellation, propagation prediction and measurement tools. Hands on Smith charts. RF testing Why power rather than voltage/current, units of power, dB and dBm power conversions. Test equipment: signal generators, power meters, network analysers, spectrum analysers. RF test setups: return loss, insertion loss. Hands on RF testing.

Duration 2 Days 12 CPD hours This course is intended for CxO?s IT Managers/ Directors Senior Project Officers Project & Program Coordinator/Managers Operations Managers Quality Managers Business Analysts Engineering Managers IT Infrastructure Managers Internal Consultants Professional Consultants Overview The purpose of the Practitioner certification is to confirm whether the candidate has achieved sufficient know-how to apply and tailor Change Management guidance in a given organizational change situation. A successful Practitioner candidate should, with suitable direction, be able to start applying the Change Management approaches and techniques to a real change initiative - but may not be sufficiently skilled to do this appropriately for all situations. Their individual Change Management expertise, complexity of the change initiative and the support provided for the use of Change Management approaches in their work environment will all be factors that impact what the Practitioner can achieve. Successful candidates will have fulfilled the knowledge requirements for Change Management Institute accreditation. Dealing with change and more importantly, the impact of change is a high priority for all organizations. The Change Management Certification has been developed by APMG in partnership with the Change Management Institute (CMI), an independent, global professional association of change managers. Together they have developed a professional ?body of knowledge? for the discipline of change management. This body of knowledge now provides an independent benchmark for the professional knowledge expected of an effective change manager. APMG?s refreshed Change Management certification is fully aligned with the change management body of knowledge. Prerequisites The change management foundation certificate is required to sit the practitioner level exam. 1 - Change Impact Levers for change Levels of adoptions and critical mass Reinforcing systems 2 - Exam Preparation Change Management Practitioner exam preparation Change Management Practitioner exam

About this Training Course Time is money in the oil business. Drilling time is big money. Whether in a technical, managerial or supporting role, you are a valuable asset to ensuring that project delivery targets are met and profits are realised. As drilling activities continue, professionals like you must grasp the language and technology of drilling operations in order to maximise expenditures throughout the producing life of a well. Drilling equipment and procedures have a unique language that must be conquered for maximum benefit. Clear and understandable explanations of drilling rig equipment, procedures, and their complex interactions provide an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. Drilling Essentials will help you de-mystify activities around the rig and well planning. It will explain the fundamentals of drilling with an emphasis on key areas such as logistical considerations, costing, and analysis of drilling contracts. Understand the urgency of drilling requests, know more about the cost implications of drilling-related problems, and understand the risks involved in a drilling contract. With the course director's drilling knowledge and skills, this is your opportunity to explore and understand important drilling concepts, principles, and technology which are presented in a reader-friendly format and illustrated with examples. As a non-drilling professional, you too can grow with the drilling industry with a deeper understanding of the critical role you play in contributing to its success! Training Objectives By attending this industry fundamentals Virtual Instructor Led Training (VILT) course, you will be better able to: Understand drilling terminology & drilling processes for completing onshore & offshore wells Appreciate major cost components of drilling operations and its impact for better project planning and management Better visualise major drilling equipment and their technical functions to promote a deeper understanding of the logistical and technical considerations Gain valuable insights on the drilling industry with a synopsis of recent technology developments that impact the drilling process Target Audience This Virtual Instructor Led Training (VILT) course has been developed for new engineers and forward-looking executives in the following fields who are interested in enhancing their knowledge and awareness of the drilling process for increased productivity & contribution to the team they're supporting: Accounting Commercial Finance & Administration General Management Logistics Procurement Tender Contract Administration E & P IT Finance Joint Ventures Materials Planning Sourcing Training Business Development Estimation & Proposal HSE Legal Planning & Budgeting Supply Chain Drilling Fluids Organisational Impact Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

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.