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.
Key Highlights: