Database administration with Microsoft SQL Server 2016 (based on MOC#20764 and MOC#20765)

IT spetsialistileMS SQL andmebaasid

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.

After completing this course, students will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud


  • Working knowledge of relational databases.
  • Working knowledge of Transact-SQL.
  • Some experience with database design.
  • This course is NOT recommended to junior developers.

See the web portfolio of lecturer here: Amir Zare Pashaei

Investeering: 1199,00 € + km
Lektor: Amir Zare Pashaei
Päevade arv: 5
Tundide arv: 40 akadeemilist tundi

Sihtgrupp:"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.

  • 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.

Price includes coffee breaks and lunches in restoran "Lusikas".

Registreeri koolitusele Küsi lisa