Sidia is a education Platform website.
Course Description
Mata kuliah Basis Data Lanjut dirancang untuk memberikan pemahaman mendalam mengenai pengelolaan dan optimasi database menggunakan SQL Server. Mahasiswa akan mempelajari konsep-konsep lanjutan dalam administrasi database, mulai dari pengenalan sistem manajemen basis data hingga teknik troubleshooting untuk memastikan performa dan keamanan database yang optimal. Mata kuliah ini berfokus pada aspek praktis dari pengelolaan database dan melibatkan berbagai topik, termasuk perancangan query, manajemen file, integritas data, hingga pemeliharaan dan optimasi database.
Program Objectives (PO)
- Mahasiswa dapat menjelaskan konsep dasar SQL Server, DBMS, dan menulis query dasar menggunakan T-SQL
- Mahasiswa dapat mengelola dan melakukan operasi pada file database serta memastikan integritas data
- Mahasiswa dapat menerapkan konsep join, sorting, filtering data, serta menggunakan tipe data dan fungsi pada SQL Server
- Mahasiswa dapat menerapkan mekanisme backup, recovery, restore, serta mengelola proses import dan export database
- Mahasiswa dapat menerapkan autentikasi, otorisasi, auditing, dan otomatisasi manajemen SQL Server serta troubleshooting
Aktifitas Pembelajaran
-
Pertemuan 1 Lecture contracts and assessment rubrics, introduction to theory in advanced database courses, Introduction to SQL Server, Introduction to Database Management Systems (DBMS) -
Pertemuan 2 Introduction to T-SQL, Query Select Basics, Writing a simple Select Query -
Pertemuan 3 Create and manage database files, Data Integrity in Database SQL Server, Basic operations on database files (CRUD), Combine data with Join -
Pertemuan 4 Data sorting techniques, Filter data using specific conditions, Introduction to data types in SQL Server -
Pertemuan 5 Operations on data types, Important functions related to data types, Concept and implementation of set operations in SQL -
Pertemuan 6 Create and manage triggers, Introduction to window and ranking functions, Implementasi aggregate functions -
Pertemuan 7 Backup and recovery concept, Create a database backup, Restore a database from a backup -
Pertemuan 8 UTS -
Pertemuan 9 Data import techniques to the database, Data export techniques from databases, Authentication methods in SQL Server -
Pertemuan 10 Manage user authorizations, Server and database role concepts, Assign roles to users -
Pertemuan 11 Manage user authorizations, Server and database role concepts, Assign roles to users -
Pertemuan 12 Automation concepts in SQL Server management, Using the SQL Server Agent for scheduled tasks, Create and manage automation scripts -
Pertemuan 13 Securing the SQL Server Agent, SQL Server monitoring techniques -
Pertemuan 14 The importance of database maintenance, Query optimization techniques -
Pertemuan 15 Systematic approach to troubleshooting, Handle common issues in SQL Server -
Pertemuan 16 UAS
References
Lecturer
Difficult Things About Education.
$75$10
More Similar Courses
Related Courses
Simpeg and E Government
This course contains studies on understanding the concepts of simpeg and e-government, analysis of simpeg and e-government, development of simpeg and e-government, implementation of simpeg
Pancasila Education
This course will discuss the concept and essence of Pancasila as the basis and ideology of the state, as well as the nation‘s way of
Literasi Digital
The Digital Literacy course is a general compulsory course (MKWU) for all Surabaya State University students which is presented in the first year of study.
Copyright © 2024 Sinau Digital UNESA All Rights Reserved