This is a self-paced lab that takes place in the Google Cloud console. This lab shows you how to monitor a Google Compute Engine virtual machine (VM) instance with Cloud Monitoring. Watch the short videos Monitor Health of All Your Cloud Apps with Google Cloud monitoring and Monitor a VM Instance with Cloud monitoring, GCP Essentials.

In this Guided Project you will create a MongoDB database and collection to store blog posts, and optimize it using indexes, while having an overview of some of the basic commands, in order to learn the basics of NoSQL document databases structure, the MongoDB shell and the usage of the powerful MongoDB Compass GUI to manage, inspect and optimize a MongoDB database. NoSQL is an alternative to traditional relational databases. NoSQL databases sacrifice some relational databases characteristics, such as a well-defined structure and strict relations between entities, in order to achieve better and easier scaling and replication, to handle large quantities of data, while being more generally flexible, cheaper and easier to manage. Instead of using tables, rows and columns, NoSQL document databases such as MongoDB use collections, documents and fields, represented with the well known JSON format. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

In this guided project, you will host a SQL server and database with Azure and use the Microsoft SQL server management studio to connect to the SQL server. We will also explore different SQL database deployment and pricing options. By the end of this project, you will be confident in hosting an SQL database on an SQL Server on Azure. In order to complete this project successfully, you need an Azure account. If you do not have an Azure account, you will be prompted to create one in the project.

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you migrate an on-premises MySQL database (running on a virtual machine) to Cloud SQL for MySQL using a continuous Database Migration Service job and VPC peering for connectivity. After you create and run the migration job, you confirm that an initial copy of your database has been successfully migrated to your Cloud SQL for MySQL instance. Then, you explore how continuous migration jobs continue to apply data updates from your source database to your Cloud SQL instance until you choose to complete the job. To conclude the migration job, you promote the Cloud SQL instance to be a new standalone database for reading and writing data.

By the end of this project, you will create a full stack web application using React on the front end and Express along with MongoDB and Node.js on the back end. Creating a full stack web application with React and Express allows the developer to use JavaScript throughout the stack. Express provides an API that simplifies the interaction with the Node.js server.

By the end of this project, you will Use C# to process XML data in a C# program. XML is an eXtensible Markup Language used to transport data across the internet for display or other processing. It provides a standard format so data may be validated as well. C#, like other languages, contains classes to read and validate XML documents.

This is a Google Cloud Self-Paced Lab. In this lab, you will learn about the fundamental LookML structures, create a view, and join the new view to an existing explore.

Which PaaS (Platform as a Service) should you use to create business applications much more quickly than with on-site solutions? Which database engine fits your performance needs? Moreover, which purchasing model should you consider? These questions and more will be answered within this Guided Project. In this intermediate-level guided project, you will create a resource group, a new SQL Server, and 3 Azure SQL databases using various purchasing models. Various queries will be run against the databases and the performance of each database will be monitored. At the end of the project, you will get an overview of each option available which will help you choose the right one based on your business needs. The requirement for this project is having a free and active Azure account and an active Azure subscription. You will be provided instructions on how to obtain these requirements within the first task.

This is a self-paced lab that takes place in the Google Cloud console. Data validation is a critical step in data warehouse, database, or data lake migration. DVT prints results in the command line interface by default, but can also write results to BigQuery. It is recommended to use BigQuery as a report handler to store and analyze the output.

In this 2-hour long project-based course, you will learn how to use SQL data definition statements for various data definition tasks and how to use SQL data manipulation statements for data manipulation tasks such as updating records in a table. In addition, you will learn how to upload a CSV file into a database using PostgreSQL.