Introduction to Databases

Course work provides an in depth knowledge of the most important aspects of database systems. Students will learn how database plays a vital role in the effective management of information. Course concepts include database design, languages, implementation, distributed database, query processing and more.

Knowledge 

• Know the advantages of Database System
• Know the basic features of SQL
• Know recovery techniques for database systems

Core Competency: Develop the capability to design a database

1. Understand the various types of database management systems
2. Explain the steps involved in designing the database system
3. Understand the aim of designing a database

Core Competency: The ability to explain the steps involved in query processing

1. Using various algorithms for implementing relational algebra operations
2. Using different types of query optimization techniques
3. Evaluating the expressions containing multiple operations

Skill 

Be able to build their own database using key concepts from subject their own website using hard and soft skills learned in course

• Knowing the process in database design
• Using query processing and optimization
• Knowing retrieval techniques to extract information from unstructured textual data

Core Competency: Develop the capability to data mine

1. The ability to differentiate between data warehouse and OLTP systems
2. Know the entire process of getting data into data warehouse
3. Explain the process of knowledge discovery in base

Core Competency: The ability to recover data regardless of any type of system failure

1. Know the various types of failures that can occur in a system
2. Understand the two categories of recovery techniques
3. Know the process of checkpointing

   Introduction to database systems, ISBN: 9788131731925 (2010)

Method of Evaluation 

Teaching Method