|
Week
|
Topics
|
Study Metarials
|
|
1
|
Introduction to SQL language and creating databases. The need for the database. Constraints.
|
K1:Unit 1
|
|
2
|
Introduction to SQL language and creating databases. The need for the database. Constraints.
|
K1:Unit 1
|
|
3
|
Introduction to SQL language and creating databases (Create database, create table, Alter command)
|
K1:Unit 1
|
|
4
|
Simple SQL sentences. Select clauses.
|
K1:Unit 2
|
|
5
|
Simple SQL sentences. Sql Operators.
|
K1:Unit 2
|
|
6
|
Simple SQL sentences. Sql Operators.
|
K1:Unit 2
|
|
7
|
Simple SQL sentences. Sql Operators.
|
K1:Unit 3
|
|
8
|
Simple SQL sentences. Sql Operators.
|
K1:Unit 3
|
|
9
|
Simple SQL sentences
|
K1:Unit 3
|
|
10
|
Simple SQL sentences
|
K1:Unit 4
|
|
11
|
Simple Sql Sentences
|
K1:Unit 4
|
|
12
|
Advanced SQL sentences
|
K1:Unit 5
|
|
13
|
Advanced SQL sentences
|
K1:Unit 6
|
|
14
|
Advanced SQL sentences
|
K1:Unit 6
|
|
Prerequisites
|
No
|
|
Language of Instruction
|
Turkish
|
|
Responsible
|
İnstructor Bekir GÜLDİBİ
|
|
Instructors
|
-
|
|
Assistants
|
-
|
|
Resources
|
Süleyman UZUNKÖPRÜ, SQL Server 2014 Kodlab Press.
|
|
Supplementary Book
|
www.w3scholl.com
udemy.com
btakademi.gov.tr
sqltutorial.org
|
|
Goals
|
Install,test,enter data,query and analize the installed DBMS to use in Web and stand alone applications.
|
|
Content
|
Installs an uptodate DBMS system. Runs the system, creates a database, tests the database, enters data, writes queries, runs the queries, analizes and reports the results to upper committee.
|
|
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.
|
4
|
|
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
|
2
|
|
5
|
Beware of data security and storage measures.
|
4
|
|
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.
|
3
|
|
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.
|
-
|
|
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
|