中In this capstone project, you will apply the skills and knowledge you’ve gained from the IBM Relational Database Administrator Professional Certificate to some real-world database administration tasks.
Relational Database Administration Capstone Project
您将学到什么
Gain real-world, hands-on experience in database administration that you can discuss in interviews and showcase in your portfolio.
Design and implement OLTP and data warehouse schemas, manage data, and query data in MySQL and PostgreSQL
Perform ETL operations, extract data from RDBMS, NoSQL databases, and weblogs, and manage pipelines using Apache Airflow
Apply backup, restore policies, automate the process, set up user access management policies, encrypt data, and optimize SQL queries
您将获得的技能
要了解的详细信息
可分享的证书
添加到您的领英档案
作业
14 项作业
授课语言：英语（English）
了解顶级公司的员工如何掌握热门技能
积累 Data Management 领域的专业知识
本课程是 IBM Relational Database Administrator 专业证书 专项课程的一部分
在注册此课程时，您还会同时注册此专业证书。
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 IBM 获得可共享的职业证书
该课程共有6个模块
In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.
涵盖的内容
2个视频1篇阅读材料2个作业1个应用程序项目4个插件
In this module, you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.
涵盖的内容
2个视频3个作业2个应用程序项目
In this module, you will use the given Python script to perform various ETL operations that load the data warehouse with the required information. You will also write a pipeline that analyzes the web server log file, extracts the required lines and fields, transforms and loads data.
涵盖的内容
2个视频3个作业2个应用程序项目
In this module, you will perform back-up and restore operations on the database. You will also implement automation to streamline database management processes.
涵盖的内容
2个视频3个作业2个应用程序项目
In this module, you will optimize the query performance and memory utilization of your database. You will also implement data security protocols, including user access management strategies and data encryption.
涵盖的内容
2个视频3个作业2个应用程序项目
In this module, you will organize and submit your project deliverables for final evaluation. This module guides you through the submission process and outlines the criteria for assessing your work.
涵盖的内容
3篇阅读材料1个应用程序项目
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
提供方
从 Data Management 浏览更多内容
状态：免费试用
状态：免费试用
状态：免费试用
状态：免费试用
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
常见问题
A capstone project is a great opportunity for you to apply your skills in a real-world context. This then enables you to demonstrate your ability to solve complex problems and show employers you are job-ready.
A capstone projects gives you the chance to create a tangible, real-world project that you can showcase to potential employers and talk about in interviews, proving your capabilities. And it really boosts your confidence too!
Completing a capstone project gives you a concrete example of your skills, which you can present to hiring managers as proof of your practical experience and problem-solving abilities. It also gives you something to talk about in interviews and chat about with peers.
更多问题
提供助学金，