ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Information Systems and Technologies | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
General course introduction information
| Course Code: | BST483 | ||||||||
| Course Name: | Oracle Database SQL | ||||||||
| Course Semester: | Spring | ||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | TR | ||||||||
| Course Requisites: | |||||||||
| Does the Course Require Work Experience?: | No | ||||||||
| Type of course: | Department Elective | ||||||||
| Course Level: |
|
||||||||
| Mode of Delivery: | Face to face | ||||||||
| Course Coordinator : | Dr.Öğr.Üyesi FERİDUN CEMAL ÖZÇAKIR | ||||||||
| Course Lecturer(s): | |||||||||
| Course Assistants: |
Course Objective and Content
| Course Objectives: | This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. |
| Course Content: | This course is given in cooperation with the Oracle Academy. On Oracle database; SELECT queries; Using Character; Number; and Date Functions; Using Single Row; Executing Database; Working With Group Functions; GROUP BY; HAVING; ROLLUP; CUBE and GROUPING SETS structures; sub-queries; DML statements; DDL statements; Creating and Modifying Tables; Using Data Types; Creating and Managing Constraints; Creating and Managing Views; Working With Sequences and Indexes; Fundamentals of Database Security; Understanding Database Transactions . |
Learning Outcomes
The students who have succeeded in this course;
|
|||||||||||||||||||||||||||||||||||
Lesson Plan
| Week | Subject | Related Preparation |
| 1) | Introduction to Database Programming with SQL, SELECT and WHERE, ORDER BY, and Intro to Functions. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 2) | Single Row Function; character case-manipulation functions (LOWER, UPPER, and INITCAP), character-manipulation functions (CONCAT, SUBSTR, LENGTH, INSTR, LPAD, RPAD, TRIM, and REPLACE), The single-row number functions (ROUND, TRUNC, and MOD). | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 3) | Single Row Functions; TO_CHAR, TO_NUMBER, and TO_DATE. NVL, NVL2; NULLIF, and COALESCE functions. Conditional Expressions; DECODE, CASE functions and IF-THEN-ELSE conditional logic. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 4) | JOINs; Cross Joins, Natural Joins, Inner - Outer Joins, Self-Joins and Hierarchical Queries | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 5) | Oracle Equijoin and Cartesian, Oracle Nonequijoins and Outer Joins | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 6) | Group Functions (SUM, AVG, COUNT, MIN, MAX, STDDEV, VARIANCE, COUNT, DISTINCT, NVL), Use DISTINCT. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 7) | Using Group By and Having Clauses, Nest group functions (Rollup and Cube Operations, and Grouping Sets) | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 8) | MidTerm | |
| 9) | Subqueries; Comparison operators IN, ANY, and ALL in multiple-row subqueries | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 10) | INSERT Statement, Updating Column Values and Deleting Rows. DEFAULT Values, MERGE, and Multi-Table Inserts. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 11) | Creating Tables, Using Data Types, Modifying a Table. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 12) | Constraints; NOT NULL and UNIQUE Constraints, PRIMARY KEY, FOREIGN KEY, and CHECK Constraints. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 13) | Creating Views, Sequences and Synonyms. | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
| 14) | Database Transactions (COMMIT, ROLLBACK, and SAVEPOINT). | Oracle iLearning (Oracle Academy) and Oracle Application Express (APEX) |
Sources
| Course Notes / Textbooks: | Oracle Database SQL Language Reference – Diana Lorentz, Mary Beth Roeser, Simon Watt - Oracle Corporation |
| References: | - Oracle Database 11g SQL – Jason Price – The McGraw-Hill Companies Mastering - Oracle PL/SQL: Practical Solutions, Connor McDonald, Chaim Katz, Christopher Beck, Joel R. Kallman, David C. Knox – Apress Publishing |
Course-Program Learning Outcome Relationship
| Learning Outcomes | 1 |
3 |
2 |
4 |
|---|---|---|---|---|
| Program Outcomes | ||||
| 1) Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | ||||
| 2) Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | ||||
| 3) Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | ||||
| 4) To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | ||||
| 5) ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | ||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | 5 |
| 2) | Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | 5 |
| 3) | Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | 3 |
| 4) | To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | 2 |
| 5) | ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | 3 |
Learning Activity and Teaching Methods
| Expression | |
| Individual study and homework | |
| Lesson | |
| Group study and homework | |
| Lab | |
| Case Study |
Assessment & Grading Methods and Criteria
| Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
| Group project | |
| Presentation | |
| Case study presentation |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | 42 | % 5 |
| Quizzes | 17 | % 10 |
| Presentation | 1 | % 10 |
| Midterms | 1 | % 25 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
Workload and ECTS Credit Grading
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Application | 32 | 1 | 32 |
| Study Hours Out of Class | 14 | 1 | 14 |
| Presentations / Seminar | 1 | 3 | 3 |
| Quizzes | 17 | 1 | 17 |
| Midterms | 1 | 3 | 3 |
| Final | 1 | 3 | 3 |
| Total Workload | 114 | ||