Administering, developing, and implementing data warehouses with Microsoft SQL Server (based on MOC#20461, MOC#20462 and MOC#20463)
The main goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries, to Administrate the databases and to Implement a data warehouse for Microsoft SQL Server 2014.
Sihtgrupp
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.
Programm
- Module 1: Introduction to Microsoft SQL Server 2016
- Module 2: Querying Multiple Tables
- Module 3: Sorting and Filtering Data
- Module 4: Using Built-In Functions
- Module 5: Grouping and Aggregating Data
- Module 6: Using Table Expressions
- Module 7: Pivoting and Grouping Sets
- Module 8: Executing Stored Procedures
- Module 9: Programming with T-SQL
- Module 10: Implementing Transactions
- Module 11: Designing and Implementing Tables
- Module 12: Introduction to Indexes
- Module 13: Designing Optimized Index Strategies
- Module 14: Designing and Implementing Views
- Module 15: Designing and Implementing Stored Procedures
- Module 16: Designing and Implementing User-Defined Functions
- Module 17: Implementing Managed Code in SQL Server
- Module 18: Storing and Querying XML Data in SQL Server
- Module 19: Storing and Querying BLOBs and Text Documents in SQL Server
- Module 20: Performance and Monitoring
Eeldused
- Working knowledge of relational databases.
- Working knowledge of Transact-SQL.
- Some experience with database design.
- This course is NOT recommended to junior developers.
Lisainfo
Price includes coffee breaks and lunches in restoran "Lusikas".
Investeering
Hind kokkuleppel
✨
Vajan seda oma tiimile
Aitame koostada päringu
✨
See koolitus hetkel ei toimu
Küsi lisainfot. Aitame leida sarnase koolituse või panna sinu soovi kirja.