BAYBURT University Information Package / Course Catalogue

Home Information on the Institution Information on Degree Programmes General Information for Students
Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
BT110B2Database ICompulsory126
Level of Course Unit
Short Cycle
Objectives of the Course
Understanding database design. Knowing data security, backing up and restoring. Learn to use the Sql language. To improve the ability to make database connections and database transactions with programming languages. Manage databases and servers.
Name of Lecturer(s)
Öğr. Gör. Ahmet DEVELİ
Learning Outcomes
1Designing a Database
2Create a database
3Querying Database
4Using Database Administrative Functions
Mode of Delivery
Normal Education
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
1. Database design and management, 2. Data security, backup and restore, 3. SQL-DDL 4. SQL DML 5. SQL-DCL
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Database basic conceptDatabase basic conceptDatabase basic concept
2NormalizationNormalizationNormalization
3Design database with Entity-Relation modelDesign database with Entity-Relation modelDesign database with Entity-Relation model
4Create database and tables with SQL Data Definition Language (DDL) CommandCreate database and tables with SQL Data Definition Language (DDL) CommandCreate database and tables with SQL Data Definition Language (DDL) Command
5usage of SQL data manipulation language (DML) commandsusage of SQL data manipulation language (DML) commandsusage of SQL data manipulation language (DML) commands
6Arithmetical operators and functionsArithmetical operators and functionsArithmetical operators and functions
7Arithmetical operators and functionsArithmetical operators and functionsArithmetical operators and functions
8Midterm
9Query on one tableQuery on one tableQuery on one table
10Query by groupingQuery by groupingQuery by grouping
11Query on more than one tableQuery on more than one tableQuery on more than one table
12Query on more than one tableQuery on more than one tableQuery on more than one table
13Usage of subqueryUsage of subqueryUsage of subquery
14Usage of subqueryUsage of subqueryUsage of subquery
15Usage of Data Control Language (DCL) commandsUsage of Data Control Language (DCL) commandsUsage of Data Control Language (DCL) commands
16Final exam
Recommended or Required Reading
Veri Tabanı Yönetim Sistemleri- Turgut ÖZSEVEN Veri Tabanı Yönetim Sistemleri PostreSQL- Ahmet FİNCAN, Yasin TATAR
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
Midterm Examination1100
SUM100
End Of Term (or Year) Learning ActivitiesQuantityWeight
Final Examination1100
SUM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
SUM100
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination111
Final Examination122
Attending Lectures14456
Practice10220
Self Study10220
Individual Study for Mid term Examination14342
Individual Study for Final Examination14342
TOTAL WORKLOAD (hours)183
Contribution of Learning Outcomes to Programme Outcomes
PO
1		PO
2		PO
3		PO
4		PO
5		PO
6		PO
7		PO
8		PO
9		PO
10		PO
11		PO
12		PO
13		PO
14		PO
15
LO1533345 54  5   
LO2533345 54  5   
LO3533345 55  5   
LO4535345 53  5   
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High