3 Review(s)

UnitUnit Outcomes (UOs)(4 to 6 UOs at Application and above level)Topics and Sub-topicsUnit - IIntroduction to Database System and SQL commands1a.Differentiate the terms : Data, Information, Records, Fields, Metadata, Data warehouse, Data dictionary.1.1Concepts and Definitions :Database and database systems and database environment.1.2Data, Information, Data Item or Fields, Records, Files, Metadata, Data dictionary and it’s components,1.3Schemas, Sub-schemas, and Instances.1b.DBMS Data types, Creating Tables (DDL), Managing Tables (DML) with SQL,1.4Data types1.5Database Language commands : Data Definition Language (DDL) : CREATE, ALTER, TRUNCATE, DROP.1.6Database Language : Data Manipulation Language (DML) : INSERT, SELECT, UPDATE, DELETE.1c.Describe & practice Transaction Control Data Control Language.1.7Transactional Control : Commit, Save point, Rollback1.8DCL Commands : Grant and Revoke. (Chapter - 1) Unit - IISQLIn built functions and Joins2a.Execute various SQL operators and Functions.2.1Operators Arithmetic, Comparison, Logical SQL functions- Single row function.i.Single row function.ii.Date functions (add-months, months-between, round, truncate).iii.Numeric Functions (abs, power, mod, round, trunc, sqrt).iv.Character Fucntions (initcap, lower, upper, ltrim, rtrim, replace, substring, instr).v.Conversion Functions (to-char, to-date, to-number).2b.Perform queries on ‘Group by’, ‘Having’ and ‘Order by’ clause.2.2Groupby, Having and Order by clause.2c.Implement ‘Joins’2.3Joins : Simple, Equi-join, Non-equi, Self-Joins, Outer-joins.2d.Perform different types of sub queries.2.4Subqueries - Multiple, Correlated.2.5Implementation of Queries using SQL Set operators : Union, union all, Intersect, Minus. (Chapter - 2)Unit - IIIDatabase Integrity Constraints & Objects3a.Describe with examples Domain Integrity and Entity Integrity constraint.3.1Domain Integrity constraints : Not null, Check.3.2Entity Integrity constraints : Unique, Primary key.3b.Describe with examples Referential Integrity constraint.3.3Referential Integrity constraints : Foreign key, referenced key, on delete cascade.3c.Database Objects3.4Views - Create, Alter, Drop views3.5Synonym : Create, Drop synonym3.6Sequences : Create, alter, Drop sequences3.7Index : Unique and composite - Create, Drop. (Chapter - 3)Unit - IVPL/ SQL andTriggers4a.Describe the fundamentals of the PL/SQL programming language.4.1Basics of PL / SQL4.1.1 Data types4.2Advantages of PL/SQL over SQL.4b.Use different Control Structures4.3Control Structures: Conditional, Iterative, Sequential4c.Write and execute PL/SQL programs in SQL*Plus.4d.Describe & Implement Concepts of exception handling.4.4Exceptions : Predefined Exceptions, User defined exceptions.4e.Implement cursor, procedure and function in Package.4.5Cursors : Static (Implicit & Explicit), Dynamic.4.6Procedures & Functions.4f.Describe the various types of triggers.4.7Fundamentals of Database Triggers.4g.Write, code, test and debug various types of triggers.4.8Creating Triggers.4.9Types of Triggers : Before, after for each row, for each statement. (Chapter - 4)Unit - VNormalization5a.Describe different Normal Forms.5.1Basics of Normalization.5b.Solve problems of normalization.5.2Normal Forms5.2.1 First Normal Form(1NF)5.2.2 Second Normal Form(2NF)5.2.3 Third Normal Form(3NF)5c.Describe advantages and disadvantages of Normalization.5.3Advantages and disadvantages of Normalization. (Chapter - 5)