Learn ETL using SSIS
Microsoft SQL Server Integration Services (SSIS) Training
Created by Rakesh Gopalakrishnan - Over 260,000 Students
Students: 52667, Price: Free
Start from an absolute beginner to writing and deploying production quality packages.
In this course we will learn about the basic and advanced concepts of SQL Server Integration Services or SSIS. We will walk through the different tools provided by SSIS to Extract, transform and Load data into various databases. This course can followed along with me, provided you have Windows OS or a Windows VM. There are no-prerequisites to the course. At the end of this course, you will be comfortable building an ETL package, moving data around systems, Transforming data using SSIS controls like Fuzzy Lookup, Web service tasks, Email Tasks etc. and configuring and deploying production quality packages with tasks like SSIS logging and checkpoint tasks. Hope you enjoy the course.
OrientDB – Getting Started with Graph and Document Databases
A full introductory course to OrientDB, the Document-Graph database. Learn about NoSQL's latest trend: GraphDBs!
Created by OrientDB Team - Free OrientDB Getting Started Training
Students: 39726, Price: Free
Graph databases are among the fastest growing trends in technology. Helping you effectively manage modern, highly connected data is the key benefit of a OrientDB. This course will provide you a comprehensive overview of the multiple models supported by OrientDB, with bigger focus on Graph and Document principles as well as walk you through hands on examples of working with the database and its API.
Bootcamp for KNIME Analytics Platform
For users new to KNIME and data science, or experienced users of other data science tools.
Created by KNIME Inc - Data Science and Evangelism
Students: 19142, Price: Free
If you've never used KNIME Analytics Platform before, this is the course for you. You can use KNIME Analytics Platform to create visual workflows with an intuitive, drag and drop style graphical interface, without the need for coding.
We'll start with installation and setup of the software, and present detailed materials on its features. We'll move on to some practical application of data blending from different sources, and use real datasets to show you all the different way you can transform, clean, and aggregate information. Finally, we'll introduce some machine learning algorithms for classification, and show you how to build your own models.
More than 50 videos are provided, along with some exercises for you to work on independently. By the end of the course, we want you to feel comfortable with the interface of KNIME Analytics Platform, be able to perform common processing tasks with your own data, and start putting predictive analytics into practice.
Data Warehouse basics for absolute beginners in 30 mins
Data Warehouse basic concepts like architecture, dimensional modeling, fact vs dimension table, star vs snowflake schema
Created by Eshant Garg | LearnCloud.Info | 80,000+ Enrollments - Instructor | LearnCloud.Info | AWS | Azure
Students: 9678, Price: Free
Please note that this is NOT a full course but a single module of the full-length course, and intended to cover very basic fundamental concepts for absolute beginners so that they can speed up with Azure Synapse SQL Data Warehouse course.
This module is NOT GOOD for you if:
You are already experienced in this technology
You are looking for an intermediate or advance concepts
You are looking for practical examples or demo
This module is GOOD for you if:
You want to understand the basic fundamental concepts of this technology.
This is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll.
Where I can find a full-length course?
Please look at the bonus lecture in the end.
What will students learn in this course?
Microsoft SQL Data Warehouse (Crash course to speed up with Cloud warehousing)
Anyone who wants to start learning Data warehousing
If you are not comfortable in English, please do not take the course, captions are not good enough to understand the course.
Database and BI developers
Data Analyst or similar profiles
Basic T-SQL and Database concepts
Course In Detail
Data Warehouse Crash Course
In this module, you will learn, what is Data Warehouse, Why we need it and how it is different from the traditional transactional database.
We will learn the concept of dimensional modeling which is a database design method optimized for data warehouse solutions.
Then I will explain what we mean when we say facts and their corresponding fact tables. What are the dimensions and their corresponding dimension tables?
how are these special kinds of tables joined together to form a star schema or snowflake schema?
This section will establish the foundation before you start my course on Azure Synapse Analytics or formally known as Azure SQL Data Warehouse.
Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS
Get to know Pentaho Kettle PDI – Introduction
Great start for you to understand what is PDI
Created by Itamar Steinberg (inflow systems) - MBA in the field of IT, Master of ETL
Students: 5054, Price: Free
This course is about the foundation of PDI - Pentaho data integration.
What am I going to get from this introduction?
understand PDI environment
learn what are jobs and transformations
learn basic table input output
understand the scope of the large course: "learn ETL with Pentaho kettle PDI "
This is a good overview on the subject,
it is not by any means a full course on the subject, you will need to take another course
to become expert by doing a lot of hands on your self.
An Introduction to Snowflake
Datawarehousing as a Service!
Created by Bhavuk Chawla - Authorized Instructor for Google, Cloudera, Confluent
Students: 2832, Price: Free
Are you also perturbed about Scalability, Performance and Cost of your existing Data Warehouses?
We have a solution for you!
Just keep your gung-ho high and join the live webinar on Snowflake. Snowflake provides Data Warehousing as a Service. It opens the door to numerous benefits including almost Zero maintenance, On Demand Scaling in just a few seconds, Simplifying Data Sharing, Zero Copy Cloning etc.
Evolution of Data Warehousing Technologies
What is Snowflake?
Snowflake vs RedShift
Setting up Snowflake Trial Account
Usecase: Implementing Change Data Capture in Snowflake
Please note that this is not an official course from Snowflake.
You may join our YouTube Channel named "DataCouch" for getting access to interesting videos free of cost.
We have many Google certified instructors who can assist your team in moving forward in Google Cloud implementation in the right way.
We are also an official training delivery partner of Confluent Kafka.. We conduct corporate trainings on various topics including Confluent Kafka Developer, Confluent Kafka Administration, Confluent Kafka Real Time Streaming using KSQL & KStreams and Confluent Kafka Advanced Optimization. Our instructors are well qualified and vetted by Confluent for delivering such courses.
Please feel free to reach out if you have any requirements for Confluent Kafka Training for your team. Happy to assist.
Data Warehouse Projects: A Short Course for IT Executives
Learn how to be successful with data warehouse projects.
Created by Bob Wakefield - Data Management Expert
Students: 2059, Price: Free
2nd Edition now available!
Data warehouse projects can be expensive and complex. If an organization does not currently have a data warehouse, the value of building one may not be clear. This course will teach you how to manage a data warehouse project in a timely, cost-effective manner that is on budget and will demonstrate value to the business from day one.
This course is designed for people who manage IT projects. If you are not an IT manager but are interested in learning how to build a data warehouse, this course can serve as a solid introduction to data warehousing.
You will learn how to manage the people and processes necessary to bring an enterprise data warehouse to initial operating capability. You will be taught common data warehouse terms so you can effectively communicate with technical resources. You will be introduced to the documents necessary to design and build a data warehouse. You will gain knowledge about common pitfalls to avoid. You will learn who you need to hire to work on the project and how to select those people.
Updates in the 2nd edition include:
Links to external resources have been added to the relevant lectures.
New lectures added after the initial publish date have been fully integrated.
Entire class has been re-recorded using professional voice talent.