| Course Type | Elective Course |
|---|
| Course Level | Master's Degree With Thesis |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 10 |
|---|
| Name of Lecturer(s) |
- |
| Learning Outcomes |
At the end of this course, the students;
- Are expected to master on SQL and have the knowledge to develop and administer databases on any platform.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | There is no recommended optional programme component for this course. |
|---|
| Course Description | Databases. Relational databases. Tables. Structured Query Language (SQL), Entering Information, Extracting Information, Advanced Database Design, Manipulating Data, Grouping and Aggregating Data, Selecting Data from Different Tables, Queries within Queries, Advanced Queries, Views, Transactions, SQL Security, Database Tuning. |
|---|
| Course Contents |
| WEEK |
TOPICS |
|
1st Week |
Database concepts and types of databases |
|
2nd Week |
Relational databases |
|
3rd Week |
Storing and Retreving data |
|
4th Week |
SQL |
|
5th Week |
Data Manipulation |
|
6th Week |
SQL operators and functions |
|
7th Week |
Oracle SQL*Plus |
|
8th Week |
MIDTERM |
|
9th Week |
PL/SQL |
|
10th Week |
Oracle Installation, Configuration and Building |
|
11th Week |
Developing Data Models |
|
12th Week |
Designing a Database's Structure |
|
13th Week |
Normalization |
|
14th Week |
Database Tools |
|
| Recommended or Required Reading | George Koch - Kevin Loney : Oracle The Complete Reference, Osborne McGraw-Hill, NewYork, 1997.
Dwight Cheu - Brian Linden: SQL Language Reference, Oracle, Ireland, 1990.
|
|---|
| Planned Learning Activities and Teaching Methods |
- Lecture
- Questions/Answers
- Problem Solving
- Other
|
|---|
| Assessment Methods and Criteria |
|
Quantity |
Percentage (%) |
| Mid-term |
1 |
30 |
| Assignment |
1 |
10 |
| Project |
1 |
10 |
| Total(%) |
|
50 |
| Contribution of In-term Studies to Overall Grade(%) |
|
50 |
| Contribution of Final Examination to Overall Grade(%) |
|
50 |
| Total(%) |
|
100 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
