• phone icon +44 7459 302492 email message icon support@uplatz.com
  • Register

BUY THIS COURSE (GBP 32 GBP 99)
5 (250 reviews)
( 1167 Students )

 

Career Path - Data Engineer

Acquire key data engineering skills, build robust data pipelines, scalable solutions architecture for efficient data processing, integration, analysis
( add to cart )
Save 68% Offer ends on 31-Oct-2024
Course Duration: 100 Hours
Preview Career Path - Data Engineer course
  Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Popular
Trending
Job-oriented
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

Courses included in Data Engineer Career Path Program

1) SQL Programming with MYSQL Database

2) SAS BI and Data Integration

3) SAP Data Services (BODS)

4) Talend

 

Who is Data Engineer

Data engineers are responsible for finding trends in data sets and developing algorithms to help make raw data more useful to the enterprise.A data engineer transforms data into a useful format for analysis. Imagine that you’re a data engineer working on a simple competitor to Uber called Rebu. Your users have an app on their device through which they access your service. They request a ride to a destination through your app, which gets routed to a driver, who then picks them up and drops them off.

 

Roles & responsibilities of a Data Engineer

The data engineers design, build and install the data systems. These systems fuel machine learning and AI analytics. They also develop information processes for a whole host of data tasks. These include data acquisition, data transformation, and data modelling, among others.

The Data Architect: Their work allows data systems to ingest, integrate, and manage all the required sources of data for business insights and reporting. The work of a data architect may need in-depth knowledge of SQL, NoSQL, and XML, among other systems and tools

The Database Administrator: Database administrators help design and maintain database systems. They ensure that database systems function seamlessly for all users in an organization.

The Data Engineer: Data engineers understand several programming languages used in data science. These include the likes of Java, Python, and R. They know the ins-and-outs of SQL and NoSQL database systems. They also understand how to use distributed systems such as Hadoop. Having such a wide expanse of knowledge allows them to work with data architects, database administrators, and data scientists.

 

Uplatz provides this extensive Data Engineer Career Path training to make you well versed with the most important tools & technologies used in data engineering space.

Course/Topic 1 - SQL Programming with MySQL Database - all lectures

  • In this video get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types

    • 30:09
  • In this video learn basic of SQL Programming and overview the SQL basic commands and how we use these commands in SQL Programming. This SQL tutorial will teach you basics on how to use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

    • 42:45
  • In this video we talk about DDL (DATA DEFINATION LANGUAGE) and also cover all the basic techniques of DDL.In this video we will learn about the SQL commands – DDL, DML, DCL; SQL Constraints – Keys, Not Null, Check , Default, and also MYSQL Hands-on and basic Querying

    • 33:59
  • In this video session we learn SQL commands and how to use these commands like select command, insert command, delete command etc. In this video we will learn about hands-on experience on the terminal, creating database, Tables and manipulating data.

    • 38:49
  • In this video we learn about SQL Basic and Aggregate Functions and also cover different functions of SQL. This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows.

    • 37:02
  • In this session we talk about SQL Regular Expression and we also cover all techniques of SQL Regular Expression.This tutorial teaches us about clauses and the update command. We will also cover making records, updating and modifying rows and EML commands.

    • 36:07
  • In this video we learn about SQL Comparison Clauses and how we use Comparison Clauses in SQL. This tutorial covers Comparison Operators by relating values by a mathematical symbol which is used to compare two values. Learn about comparison operators result - TRUE, FALSE, or UNKNOWN

    • 28:30
  • In this session we learn about SQL String and also cover all types of string in SQL and how we can use SQL Strings. In this video we will learn about the basic string functions such as concat_ws, file format, and insert function, L-case, u case, and lower case. We will also learn about basic functions such as upper functions.

    • 30:31
  • In this session we cover advance level string function and also cover all different commands we use in SQL String Function. This video is a sequel for string functions tutorial. In this tutorial we will learn few most useful string functions such as spaces and null issue as well, L-Pad command.

    • 38:20
  • In this SQL String function part 3 we learn select Repeat function and Select Replace function and also cover different between Select Repeat function and Select Replace function. This tutorial is another sequel to string functions, however, these functions are used less and not used that frequently. We will further learn here about the repeat function, absolute function, ceiling, and floor and down functions.

    • 23:20
  • In this session we learn about SQL Numeric Functions and how we use Numeric functions in SQL. In this video, we will be covering numerical functions. Learn about the basic date functions and also about truncate functions.

    • 36:50
  • In this video session we learn about SQL Numeric Function and also cover the basic functionality of SQL Numeric Function. SQL Data Functions. In this video we will learn about few more Date functions. We will further look into the day function option as well. This tutorial covers basic querying over a single table.

    • 46:38
  • : In this video we talk about SQL Joins Introduction and Demonstration and basic join’s function and how to make table using joins. In this tutorial learn about joints in SQL. This tutorial teaches us how to connect two different tables with joints. We will also cover the topic of querying two or more tables and about subquery .

    • 36:52
  • In this lecture last session we talk about MySQL Workbench and procedures and Views and MySQL Workbench functionality. In this tutorial learn about SQL in automating things. This tutorial covers stroll procedure, functions and views which are helpful for automation purposes in SQL.

    • 21:22

Course/Topic 2 - SAS Business Intelligence - all lectures

  • This tutorial teaches you the integrated platform for delivering enterprise intelligence. This platform, which we call the SAS Enterprise Intelligence Platform, optimally integrates individual technology components within your existing IT infrastructure into a single, unified system.

    • 1:26:02
  • This session teaches the change management feature enables a team of SAS Data Integration Studio users to work simultaneously with a set of related metadata and avoid overwriting each other's changes. With change management, most users are restricted from adding or updating the metadata in a change-managed folder in the Folders tree.

    • 1:32:54
  • This teaches you the Data marts which are small slices of data warehouse. This module is a collection of tips on how to run your data mart implementation project Planning a Data Warehouse, Exercises

    • 1:26:33
  • This Help you to Learn how to build a data mart during SAS BI training, starting from reviewing a case study. Review of the Case Study, Define the Source Data, what are the Target Tables in SAS BI, Load the Target Tables, Exercises

    • 1:21:55
  • In this session, you will learn the On-Line Analytical Processing (or OLAP) has long been part of the data storage and exploitation strategy for SAS professional. Take an overview on OLAP in this module of SAS BI Training. What Is OLAP, Building an OLAP Cube in SAS BI, Solutions to Exercises

    • 1:11:53
  • This tutorial is designed to give you a good idea about SCD, its dimensions, load transformation and Lookup transformation. Defining Slowly Changing Dimensions in SAS BI How to use SAS BI SCD Type 2 Loader Transformation Using the Fact Table Lookup Transformation

    • 55:41
  • This session teaches you how to schedule data integration studio jobs during SAS BI training. Scheduling SAS Data Integration Studio Jobs

    • 1:11:38
  • In this session you will understand about the online analytical processing concepts, building an OLAP cube with SAS OLAP Cube Studio, building an information map from a SAS OLAP cube

    • 1:21:09
  • This video teaches you about the introduction to SAS Visual BI and exploring the SAS integration with JMP

    • 1:17:56
  • This tutorial helps you to Reviewing the platform for SAS Business Analytics and reviewing the course environment

    • 54:13
  • This video teaches you about the SAS Stored Process concepts, creating a stored process from a SAS Enterprise Guide project creating a stored process from a SAS program, creating stored process parameters, creating a stored process to provide a dynamic data source

    • 57:18

Course/Topic 3 - SAP Data Services (BODS) - all lectures

  • SAP BO Data Services consists of a UI development interface, metadata repository, data connectivity to source and target system and management console for scheduling of jobs. This introductory tutorial gives a brief overview of the features of SAP BODS and how to use it in a systematic manner.

    • 1:41:26
  • In this beginner's SAP BODS tutorial, you will learn, History of SAP BODS, SAP Data Services Advantages and the disadvantages of SAP BODS.

    • 1:37:53
  • SAP BODS is an ETL tool for extracting data from disparate systems, transform data into meaningful information, and load data in a data warehouse. It is designed to deliver enterprise-class solutions for data integration, data quality, data processing and data profiling.

    • 1:44:34
  • Data Services Designer is a developer tool, which is used to create objects consisting of data mapping, transformation, and logic. It is GUI based and works as a designer for Data Services.

    • 1:39:01
  • SAP BO Data Services (BODS) is an ETL tool used for data integration, data quality, data profiling and data processing. It allows you to integrate, transform trusted data-to-data warehouse system for analytical reporting.

    • 1:45:08
  • This tutorial will help all those students who want to create their own local repository, configure a job server, start basic job development and execute the job to extract data from source systems and load the data to target systems after performing transformations, look-ups and validations.

    • 1:38:08
  • This tutorial will help all those readers who want to create their own local repository, configure a job server, start basic job development and execute the job to extract data from source systems and load the data to target systems after performing transformations, look-ups and validations.

    • 1:29:13
  • Learn SAP Business Objects Data Services from basic concepts to advanced concepts starting from introduction, architecture, data services, file formats, data loading, etc.

    • 1:49:55
  • SAP BODS (Business Object Data Services) is an SAP DWH (Data Warehouse) product, where DWH is an enterprise level centralized reporting system. Data services is an end-to-end data integration, Data management, Test analysis software.

    • 1:54:16
  • Before you start this SAP BODS tutorial, you should have a basic knowledge of SAP system, RDBMS, Data warehouse and Business Intelligence (BI).

    • 1:52:00
  • SAP Bods training tutorials as per syllabus wise so beginners can easily learn SAP Business Object Data Services (Bods) step by step with real time project scenarios.

    • 1:37:31
  • SAP BODS combines industry data quality into one platform. BODS provides a single environment for development, run-time, management, security, and data connectivity.

    • 1:27:31
  • SAP BODS is an ETL tool that delivers a single enterprise-class solution for data integration, data quality, and data profiling that permits you to integrate, transform, improve, and provide trusted data that supports important business processes and enables sound decisions.

    • 1:37:14
  • It provides a GUI that allows us to efficiently produce a job that mine data from various sources, convert that data to meet the business requirements of an organization, and load data into a single place.

    • 1:43:07
  • SAP BO Data Services (BODS) is an ETL tool used for data integration, data quality, data profiling and data processing. It allows you to integrate, transform trusted data-to-data warehouse system for analytical reporting.

    • 1:29:54

Course/Topic 4 - Talend - all lectures

  • Lecture 1 - Talend Introduction

    • 15:06
  • Lecture 2 - Architecture and Installation - part 1

    • 49:38
  • Lecture 3 - Architecture and Installation - part 2

    • 54:24
  • Lecture 4 - Architecture and Installation - part 3

    • 47:31
  • Lecture 5 - File - Java - Filter Components

    • 53:39
  • Lecture 6 - tAggregateRow - tReplicate - tRunJob Components - part 1

    • 53:40
  • Lecture 7 - tAggregateRow - tReplicate - tRunJob Components - part 2

    • 06:17
  • Lecture 8 - Join Components - part 1

    • 38:00
  • Lecture 9 - Join Components - part 2

    • 19:34
  • Lecture 10 - Sort Components

    • 29:26
  • Lecture 11 - Looping Components

    • 24:19
  • Lecture 12 - Context - part 1

    • 37:48
  • Lecture 13 - Context - part 2

    • 33:37
  • Lecture 14 - Slowly Changing Dimensions (SCD)

    • 44:55
  • Lecture 15 - tMap Components - part 1

    • 31:15
  • Lecture 16 - tMap Components - part 2

    • 37:47
  • Lecture 17 - tMap Components - part 3

    • 33:42
  • Lecture 18 - tMap Components - part 4

    • 13:43
  • Lecture 19 - Talend Error Handling

    • 56:03
  • Lecture 20 - Audit Control Jobs

    • 47:55
  • Lecture 21 - How to use tJAVA components with scenario

    • 54:12
  • Lecture 22 - Talend Big Data Hadoop Introduction and Installation

    • 31:57
  • Lecture 23 - Talend HIVE Components - part 1

    • 47:34
  • Lecture 24 - Talend HIVE Components - part 2

    • 24:42
  • Lecture 25 - Talend HDFS Components

    • 57:50
  • Lecture 26 - Talend TAC

    • 30:31

Course/Topic 5 - API Design & Development - all lectures

  • In this lecture session we learn about basic introduction to API Design and development with RAML and also talk about some key features of API design with RAML.

    • 1:26:59
  • In this lecture session we learn about data formats and authentication of API design and development with RAML and also talk about the importance of RAML in API design and development.

    • 1:08:47
  • In this lecture session we learn about how we start designing API and also talk about basic resources and method of API design and development in RAML.

    • 1:36:12
  • In this lecture session we learn about API design center and features of API and also talk about some function of API design center in brief.

    • 1:39:11
  • In this tutorial we learn about API best practices is to Provide language-specific libraries to interface with your service and also talk about features of API design and development with RAML.

    • 2:03:24
  • In this tutorial we learn about Schemes define which transfer protocols you want your API to use. If your API is enforced by an API Connect gateway, only the HTTPS protocol is supported and also talks about features of API security schemes.

    • 2:30:57
  • In this tutorial we learn about API Designer provides a visual or code-based guided experience for designing, documenting, and testing APIs in any language and also talk about the importance of API design principles in brief.

    • 1:01:30
  • In this lecture session we learn about RESTful API Modeling Language (RAML) makes it easy to manage the API lifecycle from design to deployment to sharing. It's concise and reusable; you only have to write what you need to define and you can use it again and again.

    • 1:22:27
  • In this lecture session we learn about RESTful API Modeling Language (RAML) is a YAML-based language for describing RESTful APIs. It provides all the information necessary to describe RESTful or practically RESTful APIs and also talk about the importance of API design and development with RAML.

    • 1:27:44
  • In this lecture session we learn about RAML stands for RESTful API Modeling Language. It's a way of describing practically-RESTful APIs in a way that's highly readable by both humans and computers. We say "practically RESTful" because, today in the real world, very few APIs today actually obey all constraints of REST.

    • 2:07:24
  • In this lecture session we learn about RAML (RESTful API Modeling Language) provides a structured, unambiguous format for describing a RESTful API. It allows you to describe your API; the endpoints, the HTTP methods to be used for each one, any parameters and their format, what you can expect by way of a response and more.

    • 47:27
  • In this lecture session we learn about The RAML specification (this document) defines an application of the YAML 1.2 specification that provides mechanisms for the definition of practically-RESTful APIs, while providing provisions with which source code generators for client and server source code and comprehensive user documentation can be created.

    • 1:46:59
  • In this tutorial we learn about RESTful API Modeling Language (RAML) is a YAML-based language for describing RESTful APIs. It provides all the information necessary to describe RESTful or practically RESTful APIs.

    • 50:42
  • In this lecture session we learn about API is the acronym for Application Programming Interface, which is a software intermediary that allows two applications to talk to each other.

    • 42:31
  • In this lecture session we learn about RAML can be used in a multitude of ways: to implement interactive PAI consoles, generate documentation, describing an API you are planning to build, and more. Despite the name, RAML can describe APIs that do not follow all of the REST rules (hence why it's referred to as "practically RESTful").

    • 53:46
  • In this lecture session we learn about API architecture refers to the process of developing a software interface that exposes backend data and application functionality for use in new applications.

    • 2:09:27
  • In this lecture session we learn about RAML (RESTful API Modeling Language) provides a structured, unambiguous format for describing a RESTful API. It allows you to describe your API; the endpoints, the HTTP methods to be used for each one, any parameters and their format, what you can expect by way of a response and more.

    • 47:18
  • In this session we learn about RESTful API Modeling Language (RAML) is a YAML-based language for describing RESTful APIs. It provides all the information necessary to describe RESTful or practically RESTful APIs.

    • 36:21
  • In this lecture session we learn about RAML libraries that may be used to modularize any number and combination of data types, security schemes, resource types, traits, and annotations.

    • 30:13