• Türkçe
  • English
Course Code: 
ACM 212
Course Period: 
Spring
Course Type: 
Core
P: 
3
Lab: 
0
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

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.

Assignments

 

Exams

 

 
 

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

 

 

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

 

 

 

11

Information Systems graduates, within his/her job responsibilities can communicate the necessary information both written and orally in Turkish, English and another foreign language, respecting the values the societal institutions and establishments, of which he/she has acquired in the program.

 

 

 

 

 

 
 

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

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