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