Information Package

Program of Statistics and Computer Sciences

İST475

DATABASES I

Course Code
İST475
Semester
-
Theory+Practice
3 + 0
ECTS
5
Course TypeElective Course
Course LevelBachelor's Degree
Year of Study-
Semester-
ECTS5
Name of Lecturer(s) -
Learning Outcomes

At the end of this course, the students;

  1. the basic concepts and terminology of database
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme ComponentsThere is no recommended optional programme component for this course.
Course DescriptionSQL Fundamentals: Describe relational database concepts, Retrieve, insert, update, and delete data, Create and maintain database objects, Describe the features and syntax of SQL, Control transactions, Conditionally control code flow (loops, control structures, and explicit cursors), Use basic SQL commands, Handle runtime errors.
Course Contents
WEEK TOPICS
1st Week Describe relational database concepts
2nd Week SQL Fundamentals
3rd Week Data types
4th Week Retreive
5th Week Retreive: Columns and Row selections
6th Week Retreive: Subqueries
7th Week Manipulation with dates
8th Week MIDTERM I
9th Week Operators and functions
10th Week Joins
11th Week Creating tables and views
12th Week Updating and deleting
13th Week Reporting
14th Week MIDTERM II
Recommended or Required ReadingMarlene Theriault, Rachel Carmichael, James Viscusi "Oracle9i DBA", McGraw-Hill.
" "Christopher Allen, Catherine Creary and Simon Chatwin "Introduction to relational Databases and SQL
Programming", McGraw-Hill.
" "Christopher Allen, Catherina Creary and Simon Charwin "Introduction to Relational Databases and SQL Programming", McGraw-Hill.
" "Rob and Coronel, "Database Systems: Design, Implementation, and Management" , Fifth Edition, Course Technology, ISBN: 0-619-06269-X, 2002.
" "McCullough-Dieter, "Oracle9i Database Administrator: Implementation and Administratio
Planned Learning Activities and Teaching Methods
  • Lecture
  • Questions/Answers
  • Case Study
  • Problem Solving
Assessment Methods and Criteria
Quantity Percentage (%)
Mid-term 2 40
Quiz 5 10
Total(%) 50
Contribution of In-term Studies to Overall Grade(%) 50
Contribution of Final Examination to Overall Grade(%) 50
Total(%) 100
Language of InstructionTurkish
Work Placement(s)No
LO1
K1 X
K2 X
K3 X
K4
K5
K6 X
K7 X
K8
K9
K10 X
K11
K12