Database Administration - Syllabus

Analysis and Synthesis Model of Compilation, including different sub-phases within analysis and synthesis phases.

Basic concepts related to Compiler, including interpreter, simple One-Pass Compiler, preprocessor, macros, symbol table, and error handler.

Institutional infrastructural preparedness refers to the readiness of government agencies and institutions to adopt and implement e-governance systems.

Human infrastructural preparedness involves the development of skills and capacities of public officials and citizens to effectively use e-governance systems.

Technological infrastructural preparedness refers to the availability and quality of technology infrastructure, including computers, internet connectivity, and other digital tools.

This topic analyzes the current state of E-Governance globally, including its growth, adoption, and impact on governments and societies.

The process of breaking the source code into a series of tokens. It involves the specification and recognition of tokens, input buffer, and finite automata relevant to compiler construction.

The process of analyzing the syntax of the source code. It involves basic parsing techniques, problem of left recursion, left factoring, ambiguous grammar, top-down parsing, bottom-up parsing, and LR parsing.

Function of Symbol Table, Information provided by Symbol Table, Attributes and Data Structures for symbol table

Managing storage during runtime

Failure Classification, The Storage Hierarchy, Transaction Model, Log-Based recovery, Buffer Management, Checkpoints, Shadow Paging, Failure with Loss of Non-volatile Storage.

Querying role information involves retrieving information about roles and their associated privileges. This topic covers the different methods for querying role information.

Database security and auditing involve ensuring the confidentiality, integrity, and availability of database data. This topic covers the different security measures and auditing techniques.

Creating and managing databases involves designing, creating, and modifying database structures. This topic covers the basics of database creation and management.

Creating and managing tables involves designing, creating, and modifying table structures. This topic covers the basics of table creation and management.

Creating and managing indexes involves designing, creating, and modifying indexes to improve query performance. This topic covers the basics of index creation and management.

Creating and managing triggers involves designing, creating, and modifying triggers to automate database operations. This topic covers the basics of trigger creation and management.

Creating and managing views involves designing, creating, and modifying views to simplify complex queries. This topic covers the basics of view creation and management.

Creating and managing stored procedures involves designing, creating, and modifying stored procedures to encapsulate complex logic. This topic covers the basics of stored procedure creation and management.

Advanced stored procedures involve using advanced techniques such as error handling and debugging to create robust stored procedures. This topic covers advanced stored procedure concepts.

Analysis and integration services involve using database tools and technologies to analyze and integrate data from multiple sources. This topic covers the basics of analysis and integration services.

This topic covers the generation of intermediate code, including high-level and low-level representations, syntax trees, and three-address code. It also discusses the generation of intermediate code for declarations, assignments, control flow, boolean expressions, and procedure calls.

This topic explores the factors affecting code generation, including target language, basic blocks, and flow graphs. It also covers dynamic programming code-generation algorithms.

This topic discusses the need and criteria for code optimization, as well as basic optimization techniques to improve code efficiency.

This topic presents case studies of compilers, including C and C++ compilers, to illustrate the application of compiler design principles.

Validating the effectiveness of a backup and recovery strategy through regular testing and simulation exercises.

A recovery technique that involves creating a temporary instance of a database to minimize downtime and data loss.

Techniques and strategies for recovering from non-critical data losses, including data reconstruction and repair.

This topic covers the fundamental concepts and principles of Virtual Reality (VR), including its history, applications, and key technologies.

This topic provides an overview of the basics of animation, including its history, types, and key concepts, as well as its applications in computer graphics.

Automatic storage management is a feature that automates the management of database storage, including disk space allocation and deallocation. This topic covers the concepts and best practices of automatic storage management.

RMAN is a utility provided by Oracle for backing up, restoring, and recovering databases. This topic covers the features, benefits, and usage of RMAN in database administration.

Overview of tuning methodology and general tuning concepts, including AADM (Automatic Database Diagnostic Monitor) and SQL Tuning Advisor.

Policy types, selective columns, and column masking in Virtual Private Database.