Back to Courses

Information Technology Courses - Page 81

Showing results 801-810 of 1471
Google Chat bot - Apps Script
This is a self-paced lab that takes place in the Google Cloud console. Learn how to create a simple Google Chatbot—"Attendance Bot"—using Google Apps Script. The bot integrates with Gmail to set a user's vacation responder and integrates with Calendar to put a meeting on the user's calendar.
Mastering SQL Joins
In this 2-hour long project-based course, you will understand how to use SQL joins like INNER JOIN, LEFT JOIN, and RIGHT JOIN to get a desired result set. In addition, you will learn how to use SQL Joins with the WHERE clause and with aggregate functions. By extension, you will learn how to join more than two tables in the database. Note: You do not need to be a data administrator or data analyst expert to be successful in this guided project, just you have to be familiar with querying databases using SQL SELECT statement to get the most of this project. If you are not familiar with SQL and want to learn the basics, start with my previous guided projects titled “Performing Data definition and Manipulation in SQL", “Querying Databases using SQL SELECT statement” and “Performing Data Aggregation using SQL Aggregate Functions”
Provision Services with Google Cloud Marketplace
This is a self-paced lab that takes place in the Google Cloud console. In this hands-on lab you'll learn how to use Google Cloud Platform's Marketplace to quickly get started with common operating systems, web frameworks, and databases. Watch the short preview Provision Services with GCP Marketplace, GCP Essentials.
Connect an App to a Cloud SQL for PostgreSQL Instance
This is a self-paced lab that takes place in the Google Cloud console. In this lab you will create a Kubernetes cluster and deploy a simple application to that cluster. Then, connect the application to the supplied Cloud SQL for PostgreSQL database instance and confirm that it is able to write to and read from it.
Industrial Internet of Things (IIoT)
In this course, learners will be introduced to the concept of the Industrial Internet of Things, or IIoT, learn how it is applied in manufacturing, and what businesses should consider as they decide to implement this technology. Considerations include information technology infrastructure, the business value of implementing IIoT, and what needs to happen across the organization to ensure successful implementation. Learners will hear from industry experts as they share their perspectives on the opportunities and challenges of implementing IIoT, how IIoT is being implemented in their companies, and insights on the future of this technology within their industry and across manufacturing. The content presented in this course draws on a number of real-life interviews and case studies, and was created through a partnership with Siemens.
Hosting Simple Web Applications using Amazon Lightsail
As a freelance developer, you are regularly building various software solutions for your customers. Recently, you received a request to create a pet adoption app on AWS. Because of a tight deadline and limited budget, you need to find a hosting platform that would satisfy all customer requirements without having a lot of setup and operations overhead. You evaluate different AWS services and decide on Amazon Lightsail to meet your use case. With Lightsail, you’ll be able to build and deploy an instance to host an app and then gradually add features to enhance app functionality.
Securing APIs with Apigee X
This is a self-paced lab that takes place in the Google Cloud console. In this lab, you modify an API to require OAuth tokens for access. You use the SpikeArrest policy to limit the rate of API calls by application, and you use private variables and data masking to hide sensitive data from users who debug API traffic.
Provisioning an Apigee X Evaluation Organization
This is a self-paced lab that takes place in the Google Cloud console. In this lab, you use the Apigee X provisioning wizard to create an Apigee X evaluation organization (org).
Introduction to SQL Window Functions
Welcome to this project-based course Introduction to SQL Window Functions. This is a hands-on project that introduces SQL users to the world of window functions. In this project, you will learn how to explore and query the project-db database extensively. We will start this hands-on project by retrieving the data in the table in the database. By the end of this 2-hour-and-a-half-long project, you will be able to use different window functions to retrieve the desired result from a database. In this project, you will learn how to use SQL window functions like ROW_NUMBER(), LEAD(), LAG(), and FIRST_VALUE() to manipulate data in the project-db database. These window functions will be used together with the OVER() clause to query this database.