> Formations > Amazon Web Services (AWS) - Data Warehousing on AWS
Course : Amazon Web Services (AWS) - Data Warehousing on AWSOfficial Course, AWS Certification Preparation
Practical course - 3d
- 21h00 - Ref. AWD
|
Download in PDF format
Share this course by email
 | Explain the fundamental concepts of data storage and their implementation on AWS |
| Designing a Data Warehouse with Amazon Redshift (node selection, distribution, compression, sorting) |
| Load, analyze, and optimize data to improve performance |
| Securing, Monitoring, and Managing an Amazon Redshift Cluster |
| Integrate Amazon Redshift with other AWS analytics services and BI tools |
Intended audience
Architects, database administrators and developers, and data analysts.
Prerequisites
Completion of the AWG (“AWS Technical Essentials”) training course or equivalent experience with AWS; foundational knowledge of relational databases and database design; and a good command of written English.
Practical details
Teaching methods
The training session will be conducted in French. Official course materials are available in English and in digital format.
Course schedule
1 Amazon Redshift Fundamentals and Implementation (Day 1)
- Introduction to Data Warehousing.
- Introducing Amazon Redshift.
- Overview of Amazon Redshift components and resources.
- Launching an Amazon Redshift cluster.
2 Data Warehouse Design and Data Loading (Day 2)
- Choose a data storage approach.
- Identification of data sources and requirements.
- Data Warehouse Architecture.
- Loading data into the data warehouse.
3 Optimization, Operation, and Analysis (Day 3)
- Query Optimization and Performance Tuning.
- Data Warehouse Monitoring and Auditing.
- Data Warehouse Maintenance.
- Data analysis and visualization.
PARTICIPANTS
Architects, database administrators and developers, and data analysts.
PREREQUISITES
Completion of the AWG (“AWS Technical Essentials”) training course or equivalent experience with AWS; foundational knowledge of relational databases and database design; and a good command of written English.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Architects, database administrators and developers, and data analysts.
PREREQUISITES
Completion of the AWG (“AWS Technical Essentials”) training course or equivalent experience with AWS; foundational knowledge of relational databases and database design; and a good command of written English.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.