Advanced Database Applications

Course Code:

ACM 212

Course Period:

Spring

Course Type:

Core

Lab:

30

Credits:

3

ECTS:

6

Course Language:

İngilizce

Course Objectives:

Access to data by using the SQL language, reports and analysis of query results graphs, tables, reports. In addition, recognition of the Oracle relational database systems, with PL / SQL to develop advanced data processing tools.

Course Content:

This course covers following topics: Making relationships in relational databases, form design for data input, subforms, creating macros, data graphics, data access pages and creating reports in design view.

Course Methodology:

1: Lecture, 2: Question-Answer, 3: Discussion, 4: Lab Work

Course Evaluation Methods:

A: Testing, B: Presentation C: Homework D: Project E: Laboratory

Vertical Tabs

Course Learning Outcomes

Learning Outcomes	Program Learning Outcomes	Teaching Methods		Assessment Methods
Queries the data in tables using SQL commands.	7,8		1,2,3,4		A,C
Creates the tables using SQL commands.	7,8		1,2,3,4		A,E
Inserts records into tables using SQL commands.	7,8		1,4		A,E
Updates the records in the table using SQL commands..	7,8		1, 4		A,E
Learn how to import data from another formats.	7,8		1, 4		A,C,E

Course Flow

COURSE CONTENT
Week	Topics	Study Materials
1	Introduction to SQL.
2	Retrieving data using the SQL SELECT statement.
3	Restricting and sorting data.
4	Using functions and conditional expressions.
5	Displaying data from multiple tables using joins.
6	Using subqueries to solve queries.
7	Create and manage tables.
8	MIDTERM
9	Creating database objects.
10	Controlling user access
11	Managing database objects.
12	Data dictionary
13	Managing large data sets.
14	Time-zone parameters and subqueries.
15	FINAL

Recommended Sources

Textbook	DATABASE PROCESSING, David M.Kroenke, David J.Auer, Pearson Education, 12.Edition
Additional Resources	ORACLE Database: SQL Fundamentals Student Guide I / II

Material Sharing

Documents

Sample databse files and documents.

Assessment

ASSESSMENT
IN-TERM STUDIES	NUMBER	PERCENTAGE
Mid-term	1	70
Project	1	20
Homework	3	10
Total		100
CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE		40
CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE		60
Total		100

ECTS

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
Activities	Quantity	Duration (Hour)	Total Workload (Hour)
Course Duration (Including the exam week: 16x Total course hours)	15	3	45
Hours for off-the-classroom study (Pre-study, practice)	15	3	45
Mid-term	1	3	3
Project	1	30	30
Homework	3	6	18
Final examination	1	3	3
Total Work Load			144
Total Work Load / 25 (h)			5.76
ECTS Credit of the Course			6

2

Search form