Google BigQuery Training Course

This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level IT professionals who wish to use Google Cloud Platform to understand core services, deploy cloud workloads, and follow operational best practices.

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

This instructor-led, live training in Botswana (online or on-site) is aimed at data analysts who wish to use Google Analytics to track and report website data.

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

• Set up Google Analytics to collect website data.
• Create and analyze reports.
• Gain insights and make 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 Botswana (available online or onsite) is targeted at intermediate-level IT professionals who wish to develop the skills required to deploy, manage, and operate workloads on Google Cloud while preparing for the Google Certified Associate Cloud Engineer certification.

Upon completion of 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 Botswana (online or onsite) is aimed at 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.

In this programme, you will acquire high-demand skills that will prepare you for employment in a short period. No academic qualifications or prior experience are necessary.

What you will learn

• Grasp the significance of cybersecurity practices and their influence on organisations.

• Recognise common risks, threats, and vulnerabilities, as well as techniques to mitigate them.

• Shield networks, devices, personnel, and data from unauthorised access and cyberattacks using Security Information and Event Management (SIEM) tools.

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

Google Docs stores your documents in the cloud, allowing you to access them from any computer or device. You can create and edit documents directly in your web browser without needing special software. Additionally, multiple people can collaborate simultaneously, view changes in real time, and rely on automatic saving for every modification.

During this course, you will learn to open Google Docs, create and format new documents, and apply templates. You will enhance your documents using features such as tables of contents, headers and footers, tables, drawings, and images. You will also learn how to share documents and understand sharing options, collaborator roles, and permissions. The course covers managing document versions, working in real time with others, and creating and managing comments and action items. You will explore various Google Docs tools, set preferences to match your work style, and utilise features like Google Explore to add value to your content.

This instructor-led live training in Botswana (online or on-site) is designed for intermediate to advanced GIS professionals seeking to apply Google Earth Pro for mapping, data visualisation, and geographic analysis.

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

• Master the Google Earth Pro user interface and comprehend the utility of its diverse tools and settings.
• Efficiently navigate the globe through search functions, coordinate inputs, and various viewing modes within Google Earth Pro.
• Create, edit, and employ placemarks, paths, and polygons to identify and analyse geographical sites.
• Leverage Google Earth Pro for sophisticated visualisation, encompassing 3D structures, historical imagery, and integrated street views.

KEY LEARNING OUTCOMES

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

• Filter, summarise, and protect data within Google Sheets.

• Perform calculations and visualise spreadsheet data effectively.

• Apply best practices for sharing and collaborating in Google Sheets.

This instructor-led, live training in Botswana (online or on-site) is aimed at beginner-level business managers who wish to use Google Workspace tools to enhance productivity, collaboration, and organisation within their respective roles.

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

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

Google Workspace comprises a suite of cloud-based tools designed to boost communication, collaboration, and productivity in both professional and academic settings. This blended training integrates virtual and in-person sessions, equipping participants with practical skills to effectively utilise Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini, supported by hands-on activities and guided practice.

Delivered as instructor-led, live training (both online and onsite), this course targets beginner to intermediate-level professionals aiming to strengthen their use of Google Workspace to streamline teamwork and operational processes.

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

• Organise and manage emails, events, and meetings efficiently using Gmail, Calendar, and Meet.
• Collaborate in real time via Google Drive, Docs, Sheets, and Slides.
• Apply communication tools such as Chat/Gemini to streamline team interactions.
• Develop practical outputs including schedules, collaborative reports, dashboards, and presentations.

Course Format

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

Course Customisation Options

• To request a customised version tailored to your organisation’s specific processes, please contact us to arrange this.

Google Workspace is a cloud-based suite of productivity and collaboration tools designed to streamline communication, file sharing, and team productivity. This course covers the essential apps and features to help participants work more efficiently and collaboratively.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level users who wish to get the most out of Google Workspace tools for daily work and collaboration.

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

• Use Gmail for professional communications.
• Manage files securely in Google Drive.
• Run effective meetings in Google Meet.
• Collaborate in real time with Docs, Sheets, and Slides.
• Organize schedules with Google Calendar.
• Communicate quickly using Google Chat.
• Create forms and collect responses with Google Forms.
• Capture ideas and manage tasks with Keep and Tasks.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and practice.
• Live demonstrations.

Course Customization Options

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

Google BigQuery is a fully managed, serverless data warehouse that facilitates cost-effective query optimization, predictive analytics via BigQuery ML, and seamless data ingestion for analytical workflows. It is engineered for teams seeking to maximise 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 optimise queries, leverage BigQuery ML for predictive modelling, and enhance ingestion and transformation processes for reporting purposes.

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

• Optimise queries in BigQuery to improve performance and reduce expenses.
• Utilise BigQuery ML to construct, 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 lecture and discussion.
• Hands-on labs involving Google BigQuery and BigQuery ML.
• Practical exercises focused on query optimisation and pipeline design.

Course Customization Options

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

This course is tailored for organisations aiming to streamline their operations by linking the various digital platforms utilised in day-to-day activities, including Trello, QuickBooks, Google Workspace, and the WhatsApp API.

Facilitated by an expert instructor, this live training (available online or on-site) walks participants through the process of connecting and automating workflows, thereby strengthening project and financial oversight while centralising information to boost decision-making capabilities.

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

• Link and automate workflows across Trello, QuickBooks, and Google Workspace.
• Incorporate WhatsApp API communication into operational processes.
• Develop multi-platform automation systems centred on efficiency and control.
• Enforce security and monitoring protocols for active integrations.
• Document and sustain automated processes in operation.

Course Format

• Theoretical explanations alongside guided demonstrations.
• Practical exercises applied to real-world operational scenarios.
• Hands-on practice using company-specific data and tools.

Customization Options

• Adapting content to align with the company’s specific platforms and processes.
• Incorporating additional tools such as Zapier, Make/Integromat, or Power Automate.
• Analysing and designing real data integration flows.