Here is the list of topics of DBMS that should be covered for PPSC exam Relational Database and Database Schema Keys Relational Query Operations and Relational Operators SQL Basics and SQL Data Definition SQL Queries Basic SQL Operations Set Operations Null Values Operations Aggregate Functions and Nested Subqueries 1 Aggregate Functions and Nested Subqueries 2 Modification of Database Join Expressions Views Transactions Integrity Constraints SQL Data Types and Schemas Authorizations Access SQL From a Programming Language Functions and Procedures Triggers Recursive Queries and Aggregation Features OLAP Relational Algebra Tuple Relational Calculus and Domain Relational Calculus The Entity-Relationship Model Constraints Entity-Relationship Diagrams Reduction to Relational Schemas Entity-Relationship Design Issues Extended E-R Features Querying database part-1 DDL Querying database part-2 DML Atomic Domains Normal Forms Functional-Dependency Theory Algorithms for Decomposition Multivalued Dependencies Database Design Process Application Programs and User Interfaces Web Fundamentals Servlets and JSP Application Architectures Rapid Application Development Application Performance Application Security Encryption and Its Applications Physical Storage Media Magnetic Disk and Flash Storage RAID Tertiary Storage File Organisations Organization of Records in Files Data-Dictionary Storage Database Buffer Ordered Indices Hashing Techniques Ordered Indexing and Hashing Bitmap Indices Index Definition in SQL Query Processing Selection Operation Sorting Join Operations Evaluation of Expressions Transformation of Relational Expressions Estimating Statistics of Expression Results Materialized Views Advanced Query Optimization Transaction Concept A Simple Transaction Model Storage Structure Transaction Atomicity and Durability Querying database part 3 Querying database part 4 Querying database part 5 Implementation of Isolation Levels Transactions as SQL Statements Lock-Based Protocols Deadlocks Multiple Granularity Multiversion Schemes Snapshot Isolation Insertion Deletion Predicate Reads Concurrency in Index Structures Failure Classification Recovery Buffer Management Failure with Nonvolatile Storage ARIES Lock Release and Undo Operations Remote Backup Systems
Posted on: Sat, 26 Jul 2014 12:46:10 +0000
Trending Topics
Recently Viewed Topics
© 2015