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
Ability to define, collect, and evaluate necessary data in the field of computer programming and effectively apply theoretical knowledge in practical applications..
PO-2
Possession of fundamental knowledge of computer systems, software, and hardware, and the ability to effectively utilize the required technologies for the profession.
PO-3
Possession of up-to-date, fundamental, and applied knowledge related to computer programming.
PO-4
Awareness of occupational health and safety, environmental consciousness, and quality processes, and the ability to apply them in the workplace.
PO-5
Ability to follow developments in information technologies and integrate innovations into the profession.
PO-6
Effectively using information technologies related to the profession (software, programs, animations, etc.).
PO-7
Acquiring the analytical thinking skills required by computer programming, developing and executing programs with an appropriate perspective.
PO-8
Independently evaluating professional problems and issues with an analytical and critical approach and presenting solutions.
PO-9
Effectively expressing the work conducted in the field to project teams and institutions.
PO-10
Taking responsibility in the workplace, organizing employees and workflow, and providing services in accordance with quality and standards.
PO-11
Effectively presenting thoughts at the level of knowledge and skills through written and verbal communication in a clear and understandable manner.
PO-12
Valuing teamwork, contributing to the group, and collaborating effectively with colleagues.
PO-13
Ability to adapt to next-generation technologies such as artificial intelligence, big data analytics, cybersecurity, and cloud computing, and to acquire fundamental knowledge and skills in these areas.
PO-14
Being aware of career management and lifelong learning, following technological advancements, and continuously improving oneself.
PO-15
Possessing social, scientific, cultural, and ethical values in the collection, implementation, and dissemination of field-related data.
PO-16
Possession of foreign language skills sufficient to follow developments in the field and communicate at an international level.
PO-17
Emphasizing effective communication in the field and using the Turkish language accurately.
PO-18
Ability to adopt and promote workplace safety, health, and environmental awareness.
PO-19
Ability to objectively evaluate the performance of team members and provide accurate information to management.
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.
