Search icon Close icon
Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
AWS Certified Database – Specialty (DBS-C01) Certification Guide

You're reading from  AWS Certified Database – Specialty (DBS-C01) Certification Guide

Product type Book
Published in May 2022
Publisher Packt
ISBN-13 9781803243108
Pages 472 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Kate Gawron Kate Gawron
Profile icon Kate Gawron
LinkedIn
Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
See other products by Kate Gawron

Table of Contents (24) Chapters

Preface 1. Part 1: Introduction to Databases on AWS
2. Chapter 1: AWS Certified Database – Specialty Overview 3. Chapter 2: Understanding Database Fundamentals 4. Chapter 3: Understanding AWS Infrastructure 5. Part 2: Workload-Specific Database Design
6. Chapter 4: Relational Database Service 7. Chapter 5: Amazon Aurora 8. Chapter 6: Amazon DynamoDB 9. Chapter 7: Redshift and DocumentDB 10. Chapter 8: Neptune, Quantum Ledger Database, and Timestream 11. Chapter 9: Amazon ElastiCache 12. Part 3: Deployment and Migration and Database Security
13. Chapter 10: The AWS Schema Conversion Tool and AWS Database Migration Service 14. Chapter 11: Database Task Automation 15. Chapter 12: AWS Database Security 16. Part 4: Monitoring and Optimization
17. Chapter 13: CloudWatch and Logging 18. Chapter 14: Backup and Restore 19. Chapter 15: Troubleshooting Tools and Techniques 20. Part 5: Assessment
21. Chapter 16: Exam Practice
22. Chapter 17: Answers 23. Other Books You May Enjoy

Converting a database using SCT

Once you have completed the assessments and decided on a target database, you can use SCT to assist in converting the database objects and code. SCT carries out the following tasks:

  • SCT installs an extension pack that contains common functions that can be used in converted database code. This extension pack is supplied within the SCT program.
  • SCT checks all DDL statements in the source database and attempts to recreate those in the language of the target. This includes tables, views, indexes, and more.
  • SCT attempts to convert the database's code into the target database's code.
  • For those who cannot automatically convert either using the native code of the target database or via the added extension pack functions, it provides a report that shows where the issues with the conversion are and what action you need to take to resolve them.

Figure 10.2 showed some example output of an assessment report for a SQL Server source...

lock icon The rest of the chapter is locked
arrow left Previous Chapter
Chapter 1 of 24
Next Chapter arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at €14.99/month. Cancel anytime}

Authors (1)

Profile icon Kate Gawron
LinkedIn
Kate Gawron is a full-time senior database consultant and part-time future racing driver. She was a competitor in Formula Woman, and she aspires to become a professional Gran Turismo (GT) racing driver. Away from the racetrack, Kate has worked with Oracle databases for 18 years and AWS for five years. She holds four AWS certifications, including the AWS Certified Database – Specialty certification as well as two professional Oracle qualifications. Kate currently works as a senior database architect, where she works with customers to migrate and refactor their databases to work optimally within the AWS cloud.
Read more
See other products by Kate Gawron

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Designing and Implementing Microsoft Azure Networking Solutions
Designing and Implementing Microsoft Azure Networking Solutions
Designing and Implementing Microsoft Azure Networking Solutions Exam Ref AZ-700 is an all-encompassing guide to the AZ-700 exam and contains all the information you need to succeed in the world of virtual networking with Azure. With this book, you will be fully prepared for the exam and the world of cloud networking.
Aug 2023 17 hours 28 minutes
Microsoft 365 Security, Compliance, and Identity Administration
Microsoft 365 Security, Compliance, and Identity Administration
The Microsoft 365 Security, Compliance, and Identity Administration is a comprehensive guide that helps you employ Microsoft 365's robust suite of features and empowers you to optimize your administrative tasks.
Aug 2023 21 hours 0 minutes
Zero Trust Overview and Playbook Introduction
Zero Trust Overview and Playbook Introduction
Get started on Zero Trust with this step-by-step playbook and learn everything you need to know for a successful Zero Trust journey with tailored guidance for every role, covering strategy, operations, architecture, implementation, and measuring success. This book will become an indispensable reference for everyone in your organization.
Oct 2023 8 hours 0 minutes
The Self-Taught Cloud Computing Engineer
The Self-Taught Cloud Computing Engineer
This self-study book helps you master multiple clouds, including AWS, Azure, and GCP, and serves as a roadmap to becoming a certified cloud computing expert. The book will guide you to develop a professional cloud career by helping you build a broad cloud knowledge base, developing hands-on cloud computing skills, and getting cloud certified.
Sep 2023 15 hours 44 minutes
Technology Operating Models for Cloud and Edge
Technology Operating Models for Cloud and Edge
This book will help you build and create ownership of a technology operating model, as well as connect your leadership with engineering and operations, keeping your internal and external customers in mind. It provides practical tips on why, where, and how to make the cloud and edge platform paradigm sing for you, your team, and your organization.
Aug 2023 7 hours 36 minutes
Azure Architecture Explained
Azure Architecture Explained
Azure is the preferred platform to build mission-critical and secure apps. This book provides comprehensive coverage of essential Azure products, services, and solutions vital for every solution architect's success. Elevate your knowledge and master the critical components of Azure to excel in your role with Azure Architecture Explained.
Sep 2023 14 hours 52 minutes
Pentesting Active Directory and Windows-based Infrastructure
Pentesting Active Directory and Windows-based Infrastructure
This practical guide helps you explore the pentesting of Microsoft infrastructure in detail, and enhances your offensive skillset by showing you the different ways to perform security assessment. This book will help blue teamers and IT engineers get up to speed with possible security issues they may encounter in their Windows environments.
Nov 2023 12 hours 0 minutes
Practical Ansible
Practical Ansible
In Practical Ansible, you'll work with the latest release of Ansible and learn to solve complex issues quickly with the help of task-oriented scenarios. You'll start by installing and configuring Ansible to automate monotonous and repetitive IT tasks and get to grips with concepts such as playbooks, inventories, plugins, collections, and network modules.
Sep 2023 14 hours 0 minutes
Windows 11 for Enterprise Administrators
Windows 11 for Enterprise Administrators
Microsoft’s launch of Windows 11 is a step toward satisfying the enterprise administrator’s needs for better management and enhanced user experience customization. This book provides the enterprise administrator with the knowledge needed to fully utilize the advanced feature set of Windows 11 Enterprise.
Oct 2023 9 hours 32 minutes
The Linux DevOps Handbook
The Linux DevOps Handbook
This book is for software and IT professionals seeking knowledge on Linux systems and DevOps practices. This book will provide you with guidance and tools to learn and gain proficiency in managing Linux-based infrastructures and knowledge of DevOps.
Nov 2023 14 hours 16 minutes
Right arrow icon