• Türkçe
  • English
Course Code: 
ACM 364
Course Period: 
Spring
Course Type: 
Area Elective
P: 
3
Lab: 
0
Credits: 
3
ECTS: 
6
Prerequisite Courses: 
Course Language: 
İngilizce
Course Objectives: 
SQL, manage the database objects, normalization process, data processing, manage the database transactions, using operator to classify data, summarize the results of a query, classify and group the data , revision of view of data, query of multiple tables, using sub-queries, union of multiple queries, management of database users, management of database security.
Course Content: 

This course covers the following topics: SQL, managing database objects, the normalization process, manipulating data, managing database transactions, using operators to categorize data, summarizing data results from a query, sorting and grouping data, restructuring the appearance of data, joining tables in queries, using sub-queries, combining multiple queries into one, managing database users, managing database security.

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

Knows about SQL commands.

7,8

1,2,3,4

A,C

Knows about creating database.

7,8

1,2,3,4

A,E

Learns about database management.

7,8

1,4

A,E

Learns about  backup, restore and recovery.

7,8

1, 4

A,E

Learns about performance and security settings.

7,8

1, 4

A,C,E

 
 

Course Flow

Week

Topics

Study Materials

1

Exploring the database architecture

 

2

Creating databases

 

3

Managing instances

 

4

Configuring network environment

 

5

Managing database storage structures

 

6

Administering user security

 

7

Create and manage tables.

 

8

MIDTERM

 

9

Managing data currency and undo data

 

10

Database auditing and maintenance

 

11

Performance management

 

12

Backup concepts

 

13

Recovery concepts

 

14

Moving data

 

15

FINAL

 

 
 

Recommended Sources

Textbook

DATABASE PROCESSING, David M.Kroenke, David J.Auer, Pearson Education, 12.Edition

Additional Resources

ORACLE Database 11G:  Administration Workshop I

 
 

Material Sharing

Documents

Sample files and documents from www.ogrencisistemi.org web site.

Assignments

 

Exams

 

 
 

Assessment

IN-TERM STUDIES

NUMBER

PERCENTAGE

Mid-term

1

70

Project

1

20

Homework

1

10

Total

 

100

CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE

 

40

CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE

 

60

Total

 

100

 

 

COURSE CATEGORY

Expertise/Field Courses

 
 

Course’s Contribution to Program

No

Program Learning Outcomes

Contribution

1

2

3

4

5

1

Information Systems graduates have the knowledge and the skills to design and develop the complete systems for multi-media visual user interface.

 

 

X

 

 

2

Information Systems graduates have advanced the knowledge and skills to design, develop and install the application systems for multi-media.

 

X

 

 

 

3

Information Systems graduates have the knowledge and the skills to design, develop and apply algorithms and data structures to solve the basic problems of information processing, within the framework of discrete mathematics.

X

 

 

 

 

4

Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specificed requirements, using modern structured development tools and install them on various hardware platforms and deploy their usage.

 

 

 

x

 

5

Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specificed requirements, using modern object-oriented development tools and install them on various hardware platforms and deploy their usage.

 

x

 

 

 

6

Information Systems graduates know the logic of computer operating systems, the basic set of system commands, how to control access to system resources by users of different departments and how to monitor the running of jobs in the system.

x

 

 

 

 

7

Information Systems graduates have the knowledge and the skills to design and develop data models serving different requirements, database applications that would access and process data using various types of software, including queries, reports and business applications.

 

 

 

 

x

8

Information Systems graduates have the knowledge and the skills to design and develop business applications that would provide data acess, modification and processing for data kept in enterprise database systems.

 

 

 

 

x

9

Information Systems graduates have the knowledge about computer networks, and have  the skills to design,  develop and monitor  computer networks, how to configure them  and how to maintain their performance.

 

x

 

 

 

10

Information Systems graduates have the knowledge and the skills to design and develop visual user interfaces for the web, web-based applications for n-tier client/server configurations, how to deploy them in enterprises.

 

x

 

 

 

 
 

ECTS

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

9

9

Project

1

9

9

Homework

3

6

18

Final examination

1

9

9

Total Work Load

 

 

135

Total Work Load / 25 (h)

 

 

5.4

ECTS Credit of the Course

 

 

6