Description
Course Name: Certificate in Database Management System
Course Id: CDMS/Q1001.
Education Qualification: 12th Pass.
Duration: 90 Hrs (Equivalent to 3 months).
How You will Get Diploma Certificate:
Step 1- Select your Course for Certification.
Step 2- Click on Enroll Now.
Step 3- Proceed to Enroll Now.
Step 4- Fill Your Billing Details and Proceed to Pay.
Step 5- You Will be Redirected to Payment Gateway, Pay Course and Exam Fee by Following Options.
Card(Debit/Credit), Wallet, Paytm, Net banking, UPI and Google pay.
Step 6- After Payment You will get Study Material Login id and Password on your email id.
Step 7- After Completion of Course Study give Online Examination.
Step 8- After Online Examination you will get Diploma Certificate soft copy(Scan Copy) and Hard Copy(Original With Seal and Sign).
Step 9- After Certification you will receive Prospect Job Opportunities as per your Interest Area.
Online Examination Detail:
Duration- 60 minutes.
No. of Questions- 30. (Multiple Choice Questions).
Maximum Marks- 100, Passing Marks- 40%.
There is no negative marking in this module.
Benefits of Certification:
- Government Authorized Assessment Agency Certification.
- Certificate Valid for Lifetime.
- Lifetime Verification of Certificate.
- Free Job Assistance as per your Interest Area.
Syllabus
Introduction to Data base Management System: Introduction to data base, objectives, database system applications, purpose of data base system, view of data, relational databases, data- manipulation language.
Database Design, ER Diagram and Unified Modeling Language: Data base design, ER relationship model, ER diagram, implementation diagram, advantages of UML diagram, disadvantages of UML diagram, data base access from application programs, data base design, design process.
Relational database model: Objectives, logical view of data, relational database design, features of good relational database design, bibliography, keys, integrity rules, Atomic domain & Normalization.
Constraints, Views and SQL: Data constraints, domain constraints, triggers SQL, security and authorization in SQL, Characteristics of SQL, Advantage of SQL, SQL Literals, Types of SQL, SQL Operator, Set Operation, Data Definition Commands, data manipulation commands, database modification, data control commands, views in SQL, nested complex queries.
Transaction management and Concurrency: ACID properties, serializability and concurrency control, lock based concurrency control, time stamping methods, optimistic methods, database recovery management.
PL-SQL: Beginning with PL/ SQl, identifiers and keywords, operators, expressions, sequences, control structure, cursors and transaction, collections composite data types, procedures and functions, exceptions handling, packages, with clause and Hierarchical, retrieval, triggers.