|Different Between Data, Information and Metadata|
|File System vs Database System|
|Table, Row, Record, Tuple concepts in Database|
|How to download and install MS SQL and Create Db|
|Component of Database environment|
|Three level Architecture|
|What is mapping and levels of mapping|
|Functions of DBMS|
|Basic Concept of Entity Relationship model|
|General concepts of relationship and ER-Diagram|
|Entity and Entity Set in DBMS|
|Standard Symbols of ER-Diagram|
|Binary Relationship in DBMS|
|What is cardinality in database|
|Converting Entity Types into Tables|
|What is key? Types of Keys in DBMS|
|Creating a database with tables in MS SQL|
|Implementing primary key and foreign key|
|Semantic objects Models Concepts|
|Normalization and Database anomalies|
|First Normal Form in Database|
|2nd normal form and concept of dependencies|
|3rd normal form and transitive dependency|
|Boyce-Codd Normal form - Special form of 3rd normal form|
|4th Normal Form|
|Projection join normal form | 5th normal form|
Database management system is one of the most important subjects in the field of computing and information technology. No Matter you chose which sub field of IT or Computer Science database will remain the main and important part of any field. it is important to get the core concepts of database management system - Our this free course will help you in getting all the core concepts of DBMS to make your strong conceptual base.
You can use these concepts with any database management system MS Sql Server, MySQL or Oracle.
In case if you need certification in this course after completing the course you can contact us through our email firstname.lastname@example.org for the certification. We will conduct a short test practical, and viva based (online) if you qualify the test we will certify you.
We will send you E-Certificate via email and your certificate will be verifiable on our site through certificate verification system. This is a paid process.