This course details Microsoft SQL Server. Topics include: learning how to create and manipulate database objects. Students will be introduced to the basics of using SQL Server, indexs, functions, triggers, cursors, security, connected ve disconnected layers, transaction.
Prerequisite(s)
Corequisite(s)
Special Requisite(s)
Instructor(s)
Course Assistant(s)
Schedule
Office Hour(s)
Teaching Methods and Techniques
Principle Sources
Other Sources
Course Schedules
Week
Contents
Learning Methods
1. Week
SQL Server Basics.
Lectures and application, Oral Presentation, Case study, Project.
2. Week
Creating databases manually
Lectures and application, Oral Presentation, Case study, Project.
3. Week
Tables, relational databases, SQL and database objects, indexs, functions
Lectures and application, Oral Presentation, Case study, Project.
4. Week
Design and develop MS SQL Server databases and tables, triggers, cursors
Lectures and application, Oral Presentation, Case study, Project.
5. Week
Obtaining information from database tables, connected ve disconnected, transaction
Lectures and application, Oral Presentation, Case study, Project.
6. Week
Working with views
Lectures and application, Oral Presentation, Case study, Project.
7. Week
Databases using Transact-SQL
Lectures and application, Oral Presentation, Case study, Project.
8. Week
Transaction
Lectures and application, Oral Presentation, Case study, Project.
9. Week
Report
Lectures and application, Oral Presentation, Case study, Project.
10. Week
Examples.
Lectures and application, Oral Presentation, Case study, Project.
11. Week
Database applications.
Lectures and application, Oral Presentation, Case study, Project.
12. Week
Windows applications.
Lectures and application, Oral Presentation, Case study, Project.
13. Week
Web applications, XML.
Lectures and application, Oral Presentation, Case study, Project.
14. Week
Examples.
Lectures and application, Oral Presentation, Case study, Project.
15. Week
Final
16. Week
Final
17. Week
Final
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
30
Quizzes
6
15
Homework / Term Projects / Presentations
8
15
Final Exam
1
40
Program Outcomes
PO-1
Effectively identifying collecting and evaluating the data required for the Computer Programming field and using theoretical knowledge for creating applications.
PO-2
Being equipped with basics of computer science.
PO-3
Possessing the knowledge of all necessary software and equipment in the profession.
PO-4
Emphasizing team work, contributing to the group and operating with team chemistry.
PO-5
Effectively expressing and sharing the completed work with project group and teammates.
PO-6
Objectively evaluating the performance of employees under his/her supervision and providing objective information to the management.
PO-7
Demonstrating problem solving skills and the education he/she obtained at the program.
PO-8
Possessing the computer programming knowledge built on skills, information and competencies provided by secondary education and supperted by higher education course materials, and demonstrating the understanding of concepts in the field of computer programming.
PO-9
Acquiring the analytical thinking skills required in the field of computer programming, and creating and running programs in accordance with this analytical perspective.
PO-10
Complying with ethical values of the field of Computer Programming and carrying social responsibility.
PO-11
Developing sufficent foreign language skills to conduct the work and follow the global developments at the best level.
PO-12
Empasizing communication and using Turkish accurately in this communication.
PO-13
Ensuring the security, environment and health awareness at personal level and among his/her employees.
PO-14
Following technological innovations in software and hardware after graduation and sustaining continuous personal development.
PO-15
Claiming responsibility at his/her workplace, organizing work flow with employees and operating according to high quality work standards.
Learning Outcomes
LO-1
SQL Server Basics, indexs, functions, triggers, cursors, security, connected ve disconnected layers, transaction.
LO-2
Understanding Tables and Databases.
LO-3
Indexes and Views.
LO-4
Stored Procedures. Database Diagrams, The Query Analyzer and SQL Basics.