Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
5.0 /5- Offered byUDEMY
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) at UDEMY Overview
Duration | 17 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Get full lifetime access of the course material
- Learn from 2 articles and 9 downloadable resources
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) at UDEMY Course details
- For beginner SQL developer, database administrator, data scientist and data warehouse administrators
- Deploy and Configure SSIS packages
- Describe data warehouse concepts and architecture considerations
- Implement an ETL solution that supports incremental data extraction and loading
- Choose between star and snowflake design schemas
- Design and implement a data warehouse
- SQL developers are expected to have a variety of skills that will enable them perform tasks such as: design, implementation and maintenance of structured query language (SQL) databases
- They may work as database or web developers, depending on the specific position. SQL developers often spend many work hours seated in front of computers
- This course is Hands-on and by the end of the course you will have experience of working with relational database management systems like Microsoft SQL Server
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) at UDEMY Curriculum
SQL Server 2019 Hardware
Software Installation Requirements
SQL Server Editions
Download SQL Server 2019 Developer Edition
SQL Server 2019 Developer Edition Installation
Installing SQL Server Management Studio
Connecting to SQL Server with SSMS
SSMS Quick Tour
Installing Reporting Services
Configure Report Server
Accessing Report Server Web Portal Locally
Accessing Report Server Web Portal Remotely
Configure SSMS for local SSRS administration
Adding users and groups to SSRS
Installing Report Builder
What is Visual Studio
Minimum Installation Requirements for visual studio 2019
Installing Visual Studio
Installing SQL Server Data Tools (SSDT)
Installing Designers for SSIS,SSAS,SSRS
What is T-SQL
What is a Database
Primary Key
Foreign Key
Intellisense
Normalization
Querying Data with SELECT Statement
Introduction to SSIS
Creating a new SSIS Project with Visual studio 2019
Create basic ETL: New SSIS project
Add a Flat File Connection Manager
Remapping Column Data Types
Add and Configure OLE DB Connection Manager
Add a Data Flow Task to a Package
What is SQL Server
What is SQL Server Reporting Services - SSRS
Requirements for creating basic report with -SSRS
How to enable built-in administrator account in Windows
SQL Server Reporting Configuration Manager
How to create SSRS Report with visual studio 2019
Create Report Server Project
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) at UDEMY Entry Requirements
- Prerequisites : Experience of working with relational databases, querying with Transact-SQL, an awareness of key business priorities such as revenue, profitability
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?