Talend + SQL + Datawarehousing Beginner to Professional

Talend + SQL + Datawarehousing – Beginner to Professional, available at $139.99, has an average rating of 4.63, with 92 lectures, based on 857 reviews, and has 5050 subscribers.

You will learn about Learn Basic concepts of ETL Learn Talend Open Studio for Data Integration with scenarios to implement. Learn Basic concepts of Datawareshousing Learn Basic concepts of SQL This course is ideal for individuals who are Anyone who wants to get through the Talend Certification or want to get job as ETL developer It is particularly useful for Anyone who wants to get through the Talend Certification or want to get job as ETL developer.

Enroll now: Talend + SQL + Datawarehousing – Beginner to Professional

Summary

Title: Talend + SQL + Datawarehousing – Beginner to Professional

Price: $139.99

Average Rating: 4.63

Number of Lectures: 92

Number of Published Lectures: 92

Number of Curriculum Items: 92

Number of Published Curriculum Objects: 92

Original Price: ?5,499

Quality Status: approved

Status: Live

What You Will Learn

Learn Basic concepts of ETL

Learn Talend Open Studio for Data Integration with scenarios to implement.

Learn Basic concepts of Datawareshousing

Learn Basic concepts of SQL

Who Should Attend

Anyone who wants to get through the Talend Certification or want to get job as ETL developer

Target Audiences

Anyone who wants to get through the Talend Certification or want to get job as ETL developer

Talend is an Open Source/Enterprise ETL Tool, which can be used by Small to Large scale companies to perform Extract Transform and Load their data into Databases or any File Format (Talend supports almost all file formats and Database vendors available in the market including Cloud and other niche services).

This Course is for anyone who wants to learn Talend from Beginner to Professional, it will also help in Enhancing your skills if you have prior experience with the tool.

In the course we teach Talend – ETL tool, PostgreSQL – SQL and all the basic Datawarehousing concepts that you would need to work and excel in the organization or freelance.

We give real world scenarios and try to explain the use of component so that it becomes more relevant and useful for your real world projects.

Prepares you for the Certification Exam.

By the end of the Course you will become the Master in Talend Data Integration and will help you land the job as ETL or Talend Developer, which is high in demand.

Call/Message us for Virtual training and many more courses: 9059731631

Prerequisites ?

Basic Knowledge of working on PC

Target Audience ?

Anyone who wants to enter the IT industry from non technical background.

Anyone who wants to enhance their concepts of Talend Studio to perform data integration.

Anyone who wants to get job as a Talend Developer.

Anyone who wants to learn basics of SQL.

Anyone who wants to learn basics of datawarehousing.

System Requirements ?

PC or lappy with preferably more than 4GB RAM and i3 above processor.

Talend Open Studio Software – FREE for everyone

PostgreSQL Database – FREE for local implementation

Course Curriculum

Chapter 1: Introduction to our Talend Course

Lecture 1: Introduction about Me and the Course

Lecture 2: What is ETL? What are the advantages of Talend over other tools?

Chapter 2: Installation of Java, Talend

Lecture 1: Resource – Installation of Free Talend, PostgreSQL, Notepad++, Java

Lecture 2: Installation of Talend 7.3 on Windows

Lecture 3: Installation of Talend 8 on Windows

Lecture 4: Generic Folder Structure on the machine as best practice

Chapter 3: Talend Studio Tour

Lecture 1: Few Tips for best learning and use of course

Lecture 2: Repository, Designer, Palette, Outline, Configuration tab

Lecture 3: Creating your first job, Java behind Talend

Chapter 4: Import/Export jobs in Talend

Lecture 1: Exporting/Importing job

Chapter 5: Reading the data from files (Extract)

Lecture 1: Extracting from File Excel – tFileInputExcel

Lecture 2: Extracting from File delimited – tFileInputDelimited

Lecture 3: Extracting from File delimited/Excel using Metadata

Lecture 4: Assignment

Chapter 6: Reading the data from Databse (Extract)

Lecture 1: Installation of PostgreSQL and Dbeaver

Lecture 2: Basic of SQL – Create, drop, insert, truncate delete records into the table

Lecture 3: Basic of SQL – Delete, Alter, Update, Commit, Rollback

Lecture 4: Extracting from DB table/using Metadata – tDBInput

Lecture 5: Assignment

Chapter 7: Process the Data (Transformation) – Processing components

Lecture 1: Processing component – tFilterRow

Lecture 2: Using SQL – Where clause

Lecture 3: tFilterColumn

Lecture 4: tSortRow and Using SQL – Order by clause

Lecture 5: Assignment

Chapter 8: Load the data (Load)

Lecture 1: Load the data into File, Excel – tFileOutputDelimited, tFileOutputExcel

Lecture 2: Load the data into Table – tDBOutput

Lecture 3: Assignment

Chapter 9: File Management Components

Lecture 1: Connection Links

Lecture 2: tFileList

Lecture 3: tFileCopy, tFileDelete

Lecture 4: tFileArchive, tFileUnarchive

Lecture 5: tFileCompare, tFileRowCount, tFileProperties

Lecture 6: tChangeFileEncoding, tFileTouch

Lecture 7: Assignment

Chapter 10: Processing Components

Lecture 1: tMap basics

Lecture 2: tMap advance

Lecture 3: tMap Join

Lecture 4: SQL – Joins

Lecture 5: tJoin

Lecture 6: tReplace,tConvertType

Lecture 7: SQL- Replace, Typecasting

Lecture 8: tAggregateRow, tAggregateRowSorted

Lecture 9: SQL – Aggregate Functions

Lecture 10: tNormalize, tDenormalize

Lecture 11: tSampleRow

Lecture 12: Assignment

Chapter 11: DataBase Components

Lecture 1: tDBOutputBulk, tDBBulkExec, tDBOutputBulkExec

Lecture 2: tDBRow

Lecture 3: Assignment

Chapter 12: Orchestrating Components

Lecture 1: tLoop

Lecture 2: tForEach

Lecture 3: tInfiniteLoop, tSleep, tFileExist

Lecture 4: tUnite, tReplicate

Lecture 5: tWaitForFile

Lecture 6: tWaitForSQLData

Lecture 7: tFlowToIterate,tIterateToFlow

Lecture 8: tRunjob, tPrejob, tPostjob

Lecture 9: Assignment

Chapter 13: Custom code, System Component

Lecture 1: tJava

Lecture 2: tJavaRow

Lecture 3: tJavaFlex

Lecture 4: tSetGlobalVar

Lecture 5: tSystem

Lecture 6: Assignment

Chapter 14: Everything about Context variable, how to load from Talend or external file/DB

Lecture 1: Explanation with job – tContextLoad, Implicit tContextLoad, tContextDump

Lecture 2: Assignment

Chapter 15: Logs & Errors Component

Lecture 1: tChronometerStart, tChronometerStop

Lecture 2: tStatCatcher

Lecture 3: tDie, tWarn, tLogCatcher

Lecture 4: tAssert, tAssertCatcher

Lecture 5: tFlowMeter, tFlowMeterCatcher

Lecture 6: Assignment

Chapter 16: Miscellaneous Components

Lecture 1: Note, tRowGenerator, tFixedFlowInput

Lecture 2: tMsgBox

Lecture 3: tBufferInput, tBufferOutput

Lecture 4: tHashInput, tHashOutput

Lecture 5: tMemoriseRow

Lecture 6: Assignment

Chapter 17: AWS components

Lecture 1: Creation of AWS account and Access Key, Secret Key

Lecture 2: tS3Close, tS3Connection, tS3Copy, tS3Delete, tS3Get, tS3List, tS3Put

Lecture 3: Assignment

Chapter 18: SQL

Lecture 1: SQL String and Date functions

Instructors

TalendTech Solutions
Professional ETL Talend Techie turned Trainer

Rating Distribution

1 stars: 4 votes

2 stars: 7 votes

3 stars: 49 votes

4 stars: 315 votes

5 stars: 482 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!