Data Warehousing on AWS

صمّم مستودع بيانات على Amazon Redshift وشغّله. تطلق المجموعات، وتصمّم المخططات، وتدمج البيانات وتحمّلها، وتكتب الاستعلامات وتضبطها، وتستخدم Redshift Spectrum، وتصون المجموعات مع الوقت.

3 أياممتوسط10 وحدات

سجّل أو استفسر ←اسأل عبر واتساب

نظرة عامة

المنهاج

المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.

10 وحدات

Understand fundamental data warehousing concepts and how they align with cloud solutions. Explore the intersection of data warehousing and big data in AWS.

Overview of Redshift’s architecture and key functionality. Examine real-world use cases and how Redshift integrates with other AWS services.

Build and configure a Redshift cluster. Implement IAM access management, data encryption, and control user permissions.

Optimize table design with columnar compression, distribution styles, and sorting. Use best practices to enhance query performance and scalability.

Connect to Amazon S3, Amazon EMR, Amazon Kinesis Firehose, and DynamoDB. Use AWS Lambda and custom ingestion methods for real-time data flows.

Use the COPY command to ingest and prepare data for the data warehouse. Handle concurrent writes, data validation, and data processing workflows.

Use Redshift SQL, UDFs, and the EXPLAIN command. Apply techniques for performance tuning, workload balancing, and resource optimization.

Query data directly from Amazon S3 without loading it into Redshift. Configure external schemas and run Spectrum queries for serverless analytics.

Monitor performance with CloudWatch, manage events, backups, and cluster resizing. Review disaster recovery, logging, and cluster management strategies.

Use Amazon QuickSight to create dashboards and visual reports. Compare QuickSight editions and explore its use for SQL-based analytics and business intelligence.

لمن هذه الدورة

معماريو قواعد البيانات ومطوّرو ذكاء الأعمال ومهندسو البيانات.