Data Base Management Systems - II
Computer Programming
Vocational School of Kocaeli
Short Cycle (Associate's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Data Base Management Systems - II | BPP212 | Compulsory | Associate degree | 2 | Spring | 4 |
Name of Lecturer(s)
Lecturer NEVIN ANTAR
Lecturer Burak ÇAKIR
Lecturer Birsen KÖSELE BAYHAN
Learning Outcomes of the Course Unit
1) Use the basic SQL functions.
2) Use SQL commands in visual programming languages .
3) Work with current database servers.
4) Design a database for the project.
5) Decide database server which will work in operating system for the required project or application.
6) Use database operations in the selected web interfaces (PHP, AJAX, ASP, etc.).
7) Perform the project in the application development platform in this way make to connection between database server and requested interfaces.
8) Perform complex expressions using basic SQL commands.
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||
| Learning Outcomes | ||||||||||||||||
| 1 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 2 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 3 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 4 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 5 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 6 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 7 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
| 8 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
There is not.
Course Contents
Using database in visual programming languages, query development, database and interface connection to perform the required data interfaces with the program to provide access, to use and explore the capabilities of the database in the programming language.
Weekly Schedule
1) Using database in visual languages2) Recognition and use of SQL server
3) Recognition of MS Visual Studio environment
4) Using web interface with C# and ASP .NET
5) Creating and connecting a database in MS Visual Studio
6) Connecting to a database in different ways
7) Using SQL in C#
8) Midterm examination/Assessment
9) Using SQL in C#.
10) Required components to use SQL
11) Required methods to use SQL
12) Using SQL commands with visual components
13) Using SQL commands with visual components
14) Security operations on the SQL server
15) Reporting
16) Final examination
Recommended or Required Reading
1- SQL Server ve Veritabanı , Yaşar GÖZÜDELİ , Seçkin Yayıncılık , 2010.
2- Veritabanı Yönetim Sistemleri , Yaşar DAŞDEMİR , Türkmen Kitabevi , 2004.
3- Veritabanı Yönetim Sistemleri ve SQL/PL-SQL/T-SQL , Zehra Alakoç BURMA , Seçkin Yayıncılık , 2009.
4- ¦¦¦
5- ¦¦¦
6- ¦¦¦
7- ¦¦¦
8- ¦¦¦
9- ¦¦¦
10- /¦¦¦
11- /¦¦¦
12- /¦¦¦
13- /¦¦¦
14- /¦¦¦
15- /¦¦¦
16- /¦¦¦
17- /¦¦¦
18- /¦¦¦
19- /¦¦¦
20- /¦¦¦
21- /¦¦¦
Planned Learning Activities and Teaching Methods
1) Lecture
2) Question-Answer
3) Discussion
4) Drill and Practice
5) Demonstration
6) Group Study
7) Case Study
8) Lab / Workshop
9) Self Study
10) Problem Solving
11) Project Based Learning
Assessment Methods and Criteria
Contribution of Midterm Examination to Course Grade |
30% |
|---|---|
Contribution of Final Examination to Course Grade |
70% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required