Program Overview

A VER TABANI PROGRAMLAMA [SQL SERVER]-I

Program Overview

The A Veri Taban Programlama [Sql Server]-I program is a 2-month course designed to provide students with the necessary skills and knowledge in database programming using SQL Server.

Program Content and General Objective

The program's content and general objective are based on the 1st Level Field Common modular programs in the field of information technologies. The program aims to provide students with the necessary skills and knowledge to work in the field of database programming.

Gains and Competencies

Upon completion of the program, students will gain the following competencies:

• Meslein ait olduu alandaki temel bilgi ve becerileri kazanabilecektir (acquire basic knowledge and skills in the field)
• Alann gerektirdii temel yeterliklere sahip olabilecektir (acquire basic qualifications required in the field)
• Meslein gerektirdii ileri yapabilecektir (perform tasks required in the profession)
• Meslein gerektirdii ÷zel mesleki yeterlikleri kazanabilecektir (acquire special professional qualifications required in the profession)
• Kursiyer merkezli, aktif ve kendi hzna g÷re ÷renme imkÔn tanyan kazanmlara sahip olabilecektir (acquire learner-centered, active, and self-paced learning opportunities)

Employment Areas and Qualifications

Graduates of the program can work in the following areas:

• Bilgisayar teknik servisi hizmeti veren bilgisayar firmalarnda, kamu kurum ve kurulularnda (computer technical service companies, public institutions, and organizations)
• A kurulum ve y÷netimi hizmeti veren ya da bu hizmete ihtiyaþ duyan firma, kamu kurum ve kurulularnda (network installation and management companies, public institutions, and organizations)
• Kullanc ara y³z³ne sahip uygulama ve veri taban programlar kullanm ve y÷netimi hizmeti veren ya da bu hizmetlere ihtiyaþ duyan firma, kamu kurum ve kurulularnda (companies, public institutions, and organizations that use and manage user interface applications and database programs)
• Web tasarm hizmeti veren veya web ortamnda þalan etkileimli programlar hazrlayan yazlm irketlerinde ya da bu hizmetlere ihtiyaþ duyan firma, kamu kurum ve kurulularnda (web design companies, software companies that develop interactive programs for the web, public institutions, and organizations)

Teaching Methods and Techniques

The program uses modular teaching methods and techniques, including:

• Bireysel ÷grenme y÷ntem ve teknikleri (individual learning methods and techniques)
• Eitimciler kursiyerlere rehberlik eder (instructors guide students)
• Kursiyerler kendi kendine ÷grenmeye tevik edilir (students are encouraged to learn on their own)
• Kursiyerlerin aktif olmas salanr (students are encouraged to be active)
• Kursiyerler aratrmaya y÷nlendirilir (students are directed to research)
• Kursiyerler kendi kendilerini deerlendirebilir (students can evaluate themselves)
• Kursiyerlere mesleki yeterlik kazandrmaya y÷nelik y÷ntem ve teknikler uygulanr (methods and techniques are applied to provide students with professional qualifications)

Measurement and Evaluation

The program uses various measurement tools to evaluate students':

• Mod³llerin sonunda kazand yeterlikler (competencies acquired at the end of each module)
• Mod³ller ile kazandklar bilgi, beceri ve tavrlar (knowledge, skills, and attitudes acquired through modules)
• Ílþme sonuþlar program sonunda deerlendirilecektir (measurement results are evaluated at the end of the program)
• Eitim kurumunda, iletmede ve kendi kendilerine yaptklar t³m ÷renim faaliyetleri deerlendirilecektir (all learning activities done in the educational institution, business, and self-study are evaluated)

Participant Criteria

The program is open to:

• Lise veya dengi okul mezunlar (high school or equivalent school graduates)
• Meslein gerektirdii ileri ve yeterlikleri yapacak bedensel ve fiziksel ÷zelliklere sahip (those who have the physical and mental abilities to perform tasks and acquire qualifications required in the profession)
• En az 17 yan tamamlam olmak (at least 17 years old)

Number of Participants

The program can accommodate up to 20 participants.

Program Duration

The program lasts for 2 months (8 weeks), with 3 days of classes per week, totaling 72 hours.

Weekly Program Content

The program content is as follows:

1. Hafta 1: Veri Taban Sistemleri, Veri Modelleri (Database Systems, Data Models)
2. Hafta 2: likisel Veri Taban Modeli, Varlk likisi (ER) Modellemesi (Relational Database Model, Entity-Relationship Modeling)
3. Hafta 3: Veri Taban Tablolarnn Normalletirilmesi, leri Veri Modelleme (Database Table Normalization, Advanced Data Modeling)
4. Hafta 4: SQL Uygulamalar (SELECT, INSERT, UPDATE, DELETE) (SQL Applications)
5. Hafta 5: SQL Uygulamalar (WHERE, GROUP BY, HAVING) (SQL Applications)
6. Hafta 6: SQL Uygulamalar (JOIN) (SQL Applications)
7. Hafta 7: Durum Ãalmas (Case Study)
8. Hafta 8: Veri Taban Tasarm (Database Design)