Data Integration Fundamentals
What you'll learn
- Data integration basics - What is data integration and why it's important in the modern business environment
- How data integration skills can create more success in your non-technical career
- Why data integration is a great way to transition into a technology career
- Learn common approaches to Business-to-Business (B2B) integration including EDI, XML, JSON, Text files, FTP and AS2.
- Gain a detailed understanding of Application Integration technologies including HTTP, SOAP, REST APIs, and Webhooks.
- Learn about Database Integration techniques like data warehousing, data lakes Extract-Transform-Load (ETL), and replication.
Requirements
- No experience with databases or programming is necessary to benefit from this course.
Description
It’s clear that we are living in a data-driven world. Our steady transition toward highly digitized lives is making data a key asset in the modern economy. When we go online to make purchases, consume content, or share on social media, we are generating valuable data. Many of the largest tech companies are now operating on business models that depend on leveraging data. However none of that is possible without data integration. Data integration is the glue that makes it possible to convert raw data into a valuable asset.
In this course, I will focus on three types of data integration: Business-to-Business Integration, Application Integration, and Database Integration. You will learn how businesses exchange data using standard EDI, XML, and APIs. I’ll explain common communication methods like FTP and AS2. You’ll also learn about application integration approaches including SOAP, REST APIs, and Webhooks. And I’ll teach you about database integration technologies involving data warehouses, data lakes, streaming data, extract-transform-load processing, and data propagation techniques like replication.
By the end of the course, you’ll have a solid understanding of how data integration can be used to improve business results. You will be knowledgeable about how these techniques are applied, and will be able to intelligently speak with software vendors, customers, suppliers or your internal IT department about data integration projects.
Who this course is for:
- If you are currently working in a technology job, this course will help you be more effective in your current role and give you the skills necessary to participate in data integration projects. If you are not currently working in an IT role, this course will give you knowledge that will set you apart from other workers in your field. Whether you work in finance, marketing, logistics, customer service, or human resources, this course will give you the knowledge to identify scenarios were data integration can optimize business results.
Instructor
John Berry has spent the last 30 years building software and data solutions for some of the world's most well-known supply chains. He is currently the IT Director for the supply chain management subsidiary of one of the world's largest contract manufacturers. In this role John leads a team of technology professionals to develop digital supply chain services focusing on supplier management, trade compliance, eCommerce fulfillment, and process automation.
John is passionate about helping others to develop their careers in the technology field. He has helped many line-level workers with no previous technical experience make a transition into IT careers. Having amassed a wealth of knowledge and experience, John devotes his time to sharing his expertise while he continues to work with technology on the front lines every day.