411 Courses in London delivered Online

Overview This comprehensive course on Complete Google Analytics Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. 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 Complete Google Analytics Course. It is available to all students, of all academic backgrounds. Requirements Our Complete Google Analytics Course 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. 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 2 sections • 21 lectures • 00:58:00 total length •Module 01: Overview: 00:02:00 •Module 02: Navigation and Admin: 00:03:00 •Module 03: Creating a New Google Analytics Account: 00:03:00 •Module 04: Website Account Creation: 00:05:00 •Module 05: Connecting To WordPress Website: 00:03:00 •Module 06: Connecting To HTML Site: 00:03:00 •Module 07: Connect Custom Page and Site Builders: 00:03:00 •Module 08: Setting Up Annotations: 00:03:00 •Module 09: Setting Up Intelligence Events: 00:03:00 •Module 10: Set Up Custom Segments: 00:02:00 •Module 11: Export Data for Analysis: 00:03:00 •Module 12: Set Up Custom Reports: 00:03:00 •Module 13: Set Up Google Integrations: 00:03:00 •Module 14: Google Analytics Templates: 00:02:00 •Module 15: Real Time Reporting: 00:02:00 •Module 16: Setting Up Goals: 00:04:00 •Module 17: Third Party Integrations: 00:03:00 •Module 18: Audience Menu Overview: 00:04:00 •Module 19: Interests and Geography: 00:03:00 •Module 20: Conclusion: 00:01:00 •Assignment - Complete Google Analytics Course: 00:00:00

Unveil the power of data through our captivating Basic Data Analysis course, where curiosity meets capability. Embark on a journey of discovery, exploring the intricacies of data and information analysis. Dive deep into various data analysis methods and tools, from exploratory data analysis to qualitative data analysis. Let us ignite your passion for deciphering insights hidden within data. In this course, you'll master the fundamentals of data analysis, gaining invaluable skills applicable across diverse fields. Explore modules covering the principles of process management and strategies for driving improvement through data-driven insights. From understanding variation to presenting performance data effectively, each module equips you with practical knowledge essential for success in data analysis jobs. So, if you are looking for data analysis courses, you've landed on the right page.  Learning Outcomes: Acquire proficiency in using data analysis tools such as Pareto charts, histograms, and control charts. Develop the ability to interpret performance data and identify patterns through exploratory data analysis. Gain a comprehensive understanding of variation and strategies to manage it effectively. Apply data-driven approaches to drive continuous improvement and enhance decision-making processes. Demonstrate proficiency in structuring performance measurement systems to optimize organizational outcomes. Why buy this Basic Data Analysis Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Basic Data Analysis there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Basic Data Analysis course for? Individuals eager to enter the field of data analysis. Professionals seeking to enhance their data analysis skills. Students interested in exploring the principles of process management. Anyone curious about leveraging data for informed decision-making. Individuals aiming to pursue data analysis jobs in various industries. Prerequisites This Basic Data Analysis does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Basic Data Analysis was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £45,000 Per Annum Financial Analyst: £30,000 - £50,000 Per Annum Market Research Analyst: £25,000 - £35,000 Per Annum Operations Analyst: £25,000 - £40,000 Per Annum Quality Assurance Analyst: £25,000 - £35,000 Per Annum Course Curriculum Basic Data Analysis Module 01: Introduction 00:02:00 Module 02: Agenda and Principles of Process Management 00:06:00 Module 03: The Voice of the Process 00:05:00 Module 04: Working as One Team for Improvement 00:04:00 Module 05: Exercise: The Voice of the Customer 00:03:00 Module 06: Tools for Data Analysis 00:07:00 Module 07: The Pareto Chart 00:03:00 Module 08: The Histogram 00:03:00 Module 09: The Run Chart 00:04:00 Module 10: Exercise: Presenting Performance Data 00:05:00 Module 11: Understanding Variation 00:06:00 Module 12: The Control Chart 00:06:00 Module 13: Control Chart Example 00:04:00 Module 14: Control Chart Special Cases 00:06:00 Module 15: Interpreting the Control Chart 00:10:00 Module 16: Control Chart Exercise 00:07:00 Module 17: Strategies to Deal with Variation 00:06:00 Module 18: Using Data to Drive Improvement 00:14:00 Module 19: A Structure for Performance Measurement 00:06:00 Module 20: Data Analysis Exercise 00:06:00 Module 21: Course Project 00:03:00 Module 22: Test your Understanding 00:17:00 Assignment Assignment - Diploma in Data Analysis Fundamentals 00:00:00

Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Google Analytics Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Google Analytics Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Google Analytics Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Google Analytics Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Google Analytics? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Google Analytics there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Google Analytics course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Google Analytics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Google Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Google Analytics is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Google Analytics Module 01: Overview 00:02:00 Module 02: Navigation and Admin 00:03:00 Module 03: Creating a New Google Analytics Account 00:03:00 Module 04: Website Account Creation 00:05:00 Module 05: Connecting To WordPress Website 00:03:00 Module 06: Connecting To HTML Site 00:03:00 Module 07: Connect Custom Page and Site Builders 00:03:00 Module 08: Setting Up Annotations 00:03:00 Module 09: Setting Up Intelligence Events 00:03:00 Module 10: Set Up Custom Segments 00:02:00 Module 11: Export Data for Analysis 00:03:00 Module 12: Set Up Custom Reports 00:03:00 Module 13: Set Up Google Integrations 00:03:00 Module 14: Google Analytics Templates 00:02:00 Module 15: Real Time Reporting 00:02:00 Module 16: Setting Up Goals 00:04:00 Module 17: Third Party Integrations 00:03:00 Module 18: Audience Menu Overview 00:04:00 Module 19: Interests and Geography 00:03:00 Module 20: Conclusion 00:01:00 Assignment Assignment - Google Analytics 00:00:00

Isn't it interesting that you searched for something on the internet and some relevant results appeared? Alternatively, you can enter your daily data into a health app that automatically recommends a diet and exercise routine for you. All of this would not have been possible without data science. The modern world is entirely dependent on Machine Learning, Artificial Intelligence, Neural networks or data science in one phrase. Data science is a new field with no established leaders. It's too difficult to decide which one to learn, which leads to even more frustration because you can't make any progress. It is becoming more important, but the market for skilled data scientists is limited and competitive. What if you are one of those individuals? If you have a background in maths or statistics, we have good news: you can become a data scientist with little training! Anyone can become a data scientist with the help of our Data Science courses. Whatever your background, this training will teach you how to analyse and interpret data to generate new insights that lead to better decisions and results. Our interactive materials set us apart and make us more effective for our students. So don't be late to take your place. Enrol now! Learning Outcomes Understanding of the basic concepts and techniques in data science, such as data exploration, cleaning, and preprocessing Knowledge of statistical analysis methods, including hypothesis testing, regression analysis Learn probability theory and it's use in Data science Knowledge of Advanced regression & machine learning algorithms Ability to communicate data science results effectively to a non-technical audience. Key Highlights for Data Science Course: Developed by industry experts Instant e-certificate and hard copy dispatch by the next working day Interactive course with audio voice-over 24/7 Learning Assistance Lifetime access & update without any limits Unlimited Retake Exam and premium support for life Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning satisfaction guarantee Covers to explore multiple job positions One-stop solution for entrepreneurs and Jobseekers Fastest growing sector Boost your salary on program completion Learn from diligent experts Expert-verified response for quality education So, You should not wait too long. Now is the time to enrol! Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the Course Section 01: Let's get started Section 02: Descriptive statistics Section 03: Distributions Section 04: Probability theory Section 05: Hypothesis testing Section 06: Regressions Section 07: Advanced regression & machine learning algorithms Section 08: ANOVA (Analysis of Variance) Section 09: Wrap up CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Requirements To enrol in this Data Science course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Data Science, such as- Data Analyst: £25,000 to £45,000 per year Data Scientist: £35,000 to £60,000 per year Business Intelligence (BI) Analyst: £30,000 to £50,000 per year Machine Learning Engineer: £40,000 to £70,000 per year Data Engineer: £35,000 to £60,000 per year Data Consultant: £45,000 to £75,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Overview of Data Analyst: Data Analysis in Excel Join our Data Analyst: Data Analysis in Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Data Analyst: Data Analysis in Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Data Analyst: Data Analysis in Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Data Analyst: Data Analysis in Excel Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Data Analyst: Data Analysis in Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Data Analyst: Data Analysis in Excel course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Data Analyst: Data Analysis in Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Data Analyst: Data Analysis in Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Data Analyst: Data Analysis in Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

A course by Sekhar Metla IT Industry Expert RequirementsNo programming experience needed. You will learn everything you need to knowNo software is required in advance of the course (all software used in the course is free)No pre-knowledge is required - you will learn from basic Audience Beginner JavaScript, Python and MSSQL developers curious about data science development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Audience Beginner JavaScript, Python and MSSQL developers curious about data science development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer

GDPR Data Protection Law [Updated 2023] Stay ahead in compliance with our updated 2023 GDPR Data Protection Law course. Equip yourself with the latest in GDPR Data Protection standards. Secure your organisation's future with comprehensive GDPR Data Protection knowledge. Learning Outcomes: Navigate the Introduction to GDPR for compliance. Uphold the Principles of GDPR in data management. Ensure Lawful Basis for Processing personal data. Defend the Rights of Data Subject under GDPR. Differentiate roles of Data Controller and Processor. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from GDPR Data Protection Law [Updated 2023]: Introduction to GDPR: Familiarise yourself with the GDPR's scope and its impact on GDPR Data Protection practices. Principles of GDPR: Grasp the key GDPR principles that underpin effective GDPR Data Protection strategies. Lawful Basis for Processing: Understand the legal grounds for processing personal data within GDPR Data Protection frameworks. Rights of Data Subject: Recognise the rights individuals hold over their data, a cornerstone of GDPR Data Protection. Data Controller and Data Processor: Define and distinguish between the responsibilities of data controllers and processors under GDPR Data Protection laws. Data Protection by Design and by Default: Implement GDPR Data Protection requirements throughout your data processing activities. Security of Data: Master the security measures required to protect data in line with GDPR Data Protection guidelines. Data Breaches: Learn how to effectively manage and report data breaches in accordance with GDPR Data Protection procedures. Workplace and GDPR: Apply GDPR Data Protection policies within your organisational processes and workplace culture. Transferring Data Outside of EEA: Navigate the complexities of transferring data internationally under GDPR Data Protection rules. Exemptions: Identify the exemptions within GDPR Data Protection law and how they may apply to certain data processing scenarios.

Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level course designed to teach experienced systems administrators how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Previous Hadoop experience is not required. Overview Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will learn to: Understand the benefits of distributed computing Understand the Hadoop architecture (including HDFS and MapReduce) Define administrator participation in Big Data projects Plan, implement, and maintain Hadoop clusters Deploy and maintain additional Big Data tools (Pig, Hive, Flume, etc.) Plan, deploy and maintain HBase on a Hadoop cluster Monitor and maintain hundreds of servers Pinpoint performance bottlenecks and fix them Apache Hadoop is an open source framework for creating reliable and distributable compute clusters. Hadoop provides an excellent platform (with other related frameworks) to process large unstructured or semi-structured data sets from multiple sources to dissect, classify, learn from and make suggestions for business analytics, decision support, and other advanced forms of machine intelligence. This is an introductory-level, hands-on lab-intensive course geared for the administrator (new to Hadoop) who is charged with maintaining a Hadoop cluster and its related components. You will learn how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Introduction Hadoop history and concepts Ecosystem Distributions High level architecture Hadoop myths Hadoop challenges (hardware / software) Planning and installation Selecting software and Hadoop distributions Sizing the cluster and planning for growth Selecting hardware and network Rack topology Installation Multi-tenancy Directory structure and logs Benchmarking HDFS operations Concepts (horizontal scaling, replication, data locality, rack awareness) Nodes and daemons (NameNode, Secondary NameNode, HA Standby NameNode, DataNode) Health monitoring Command-line and browser-based administration Adding storage and replacing defective drives MapReduce operations Parallel computing before MapReduce: compare HPC versus Hadoop administration MapReduce cluster loads Nodes and Daemons (JobTracker, TaskTracker) MapReduce UI walk through MapReduce configuration Job config Job schedulers Administrator view of MapReduce best practices Optimizing MapReduce Fool proofing MR: what to tell your programmers YARN: architecture and use Advanced topics Hardware monitoring System software monitoring Hadoop cluster monitoring Adding and removing servers and upgrading Hadoop Backup, recovery, and business continuity planning Cluster configuration tweaks Hardware maintenance schedule Oozie scheduling for administrators Securing your cluster with Kerberos The future of Hadoop

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts

Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for developers and administrators who intend to use HBase. Overview Skills learned on the course include:The use cases and usage occasions for HBase, Hadoop, and RDBMSUsing the HBase shell to directly manipulate HBase tablesDesigning optimal HBase schemas for efficient data storage and recoveryHow to connect to HBase using the Java API, configure the HBase cluster, and administer an HBase clusterBest practices for identifying and resolving performance bottlenecks Cloudera University?s four-day training course for Apache HBase enables participants to store and access massive quantities of multi-structured data and perform hundreds of thousands of operations per second. Introduction to Hadoop & HBase What Is Big Data? Introducing Hadoop Hadoop Components What Is HBase? Why Use HBase? Strengths of HBase HBase in Production Weaknesses of HBase HBase Tables HBase Concepts HBase Table Fundamentals Thinking About Table Design The HBase Shell Creating Tables with the HBase Shell Working with Tables Working with Table Data HBase Architecture Fundamentals HBase Regions HBase Cluster Architecture HBase and HDFS Data Locality HBase Schema Design General Design Considerations Application-Centric Design Designing HBase Row Keys Other HBase Table Features Basic Data Access with the HBase API Options to Access HBase Data Creating and Deleting HBase Tables Retrieving Data with Get Retrieving Data with Scan Inserting and Updating Data Deleting Data More Advanced HBase API Features Filtering Scans Best Practices HBase Coprocessors HBase on the Cluster How HBase Uses HDFS Compactions and Splits HBase Reads & Writes How HBase Writes Data How HBase Reads Data Block Caches for Reading HBase Performance Tuning Column Family Considerations Schema Design Considerations Configuring for Caching Dealing with Time Series and Sequential Data Pre-Splitting Regions HBase Administration and Cluster Management HBase Daemons ZooKeeper Considerations HBase High Availability Using the HBase Balancer Fixing Tables with hbck HBase Security HBase Replication & Backup HBase Replication HBase Backup MapReduce and HBase Clusters Using Hive & Impala with HBase Using Hive and Impala with HBase Appendix A: Accessing Data with Python and Thrift Thrift Usage Working with Tables Getting and Putting Data Scanning Data Deleting Data Counters Filters Appendix B: OpenTSDB