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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024