Selecting your Data Migration Strategy with AWS
Are you an architect or storage administrator who is interested in migrating your storage implementation to the cloud? Do you want to understand how different data types your organization uses might impact your migration decisions? If so, then this course is for you! – Course level: Fundamental – Duration: 30 minutes Activities This course includes presentations and assessments. Course objectives In this course, you will learn to: – Explain the benefits of migrating storage implementations to the AWS Cloud – Identify the different types of data that organizations migrate and appropriate Amazon Web Services (AWS) target services – Identify the tools and methodologies, both online and offline, that organizations can use to move data to the AWS Cloud Intended audience This course is intended for: – Business decision makers – Solutions architects – Storage administrators Prerequisites We recommend that attendees of this course have completed: – Getting Started with AWS Storage Course outline Section 1: Benefits of migrating storage to the AWS Cloud – Cloud storage migration advantages Section 2: Migration process overview and data types ‐ Data migration process overview ‐ Data type examples Section 3: Data migration tools and methodologies – Migration requirements – Online and offline migration options
Getting Started with Amazon Redshift
In this course, you will learn the benefits, typical use cases, and technical concepts of Amazon Redshift. You can also try the service through a demonstration using the AWS Management Console. The cloud data warehouse service integrates with data lakes based on Amazon Simple Storage Service (Amazon S3). It also integrates with relational database services such as Amazon Relational Database Service (Amazon RDS) for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, Amazon RDS for MySQL, and Amazon Aurora MySQL-Compatible Edition. Amazon Redshift supports building and using machine learning (ML) models using familiar SQL commands, thereby reducing the skills needed to take advantage of ML. • Course level: Fundamental • Duration: 1 hour Activities This course includes presentations, graphics, and a demonstration with the option to follow along. Course objectives In this course, you will learn to: • Understand how Amazon Redshift works • Familiarize yourself with the technical concepts of Amazon Redshift • List typical use cases for Amazon Redshift • Specify what it would take to implement Amazon Redshift in a real-world scenario • Recognize the benefits of Amazon Redshift • Explain the cost structure of Amazon Redshift • Use Amazon Redshift from the AWS Management Console Intended audience This course is intended for: • Data warehouse engineers • Solutions architects Prerequisites • One or more years of data warehouse management experience • [AWS Technical Essentials] () Course outline • Amazon Redshift Basics • Using Amazon Redshift • Learn More
PostgreSQL Fundamentals
This course offers a Foundational introduction to PostgreSQL, which is an open-source relational database management system. You will learn about the history of PostgreSQL, get an introduction to databases, and learn PostgreSQL fundamentals. You will also learn how to begin using PostgreSQL databases. Intended audience: This course is intended for: •Database administrators •Database developers •Database architects •Database engineers Course objectives: In this course, you will learn how to: •Begin using PostgreSQL databases Prerequisites: We recommend that attendees of this course have the following prerequisites: •Familiarity with relational databases •Familiarity with structured query language (SQL) Delivery method: This course is delivered through •Digital training Duration: 20 Minutes Course outline: This course covers the following concepts: •PostgreSQL history •PostgreSQL lineage •Database 101 •Database 101 – Transactions •Database 101 – Isolation •PostgreSQL 101 •Features •Database limitations •PostgreSQL terminology
PostgreSQL Fundamentals: SQL Command Line
Intended Audience This course is intended for: •Database administrators •Database developers •Database architects •Database engineers Course Objectives: In this course, you will learn how to: •Use psql – The native, command-line client to postgresql Prerequisites: We recommend that attendees of this course have the following prerequisites: •Taken the PostgreSQL Fundamentals course •Familiarity with relational databases Delivery Method: This course is delivered through: •Digital training Duration: 15 minutes Course Outline: This course covers the following concepts: •psql client •Create a test table •List All Tables •Describe Tables •Make a CSV •Expanded Output Mode •SET Parameters •psqlrc File •Prompts •Watching Queries •Using in Scripts
PostgreSQL Fundamentals: Explain
Intended Audience This course is intended for: •Database administrators •Database developers •Database architects •Database engineers Course Objectives: In this course, you will learn how to: •Use Explain in PostgreSQL Prerequisites: We recommend that attendees of this course have the following prerequisites: •Taken the PostgreSQL Fundamentals course •Familiarity with relational databases •Familiarity with psql Delivery Method: This course is delivered through: •Digital training Duration: •30 minutes Course Outline: This course covers the following concepts: •Explain •Explain Analyze •Explain with Multiple levels •Diagnosing performance issues •Explain Options
PostgreSQL Fundamentals: Architecture
Intended Audience This course is intended for: •Database administrators •Database developers •Database architects •Database engineers Course Objectives: In this course, you will learn how to: •Understand the architecture of a PostgreSQL database •Read, write, and edit data in a PostgreSQL database •Store data in a PostgreSQL database Prerequisites: We recommend that attendees of this course have the following prerequisites: •Taken the PostgreSQL Fundamentals course •Familiarity with relational databases •Familiarity with structured query language (SQL) Delivery Method: This course is delivered through: •Digital training Duration: 1 hour Course Outline: This course covers the following concepts: •Client Architecture •Server Overview •Process Components •Memory Components •Per-Session Memory •Data Directory •base Directory •Block / Page Layout •Storing Large Values •TOAST Table •pg_wal Directory •On-Disk Components •In-Motion •Connect Request •Reading Data •Writing (or deleting) Data •MVCC •Logical Layout •Logical-Physical Mappings
Getting Started with Amazon RDS for MariaDB
With Amazon Relational Database Service (Amazon RDS) for MariaDB, you can run the MariaDB open-source database engine on the Amazon Web Services (AWS) relational database service, Amazon RDS. In this Getting Started course, you will learn the benefits, typical use cases, and technical concepts of Amazon RDS for MariaDB. You will be able to try the service through demonstrations using the Amazon RDS console. •Course level: Fundamental •Duration: 1 hour Activities: This course includes demonstrations, graphics, and interactive activities. Course objectives: In this course, you will: •Understand how Amazon RDS for MariaDB works. •Familiarize yourself with the technical concepts of Amazon RDS for MariaDB. •Learn typical use cases for Amazon RDS for MariaDB. •Learn what it would take to implement Amazon RDS for MariaDB in a real-world scenario. •Recognize the benefits of Amazon RDS for MariaDB. •Understand the cost structure of Amazon RDS for MariaDB. •See how to use Amazon RDS for MariaDB on the Amazon RDS console and use the AWS Command Line Interface (AWS CLI). Intended audience: This course is intended for: •Developers •Solutions architects •Cloud practitioners •IT operations engineers •IT professionals •IT leaders •Database administrators Prerequisites: No prerequisites needed. Course outline: •Amazon RDS for MariaDB basics •Using Amazon RDS for MariaDB •Learn more
Getting Started with Amazon DocumentDB (with MongoDB compatibility)
Using Amazon DocumentDB (with MongoDB compatibility), a document database service, you can store and scale JavaScript Object Notation (JSON) workloads. You don’t need to worry about running cluster management software, configuring backups, or monitoring production workloads. You can also migrate self-managed MongoDB-compatible databases to Amazon DocumentDB because it is fully managed. In this course, you will learn about the benefits and technical concepts of Amazon DocumentDB. You will review how to start with Amazon DocumentDB through a demo using the AWS Management Console and AWS Command Line Interface (AWS CLI). You will also learn about the native architecture and how built-in features help scale and manage your document database workload. The course covers where Amazon DocumentDB fits in a larger cloud-based architecture and includes typical use cases for building solutions. •Course level: Fundamental •Duration: 1 hour Activities: This course includes demonstrations, graphics, and interactive activities. Course objectives: In this course, you will learn to: •Understand how Amazon DocumentDB works •Familiarize yourself with the technical concepts of Amazon DocumentDB •List typical use cases for Amazon DocumentDB •Specify what it would take to implement Amazon DocumentDB in a real-world scenario •Recognize the benefits of Amazon DocumentDB •Explain the cost structure of Amazon DocumentDB •Use Amazon DocumentDB with AWS CLI in the AWS Management Console Intended audience: This course is intended for: •Developers •Solutions architects •Cloud practitioners •IT operations engineers •IT professionals •IT leaders •Database administrators Prerequisites: None Course outline: •Introduction to Amazon DocumentDB •Architecture and Use Cases •Create an Amazon DocumentDB Cluster •Insert and Query Data in Amazon DocumentDB •Use AWS CLI with Amazon DocumentDB •Connect to Amazon DocumentDB Using Programming Languages •Learn More
Amazon RDS Service Primer
This course introduces you to Amazon Relational Database Service (Amazon RDS) and its core features and capabilities. The course describes how this service integrates with other AWS services, introduces important terminology and technology concepts, and includes a demonstration of the service. Intended Audience: This course is intended for: •IT professionals •Data platform engineers •Database developers •Solutions architects Course Objectives: In this course, you will learn to: •List the purpose of the service and its function •Summarize the benefits of the service •Recall how the service works •Identify use cases for the service •Recognize how the service is billed •Recall how to get additional information on the service •Clarify how this service integrates with other services •Summarize the relevant terminology associated with this service •Identify security strategies used by this service Prerequisites: We recommend that attendees of this course have the following prerequisites: •None Delivery Method: This course is delivered through: •Digital training Duration: •20 Minutes Course Outline: This course covers the following concepts: •Service Introduction •Service Technical Overview •Service Demonstration •Service Assessment •Service Review
Amazon Quantum Ledger Database (QLDB) Service Primer
This course introduces you to Amazon QLDB and its core features and capabilities. The course describes how this service integrates with other AWS services, introduces important terminology and technology concepts, and includes a demonstration of the service. Intended Audience: This course is intended for: •IT professionals •Data platform engineers •Database developers •Solutions architects Course Objectives: In this course, you will learn to: •List the purpose of the service and its function •Summarize the benefits of the service •Recall how the service works •Identify use cases for the service •Recognize how the service is billed •Recall how to get additional information on the service •Clarify how this service integrates with other services •Summarize the relevant terminology associated with this service •Identify security strategies used by this service Prerequisites: We recommend that attendees of this course have the following prerequisites: •None Delivery Method: This course is delivered through: •Digital training Duration: •20 Minutes Course Outline: This course covers the following concepts: •Service Introduction •Service Technical Overview •Service Demonstration •Service Assessment •Service Review
Amazon Neptune Service Primer
This course introduces you to Amazon Neptune and its core features and capabilities. The course describes how this service integrates with other AWS services, introduces important terminology and technology concepts, and includes a demonstration of the service. Intended Audience: This course is intended for: •IT professionals- •Data platform engineers •Database developers •Solutions architects Course Objectives: In this course, you will learn to: •List the purpose of the service and its function •Summarize the benefits of the service •Recall how the service works •Identify use cases for the service •Recognize how the service is billed •Recall how to get additional information on the service •Clarify how this service integrates with other services •Summarize the relevant terminology associated with this service •Identify security strategies used by this service Prerequisites: We recommend that attendees of this course have the following prerequisites: •None Delivery Method: This course is delivered through: •Digital training Duration: •20 minutes Course Outline: This course covers the following concepts: •Service Introduction •Service Technical Overview •Service Demonstration •Service Assessment •Service Review
Amazon ElastiCache Service Primer
This course introduces you to Amazon ElastiCache and its core features and capabilities. The course describes how this service integrates with other AWS services, introduces important terminology and technology concepts, and includes a demonstration of the service. Intended Audience: This course is intended for: •IT professionals •Data platform engineers •Database developers •Solutions architects Course Objectives: In this course, you will learn to: •List the purpose of the service and its function •Summarize the benefits of the service •Recall how the service works •Identify use cases for the service •Recognize how the service is billed •Recall how to get additional information on the service •Clarify how this service integrates with other services •Summarize the relevant terminology associated with this service •Identify security strategies used by this service Prerequisites: We recommend that attendees of this course have the following prerequisites: •None Delivery Method: This course is delivered through: •Digital training Duration: •20 Minutes Course Outline: This course covers the following concepts: •Service Introduction •Service Technical Overview •Service Demonstration •Service Assessment •Service Review
