|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction of Database Management System And Designing Relational Database.
|
K1 - Sql Server Process
|
|
2
|
Creating Database Tables and Basic Sql Commands
|
K1 - Sql Server Process
|
|
3
|
Using Database Library in Visual Studio 2019 and Creating Connection Objects
|
K1 - Sql Server and ADO.NET
|
|
4
|
DatagridView Object Properties and Methods
|
K1 - Using DatagridView Object
|
|
5
|
Creating and Using Datatable, Dataset and DataReader Objects
|
K1 - Using Data Objects In Visual Studio
|
|
6
|
Using Basic Sql Commands on Form Applications
|
K1 - Using SQL on Visual Studio
|
|
7
|
Usıng Advanced Sql Command on Form Applications
|
K1 - Using SQL on Visual Studio
|
|
8
|
İnsert, Edit, Delete operations on Relational Database with Forms Part One
|
K1 - Using Insert, Edit, Delete Commands on Visual Studio
|
|
9
|
İnsert, Edit, Delete operations on Relational Database with Forms Part Two
|
K1 - Using Insert, Edit, Delete Commands on Visual Studio
|
|
10
|
Using Language Integrated Query
|
K1 - LINQ
|
|
11
|
Creating And Using Reporting Objects and Functions
|
K1 - Using ReportViewer Object
|
|
12
|
Exception Handling On Forms and Databases
|
K1 - Exception Handling
|
|
13
|
Using Exception Handling Classes
|
K1 - Exception Handling
|
|
14
|
Creating Setup Project and Publishing
|
K1 - Creating Setup Project Files
|
|
Prerequisites
|
-
|
|
Language of Instruction
|
Turkish
|
|
Responsible
|
Lecturer İsmail KARAMAN
|
|
Instructors
|
-
|
|
Assistants
|
-
|
|
Resources
|
K1 - Lecture Notes
|
|
Supplementary Book
|
YK1 - Using C# 4.0 With Visual Studio
YK2 - www.msdn.com
|
|
Goals
|
The goals of this lesson, gaining experience and communicating between Visual programming Languages and Databases, preparing Setup Projects to students
|
|
Content
|
Introduction of Database Management System And Designing Relational Database, Creating Database Tables and Basic Sql Commands, Using Database Library in Visual Studio 2019 and Creating Connection Objects, DatagridView Object Properties and Methods, Creating and Using Datatable, Dataset and DataReader Objects, Using Basic Sql Commands on Form Applications, Usıng Advanced Sql Command on Form Applications, İnsert, Edit, Delete operations on Relational Database with Forms, Using Language Integrated Query, Creating And Using Reporting Objects and Functions, Exception Handling On Forms and Databases, Creating Setup Project and Publishing.
|
|
Program Learning Outcomes |
Level of Contribution |
|
1
|
Knows the basic concepts in the field of computer programmıng and takes place in the computer industry as a qualified intermediate staff.
|
-
|
|
2
|
Are involved in the planning and designing of software.
|
4
|
|
3
|
In the software sector, performs non-managerial tasks within the group.
|
4
|
|
4
|
Takes responsibility in software installation, testing and acceptance
|
3
|
|
5
|
Beware of data security and storage measures.
|
-
|
|
6
|
Uses and establishes basic software like word processor, spreadsheet, presentation, database, a graphical design programs.
|
-
|
|
7
|
Detects and solves the problems encountered in computer software and hardware failures.
|
-
|
|
8
|
Uses and manages the personal and network systems.
|
-
|
|
9
|
Able to do effective search and exploration in the internet and prepares web sites.
|
-
|
|
10
|
Takes responsibility in exploration costs.
|
-
|
|
11
|
Takes place in the works related to hardware supply and installation.
|
-
|
|
12
|
Beware of health and safety regulations..
|
-
|
|
13
|
Knows the basic concepts in the field of human relations and entrepreneurship, service concepts.
|
-
|
|
14
|
Gain the ability to think analytically. Applies the standards and regulations to techniques given in detail.
|
4
|
|
15
|
Gains the habit of being open to criticism. Contributes to the country`s economy by using their knowledge and skills related to the field.
|
4
|