Pamukkale University
University is the guide to life
Welcome to PAU;
Prospective Student
Our Students
Our Staff
TR
Information Package & Course Catalogue
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes
SHORT CYCLE - ASSOCIATE'S DEGREE
ÇİVRİL ATASAY KAMER VOCATIONAL SCHOOL
COMPUTER TECHNOLOGIES DEPARTMENT
760 COMPUTER PROGRAMMING (Evening Classes)
Course Information
Course Learning Outcomes
Course's Contribution To Program
ECTS Workload
Course Details
Print
COURSE INFORMATION
Course Code
Course Title
L+P Hour
Semester
ECTS
CBPG 108
DATABASE I
3 + 1
2nd Semester
4
COURSE DESCRIPTION
Course Level
Associate's Degree
Course Type
Compulsory
Course Objective
With this course, students, data base designing, creating, querying, data base administrative functions, gain qualifications.
Course Content
Database Needs Analysis Normalization Normalization Normalization Installing the Database Tools Creating tables and determine the characteristics of Creating tables and determine the characteristics of Creating tables and determine the characteristics of Create and use the kinds of queries Create and use the kinds of queries Prepare tables associated with the query Prepare tables associated with the query Using DML queries Using DML queries User queries Writing Writing Queries View Writing Trigger Queries Writing Trigger Queries Writing Queries Sub-Programme Make Transaction Processing Writing Queries Index
Prerequisites
No the prerequisite of lesson.
Corequisite
No the corequisite of lesson.
Mode of Delivery
Face to Face
COURSE LEARNING OUTCOMES
1
Database design
2
Creating database
3
Querying the database
COURSE'S CONTRIBUTION TO PROGRAM
PO 01
PO 02
PO 03
PO 04
PO 05
PO 06
PO 07
PO 08
PO 09
PO 10
PO 11
PO 12
PO 13
PO 14
PO 15
PO 16
PO 17
PO 18
PO 19
LO 001
1
5
5
4
LO 002
1
5
5
2
LO 003
1
5
5
3
Sub Total
3
15
15
9
Contribution
1
0
0
0
5
0
0
5
0
3
0
0
0
0
0
0
0
0
0
ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
Activities
Quantity
Duration (Hour)
Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)
14
4
56
Hours for off-the-classroom study (Pre-study, practice)
14
2
28
Mid-terms
1
6
6
Final examination
1
8
8
Quiz
2
3
6
Total Work Load
ECTS Credit of the Course
104
4
COURSE DETAILS
Select Year
All Years
2023-2024 Spring
2022-2023 Spring
2021-2022 Spring
2020-2021 Spring
2019-2020 Spring
2018-2019 Spring
2017-2018 Spring
2016-2017 Spring
2015-2016 Spring
2014-2015 Spring
2013-2014 Summer
2013-2014 Spring
2012-2013 Summer
2012-2013 Spring
2011-2012 Summer
2011-2012 Spring
Course Term
No
Instructors
Details
2023-2024 Spring
1
ALİ COŞKUN
Details
2022-2023 Spring
1
ALİ COŞKUN
Details
2021-2022 Spring
1
ALİ COŞKUN
Details
2020-2021 Spring
1
ALİ COŞKUN
Details
2019-2020 Spring
1
ALİ COŞKUN
Details
2018-2019 Spring
1
ALİ COŞKUN
Details
2017-2018 Spring
1
ALİ COŞKUN
Details
2016-2017 Spring
2
ALİ COŞKUN
Details
2015-2016 Spring
2
ALİ COŞKUN
Details
2014-2015 Spring
2
ALİ COŞKUN
Details
2013-2014 Summer
1
ALİ COŞKUN
Details
2013-2014 Summer
1
ALİ COŞKUN
Details
2013-2014 Spring
2
ALİ COŞKUN
Details
2012-2013 Summer
1
ALİ COŞKUN
Details
2012-2013 Summer
1
ALİ COŞKUN
Details
2012-2013 Summer
1
ALİ COŞKUN
Details
2012-2013 Spring
2
ALİ COŞKUN
Details
2011-2012 Summer
1
ALİ COŞKUN
Details
2011-2012 Spring
2
ALİ COŞKUN
Print
Course Details
Course Code
Course Title
L+P Hour
Course Code
Language Of Instruction
Course Semester
CBPG 108
DATABASE I
3 + 1
1
Turkish
2023-2024 Spring
Course Coordinator
E-Mail
Phone Number
Course Location
Attendance
Lecturer ALİ COŞKUN
alicoskun@pau.edu.tr
ÇMYO A0064
%70
Goals
With this course, students, data base designing, creating, querying, data base administrative functions, gain qualifications.
Content
Database Needs Analysis Normalization Normalization Normalization Installing the Database Tools Creating tables and determine the characteristics of Creating tables and determine the characteristics of Creating tables and determine the characteristics of Create and use the kinds of queries Create and use the kinds of queries Prepare tables associated with the query Prepare tables associated with the query Using DML queries Using DML queries User queries Writing Writing Queries View Writing Trigger Queries Writing Trigger Queries Writing Queries Sub-Programme Make Transaction Processing Writing Queries Index
Topics
Weeks
Topics
1
Introduction to data base
2
Basic Concepts
3
Relational Database Design
4
Normalization
5
Example Database Application
6
SQL - Structured Query Language
7
Single-Table Queries
8
Arithmetic Operators and Functions
9
Query grouping
10
Query on multiple tables
11
Old Queries
12
Views
13
Use of index
14
Project Presentation
Materials
Materials are not specified.
Resources
Resources
Resources Language
Veri Tabamı Yönetim Sistemleri -1 - Turgut Özseven - Murathan Yayınevi
Türkçe
Course Assessment
Assesment Methods
Percentage (%)
Assesment Methods Title
Final Exam
50
Final Exam
Midterm Exam
30
Midterm Exam
Project
20
Project
L+P:
Lecture and Practice
PQ:
Program Learning Outcomes
LO:
Course Learning Outcomes
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##
Home Page
About University
Name And Address
Acedemic Authorities
General Discription
Academic Calendar
General Admission Requirements
Recognition of Prior Learning
General Registration Procedures
ECTS Credit Allocation
Academic Guidance
Information For Students
Cost Of Living
Accommodation
Meals
Medical Facilities
Facilities for Special Needs Students
Insurance
Financial Support for Students
Student Affairs
Learning Facilities
International Programs
Language Courses
Internships
Sports Facilities and Leisure Activities
Student Associations
Practical Information for Mobile Students
Degree Programmes