This course covers following topics: Making relationships in relational databases, form design for data input, subforms, creating macros, data graphics, data access pages and creating reports in design view.
Vertical Tabs
Course Learning Outcomes
Learning Outcomes |
Program Learning Outcomes |
Teaching Methods |
Assessment Methods |
|||
Queries the data in tables using SQL commands. |
7,8 |
1,2,3,4 |
A,C |
|||
Creates the tables using SQL commands. |
7,8 |
1,2,3,4 |
A,E |
|||
Inserts records into tables using SQL commands. |
7,8 |
1,4 |
A,E |
|||
Updates the records in the table using SQL commands.. |
7,8 |
1, 4 |
A,E |
|||
Learn how to import data from another formats. |
7,8 |
1, 4 |
A,C,E |
Course Flow
Week |
Topics |
Study Materials |
1 |
Introduction to SQL. |
|
2 |
Retrieving data using the SQL SELECT statement. |
|
3 |
Restricting and sorting data. |
|
4 |
Using functions and conditional expressions. |
|
5 |
Displaying data from multiple tables using joins. |
|
6 |
Using subqueries to solve queries. |
|
7 |
Create and manage tables. |
|
8 |
MIDTERM |
|
9 |
Creating database objects. |
|
10 |
Controlling user access |
|
11 |
Managing database objects. |
|
12 |
Data dictionary |
|
13 |
Managing large data sets. |
|
14 |
Time-zone parameters and subqueries. |
|
15 |
FINAL |
|
Recommended Sources
Textbook |
DATABASE PROCESSING, David M.Kroenke, David J.Auer, Pearson Education, 12.Edition |
Additional Resources |
ORACLE Database: SQL Fundamentals Student Guide I / II |
Material Sharing
Documents |
Sample databse files and documents. |
Assignments |
|
Exams |
|
Assessment
IN-TERM STUDIES |
NUMBER |
PERCENTAGE |
Mid-term |
1 |
70 |
Project |
1 |
20 |
Homework |
3 |
10 |
Total |
|
100 |
CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE |
|
40 |
CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE |
|
60 |
Total |
|
100 |
COURSE CATEGORY |
Expertise/Field Courses |
Course’s Contribution to Program
No |
Program Learning Outcomes |
Contribution |
||||
1 |
2 |
3 |
4 |
5 |
||
1 |
Information Systems graduates have the knowledge and the skills to design and develop the complete systems for multi-media visual user interface. |
|
|
X |
|
|
2 |
Information Systems graduates have advanced the knowledge and skills to design, develop and install the application systems for multi-media. |
|
X |
|
|
|
3 |
Information Systems graduates have the knowledge and the skills to design, develop and apply algorithms and data structures to solve the basic problems of information processing, within the framework of discrete mathematics. |
X |
|
|
|
|
4 |
Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specificed requirements, using modern structured development tools and install them on various hardware platforms and deploy their usage. |
|
|
|
x |
|
5 |
Information Systems graduates have the knowledge and the skills to design and develop computer applications, based on user specificed requirements, using modern object-oriented development tools and install them on various hardware platforms and deploy their usage. |
|
x |
|
|
|
6 |
Information Systems graduates know the logic of computer operating systems, the basic set of system commands, how to control access to system resources by users of different departments and how to monitor the running of jobs in the system. |
x |
|
|
|
|
7 |
Information Systems graduates have the knowledge and the skills to design and develop data models serving different requirements, database applications that would access and process data using various types of software, including queries, reports and business applications. |
|
|
|
|
x |
8 |
Information Systems graduates have the knowledge and the skills to design and develop business applications that would provide data acess, modification and processing for data kept in enterprise database systems. |
|
|
|
|
x |
9 |
Information Systems graduates have the knowledge about computer networks, and have the skills to design, develop and monitor computer networks, how to configure them and how to maintain their performance. |
|
x |
|
|
|
10 |
Information Systems graduates have the knowledge and the skills to design and develop visual user interfaces for the web, web-based applications for n-tier client/server configurations, how to deploy them in enterprises. |
|
x |
|
|
|
11 |
Information Systems graduates, within his/her job responsibilities can communicate the necessary information both written and orally in Turkish, English and another foreign language, respecting the values the societal institutions and establishments, of which he/she has acquired in the program. |
|
|
|
|
|
ECTS
Activities |
Quantity |
Duration |
Total |
Course Duration (Including the exam week: 16x Total course hours) |
15 |
3 |
45 |
Hours for off-the-classroom study (Pre-study, practice) |
15 |
3 |
45 |
Mid-term |
1 |
3 |
3 |
Project |
1 |
30 |
30 |
Homework |
3 |
6 |
18 |
Final examination |
1 |
3 |
3 |
Total Work Load |
|
|
144 |
Total Work Load / 25 (h) |
|
|
5.76 |
ECTS Credit of the Course |
|
|
6 |