Certificate Course in DBMS with SQL
Course Code : ICTA 0056
Duration : 6 months
Eligibility : Class XII+ and Dit
- Basic concepts of DBMS ( introduction, what is Database, Types of database, what is RDBMS, DBMS Vs RDBMS, DBMS Vs file system, DBMS architecture, three schema, architecture,data module,data model schema,data independence, DBMS language,ACID propertiesin DBMS.)
- Data Modeling.
- Er model concept notation for ER Diagram.
- Normalisation.
- Relational Algebra.
- SQL query (Create, select, insert, update, delete,alter, sorting,where, clause, pattern, group by having).