Database administration with Microsoft SQL Server 2016 (MOC#20764 and MOC#20765)
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Prerequisites:
- Working knowledge of relational databases.
- Working knowledge of Transact-SQL.
- Some experience with database design.
- This course is NOT recommended to junior developers.
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Program:
- 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
Learning methods: Practical exercise, independent work.
Assesment methods: Execution of independent work.
Assesment form: Independent practical tasks on relevant topics.
Koolitaja:
Gunnar Peipman BCS Koolituse partnerlektor. Gunnar on ASP.NET, Azure ja SharePointi huviline, Estonian Microsoft kasutajate grupi liider, blogija, õppejõud ja tehnikahuviline. Alates 2008. aastast on ta Microsoft MVP ja spetsialiseerunud ASP.NET-ile.
Lisainfo:
Price includes coffee breaks and lunches in restoran “Lusikas”.
Koolitusel saab osaleda nii klassis kui ka veebi teel.
- Klassikoolitustel oleme omalt poolt võtnud kasutusele kõik ettevaatusabinõud, et koolitustel osalemine oleks teile meeldiv ja turvaline kogemus.
- Veebikoolitusel saab osaleda videokonverentsi keskkonnas. Koolituse keskkonda sisenemise link koos juhendiga saadetakse koolitusele registreerujatele enne koolitust. Hoolsa õpilasena pääsed „klassiruumi“ 15 min enne koolituse algust, et kõik vajalik (pilt, mikrofon ja vestlus) häälestada. Väga tervitatav on kahe ekraani kasutamise võimalus (kui ei ole, saab hakkama ka ühega). Koolituse käigus tehakse läbi praktilisi harjutusi, mis eeldab osaleja interaktiivset panustamist.
Koolitusfirma tutvustus
BCS Koolitus on Eesti juhtiv IKT valdkonna koolitus-, projektijuhtimis- ja konsultatsiooniettevõte. Loen koolitusfirma kohta veel...