[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - [ End to End ]

Course Feature
  • Cost
    Free
  • Provider
    Youtube
  • Certificate
    No Information
  • Language
    English
  • Start Date
    2021-09-27
  • Learners
    No Information
  • Duration
    No Information
  • Instructor
    Analytics with Nags
Next Course
2.0
141,584 Ratings
This 3-hour course is a comprehensive guide to Data Warehouse concepts, architecture, terminologies, design, implementation, and more. It covers topics such as SQL Server, SSIS, SSAS, and Power BI, and provides hands-on experience with the Adventure Works OLTP Database and AWN Data Warehouse Database Scripts. With this course, you will learn how to install SQL Server and SSDT SSMS, create Power BI reports, and deploy SSIS packages and SQL Agent Schedules. Get the skills you need to become a Data Warehouse expert today!
Show All
Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 21st, 2023]

This 3-hour course provides an end-to-end overview of Data Warehouse concepts, architecture, terminologies, design, implementation, and reporting. It covers topics such as SQL Server, SSIS, SSAS, and Power BI. The course begins with an introduction to Data Warehouse and its architecture. It then covers Data Warehouse terminologies and a business case study. It then moves on to Data Warehouse designing and implementation. It also covers SSIS, surrogate key, and slowly changing dimension. It also covers adding data to dimension and incremental load, deploying SSIS package and SQL agent schedule, SSAS tabular model, and creating Power BI reports. The course also covers installing SQL Server and SSDT SSMS, and downloading the Adventure works OLTP Database and AWN Data warehouse Database Scripts.

Show All
Recommended Courses
free data-warehouse-concepts-data-warehouse-tutorial-data-warehouse-architecture-edureka-5058
Data Warehouse Concepts Data Warehouse Tutorial Data Warehouse Architecture Edureka
1.5
Youtube 403,923 learners
Learn More
This Data Warehouse Concepts tutorial will help you understand what is a Data Warehouse, its architecture, different types of Data Warehouses, its components, and its advantages. This Data Warehouse Concepts tutorial from Edureka is designed to help you understand the fundamentals of Data Warehousing. It covers topics such as what is a Data Warehouse, its architecture, different types of Data Warehouses, its components, and its advantages. With this tutorial, you will gain a comprehensive understanding of the concepts of Data Warehousing and its architecture. It will also help you understand the different types of Data Warehouses and their components. Finally, you will learn about the advantages of Data Warehousing.
free microsoft-sql-server-2014-database-administration-5069
Microsoft SQL Server 2014 Database Administration
4.1
Udemy 10,823 learners
Learn More
This course is perfect for anyone looking to become a SQL Developer. It covers the basics of SQL Server from installing to updating data. It also covers general knowledge of what a database is, different versions of SQL Server 2014, how to install SQL Server Express 2014, create a database, create tables, add data into tables, set foreign key relationships between tables, delete data from tables, update data in tables, and backup and restore databases. With this course, you will have the necessary knowledge to become a SQL Developer. Click now to get started!
free introduction-to-databases-and-sql-querying-5070
Introduction to Databases and SQL Querying
4.5
Udemy 513,515 learners
Learn More
This course is the perfect introduction to Databases and SQL Querying for anyone looking to get acquainted with the concept. With no pre-requisites, all you need is a Windows machine and you'll be guided step-by-step from setting up your environment to creating your first table and writing your first query. Structured in a way that you can follow along, you'll be comfortable writing simple queries related to Dates, String manipulation, Aggregation, etc. by the end of the course. So, if you're looking to brush up on your skills for your next analyst interview, this is the course for you.
free distributed-sql-and-yugabytedb-fundamentals-5071
Distributed SQL and YugabyteDB Fundamentals
4.7
Udemy 3,869 learners
Learn More
This course will teach you the fundamentals of distributed SQL and YugabyteDB. In 90 minutes, you'll learn the core concepts of distributed SQL, YugabyteDB architecture and design principles, YSQL API development, and more. Through lectures and hands-on exercises, you'll gain the knowledge and skills to configure and get started with YugabyteDB. You'll also work through a variety of exercises, such as single and multi-node cluster installs, JDBC connectivity, user management and basic security, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools, using a Java load generator, and testing fault tolerance. Don't miss out on this opportunity to learn the fundamentals of distributed SQL and YugabyteDB!
Favorites (0)
Favorites
0 favorite option

You have no favorites

Name delet
arrow Click Allow to get free [[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - [ End to End ] courses!