Need help finding the right learning solutions? Email Us: [email protected]
- Onboard For Tech Teams
- Reduce initial time to productivity.
- Increase employee tenure.
- Plug-and-play into HR onboarding and career pathing programs.
- Customize for ad-hoc and cohort-based hiring approaches.
- Upskill For Tech Teams
- Upgrade and round out developer skills.
- Tailor to tech stack and specific project.
- Help teams, business units, centers of excellence and corporate tech universities.
- Reskill For Tech Teams
- Offer bootcamps to give employees a running start.
- Create immersive and cadenced learning journeys with guaranteed results.
- Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.
- Design For Tech Teams
- Uplevel your existing tech learning framework.
- Extend HR efforts to provide growth opportunities within the organization.
- Prepare your team for an upcoming tech transformation.
Get your team started on a custom learning journey today!
Our Boulder, CO-based learning experts are ready to help!
Course Summary
Home > Courses >Cloud Computing Training >AWS >AWS Authorized Training Course – Data Warehousing on AWS
The Data Warehousing on AWS training course is designed to demonstrate the concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift.
The course examines how to collect, store, and prepare data for the data warehouse. Next, it evaluates how to use AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. The course concludes by exploring how to use Amazon QuickSight to perform analysis on your data.
AWS Authorized Training is only available in Argentina, Brazil, Canada, Chile, Colombia, Costa Rica, Mexico, United States, and Peru.
THIS COURSE IS NOT ELIGIBLE FOR TRAINING BUNDLES.
Purpose
How to a cloud-based data warehousing solution using Amazon Redshift
Audience
Database Architects, Database Administrators, Database Developers, Data Analysts and Data Scientists
Role
Skill Level
Style
Duration
3 Days
Related Technologies
- Productivity Objectives:
- 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
- Utilize Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse
Request Information
Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.
If you are not completely satisfied with your training class, we'll give you your money back.
about our training
-
Real-World Content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
-
Expert Practitioners
Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
-
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
-
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
What You'll Learn
In the AWS Authorized Training Course – Data Warehousing on AWS training course, you'll learn:
- Introduction to Data Warehousing
- Relational databases
- Data warehousing concepts
- The intersection of data warehousing and big data
- Overview of data management in AWS
- Introduce Amazon Redshift Lab
- Introduction to Amazon Redshift
- Conceptual overview
- Real-world use cases
- Launch an Amazon Redshift cluster Lab
- Launching Clusters
- Build the cluster
- Connect to the cluster
- Control access
- Database security
- Load data
- Optimize database schemas
- Designing the Database Schema
- Schemas and data types
- Columnar compression
- Data distribution styles
- Data sort methods
- Identifying Data Sources
- Data sources overview
- Amazon S3
- Amazon DynamoDB
- Amazon EMR
- Amazon Kinesis Data Firehose
- AWS Lambda Database Loader for Amazon Redshift
- Load real-time data into an Amazon Redshift database Lab
- Loading Data
- Prepare Data
- Load data with COPY
- Maintain tables
- Concurrent write operations
- Troubleshoot load issues
- Load data with the COPY command
- 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)
- Configure workload management Lab
- Amazon Redshift Spectrum
- Amazon Redshift Spectrum
- Configure data for Amazon Redshift Spectrum
- Amazon Redshift Spectrum Queries
- Utilize Amazon Redshift Spectrum Lab
- Maintaining Clusters
- Audit log
- Performance monitor
- Events and notifications
- Audit and monitor clusters Lab
- Resize clusters
- Back up and restore clusters
- Resource tags and limits and constraints
- Back up, restore and resize clusters Lab
- Analyzing and Visualizing Data
- Power of visualizations
- Build dashboards
- Amazon QuickSight editions and features
Real-world content
Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners
Industry experts that bring their battle scars into the classroom.
Experiential Learning
More coding than lecture, coupled with architectural and design discussions.
Fully Customized
One-size-fits-all doesn't apply to training teams. That's where we come in!
Elite Instructor Program
We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.
Customized Technical Learning Solutions to Help Attract and Retain Talented Developers
Talk to one of our Learning Solution Architects today
Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.
DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.
“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”
VMwareAbout Us
LET’S DISCUSS
DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.
Resources
Thank you for everyone who joined us this past year to hear about our proven methods of attracting and retaining tech talent.
- Boulder, Colorado Headquarters: 980 W. Dillon Road, Louisville, CO 80027
© 2013 - 2022 DevelopIntelligence LLC - Privacy Policy