IBM
IBM Relational Database Administrator 专业证书
IBM

IBM Relational Database Administrator 专业证书

Build job-ready database skills. Gain practical experience in the high-demand fields of data management and data engineering, valued by employers with hands-on skills and experience employers look for.

Abhishek Gagneja
Joseph Santarcangelo
Rav Ahuja

位教师:Abhishek Gagneja

12,942 人已注册

包含在 Coursera Plus

获得职业证书,展示您的专业知识
4.7

(305 条评论)

中级 等级

推荐体验

6 月 完成
在 10 小时 一周
灵活的计划
自行安排学习进度
获得职业证书,展示您的专业知识
4.7

(305 条评论)

中级 等级

推荐体验

6 月 完成
在 10 小时 一周
灵活的计划
自行安排学习进度

您将学到什么

  • Gain job-ready database skills by mastering core RDBMS concepts used across industries

  • Learn SQL and work with popular databases like MySQL and PostgreSQL to retrieve and manage data efficiently

  • Design smarter databases with techniques like data optimization, stored procedures, and seamless data transfers using ETL/ELT processes

  • Ensure top performance and security by optimizing queries, managing user roles, and leveraging AI to improve workflows

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言:英语(English)

了解顶级公司的员工如何掌握热门技能

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

借助热门技能来开拓您的职业生涯

  • 接受 IBM 的专业级培训
  • 展现您对技术的精通程度
  • 通过 IBM 获得雇主认可的证书

专业认证 - 11门课程系列

Introduction to Data Engineering

Introduction to Data Engineering

第 1 门课程13小时

您将学到什么

  • List basic skills required for an entry-level data engineering role.

  • Discuss various stages and concepts in the data engineering lifecycle.

  • Describe data engineering technologies such as Relational Databases, NoSQL Data Stores, and Big Data Engines.

  • Summarize concepts in data security, governance, and compliance.

您将获得的技能

类别:Data Pipelines
类别:Extract, Transform, Load
类别:Data Warehousing
类别:Data Security
类别:Data Architecture
类别:Data Store
类别:Data Governance
类别:Apache Spark
类别:Big Data
类别:SQL
类别:NoSQL
类别:Relational Databases
类别:Apache Hadoop
类别:Data Science
类别:Data Lakes
类别:Databases

您将学到什么

  • Describe data, databases, relational databases, and cloud databases.

  • Describe information and data models, relational databases, and relational model concepts (including schemas and tables). 

  • Explain an Entity Relationship Diagram and design a relational database for a specific use case.

  • Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

您将获得的技能

类别:Relational Databases
类别:Database Design
类别:SQL
类别:PostgreSQL
类别:MySQL
类别:Data Manipulation
类别:Database Architecture and Administration
类别:Data Integrity
类别:Database Management Systems
类别:Databases
类别:Data Modeling
类别:Data Management
类别:IBM DB2
类别:Command-Line Interface

您将学到什么

  • Develop a foundational understanding of Python programming by learning basic syntax, data types, expressions, variables, and string operations.

  • Apply Python programming logic using data structures, conditions and branching, loops, functions, exception handling, objects, and classes.

  • Demonstrate proficiency in using Python libraries such as Pandas and Numpy and developing code using Jupyter Notebooks.

  • Access and extract web-based data by working with REST APIs using requests and performing web scraping with BeautifulSoup.

您将获得的技能

类别:Python Programming
类别:Pandas (Python Package)
类别:Data Structures
类别:Web Scraping
类别:NumPy
类别:Data Manipulation
类别:Application Programming Interface (API)
类别:Object Oriented Programming (OOP)
类别:JSON
类别:Scripting
类别:Data Processing
类别:Data Analysis
类别:Data Import/Export
类别:Computer Programming
类别:Programming Principles
类别:Restful API
类别:Automation
类别:Jupyter
Python Project for Data Engineering

Python Project for Data Engineering

第 4 门课程9小时

您将学到什么

  • Demonstrate your skills in Python for working with and manipulating data

  • Implement webscraping and use APIs to extract data with Python

  • Play the role of a Data Engineer working on a real project to extract, transform, and load data

  • Use Jupyter notebooks and IDEs to complete your project

您将获得的技能

类别:Data Manipulation
类别:Web Scraping
类别:Extract, Transform, Load
类别:Python Programming
类别:Databases
类别:Unit Testing
类别:Code Review
类别:Restful API
类别:Data Transformation
类别:Integrated Development Environments
类别:Application Programming Interface (API)
类别:SQL
类别:Style Guides
类别:Data Processing

您将学到什么

  • Analyze data within a database using SQL and Python.

  • Create a relational database and work with multiple tables using DDL commands.

  • Construct basic to intermediate level SQL queries using DML commands.

  • Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

您将获得的技能

类别:SQL
类别:Pandas (Python Package)
类别:Relational Databases
类别:Jupyter
类别:Databases
类别:Data Analysis
类别:Data Manipulation
类别:Transaction Processing
类别:Query Languages
类别:Python Programming
类别:Stored Procedure

您将学到什么

  • Describe the Linux architecture and common Linux distributions and update and install software on a Linux system.

  • Perform common informational, file, content, navigational, compression, and networking commands in Bash shell.

  • Develop shell scripts using Linux commands, environment variables, pipes, and filters.

  • Schedule cron jobs in Linux with crontab and explain the cron syntax. 

您将获得的技能

类别:Linux Commands
类别:Shell Script
类别:Linux
类别:Unix Commands
类别:Unix
类别:Scripting
类别:File Management
类别:Linux Servers
类别:Bash (Scripting Language)
类别:Scripting Languages
类别:Command-Line Interface
类别:Ubuntu
类别:Operating Systems
类别:Automation
类别:Software Installation
类别:Network Protocols

您将学到什么

  • Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.

  • Explain batch vs concurrent modes of execution.

  • Implement ETL workflow through bash and Python functions.

  • Describe data pipeline components, processes, tools, and technologies.

您将获得的技能

类别:Data Pipelines
类别:Extract, Transform, Load
类别:Apache Airflow
类别:Apache Kafka
类别:Shell Script
类别:Big Data
类别:Data Processing
类别:Unix Shell
类别:Scalability
类别:Data Transformation
类别:Command-Line Interface
类别:Data Warehousing
类别:Performance Tuning
类别:Data Migration
类别:Data Integration
类别:Data Mart
类别:Web Scraping
Data Warehouse Fundamentals

Data Warehouse Fundamentals

第 8 门课程15小时

您将学到什么

  • Job-ready data warehousing skills in just 6 weeks, supported by practical experience and an IBM credential.

  • Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views.

  • Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.

  • How to design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

您将获得的技能

类别:Data Warehousing
类别:Data Lakes
类别:Star Schema
类别:Data Mart
类别:Snowflake Schema
类别:IBM DB2
类别:Query Languages
类别:Data Cleansing
类别:SQL
类别:Data Architecture
类别:Database Systems
类别:Extract, Transform, Load
类别:PostgreSQL
类别:Data Integration
类别:Data Modeling
类别:Data Quality
类别:Database Design
类别:Data Validation

您将学到什么

  • Create, query, and configure databases and access and build system objects such as tables.

  • Perform basic database management including backing up and restoring databases as well as managing user roles and permissions. 

  • Monitor and optimize important aspects of database performance. 

  • Troubleshoot database issues such as connectivity, login, and configuration and automate functions such as reports, notifications, and alerts. 

您将获得的技能

类别:Database Management
类别:Database Architecture and Administration
类别:MySQL
类别:Relational Databases
类别:Encryption
类别:Database Systems
类别:Database Administration
类别:Database Design
类别:Disaster Recovery
类别:Operational Databases
类别:IBM DB2
类别:System Monitoring
类别:Data Storage Technologies
类别:Performance Tuning
类别:Role-Based Access Control (RBAC)
类别:User Accounts
类别:PostgreSQL

您将学到什么

  • 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

您将获得的技能

类别:Data Warehousing
类别:Database Management
类别:Performance Tuning
类别:Extract, Transform, Load
类别:Data Pipelines
类别:Apache Airflow
类别:Relational Databases
类别:MySQL
类别:Database Design
类别:SQL
类别:Data Transformation
类别:Data Security
类别:Disaster Recovery
类别:Operational Databases
类别:PostgreSQL
类别:Database Administration
类别:Database Architecture and Administration

您将学到什么

  • Leverage various generative AI tools and techniques in data engineering processes across industries

  • Implement various data engineering processes such as data generation, augmentation, and anonymization using generative AI tools

  • Practice generative AI skills in hands-on labs and projects for data warehouse schema design and infrastructure setup

  • Evaluate real-world case studies showcasing the successful application of Generative AI for ETL and data repositories

您将获得的技能

类别:Generative AI
类别:Data Analysis
类别:Data Synthesis
类别:Extract, Transform, Load
类别:Data Warehousing
类别:Data Pipelines
类别:Artificial Intelligence
类别:Data Architecture
类别:Query Languages
类别:Responsible AI
类别:Data Ethics
类别:Data Infrastructure
类别:Data Mining
类别:Data Quality
类别:Database Design

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

Abhishek Gagneja
IBM
6 门课程238,660 名学生
Joseph Santarcangelo
IBM
36 门课程2,171,524 名学生
Rav Ahuja
IBM
56 门课程4,308,035 名学生

提供方

IBM

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情,我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程,Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好:它远不止于此。Coursera 让我无限制地学习。'
Coursera Plus

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能,使其在数字经济中脱颖而出

常见问题

¹ 基于美国 2021 年 Cousera 学生结果调查的结果。