107 AWS Certified Database courses

Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB. Overview At the end of this course, the students will have learned: Migrate on-premises MySQL to Azure SQL DB for MySQL Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database. MIGRATE TO AZURE SQL DB FOR MYSQL & POSTGRESQL * OSS databases overview * Common OSS database workloads * Customer challenges in migration MIGRATE ON-PREMISES MYSQL TO AZURE SQL DB FOR MYSQL * Configure and Manage Azure SQL DB for MySQL * Migrate on-premises MySQL to SQL DB for MySQL * Application Migration * Post-migration considerations MIGRATE ON-PREMISES POSTGRESQL TO AZURE SQL DB FOR POSTGRESQL * Configure and Manage Azure SQL DB for PostgreSQL * Migrate on-premises MySQL to SQL DB for PostgreSQL * Application Migration * Post-migration considerations

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data MODULE 1: INTRODUCTION TO DATA WAREHOUSING * Relational databases * Data warehousing concepts * The intersection of data warehousing and big data * Overview of data management in AWS * Hands-on lab 1: Introduction to Amazon Redshift MODULE 2: INTRODUCTION TO AMAZON REDSHIFT * Conceptual overview * Real-world use cases * Hands-on lab 2: Launching an Amazon Redshift cluster MODULE 3: LAUNCHING CLUSTERS * Building the cluster * Connecting to the cluster * Controlling access * Database security * Load data * Hands-on lab 3: Optimizing database schemas MODULE 4: DESIGNING THE DATABASE SCHEMA * Schemas and data types * Columnar compression * Data distribution styles * Data sorting methods MODULE 5: IDENTIFYING DATA SOURCES * Data sources overview * Amazon S3 * Amazon DynamoDB * Amazon EMR * Amazon Kinesis Data Firehose * AWS Lambda Database Loader for Amazon Redshift * Hands-on lab 4: Loading real-time data into an Amazon Redshift database MODULE 6: LOADING DATA * Preparing Data * Loading data using COPY * Data Warehousing on AWS * AWS Classroom Training * Concurrent write operations * Troubleshooting load issues * Hands-on lab 5: Loading data with the COPY command MODULE 7: WRITING QUERIES AND TUNING FOR PERFORMANCE * Amazon Redshift SQL * User-Defined Functions (UDFs) * Factors that affect query performance * The EXPLAIN command and query plans * Workload Management (WLM) * Hands-on lab 6: Configuring workload management MODULE 8: AMAZON REDSHIFT SPECTRUM * Amazon Redshift Spectrum * Configuring data for Amazon Redshift Spectrum * Amazon Redshift Spectrum Queries * Hands-on lab 7: Using Amazon Redshift Spectrum MODULE 9: MAINTAINING CLUSTERS * Audit logging * Performance monitoring * Events and notifications * Lab 8: Auditing and monitoring clusters * Resizing clusters * Backing up and restoring clusters * Resource tagging and limits and constraints * Hands-on lab 9: Backing up, restoring and resizing clusters MODULE 10: ANALYZING AND VISUALIZING DATA * Power of visualizations * Building dashboards * Amazon QuickSight editions and feature

Duration 1 Days 6 CPD hours This course is intended for This course is intended for data warehouse engineers, data platform engineers, and architects and operators who build and manage data analytics pipelines. Completed either AWS Technical Essentials or Architecting on AWS Completed Building Data Lakes on AWS Overview In this course, you will learn to: Compare the features and benefits of data warehouses, data lakes, and modern data architectures Design and implement a data warehouse analytics solution Identify and apply appropriate techniques, including compression, to optimize data storage Select and deploy appropriate options to ingest, transform, and store data Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights Secure data at rest and in transit Monitor analytics workloads to identify and remediate problems Apply cost management best practices In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service. The course focuses on the data collection, ingestion, cataloging, storage, and processing components of the analytics pipeline. You will learn to integrate Amazon Redshift with a data lake to support both analytics and machine learning workloads. You will also learn to apply security, performance, and cost management best practices to the operation of Amazon Redshift. MODULE A: OVERVIEW OF DATA ANALYTICS AND THE DATA PIPELINE * Data analytics use cases * Using the data pipeline for analytics MODULE 1: USING AMAZON REDSHIFT IN THE DATA ANALYTICS PIPELINE * Why Amazon Redshift for data warehousing? * Overview of Amazon Redshift MODULE 2: INTRODUCTION TO AMAZON REDSHIFT * Amazon Redshift architecture Interactive Demo 1: Touring the Amazon Redshift console Amazon Redshift features Practice Lab 1: Load and query data in an Amazon Redshift cluster MODULE 3: INGESTION AND STORAGE * Ingestion * Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API * Data distribution and storage * Interactive Demo 3: Analyzing semi-structured data using the SUPER data type * Querying data in Amazon Redshift * Practice Lab 2: Data analytics using Amazon Redshift Spectrum MODULE 4: PROCESSING AND OPTIMIZING DATA * Data transformation * Advanced querying * Practice Lab 3: Data transformation and querying in Amazon Redshift * Resource management * Interactive Demo 4: Applying mixed workload management on Amazon Redshift * Automation and optimization * Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster MODULE 5: SECURITY AND MONITORING OF AMAZON REDSHIFT CLUSTERS * Securing the Amazon Redshift cluster * Monitoring and troubleshooting Amazon Redshift clusters MODULE 6: DESIGNING DATA WAREHOUSE ANALYTICS SOLUTIONS * Data warehouse use case review * Activity: Designing a data warehouse analytics workflow MODULE B: DEVELOPING MODERN DATA ARCHITECTURES ON AWS * Modern data architectures

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modeling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title. 1 - INTRODUCTION TO DATABASES * Introduction to Relational Databases * Other Databases and Storage * Data Analysis * SQL Server Database Languages 2 - DATA MODELING * Data Modelling * Designing a Database * Relationship Modeling 3 - NORMALIZATION * Fundamentals of Normalization * Normal Form * Denormalization 4 - RELATIONSHIPS * Introduction to Relationships * Planning Referential Integrity 5 - PERFORMANCE * Indexing * Query Performance * Concurrency 6 - DATABASE OBJECTS * Tables * Views * Stored Procedures, Triggers and Functions ADDITIONAL COURSE DETAILS: Nexus Humans 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4.5 Days 27 CPD hours This course is intended for This course is intended for individuals who have basic knowledge on cloud computing; on-premise system administrators; IT specialists, interested in AWS and Cloud Technologies. Overview Upon successful completion of this course, students will know how to design and deploy scalable, highly accessible and fault-tolerant systems in AWS. In this course, students will learn the main 'Managed Service' offered by AWS; How to design and deploy scalable, highly accessible and fault-tolerant systems in AWS; How to choose the most appropriate AWS service. INTRODUCTION * Course overview * Exam Blue Print * Public clouds & cloud economics * AWS Overview & Whitepapers * Setting up AWS Account IDENTITY AND ACCESS MANAGEMENT (IAM) * Local users, groups & roles * SAML providers * Policies * Cross Account Access * Best practices & Examples * Lab * Exam highlights * Sample questions SIMPLE STORAGE SERVICE (S3) & GLACIER * Buckets * Objects * Lifecycle * Configurations and permissions * Custom bucket policies * Best Practices & Examples * Lab * Exam highlights * Sample questions VIRTUAL PRIVATE CLOUD (VPC) * VPC * Internet gateway vs NAT Gateway * Elastic IPs * Subnets & Routing tables * Security Groups & Network Access Lists * VPC Peering & Endpoints * Managed VPN Connections * Best Practices & Examples * Lab * Exam highlights * Sample questions ELASTIC COMPUTE CLOUD (EC2) * Instances * Amazon Machine Images(AMIs) * Elastic Block Store (EBS) * Network & Security * Load Balancers (ELB) * Auto Scaling Groups (ASG) * Instance Management * Best Practices & Examples * Lab * Exam highlights * Sample questions ROUTE 53 * Hosted Zones * Health checks * Traffic flow * Best Practices & Examples * Lab * Exam highlights * Sample questions RELATIONAL DATABASE SERVICE (RDS) * Engine types * Performance & Resilience * Subnet groups * Best Practices & Examples * Lab * Exam highlights * Sample questions CLOUDWATCH * Dashboard and Metrics * CloudWatch logs * CloudWatch rules * Best Practices & Examples * Lab * Exam highlights * Sample questions OTHER AWS SERVICES SIMPLE OVERVIEW * CloudFront * DynamoDB * Elasticache * Redshift * SQS * SWF * SNS * Elastic Transcoder * API Gateway * Kenesis * CloudFormation * Exam highlights * Sample questions MULTIPLE AWS SERVICES EXERCISE * Lab 1 - Architecting multi-tier environment * Lab 2 - Configure backup and monitoring PRACTICE EXAM ADDITIONAL COURSE DETAILS: Nexus Humans AWS Certified Solutions Architect - Associate training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AWS Certified Solutions Architect - Associate course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Cloud Solutions Architects  DevOps Engineers  Individuals using Google Cloud Platform who deploy applications, monitor operations, and manage enterprise solutions Overview At course completion, you will have attained knowledge of: Fundamentals of Google Cloud Platform (GCP) Google Cloud Storage Google Compute Engine Google Cloud SQL Load Balancing (LB) Google Cloud Monitoring Auto-Scaling Virtual Private Cloud (VPC) Network Cloud Identity and Access Management (IAM) Cloud CDN and DNS Cloud VPN Google Cloud Deployment Manager Google Container Engine Cloud Run Cloud Bigtable Cloud Datastore Cloud BigQuery Cloud DataFlow Cloud DataProc Cloud Pub/Sub In this course you will attain a deep knowledge of Google Cloud Platform infrastructure and design patterns on developing applications on GCP. This course will prepare you for the Google Cloud Architect Associate Certification Exam. FUNDAMENTALS OF GOOGLE CLOUD PLATFORM (GCP) * Overview * Regions and Zones * Review of major GCP services * GOOGLE CLOUD STORAGE * Fundamental APIs * Consistency * Cloud Storage Namespace * Buckets and Objects * Bucket and Object Naming Guidelines * Encryption * Object Versioning * Object Lifecycle Management * Access Control * Access Control Lists * Signed URL * Multipart upload * Resumable upload * Understanding Pricing for Cloud Storage * Offline Media Import/Export * Architecture case study of common Use Cases of Google Cloud Storage * Hands-on: Cloud Storage Lab; Creating Buckets, objects, and managing access control * GOOGLE COMPUTE ENGINE * Compute Engine Architecture * VM Instances types * Persistence Disks * Images * Generating Custom Images * IP Addresses * Static IPs * Ephemeral * Access Control Options * IAM * Service Account * Monitoring Instances with Google Cloud Monitoring * Compute Engine Networks and Firewalls * Hands-on: Hosting an Application on Compute Engine * GOOGLE CLOUD SQL * Core advantages of Cloud SQL * Cloud SQL database instance types * Access Control * High availability options * Failover * Read replica * Backup options * On Demand * Automated * Understanding Pricing of Cloud SQL * LOAD BALANCING (LB) * Fundamentals of a Load Balancer * Network Load balancing * HTTPS Load balancing * Cross region Load balancing * Content Load balancing * Target proxies * SSL Load Balancing * Internal Load Balancing * Network Load Balancing * Understanding Pricing for Load Balancer * GOOGLE CLOUD MONITORING * Architecture of Cloud Monitoring * Supported metrics * Stackdriver Monitoring APIs * AUTO-SCALING * Overview of Autoscaling * Auto-scaling Fundamentals * Instance groups * Templates * Policies * Decisions * Hands-on: Deploying a scale application on GCP using Autoscaling, Compute Engine, Cloud SQL, Load Balancers. * VIRTUAL PRIVATE CLOUD (VPC) NETWORK * Salient features of Virtual Private Cloud (VPC) Network Infrastructure * Virtual Private Cloud (VPC) Networking Fundamentals * Subnetworks * Firewall * Internal DNS * Network Routes * Hands-on: Hosting Secure Applications in Google Cloud VPC Networks * CLOUD IDENTITY AND ACCESS MANAGEMENT (IAM) * Introduction * User and Service Accounts * IAM Roles * Policy * Hands-on: Managing Users, Policies and Granting Roles using Service Accounts * CLOUD CDN AND DNS * What is CDN * Google Cloud CDN * Cloud CDN Concepts * Some of the Cloud CDN Edge locations * Cloud DNS * Cloud DNS Terminologies * Supported Record Types * Hands-on: Moving an Existing Domain Name to Cloud DNS * CLOUD VPN * Cloud VPN overview * Types of Cloud VPN * Specifications * Maintenance and Availability * Google Cloud Deployment Manager * Deployment Manager * Deployment Manager Fundamentals * Runtime Configurator * Quotas * Hands-on: Generating and Creating Cloud Deployment Manager Template * GOOGLE CONTAINER ENGINE * Google Container Engine Overview * Docker Overview * Kubernetes Terminologies * Replication Controller * Deployment * Price and Quotas * Hands-on: Deploying WordPress Cluster using Container Engine * CLOUD RUN * Overview of Cloud Run * Deploy a Prebuilt Sample container * CLOUD BIGTABLE * Overview of Cloud Bigtable * Access Control * Performance * Locations * Cloud Datastore * Overview of Cloud Datastore * Limits * Storage Size * Multitenancy * Benefits of Multitenancy * Encryption * Locations * CLOUD BIGQUERY * BigQuery Overview * Interacting with BigQuery * Datasets, Tables, and Views * Partitioned Tables * Query Plan Explanation * Hands-on: Getting Started with BigQuery * CLOUD DATAFLOW * Overview * Programming Model * DataFlow SDK 1.x for java * Cloud Dataflow SDK 2.x * Security and Permissions * Advanced Access Control * CLOUD DATAPROC * Overview * Clusters * Versioning * CLOUD PUB/SUB * Overview of Cloud Pub/Sub * Pub/Sub Concepts and Message Flow * Data Model * Cleanup of All Services * Hands-on: Cloud Pub/Sub Lab with Background Cloud Function * ADDITIONAL COURSE DETAILS: Nexus Humans Google Cloud Engineer Associate Certification Bootcamp training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Google Cloud Engineer Associate Certification Bootcamp course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for: Solutions architects and cloud architects seeking their AWS Certified Solutions Architect - Associate certification Customers and APN Partners who have 6 to 12 months of experience with AWS including a strong architecture background and experience Individuals who prefer an instructor led course for training and exam readiness Individuals who have not taken the Architecting on AWS course in the last ~6 months Overview In this course, you will learn to: Make architectural decisions based on AWS architectural principles and best practices Leverage AWS services to make your infrastructure scalable, reliable, and highly available Leverage AWS Managed Services to enable greater flexibility and resiliency in an infrastructure Make an AWS-based infrastructure more efficient to increase performance and reduce costs Use the Well-Architected Framework to improve architectures with AWS solutions Navigate the logistics of the examination process, exam structure, and question types Identify how questions relate to AWS architectural concepts Interpret the concepts being tested by an exam question This five-day, instructor-led course helps busy architects get away from the day-to-day to get focused and ready for their AWS Certified Solutions Architect ? Associate exam. Attendees learn the fundamentals of building IT infrastructure on AWS, so they can build scalable and resilient solutions in the cloud, by spending the first 3 days on the Architecting on AWS course. They?ll start getting in the exam readiness mindset with bonus end of module quizzes. Next, they?ll learn strategies to answer exam questions and avoid common mistakes with the Exam Readiness: AWS Certified Solutions Architect ? Associate half-day course. The course broadens attendees? knowledge of AWS services with deep dives into Amazon Redshift, Amazon Kinesis, and AWS Key Management Service, and then concludes with two quizzes and an instructor guided review of the AWS Certified Solutions Architect ? Associate practice exam. ARCHITECTING ON AWS * Module 1: Introduction * Module 2: The Simplest Architectures * Hands-On Lab 1: Hosting a Static Website * Module 3: Adding a Compute Layer * Module 4: Adding a Database Layer * Hands-On Lab 2: Deploying a Web Application on AWS * Module 5: Networking in AWS Part 1 * Hands-On Lab 3: Creating a Virtual Private Cloud ARCHITECTING ON AWS (CONTINUED) * Module 6: Networking in AWS Part 2 * Module 7: AWS Identity and Access Management (IAM) * Module 8: Elasticity, High Availability, and Monitoring * Hands-On Lab 4: Creating a Highly Available Environment * Module 9: Automation * Hands-On Lab 5: Automating Infrastructure Deployment with AWS CloudFormation * Module 10: Caching ARCHITECTING ON AWS (CONTINUED) * Module 11: Building Decoupled Architectures * Module 12: Microservices and Serverless Architectures * Hands-On Lab 6: Implementing a Serverless Architecture with AWS Managed Services * Module 13: RTP/RPO and Backup Recovery Setup * Module 14: Optimizations and Review EXAM READINESS: AWS CERTIFIED SOLUTIONS ARCHITECT -- ASSOCIATE * Module 0: The Exam * Module 1: Design Resilient Architectures * Module 2: Design Performant Architectures * Module 3: Specify Secure Applications and Architectures * Module 4: Design Cost-Optimized Architectures * Module 5: Define Operationally Excellent Architectures * EXAM READINESS * Additional deep dive of AWS services * Quiz #1 * Practice exam: AWS Certified Solutions Architect ? Associate * Quiz #2 * Wrap-up