MYP214


Course Title Course Code Program Level
Database II MYP214 Computer Programming Associate Degree

Course Term
(Course Semester)
Teaching and Learning Methods
Credits
Theory Practice Lab Projects/Field Work Seminars/Workshops Other Total Credits ECTS Credits
04
(Spring)
28 28 56 3 5

Teaching Staff
Language of Instruction Türkçe (Turkish)
Type Of Course Vocational
Prerequisites
Recommended Optional Programme Component
Course Objectives The aim of this course is to gain competencies to the students which is related to database and the servers.
Course Content
Learning Outcomes (LO) 1. Installing the database 2. Making basic table operations 3. Performing advanced table operations 4. Managing the database server
Mode of Delivery Face to face
Course Outline
Week Topics
1. Week installing server software of at least two different vendors as an industrial standart
2. Week Setting up the database administration panel, creating the database and defining the users
3. Week Creating databases and defining users, Defining tables and managing diagrams
4. Week Defining tables and managing diagrams, Performing data transfer operations
5. Week Performing data transfer operations, Creating new database from existing database
6. Week Creating new database from existing database, Editting view, trigger, subprograms and indexes
7. Week Editting view, trigger, subprograms and indexes
8. Week Editting view, trigger, subprograms and indexes, Editing user roles, user-defined data types
9. Week Editing user roles, user-defined data types
10. Week Editting rules and default values
11. Week Editting rules and default values, Performing data replication operations and maintenance plan
12. Week Performing data replication operations and maintenance plan
13. Week Performing performance analysis and improvements
14. Week Performing performance analysis and improvements
Assessment
  Percentage(%)
Mid-term (%) 40
Quizes (%)
Homeworks/Term papers (%)
Practice (%)
Labs (%)
Projects/Field Work (%)
Seminars/Workshops (%)
Final (%) 60
Other (%)
Total(%) 100
Course Book (s) and/or References Ünal Yarımağan, Veri Tabanı Sistemleri, Akademi Yayınevi, 2010. Mannino, Michael V, Database Design, Application Development and Administration, McGraw-Hill, 2007. Connolly, T.M. and Begg, C.E. Database Systems: A Practical Approach to Design, Implementation, and Management, addison-Wesley, 2005. A. Silberschatz, H.F. Korth ve S. Sudarshan. Database Systems Concepts 6th Edition. McGraw Hill, 2010. Elmasri and Navathe, Fundamentals of Database Systems, Sixth Edition, Pearson Education, 2010 Raghu Ramakrishnan and Johannes Gehrke, “Database Management Systems”, Third Edition, McGraw-Hill, 2002. Oracle 12g Administration Fundamentals I & II ve Oracle ile ilgili bütün açık kaynaklar. Çağıltay, N. E ve Tokdemir, G. Veritabanı Sistemleri Dersi: Teoriden Pratiğe. Seçkin Yayıncılık, Ankara, 2010.
Work Placement(s)
The Relationship between Program Qualifications (PQ) and Course Learning Outcomes (LO)