Drive your career forward

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.