Ders Planı

CLASS 1

CLASS 2

CLASS 3

CLASS 4

Lesson plan /

Lesson Information

Course Credit
Course ECTS Credit
Teaching Language of Instruction	Türkçe
Level of Course	Bachelor's Degree, TYYÇ: Level 6, EQF-LLL: Level 6, QF-EHEA: First Cycle
Type of Course
Mode of Delivery	Face-to-face
Does the course require compulsory or optional work experience?
Course Coordinator
Instructor (s)
Course Assistant

Purpose and Content

The aim of the course	To gain knowledge and skills about the general structure of databases and teaching database management systems through Sql server program.
Course Content	Basic database concepts, data and data models, relational database design, SQL structural query language, basic SQL residences, SQL functions, grouping in SQL, concatenation in SQL, SQL administrative functions, using multiple tables with SQL, SQL programming and function, transaction and error conditions in SQL programming, DBMS setup and administrative operations, SQL queries on DBMS.

Learning Outcomes

Defines basic concepts related to Computer and Instructional Technology Education.
The Computer and Instructional Technology Education (BÖTE) analyzes the relationship between the basic concepts in the courses and information technologies and applications.
Analyzes the developments in the field of Computer and Instructional Technology education with related models.
Evaluates data related to computer and instructional technologies within the scope of scientific processes.
Develops projects related to the field of computer and instructional technology teaching.
Plan the teaching-learning process for Computer and Instructional Technology Education according to the development characteristics and individual differences of the students.
Through computer technology, visual design is gaining importance in industry and education.
Compares the aims and principles of the Basic Laws of Turkish National Education at every level of education.
Computer and Instructional Technology assesses the cultural, social and psychological elements that will influence practices in the field of education.
Uses models, methods and techniques related to instructional technology and design.
Evaluates the basic concepts and principles of Computer and Instructional Technology Education in a multi-faceted way.
Explains concepts of computer installation, internet, web based access and security.
Develops materials and projects with teaching and information technology based on teaching design models.
Plan the teaching-learning process by taking into account the characteristics of each stage and subject area in the field of teaching design modeling approach and Computer and Instructional Technology Education.
Designs activities to develop technical and vocational skills through Computer and Instructional Technology Education.
It plans and implements distance education technology.
Students organize educational environments based on instructional design models for the highest level of learning, taking into account the level of readiness in the field of Computer and Instructional Technology Education.
Uses computer and education technologies effectively and meaningfully in individual and group work related to his field.
It takes responsibility for the correct use of communication technology in school and everyday life (student, teacher, family).
Computer and Instructional Technology Responsible for individual or instructional design team work in the project development process to solve problems related to education.
He manages and develops projects with instructional design models.
The positive effects of the development of new technologies are used in daily life.
Computer Education and Instructional Technology develops a teaching strategy in accordance with the level of readiness of the students.
Creates new examples of approaches to the field of Computer and Instructional Technology Education, taking into account the qualifications and characteristics of students at all levels.
Teaching design models develop material for learners at different levels and for different sectors.
In the field of Computer and Instructional Technology Education, students at all levels develop sensitivity about acquiring good habits in technology use.
It follows the national and international developments on the net with communication networks.
In the field of education and training, design, software and technology usage solutions are shared by developing solutions around them.
He is competent in developing projects that will contribute to teaching technologies related to his field.
It represents the field and the teaching profession in every sector as required.
It provides the necessary security when using communication technologies in the school environment.

Weekly Course Subjects

1	Database definition and types, functions and advantages of database management systems
2	Database planning and design
3	ACCESS objects overview
4	Creating database, creating tables, field definitions and properties, data types.
5	Defining relationships between tables, entering data into tables, importing and importing data from outside.
6	Creating forms, creating queries
7	Report creation, page creation, macro creation, module creation
8	Introduction to SQL language, Basic SQL commands DDL commands, DML commands
9	mid-term exam
10	SQL functions
11	Grouping, GROUP BY, HAVING
12	Merge, JOIN
13	SQL Server, setup, interface and usage, creating database, creating table, field definitions and features
14	Data types, creating and customizing queries

Resources

1-Metin Ç.,(2007), SQL Server notları

2- Çubukçu, F. ,(2006), Veri Tabanı Yönetim Sistemleri İstanbul:ALFA
3- Gözüdeli Y.(2003) Veri Tabanı Programlama I

CLASS 1

CLASS 2

CLASS 3

CLASS 4

Lesson Information

Purpose and Content

Learning Outcomes

Weekly Course Subjects

Resources

ABOUT IAU

COMMITTEE

PUBLICATIONS

MEDIA CENTER