This course details the basics of Microsoft SQL Server. Students will be introduced to the basics of using SQL Server.Introduction to database management systems, basic database concepts such as OLTP, OLAP, Datawarehouse, Data Mining, database management system working structure, Database creation, backup and restore operations, maintenance wizard and usage, user operations, role and authorization, replication operations, There are database management topics and applications including the automatic execution of routine operations by the database server at certain periods, the use of Job, Alert and Operator, the usage areas of table, view, stored procedure, trigger, function objects.
* It is planned as a Digital Distance Education and will be given in the Fall Semester with 100% Asynchronous and Synchronous enriched digital method and CATs V3.0 interface. It will be supported by sectoral E-Webinars.
Principle Sources
Introducing Microsoft SQL Server 2012 by Ross Mistry and Stacia Misner (Apr 7, 2012)
The Language of SQL: How to Access Data in Relational Databases by Larry Rockoff (Jun 3, 2010)
Other Sources
Microsoft ADO.NET 4 Step by Step (Step by Step (Microsoft)) by Tim Patrick (Nov 1, 2010)
Programming Microsoft ADO.NET 4 by David Sceppa (May 22, 2013)
Course Schedules
Week
Contents
Learning Methods
1. Week
Introduction to database management systems, basic database concepts such as OLTP, OLAP, Datawarehouse, Data Mining
Lectures and application, Oral Presentation, Case study, Project.
2. Week
Database design. database file types
Lectures and application, Oral Presentation, Case study, Project.
Lectures and application, Oral Presentation, Case study, Project.
4. Week
Data model, relations, keys, data types, data management, relational database properties, normalization, data models.
Lectures and application, Oral Presentation, Case study, Project.
5. Week
Database creation, backup and restore operations
Lectures and application, Oral Presentation, Case study, Project.
6. Week
Database maintenance wizard and usage
Lectures and application, Oral Presentation, Case study, Project.
7. Week
Database user operations, role and authorization
Lectures and application, Oral Presentation, Case study, Project.
8. Week
Automatic execution of routine transactions by the database server at certain periods
Lectures and application, Oral Presentation, Case study, Project.
9. Week
Automatic execution of routine transactions by the database server at certain periods
Lectures and application, Oral Presentation, Case study, Project.
10. Week
Working with database objects, table, view
Lectures and application, Oral Presentation, Case study, Project.
11. Week
Working with database objects stored procedure, trigger, function
Lectures and application, Oral Presentation, Case study, Project.
12. Week
database design and normalization
Lectures and application, Oral Presentation, Case study, Project.
13. Week
Sample database design
Lectures and application, Oral Presentation, Case study, Project.
14. Week
Replication operations between databases
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
20
Homework / Term Projects / Presentations
3
30
Final Exam
1
50
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
Basic database concepts such as OLTP, OLAP, Datawarehouse, Data Mining
LO-2
Database management system working structure, Database files and database creation
LO-3
Database backup and restore operations
LO-4
Databaase Maintenance Plan wizard and usage
LO-5
User actions, role and authorization
LO-6
Replication processes
LO-7
Performing routine operations automatically by the database server at certain periods, using Job, Alert and Operator
LO-8
Overview of database objects, usage areas of table, view, stored procedure, trigger, function objects