Data Engineering Professional Certificate
What you will learn:
- Describe the core concepts, processes, tools and technologies in the field of data engineering.
- Demonstrate your aptitude with RDBMS fundamentals including design & creation of databases, schemas, tables; DB administration, security & working with MySQL, PostgreSQL & IBM Db2.
- Demonstrate your proficiency with SQL query language, SELECT, INSERT, UPDATE, DELETE statements, database functions, stored procs, working with multiple tables, JOINs, & transactions.
- Explain NoSQL and big data concepts including practice with MongoDB, Cassandra, IBM Cloudant, Apache Hadoop, Apache Spark, SparkSQL, SparkML, Spark Streaming.
- Describe ETL tools, data pipelines using Python, shell scripts with Linux, Apache Airflow and Apache Kafka.
- Describe Data Lakes, Data Marts and Enterprise Data Warehouses (EDW) and design them using Star and Snowflake schemas.
- Design and populate Data Warehouses and analyze their data with Business Intelligence (BI) tools like Cognos Analytics.