Description
Data Warehouse Developer Course – SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL. Database Developer Course – SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL. This course explains how to design and implement a database solution. Students will learn how to implement a database with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and clean data with SQL Server Data Quality Services and SQL Server Master Data Services. The main responsibilities of a database developer are:
- Database implementation.
- Development of SSIS packages to extract, transform and load data.
- Enforce data integrity using Master Data Services.
- Data deletion using data quality services.
Prerequisites:
Experience working with relational databases including:
Normalized Database Design.
Create the table and
Querying Relations with Transact-SQL.
Some demonstration of basic programming structures (such as loops and branching).
Knowledge of key business priorities such as revenue, profitability and financial accounting is desirable.
Students will learn how to:
••Deployment and configuration of SSIS packages.
••Download and install SQL Server
••Download and attach the AdventureworksDW database
••Download and install SSDT
••Download and install Visual Studio
••Explain database concepts and architectural considerations.
Select an appropriate hardware platform for the database.
••And…
The amount of data available is huge and is growing every day. Structured Query Language – SQL (pronounced as sequence) is a standard language used to communicate and interact with data stored in relational database systems such as Microsoft SQL Server, Oracle, PostgreSQL, MySQL, etc. Different database management systems have their own version of the SQL language, but they all conform to using some commands in SQL in a similar way. Microsoft SQL Server’s version of SQL is known as Transact-SQL (T-SQL). You will learn the basics of SQL and Transact-SQL as they both use some commands in a similar way. What you will learn includes:
- Install SQL Server
- Install SSMS
- Basic Database Concepts
- Create a database
- Create a table
- Create the scene
- Create Stored Procedures
- reading data from database
- Update a database record
- Database Backup
- Delete record
- Cutting table
- drop TABLE
- Delete a database
- Database Recovery
What you will learn in the Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL course
-
Build an ETL Solution with SSIS
-
Troubleshoot and troubleshoot SSIS packages
-
Deploying an SSIS Solution
-
Data Quality Implementation
-
Loading and modifying data
-
Data consumption in the database
-
Create a report using SSRS
-
Interact with data using T-SQL
This course is suitable for those who
- beginner data analyst
- Beginner Database Engineer
- A novice data scientist
- Beginner Data Engineer
Course Specifications Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL Course Topics May 2023
Data Warehouse Developer Course Requirements-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
- A computer and internet access is required
- Some free software is required. The course will guide you.
Course Images
Sample video of the course
installation Guide
After extract, watch with your favorite player.
English subtitle
Quality: 720p
download link
File Password: www.downloadly.ir
size
2.3 GB