{"product_id":"9789389180626-6","title":"Database Management Systems (Engineering Reference Books)","description":"\u003cp\u003e1.Database system architecture: Data Abstraction, Data Independence, Data Definition Language (DDL), Data Manipulation Language (DML). (Chapter - 1) 2.Data models: Entity-relationship model, network model, relational and object oriented data models, integrity constraints, data manipulation operations. (Chapter - 2) 3.Relational query languages: Relational algebra, Tuple and domain relational calculus, SQL3, DDL and DML constructs, Open source and Commercial DBMS - MYSQL, ORACLE, DB2, SQL server. (Chapter - 3) 4.Relational database design: Domain and data dependency, Armstrong's axioms, Normal forms, Dependency preservation, Lossless design. (Chapter - 4) 5.Query processing and optimization: Evaluation of relational algebra expressions, Query equivalence, Join strategies, Query optimization (Chapter - 5) 6.Storage strategies: Indices, B-trees, hashing. (Chapter - 6) 7.Transaction processing: Concurrency control, ACID property, Serializability of scheduling, Locking and timestamp based schedulers, Multi-version and optimistic Concurrency Control schemes, Database recovery. (Chapter - 7) 8.Database Security: Authentication, Authorization and access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection. (Chapter - 8) 9.SQL Concepts: Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, aggregate functions, Built-in functions –numeric, date, string functions, set operations, sub-queries, correlated sub-queries, join, Exist, Any, All , view and its types., transaction control commands. (Chapter - 9) 10. PL\/SQL Concepts: Cursors, Stored Procedures, Stored Function, Database Triggers (Chapter - 10)\u003c\/p\u003e","brand":"Technical Publications","offers":[{"title":"Default Title","offer_id":46447214133419,"sku":"11698771680","price":415.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0620\/3355\/9723\/files\/9789389180626_6_c596bd31-8258-40dc-a36b-11b88c423e3c.jpg?v=1776093384","url":"https:\/\/technicalpublications.in\/products\/9789389180626-6","provider":"Technical Publications","version":"1.0","type":"link"}