Information Systems and Technologies | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | BST483 | ||||||||
Course Name: | Oracle Database SQL | ||||||||
Course Semester: | Fall | ||||||||
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 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 . |
The students who have succeeded in this course;
|
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) |
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 |
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. |
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 |
Expression | |
Individual study and homework | |
Lesson | |
Group study and homework | |
Lab | |
Case Study |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Group project | |
Presentation | |
Case study presentation |
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 |
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 |