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 describes 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.
- Apply data integrity using Master Data Services.
- Erasure of data using data quality services.
prerequisites :
Experience working with relational databases including:
Normalized database design.
Create tables and relationships
Queries with Transact-SQL.
Some exposure to basic programming constructs (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.
Choose a suitable hardware platform for the database.
••And…
The amount of available data is huge and is increasing 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 correspond to using some commands in SQL in a similar way. The SQL version of Microsoft SQL Server is known as Transact-SQL (T-SQL). You will learn the basics of SQL and Transact-SQL because they both use certain 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 views
- Create stored procedures
- Reading data from the database
- Update database records
- Database backup
- Delete records
- cutting table
- drop table
- Delete the database
- Database recovery
What you will learn in Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL course
-
Database design
-
Implement a database
-
Build ETL solution with SSIS
-
Troubleshoot and troubleshoot SSIS packages
-
Deploying the SSIS solution
-
Data quality implementation
-
Clear the data
-
Explore data sources
-
Modified data extraction
-
Loading and modifying data
-
Data consumption in the database
-
Create reports using SSRS
-
Data analysis with SSAS
-
Interact with data using T-SQL
This course is suitable for people who
- Beginner data analyst
- Beginner database engineers
- A novice data scientist
- Beginner data engineers
Course Specifications Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
- Publisher: Udemy
- teacher: Bluelime Learning Solutions
- Training level: beginner to advanced
- Training duration: 8 hours and 4 minutes
- Number of courses: 83
Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL course topics on May 2023
Data Warehouse Developer course prerequisites-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
- A computer and internet access required
- Some free software required. The course will guide you.
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
2.3 GB
Be the first to comment