fbpx
Image for
Home

Authentication systems and databases

  • Class 15
  • Practice 30
  • Independent work 75
Total 120

Course title

Authentication systems and databases

Lecture type

Obligatory

Course code

22-00-507

Semester

3

ECTS

4

Lecturers and associates

Course overview

The objective of this module is to enable students to learn:
• LDAP directories and Active Directory
• the managaement and administration of Microsoft SQL database

Students learn the LDAP and Active Directory, a standard and a most prominent implementation of LDAP directory standard on the market. Students will start with LDAP and Active Directory from the bottom up (other modules in the curriculum focus on how to "objectify" and look into LDAP and Active Directory top-down). Students will also learn SQL server deployment and management, which is essential knowledge for IT for the 21st century.

It is important for students to take this module as it will enable them to comprehensively learn the most commonly used authentication system (LDAP/Active Directory) and most commonly used database (Microsoft SQL) on the market.

Literature

Essential reading:
1. Carter, G. (2003) LDAP System Administration: Putting Directories to work, PO Box 722, Farnham GU9 1PL, O'Reilly
2. Assaf W., West, R., Aelterman, S., Curnutt, M. (2018) SQL Server 2017 Administration Inside Out 1st Edition, Microsoft Press

Recommended reading:
1. Desmond, B., Richards, J., Allen, R., G.Lowe-Norris A. (2013) Active Directory: Designing, Deploying and Running Active Directory Fifth Edition, PO Box 722, Farnham GU9 1PL, O'Reilly

Further reading:
1. Radivojevic, M. Sarka, D., Durkin, W., Cote, C., Lah, M. (2019) Mastering SQL Server 2017, Livery Place, 35 Livery Street, Birmingtham B3 2PB, Packt Publishing.

Download student guide

Minimal learning outcomes

  • Support LDAP, AAA, and IDM systems
  • Evaluate Microsoft LDAP strategy
  • Justify the use of OpenLDAP, SAML, OAuth and similar authentication systems
  • Support installation and configuration of SQL instance
  • Argue the implementation of a new database and database backup, automated data export tasks
  • Recommend monitoring tools for SQL server performance

Preferred learning outcomes

  • Critically argue LDAP, AAA, and IDM systems
  • Suggest options for implementing Microsoft LDAP strategy
  • Suggest options for using OpenLDAP, SAML, OAuth and similar authentication systems
  • Suggest options for installation and configuration of SQL instance
  • Design new database and database backup, automated data export tasks
  • Determine correct monitoring tools for SQL server performance
Share: Facebook Twitter