Akademik Dersler - İçerik

Will be able to comprehend and evaluate the role of database management systems in information technology applications within organizations.
Effectively explains the basic concepts of databases and data models.
Explains the features of database management systems, architecture of database systems, and the role of database users.
Defines the basics of the relational data model.
Lists the database design process steps.
Will be able to design properly structured databases that match the standards based on realistic constraints and conditions.
Develops an Entity-Relationship model based on user requirements.
Converts an Entity-Relationship diagram to Relational Schema.
Explains Functional Dependency and Functional Decomposition.
Applies various Normalization techniques for database design improvement.
Will be able to comprehend how to use Structured Query Language (SQL) to define and manipulate database information.
Designs SQL queries to create database tables and make structural modifications.
Designs SQL queries to add data to the database, edit existing data, and to delete data from the database.
Effectively designs basic and advanced SQL queries to retrieve data from the database
Declares and enforces integrity constraints on a database.
Understands indexing mechanisms in databases.
Will be able to describe Relational Algebra and Relational Calculus queries.
Constructs queries with relational algebra.
Explains the basics of query evaluation mechanisms.
Will be able to explain the principle of transaction management design.
Explains the concurrency control and recovery algorithms.
Applies transaction processing mechanisms in relational databases.
Will be able to work in a group on the design, and implementation of a database system project.
Experiences how to apply the theoretical information in database management systems area into practice to model and solve an engineering problem.
Experiences how to use SQL language for constructing and utilizing a database application.
Experiences how to manage data by establishing a database connection over the current programming languages.
Experiences on how to implement an application using a database management system.