К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Build a Data Warehouse in AWS · LearnSpace
Назад в каталог
courseraIT и технологии

Build a Data Warehouse in AWS

Курс от Edureka
Средний≈ 15.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Data Warehouse in AWS is a hands-on course designed to help you master the fundamentals of Amazon Redshift and cloud-based data warehousing. This course provides practical knowledge to help you build, manage, and optimize data warehouses using AWS services. Throughout the course, you will explore core AWS data warehousing concepts, work with real-world data, and learn how to use Amazon Redshift for scalable, high-performance analytics. By the end of this course, you will be able to: - Explore and understand the concepts of AWS Services used for Data Warehousing in AWS. - Gain proficiency in creating and managing IAM users and groups, understanding IAM policies and roles, and applying this knowledge in practical, hands-on scenarios. - Differentiate between traditional and cloud storage, operate Simple Storage Service, and understand various storage classes and versioning in AWS S3. - Gain a solid understanding of Amazon Redshift and effectively utilize it for data warehousing needs. - Effectively set up and managed a data warehouse using Amazon Redshift. - Develop a thorough understanding and practical expertise in implementing ETL (Extract, Transform, Load) processes in Amazon Redshift. - Acquire knowledge on monitoring and optimizing the performance of Amazon Redshift environments. This course is designed for Data Engineers, Cloud Solution Architects, Data Analysts, Database Administrators (DBAs), Software Developers, and Engineers seeking to explore the AWS Data Warehouse and its applications. Prior working experience with RDBMS, SQL, and AWS is recommended but optional for this course. Begin an educational journey to learn about the Data Warehouse in AWS and its concepts for handling and analyzing large volumes of data.

Навыки, которые вы освоите

Identity and Access ManagementQuery LanguagesCloud Computing ArchitectureCloud StorageUser ProvisioningData ManagementServerless ComputingDatabase Architecture and Administration

Программа курса

4 модулей · 158 учебных материалов

01Introduction to AWS Services48 материалов

Introduction to Cloud Computing and AWS

Course Syllabus: Build a Data Warehouse in AWSЧтениеCourse IntroductionВидеоYour Baseline Knowledge CheckpointDIALOGUEData Center and VirtualizationЧтение

Учитесь у экспертов

Edureka

Преподаватель курса

Build a Data Warehouse in AWS
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 15.6 ч

4 модулей

Язык: Английский

Субтитры: Испанский

Часть программы вашего университета
Introduction to Cloud ComputingВидео
Cloud Computing Service ModelsВидео
Cloud Computing Deployment Models Видео
Amazon Web Services and Its BenefitsВидео
Amazon Regions and Availability ZonesВидео
Practice Knowledge Check: Introduction to Cloud Computing and AWSЗадание
How to Use Discussion ForumsЧтение
How does AWS and cloud computing improve business efficiency? Обсуждение

AWS Free Tier Account

What is a Free Tier Account?ВидеоSignup an AWS Free Tier AccountВидеоDifferent Amazon Web ServicesВидеоWays to access AWS: CLI, Console, and SDKsВидеоConfiguration of AWS CLIЧтениеPractice Knowledge Check: AWS Free Tier AccountЗаданиеHow has AWS Free Tier impacted your cloud experience?Обсуждение

Identity and Access Management in AWS

Identity and Access Management (IAM)ВидеоConcept of Creating and Managing an IAM Users ВидеоCreating and Managing IAM Users on Management ConsoleВидеоCreate a New IAM User GroupВидеоCreating an IAM RoleВидеоIAM PoliciesВидеоCreating Policies for New UsersЧтениеMiscellaneous topics on IAMЧтениеPractice Knowledge Check: Identity and Access Management in AWSЗаданиеHow does AWS IAM strengthen security? Share best practices for user access in AWS.Обсуждение

Compute Services in AWS

Amazon Elastic Compute Cloud (EC2)ВидеоAmazon Machine Image (AMI) and Instance TypesВидеоSecurity Groups in AWSВидеоCreating an EC2 instanceВидеоCreating a Custom AMIВидеоNetworking Layer in EC2ЧтениеElastic Block Store (EBS)ЧтениеPractice Knowledge Check: Compute Services in AWSЗаданиеHow does EC2's elasticity optimize costs in AWS? Обсуждение

Storage Services in AWS

Traditional Storage and Cloud StorageЧтениеOverview of Simple Storage ServiceВидеоWorking on S3 and Bucket PolicyВидеоCreation of an S3 BucketВидеоVersioning in AWS S3ВидеоPractice Knowledge Check: Storage Services in AWSЗаданиеWhat makes Amazon S3 stand out in AWS storage? Discuss its advantages, use cases, and how it addresses common challenges for businesses in the cloud.Обсуждение

Module Wrap Up and Assessment

End Module Knowledge CheckpointDIALOGUEGraded Knowledge Check: Introduction to AWS Services ЗаданиеSummaryЧтение
02Empowering Data Warehousing using SQL and AWS32 материалов

Networking using AWS

CIDR, Private vs Public IPЧтениеOverview of Virtual Private Cloud (VPC) and its ComponentsВидеоVPC and SubnetsВидеоInternet Gateways and Route TablesВидеоAWS Networking TerminologiesЧтениеPractice Knowledge Check: Networking using AWSЗаданиеDiscuss the advantages and challenges of networking on AWS, focusing on key features and best practices for scalability and reliabilityОбсуждение

Databases in AWS

Database Services Provided by AWSВидеоAmazon RDSВидеоRDS Database InstancesВидеоIdentity and Access Management in Amazon RDSВидеоCreation of RDSВидеоPractice Knowledge Check: Databases in AWSЗаданиеHow do AWS databases enhance scalability and performance in cloud applications? Discuss key services and considerations for various use cases

Overview of SQL

Introduction to SQLВидеоDDL CommandsВидеоDQL CommandsВидеоDML CommandsВидеоDCL CommandsВидеоTCL CommandsЧтениеPractice Knowledge Check: Overview of SQLЗадание

Introduction to Data Warehousing

Introduction to Data WarehousingВидеоData Warehouse ComponentsВидеоData Modeling in Data WarehousingВидеоELT Processes in Data WarehousingВидеоBenefits and Challenges of Data WarehousingВидеоPractice Knowledge Check: Introduction to Data WarehousingЗадание

Module Wrap Up and Assessment

End Module CheckpointDIALOGUEGraded Knowledge Check: Empowering Data Warehousing using SQL and AWS ЗаданиеSummaryЧтение
03Fundamentals of Amazon Redshift32 материалов

Getting Started with Amazon Redshift

Introduction to Amazon RedshiftВидеоFeatures of Amazon Redshift: Key Features and CapabilitiesВидеоFeatures of Amazon Redshift: Price PerformanceВидеоArchitecture of Redshift Data WarehouseВидеоWorking of RedshiftВидеоData Processing Flow in Amazon RedshiftВидеоWhy use Amazon Redshift: Setup ProcessВидеоWhy use Amazon Redshift: Better PerformanceВидеоBenefits and real-life use cases of Amazon RedshiftЧтениеShare reasons why organizations might choose Amazon Redshift over other data warehousing solutions.ОбсуждениеGetting Started with Amazon RedshiftЗадание

Classification of Amazon Redshift

Amazon Redshift ServerlessВидеоAmazon Redshift Serverless ArchitectureВидеоAmazon Redshift Provisioned Clusters: IntroductionВидеоAmazon Redshift Provisioned Clusters: Key ComponentsВидеоAmazon Redshift provisioned clusters Architecture: IllustrationВидеоAmazon Redshift provisioned clusters Architecture: ComponentsВидео

Key Elements in Amazon Redshift

Clusters in RedshiftВидеоNodes in RedshiftВидеоAmazon Redshift Serverless workgroups and namespacesВидеоColumnar Storage in Amazon RedshiftВидеоSecurity in Amazon Redshift: IntroductionВидеоSecurity in Amazon Redshift: Data EncryptionВидео

Module Wrap Up and Assessment

End Module CheckpointDIALOGUEFundamentals of Amazon RedshiftЗадание
04Build a Data Warehouse in Amazon Redshift46 материалов

Setting up Data Warehouse in Amazon Redshift

AWS Secrets ManagerВидеоCreating KMS for Redshift ServerlessВидеоIAM Roles Configuration for Redshift Query Editor v2ВидеоCreating Data Warehouse in Amazon RedshiftВидеоCreating Data Warehouse in Amazon Redshift: DemonstrationВидеоUploading Sample Data to S3ВидеоUploading Sample Data to S3: DemonstrationВидеоCreate Tables in Query Editor v2ВидеоLoading Data from S3 to Amazon RedshiftВидеоLoading Data from S3 to Amazon Redshift: DemonstrationВидеоRunning Sample QueriesВидеоVisualizing QueriesВидеоVisualizing Queries DemonstrationВидеоMaterialized ViewsВидеоMaterialized Views DemonstrationВидеоDiscuss the importance of Key Management Service (KMS) in the context of Redshift Serverless. How does it contribute to data encryption and security in a serverless environment?ОбсуждениеSetting up Data Warehouse in Amazon RedshiftЗадание

Redshift Spectrum

Amazon Redshift SpectrumВидеоQuerying Data using Redshift Spectrum: IAM Role and Cluster CreationВидеоQuerying Data using Redshift Spectrum: Creating External SchemaВидеоQuerying Data using Redshift Spectrum Demonstration: IAM Role and Cluster CreationВидеоQuerying Data using Redshift Spectrum Demonstration: Creating External Schema and TablesВидеоRedshift Spectrum Pricing ModelЧтение

ETL in Amazon Redshift

ETL (Extract, Transform and Load): IntroductionВидеоETL (Extract, Transform and Load): Working of ETLВидеоZero-ETLВидеоZero-ETL with Amazon Redshift Demonstration: Creating Database and TablesВидеоZero-ETL with Amazon Redshift Demonstration: Connecting to AuroraВидеоZero-ETL with Amazon Redshift Demonstration: Running Zero-ETL QueriesВидео

Monitoring in Amazon Redshift

Introduction to Monitoring in RedshiftЧтениеMonitoring cluster performance dataВидеоMonitoring query history dataВидеоMonitoring database performance dataВидеоMonitoring workload concurrency and concurrency scaling dataВидеоExplore how monitoring individual queries and loads can contribute to performance tuning and optimization efforts.Обсуждение

Module Wrap Up and Assessment

Build a Data Warehouse in Amazon RedshiftЗадание

End Course Assessment and Project

End Course CheckpointDIALOGUEPractice ProjectЧтениеBuild a Data Warehouse in AWSЗаданиеCourse Summary: Build a Data Warehouse in AWSВидео
Обсуждение
What are the key principles and functionalities of SQL, and how does it serve as a fundamental tool for managing and manipulating relational databases?Обсуждение
How does data warehousing contribute to effective decision-making in organizations? Discuss key concepts, benefits, and real-world applications.Обсуждение
Comparison between Amazon Redshift Serverless and Provisioned ClustersВидео
Redshift Pricing ModelЧтение
Discuss the real-world examples or case studies highlighting the effective use of Amazon Redshift Serverless and Provisioned Clusters.Обсуждение
Classification of Amazon RedshiftЗадание
Users and Groups in Amazon RedshiftЧтение
Discuss the advantages of columnar storage over traditional row-based storage, especially in terms of query performance and data compression.Обсуждение
Key Elements in Amazon RedshiftЗадание
Discuss strategies for optimizing performance when querying data using Redshift Spectrum. How can users fine-tune their queries to achieve faster results? Share your experiences in overcoming performance bottlenecks and ensuring efficient data retrieval.Обсуждение
Redshift SpectrumЗадание
Considerations when using zero-ETL integrations with Amazon RedshiftЧтение
Discuss key features of Amazon Redshift that make it suitable for Zero-ETL integrations.Обсуждение
ETL in Amazon RedshiftЗадание
Monitoring in Amazon RedshiftЗадание