• 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 Coordinator: 
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

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

MATERIAL SHARING
Documents Sample databse files and documents.
Assignments  
Exams  

 

Assessment

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’s Contribution to Program

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

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 15 15
Homework 1 6 6
Final examination 1 3 3
Total Work Load     117
Total Work Load / 25 (h)     4.68
ECTS Credit of the Course     5

 

2