Database Management Systems II
Computer Programming (Distance Learning)
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 |
|---|---|---|---|---|---|---|
| Database Management Systems II | BUE233 | Compulsory | Associate degree | 2 | Spring | 4 |
Name of Lecturer(s)
Associate Prof. Dr. Özkan KAFADAR
Lecturer NEVIN ANTAR
Lecturer Birsen KÖSELE BAYHAN
Lecturer Mustafa OF
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
Bölümün/programın program yeterlilikleri sistemde olmadığından ilişkilendirme işlemi yapılamamıştır.
Mode of Delivery
e-course
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Not Required
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
Planned Learning Activities and Teaching Methods
1) Lecture
2) Question-Answer
3) Discussion
4) Drill and Practice
5) Demonstration
6) Simulation
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 |
20% |
|---|---|
Contribution of Final Examination to Course Grade |
80% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required