This is a self-paced lab that takes place in the Google Cloud console. In this lab you review schema related features of Cloud Spanner and apply those to a Banking Operations database. You also review the methods and rules by which Cloud Spanner creates query plans. … [Read more...] about Cloud Spanner – Defining Schemas and Understanding Query Plans
Data Management
MySQL with Information Technology
In this project you will explore how MySQL fits into information systems. You will become familiar with MySQL features as you explore database management system options and participate in hands-on exercises using MySQL Workbench to create and populate a table in a MySQL relational database. Note: This course works best for learners who are based in the North America region. … [Read more...] about MySQL with Information Technology
Advanced SQL Retrieval Queries in SQLiteStudio
In this course you will learn to write advanced SQL (Structured Query Language) retrieval queries using SQLiteStudio. Retrieving data from a relational database is one of the primary methods used by application and web developers to display data and populate web pages. Since a database can be made up of a complex combination of relational tables, retrieving that data can be … [Read more...] about Advanced SQL Retrieval Queries in SQLiteStudio
Amazon QLDB Primer
This course introduces you to Amazon Quantum Ledger Database (Amazon QLDB), an AWS fully managed ledger database. This course introduces you to the service and its core features and capabilities. You will see how this service integrates with other AWS services and be introduced to important terminology and technology concepts. The course includes a demonstration of Amazon … [Read more...] about Amazon QLDB Primer
Business Intelligence (BI) Essentials
This course provides a comprehensive introduction to business intelligence (BI), its key concepts, components, and the benefits and challenges of implementing BI solutions. It also discusses career opportunities and roles available in the BI arena and the skills and qualifications required. You will also gain insight into the data ecosystem, BI analytics landscape, data … [Read more...] about Business Intelligence (BI) Essentials