Databases are the spine of all major applications today! Whether internet-based, financial, social, administrative or intranet applications, without databases they all are namesake! Oracle, Microsoft SQL Server, have emerged as leading commercial systems whereas MySQL, PostgreSQL have led the open-source.
While DBMSs differ profoundly, they resemble a common set of models, design paradigms and a Structured Query Language (SQL). With this course, our main intention is to cover these details.
Who is the course for?
This course is designed for learners who are:
-
beginners in this field
-
want to prepare for University examinations
-
want to prepare for placement interviews
-
software professionals who want to quick start there carrier as a Database expert
in a short time span.
What topics will this course cover?
-
Basics of DBMSs
-
Comparison of DBMS with File Based System
-
Three Level Architecture of DBMS
-
Different models of DBMS- Relational, Hierarchical, Network Data models with Data operations on them.
-
Understanding Primary, Foreign Key, Super Key, Candidate key and Artificial key
-
Designing ER Model
-
Concept of Entity, Entity Set, Strong and weak entity, Total and Partial Dependence
-
Conversion of ER Model to Tables
-
Learn Normalization from scratch.
-
Concept of Functional Dependence, Fully Functional Dependence, Transitive Dependence and Multi Value Dependence
-
Transaction Management
-
Full SQL: Creation of Tables
-
Insertion, Updation and Deletion of Data
-
Alter Table
-
Joining of Tables
-
Cartesian Product, Inner Join, Outer Join and Self Join
-
Grouping of Data in SQL
