The students will be able to write SQL scripts for the solutions of real problems in the domain of database management
Mode of Delivery
Face to face
Prerequisites
No
Recommended Optional Programme Components
None
Course Description
Database concepts and types of databases, Relational databases, Storing and Retreving data, SQL, Data Manipulation, SQL operators and functions, Oracle SQL*Plus, PL/SQL, Installation and Configuration of a database, Developing Data Models, Designing a Database?s Structure, Normalization, Database Tools
Course Contents
WEEK
TOPICS
1st Week
Database concepts and types of databases
2nd Week
Relational databases
3rd Week
Storing and Retreiving data
4th Week
SQL
5th Week
Data Manipulation
6th Week
SQL operators and functions
7th Week
Database Tools
8th Week
MIDTERM I
9th Week
Oracle SQL*Plus
10th Week
PL/SQL
11th Week
Oracle Installation, Configuration and Building
12th Week
Developing Data Models
13th Week
Designing a Database's Structure
14th Week
Normalization
Recommended or Required Reading
1. Timur Karaçay, http://www.baskent.edu.tr/~tkaracay web sitesindeki ders notları. 2. George Koch - Kevin Loney : Oracle The Complete Reference, Osborne McGraw-Hill, NewYork, 1997. 3. Dwight Cheu - Brian Linden: SQL Language Reference, Oracle, Ireland, 1990. 4. Ken Rudin - Tom Portfolio : PL/SQL User's Guide and Reference, Oracle, Ireland, 1990
Planned Learning Activities and Teaching Methods
Lecture
Questions/Answers
Case Study
Problem Solving
Assessment Methods and Criteria
Quantity
Percentage (%)
Mid-term
1
10
Assignment
5
10
Quiz
5
10
Practice
1
10
Project
1
10
Total(%)
50
Contribution of In-term Studies to Overall Grade(%)
50
Contribution of Final Examination to Overall Grade(%)