WHAT YOU WILL LEARN
Compose and execute varied forms of SQL statements and queries to entry and manipulate information in databases
Deploy, Handle, Safe, Operationalize, Monitor and Optimize relational database techniques like MySQL, PostgreSQL, and DB2
Create Knowledge Pipelines to extract, remodel and cargo information repositories utilizing shell scripts, and instruments equivalent to Apache Airflow & Kafka
Design and populate Knowledge Warehouses and analyze their information with Enterprise Intelligence (BI) instruments like Cognos Analytics
SKILLS YOU WILL GAIN
- Relational Database (RDBMS)
- Enterprise Intelligence (BI)
- Enterprise Knowledge Warehouse (EDW)
- SQL
- Extract Remodel Load (ETL)
- Knowledge Science
- Database (DBMS)
- NoSQL
- Database (DB) Design
- Database Structure
- Postgresql
- MySQL
About this Skilled Certificates
This Skilled Certificates is meant that will help you develop the job-ready expertise and portfolio for an entry-level Enterprise Intelligence (BI) or Knowledge Warehousing Engineering place. All through the web programs on this program, you’ll immerse your self within the in-demand function of a Knowledge Warehouse Engineer and purchase the important expertise it is advisable work with a variety of instruments and databases to design, deploy, operationalize and handle Enterprise Knowledge Warehouses (EDW).
By the tip of this Skilled Certificates, it is possible for you to to carry out the important thing duties required in an information warehouse engineering function. You’ll work with Relational Database Administration Techniques (RDBMS) and question information utilizing SQL statements.
You’ll use Linux/UNIX shell scripts to automate repetitive duties, and construct information pipelines with instruments like Apache Airflow and Kafka to Extract, Remodel and Load (ETL) information. You’ll acquire expertise with managing databases and information warehouses.
Lastly, you’ll design and populate information warehouse techniques and make the most of Enterprise Intelligence instruments to research and extract insights utilizing experiences and dashboards.
This program is appropriate for anybody with a ardour for studying and is appropriate for you whether or not you may have a school diploma or not and doesn’t require any prior information engineering, or programming expertise.
Utilized Studying Mission
Every course contains quite a few hands-on labs and a venture to hone and apply the ideas and expertise you study. By the tip of this system, you should have designed, carried out, configured, queried, and maintained quite a few databases and created information pipelines utilizing real-world instruments and information repositories to construct a portfolio of job-ready expertise.
You’ll begin by provisioning a database occasion on Cloud. Subsequent, you’ll design databases utilizing Entity-Relationship Diagrams (ERD) and create database objects like tables and keys utilizing MySQL, PostgreSQL and IBM Db2.
You’ll then turn into proficient with querying databases with SQL utilizing SELECT, INSERT, UPDATE and DELETE statements, and study to filter, type & combination end result units. Subsequent, you’ll turn into accustomed to frequent Linux/Unix shell instructions and use them to construct Bash scripts.
You will create Knowledge Pipelines for batch and streaming ETL jobs utilizing Apache Airflow and Kafka. Lastly, implement information warehouses & create BI dashboards.
0 Comments