SQL Developer (MS SQL / SSIS / Reports / T-SQL / DBA)
Taking this Microsoft SQL Server centric course is a great approach to boosting your brand value, developing your database skills, and assisting your business in extracting valuable insights. We want you to be successful in your endeavors through this simplified curriculum.
What you’ll learn
- Journey through the role of SQL Server DBA, ETL Developer and Reports Writer.
- Writing SQL queries.
- Creation of MS SQL Reports and SSIS ETL packages.
- Overview of the SQL Server DBA duties.
Course Content
- SQL and T-SQL –> 14 lectures • 1hr 17min.
- SSIS – SQL Server Integration Services –> 6 lectures • 1hr 13min.
- Report Builder (SQL Server) –> 4 lectures • 48min.
- SQL DBA (MS SQL Database Administrator) –> 7 lectures • 1hr 25min.
Requirements
Taking this Microsoft SQL Server centric course is a great approach to boosting your brand value, developing your database skills, and assisting your business in extracting valuable insights. We want you to be successful in your endeavors through this simplified curriculum.
The benefits of Mastering Microsoft SQL Server platform includes advancing your SQL Server abilities. Build strong databases, learn to write advanced SQL queries, and understanding data warehousing principles for better data insight and wiser business choices.
This is a comprehensive course that includes:
* SQL Database Administrator
— Overview of SQL DBA
— Benefits of T-SQL in querying
— Introduction to Normalization in Database Design
— Performance Tuning an essential aspect of Database Administration
— Troubleshooting is an important skill of the DBA
— High Availability
* SSIS
— Introduction to SSIS packages
— Loading and merging multiple files using SSIS
— Loading and Renaming multiple files using SSIS
— Events handlers in SSIS
— Scheduling SSIS packages
* Report Builder
— SQL Server Report Builder
— Creating Report Builder VARCHAR Parameters
— Creating Report Builder Data Parameters
— Creating Report Builder Multi-parameterized Reports
* SQL
— Introduction to SQL (T-SQL)
— SQL Server database environment (T-SQL)
— DDL – Create Alter and Drop commands (T-SQL)
— DML Insert Update and Delete commands (T-SQL)
— SELECT query syntax (T-SQL)
— SELECT distinct command (T-SQL)
— SELECT Where clause (T-SQL)
— SELECT Top (T-SQL)
— SELECT Joins (T-SQL)
— SELECT Group by (T-SQL)