logo

Dr. Fırat YÜCEL
Akdeniz Üniversitesi Rektörlüğü
Enformatik Bölüm Başkanlığı

 
 
 
» Lisans > IE220 Introduction to Database Systems

Course Code and Name IE220 Introduction to Database Systems
Credits 2+0
Short Content Basic database concepts, relational model, design of database, queries in SQL
Contents
-Week 1: Introduction to databases
-Week 2: Basic concepts and general architecture of databases
-Week 3: Relational data model
-Week 4: Database design and normalization
-Week 5: Data modelling with ER Model
-Week 6: SQL (Structural Query Language): Introduction, Features of Microsoft SQL Server Management Studio
-Week 7: SQL: Creating database objects, Data types, Basic queries

Midterm Exam

-Week 8: SQL: Select-From-Where query statements between related tables, Query practice lab.
-Week 9: SQL: Alias, Undetermined query statements, String searcing in a database, Query practice lab.
-Week 10: SQL: Arithmetical & Logical operations in SQL, Between operator, Ordering, Query practice lab.
-Week 11: SQL: Basic Statistical Processing in SQL (Count, Avg, Sum), Query practice lab.
-Week 12: SQL: Processing on Records (Insert, Update, Delete), Query practice lab.
-Week 13: SQL: Complex SQL Queries (Grouping, Having), Queries with open-value sets, Query practice lab.
-Week 14: SQL: Nested Queries, Inner/Outer Joins, Query practice lab.
-Week 15: Evaluation of Database Projects
Evaluation

Midterm Exam (30%): Theoric
Project (20%): Ms Access 2016 database application
Final Exam (50%): Practical on Ms Access
2016

Attandance : 70% of classes

Books
& References

1) Book: Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed., 2010.

2) Weeks 1-2: Lecture Presentation (.pdf) (23/04/2019)

3) Week 3: Lecture Presentation (.pdf) (23/04/2019)

4) Week 4: Lecture Presentation (.pdf) (23/04/2019)

5) Week 5: Lecture Presentation (.pdf) (23/04/2019)

6) Weeks 6-8: Lecture Presentation (.pdf) (23/04/2019)

7) Week 9: Lab. Practice #1 (.pdf) (23/04/2019)

8) Weeks 10-12: Lecture Presentation (.pdf) (08/05/2019)

9) Week 11: Lab. Practice #2 (.pdf) (08/05/2019)

10) Weeks 13-14: Lecture Presentation (.pdf) (08/05/2019)

11) Semester Projects List (.pdf) (02/05/2019)

12) Semester Projects Report Template (.docx) (02/05/2019)

13) Download SQL Server Express 2017

14) Download SSMS 17.9.1

15) Download Microsoft Northwind Sample Database

16) Explanation of Microsoft Northwind Sample Database

 

 
 
Her hakkı saklıdır ve Fırat Yücel'e aittir. 2017 ©