WHAT YOU WILL LEARN
Create, design, and handle relational databases and apply database administration (DBA) ideas to RDBMSes corresponding to MySQL, PostgreSQL, and IBM Db2.
Develop and execute SQL queries utilizing SELECT, INSERT, UPDATE, DELETE statements, database capabilities, saved procedures, Nested Queries, and JOINs.
Display working data of NoSQL & Large Information utilizing MongoDB, Cassandra, Cloudant, Hadoop, Apache Spark, Spark SQL, Spark ML, Spark Streaming.
Implement ETL & Information Pipelines with Bash, Airflow & Kafka; architect, populate, deploy Information Warehouses; create BI experiences & interactive dashboards.
SKILLS YOU WILL GAIN
- Relational Database Administration Syste (RDBMS)
- ETL & Information Pipelines
- NoSQL and Large Information
- Apache Spark
- SQL
- Information Science
- Database (DBMS)
- NoSQL
- Python Programming
- Information Evaluation
- Pandas
- Numpy
About this Skilled Certificates
This Skilled Certificates is for anybody who desires to develop job-ready abilities, instruments, and a portfolio for an entry-level knowledge engineer place. All through the self-paced on-line programs, you’ll immerse your self within the function of an information engineer and purchase the important abilities it’s essential to work with a spread of instruments and databases to design, deploy, and handle structured and unstructured knowledge.
By the tip of this Skilled Certificates, it is possible for you to to elucidate and carry out the important thing duties required in an information engineering function. You’ll use the Python programming language and Linux/UNIX shell scripts to extract, rework and cargo (ETL) knowledge. You’ll work with Relational Databases (RDBMS) and question knowledge utilizing SQL statements. You’ll use NoSQL databases and unstructured knowledge. You’ll be launched to Large Information and work with Large Information engines like Hadoop and Spark. You’ll acquire expertise with creating Information Warehouses and make the most of Enterprise Intelligence instruments to investigate and extract insights.
Every course consists of quite a few hands-on labs & initiatives to use the ideas and abilities you study. This system will culminate in a Capstone Undertaking the place you’ll convey collectively all of those abilities to develop and implement a complete knowledge platform with varied knowledge repositories and pipelines to handle a real-world impressed knowledge analytics downside.
This program doesn’t require any prior knowledge engineering, or programming expertise.
Utilized Studying Undertaking
All through this Skilled Certificates, you’ll full hands-on labs and initiatives that can assist you acquire sensible expertise with Python, SQL, Relational Databases, NoSQL Databases, Apache Spark, constructing an information pipeline, managing a database and dealing with knowledge in an information warehouse.
Within the closing course on this Skilled Certificates, you’ll full a Capstone Undertaking that applies what you could have realized to a real-world impressed situation that requires you to design, deploy and handle an end-to-end knowledge engineering platform consisting of assorted Relational (Transactional Information Warehousing), NoSQL & Large Information repositories in addition to knowledge piplelines to attach them.
0 Comments