Information Package

Program of Statistics and Computer Sciences

İST476

DATABASES II

Course Code
İST476
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. learn the basic concepts and terminology of data structures.
Mode of DeliveryFace to face
PrerequisitesNo
Recommended Optional Programme ComponentsThere is no recommended optional programme component for this course.
Course DescriptionDeveloping and managing stored procedures and functions, package, and database triggers, Learning Internet Application Developer and the tools to create vigorous, highly scalable client/ server applications, and Web deployment of those applications, Developing and managing various reports that will provide the necessary information to make sound business decisions, Developing and managing stored procedures and functions, package, and database triggers. Layout editor and forms, Forms storage and executable, Blocks validation and navigation, Building menu modules, the query interface, Creating reusable code and managing multi-applications, Design, run and create reports, Data and model and layout basis, Performance issues.
Course Contents
WEEK TOPICS
1st Week Web database systems
2nd Week Modern Database Applications
3rd Week Internet Application Developer
4th Week Tools to create vigorous, highly scalable client/ server applications
5th Week Web deployment
6th Week Developing and managing various reports
7th Week Developing and managing stored procedures
8th Week MIDTERM I
9th Week Developing functions
10th Week Developing packages
11th Week Database triggers
12th Week Forms, Forms storage and executable
13th Week Design, run and create reports
14th Week Data and model and layout basis (MID TERM II)
Recommended or Required Reading"Michael Mannino, "Databases - Design, Application Development and Administration with ER Assistant", McGraw-Hill."
"Barry Eaglestone, "Web Database Systems", McGraw-Hill.
" "Barry Eaglestone, "Database Design & Programming", McGraw-Hill." "Marlene 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 Administration", Course Technology, ISBN: 0-619-15900-6, 2003".
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