Database Management Systems-I
Structure of Microsoft SQL database server; relational database concepts; data storage models; database components; client-server architecture; database products and versions; preparation before installation; instance name; service account setting; etc.; SQL Server Management Studio; Standard SQL server databases; creating and deleting databases; DDL commands; Recovery-Transact Log; compatibility; database table operations; data types; data entry and data deletion; database backup and restore; queries; SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER commands and WHERE, ORDER BY, GROUP BY, HAVING, JOIN structures; data transfer operations; table join structures; constraints (UNIQUE, CHECK, PK, FK); index concept; saved procedures; triggers; SQL Server Agent.
| Course Credit | Credit Fees | ECTS Credit | Season | Language | Lecturer | Course Calendar |
|---|---|---|---|---|---|---|
| 3 | 6800₺ | 5 | SPRING | Turkish | Updating |