Associate Degree Programs
Vocational School of Technical Sciences
Computer Programming
Anlık RSS Bilgilendirmesi İçin Tıklayınız.Düzenli bilgilendirme E-Postaları almak için listemize kaydolabilirsiniz.


Database Programming

Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
TBP2002 2 Database Programming 2/0/0 CC Türkçe 2
Course Goals
 To ensure that students understand the concept of database and that database is the basic element of a software, also to teach students the T-SQL language effectively and to introduce students to the platforms on which this language will be used.
Prerequisite(s) Course Code Course Name…
Corequisite(s) Course Code Course Name…
Special Requisite(s) The minimum qualifications that are expected from the students who want to attend the course.(Examples: Foreign language level, attendance, known theoretical pre-qualifications, etc.)
Instructor(s) Lecturer Muharrem Altunisik
Course Assistant(s)
Schedule Friday, 09.00-10.50 / 11.00-12.50 / 13.00-14.50, Ataköy Campus Basement 2nd Floor Computer Laboratory 1 (AKLAB B2FEFPC1)
Office Hour(s) Thursday, 11.00-12.50, Incirli Campus 1st Floor A Corridor Room 09 (1A09)
Teaching Methods and Techniques - Hybrid, Applied explanation
Principle Sources - Lecture note documents shared after class
Other Sources -
Course Schedules
Week Contents Learning Methods
1. Week Introduction to Database Programming Hybrid Lecture and Application
2. Week T-SQL Programming Hybrid Lecture and Application
3. Week T-SQL String Functions Hybrid Lecture and Application
4. Week T-SQL DateTime Functions Hybrid Lecture and Application
5. Week T-SQL Type Conversion Functions Hybrid Lecture and Application
6. Week T-SQL Mathematical Functions Hybrid Lecture and Application
7. Week Midterm Week Midterm Week
8. Week Variables Hybrid Lecture and Application
9. Week Condition Blocks Hybrid Lecture and Application
10. Week Loops Hybrid Lecture and Application
11. Week View Hybrid Lecture and Application
12. Week User Defined Functions Hybrid Lecture and Application
13. Week Stored Procedure Hybrid Lecture and Application
14. Week Finals Week Finals Week
15. Week
16. Week
17. Week
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 20
Homework / Term Projects / Presentations 1 30
Final Exam 1 50


Program Outcomes
PO-1Effectively identifying collecting and evaluating the data required for the Computer Programming field and using theoretical knowledge for creating applications.
PO-2Being equipped with basics of computer science.
PO-3Possessing the knowledge of all necessary software and equipment in the profession.
PO-4Emphasizing team work, contributing to the group and operating with team chemistry.
PO-5Effectively expressing and sharing the completed work with project group and teammates.
PO-6Objectively evaluating the performance of employees under his/her supervision and providing objective information to the management.
PO-7Demonstrating problem solving skills and the education he/she obtained at the program.
PO-8Possessing the computer programming knowledge built on skills, information and competencies provided by secondary education and supperted by higher education course materials, and demonstrating the understanding of concepts in the field of computer programming.
PO-9Acquiring the analytical thinking skills required in the field of computer programming, and creating and running programs in accordance with this analytical perspective.
PO-10Complying with ethical values of the field of Computer Programming and carrying social responsibility.
PO-11Developing sufficent foreign language skills to conduct the work and follow the global developments at the best level.
PO-12Empasizing communication and using Turkish accurately in this communication.
PO-13Ensuring the security, environment and health awareness at personal level and among his/her employees.
PO-14Following technological innovations in software and hardware after graduation and sustaining continuous personal development.
PO-15Claiming responsibility at his/her workplace, organizing work flow with employees and operating according to high quality work standards.
Learning Outcomes
LO-1T-SQL Programming Can Be Done.
LO-2Stored Procedure and Procedure Can Be Used.
LO-3Movement Management Can Be Performed.
LO-4Backup and Maintenance Operations Will Be Understood.
LO-5Maintenance operations can be performed.
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15
LO 1
LO 2
LO 3
LO 4
LO 5