Google BigQuery Training Course

This instructor-led live training in Kenya (online or onsite) is designed for beginner-level IT professionals aiming to use Google Cloud Platform to understand core services, deploy cloud workloads, and adhere to operational best practices.

By the end of this session, participants will be able to explain core Google Cloud services, deploy basic workloads, and apply essential security and monitoring practices.

This instructor-led live training in Kenya (available online or onsite) is designed for data analysts who intend to use Google Analytics to monitor and report on website data.

By the conclusion of this training, participants will be able to:

• Configure Google Analytics to gather website data.
• Generate and analyze reports.
• Extract insights and facilitate data-driven decisions.

This three-day instructor-led class introduces participants to the comprehensive and flexible infrastructure and platform services provided by Google Cloud Platform, with a focus on Compute Engine. Through a combination of presentations, demos, and hands-on labs, participants explore and deploy solution elements, including infrastructure components such as networks, systems, and application services. This course also covers deploying practical solutions including securely interconnecting networks, customer-supplied encryption keys, security and access management, quotas and billing, and resource monitoring.

This instructor-led, live training in Kenya (available online or onsite) is designed for intermediate-level IT professionals aiming to build the skills necessary to deploy, manage, and operate workloads on Google Cloud while preparing for the Google Certified Associate Cloud Engineer certification.

Upon completing this training, participants will be able to:

• Set up and manage Google Cloud projects, resources, networking, and storage services.
• Deploy and administer applications using Compute Engine, Google Kubernetes Engine (GKE), Cloud Run, and App Engine.
• Configure identity and access management, security controls, and billing budgets, alerts, and cost monitoring.
• Provision and automate cloud infrastructure using Terraform and Cloud Build.
• Monitor, troubleshoot, and optimize Google Cloud environments using Cloud Monitoring and Cloud Logging.
• Understand the capabilities of Vertex AI and Google Cloud AI services for common business and operational use cases.

This instructor-led live training in Kenya (online or onsite) is designed for beginner-level IT professionals who wish to manage and operate the Google Cloud Platform.

By the end of this training, participants will be able to:

• Understand the core services and infrastructure of GCP.
• Learn how to manage networks and virtual machines.
• Understand and apply general security best practices in GCP.
• Explore Kubernetes and container management in GCP.
• Learn about storage options and how to configure them.
• Deploy and configure databases on GCP.

This programme equips you with high-demand skills, enabling you to become job-ready in a short timeframe. No prior degree or professional experience is necessary.

Key Learning Outcomes

• Comprehend the significance of cybersecurity practices and their impact on organisational integrity.

• Identify prevalent risks, threats, and vulnerabilities, alongside strategies to mitigate them.

• Defend networks, devices, personnel, and data against unauthorised access and cyber threats using Security Information and Event Management (SIEM) tools.

• Acquire practical experience with Python, Linux, and SQL.

Google Docs keeps your documents securely in the cloud, allowing you to access and edit them from any computer or device via your web browser without the need for additional software. It supports simultaneous collaboration, enabling multiple users to work on the same document in real time, with all changes visible and saved automatically.

This course covers the fundamentals of opening Google Docs, creating and formatting new documents, and applying templates. Participants will learn how to enhance their work using features like tables of contents, headers and footers, tables, drawings, and images. The training also addresses sharing documents, exploring sharing options, and understanding collaborator roles and permissions. You will master version management and real-time co-authoring techniques. Additionally, the course includes creating and managing comments and action items, reviewing essential Google Docs tools, customizing preferences to fit your workflow, and utilizing Google Explore to enrich your content.

This instructor-led live training in Kenya (online or onsite) is tailored for intermediate to advanced GIS professionals aiming to utilize Google Earth Pro for mapping, data visualization, and geographic analysis.

By the conclusion of this course, participants will be able to:

• Navigate the Google Earth Pro user interface effectively and comprehend the functionality of its tools and options.
• Efficiently move across the globe using Google Earth Pro, including utilizing search capabilities, coordinates, and different view modes.
• Create, edit, and apply placemarks, paths, and polygons to mark and analyze geographical locations.
• Leverage Google Earth Pro for advanced visualization, encompassing 3D buildings, historical imagery, and street view integration.

WHAT YOU WILL LEARN

• Add, import, manage, and format data using Google Sheets.

• Filter, summarize, and protect data in Google Sheets.

• Perform calculations and visualize your spreadsheet data.

• Apply best practices to share and collaborate in Google Sheets.

This instructor-led, live training in Kenya (online or onsite) targets beginner-level business managers who want to use Google Workspace tools to enhance productivity, collaboration, and organization within their roles.

By the end of this training, participants will be able to:

• Grasp the fundamentals of Google Workspace.
• Effectively schedule and manage meetings using Google Calendar.
• Confidently host, join, and manage virtual meetings, and utilize collaboration features such as screen sharing.
• Create professional documents, utilize collaboration features, and convert documents to various formats.
• Create, format, and share presentations, and collaborate with others on the same presentation.

Google Workspace is a comprehensive suite of cloud-based applications designed to boost communication, collaboration, and productivity across professional and academic settings. This hybrid training programme merges virtual and face-to-face sessions to equip participants with practical skills for mastering Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini, supported by hands-on exercises and guided practice.

This instructor-led, live training (available both online and onsite) targets beginner to intermediate-level professionals aiming to strengthen their use of Google Workspace to streamline teamwork and operational efficiency.

Upon completion of this training, participants will be able to:

• Effectively organize and manage emails, events, and meetings using Gmail, Calendar, and Meet.
• Collaborate in real-time via Google Drive, Docs, Sheets, and Slides.
• Utilize communication tools like Chat/Gemini to optimize team interactions.
• Produce practical outputs such as schedules, collaborative reports, dashboards, and presentations.

Course Format

• Blended learning approach: 2 hours of virtual instruction plus 12 hours of in-person sessions.
• Interactive lectures and group discussions.
• Hands-on exercises, group projects, and scenario-based simulations.
• Video tutorials and guided virtual practice activities.

Course Customization Options

• To request a customized version tailored to your organization’s specific processes, please contact us to arrange.

Google Workspace is a cloud-based collection of productivity and collaboration applications designed to enhance communication, simplify file sharing, and boost team efficiency. This course explores the core applications and functionalities required to help participants work more effectively and collaboratively.

This instructor-led, live training session (available online or on-site) is tailored for users ranging from beginner to intermediate proficiency who aim to maximize the utility of Google Workspace tools in their daily professional activities and collaborative efforts.

Upon completion of this training, participants will be capable of:

• Utilizing Gmail for professional correspondence.
• Securely managing files within Google Drive.
• Conducting productive meetings via Google Meet.
• Engaging in real-time collaboration using Docs, Sheets, and Slides.
• Organizing schedules effectively with Google Calendar.
• Facilitating rapid communication through Google Chat.
• Developing forms and gathering responses via Google Forms.
• Documenting ideas and managing tasks using Keep and Tasks.

Course Delivery Format

• Interactive lectures and group discussions.
• Practical, hands-on exercises.
• Live software demonstrations.

Customization Options for the Course

• For organizations seeking tailored training, please reach out to us to discuss specific arrangements.

Google BigQuery serves as a fully managed, serverless data warehouse that enables cost-effective query optimization, predictive analytics through BigQuery ML, and smooth data ingestion for analytical workflows. It is tailored for teams aiming to maximize query efficiency, construct machine learning models directly within SQL, and streamline reporting pipelines.

This instructor-led, live training (available online or onsite) targets teams with a foundational understanding of SQL who wish to optimize queries, leverage BigQuery ML for predictive modeling, and enhance ingestion and transformation processes for reporting.

Upon completion of this training, participants will be able to:

• Optimize queries in BigQuery to boost performance and minimize costs.
• Utilize BigQuery ML to build, train, and evaluate predictive models.
• Design efficient data ingestion and transformation pipelines for reporting.
• Apply best practices for scaling analytics within Google BigQuery.

Course Format

• Interactive lectures and discussions.
• Practical labs involving Google BigQuery and BigQuery ML.
• Practical exercises focused on query optimization and pipeline design.

Customization Options

• To request a customized training for this course, please contact us to make arrangements.

This course is tailored for organizations aiming to streamline their operations by seamlessly linking various digital platforms used in day-to-day activities, such as Trello, QuickBooks, Google Workspace, and the WhatsApp API.

Through this instructor-led, live training (available online or on-site), participants will learn how to connect and automate workflows, thereby enhancing project and financial oversight while centralizing information to support better decision-making.

Upon completing this training, participants will be equipped to:

• Link and automate workflows between Trello, QuickBooks, and Google Workspace.
• Incorporate WhatsApp API communication into operational processes.
• Construct multi-platform automation systems aimed at boosting efficiency and control.
• Establish security and monitoring protocols for active integrations.
• Document and maintain automated processes effectively.

Course Format

• Conceptual explanations accompanied by guided demonstrations.
• Practical exercises applied to real-world operational scenarios.
• Hands-on practice utilizing company-specific data and tools.

Course Customization Options

• Tailoring content to the company’s specific platforms and processes.
• Including additional tools such as Zapier, Make/Integromat, or Power Automate.
• Analyzing and designing real data integration flows.