B COM Semester - III Relational Database Management System (Computer)
B COM Semester - III Relational Database Management System
Updated on Aug, 2025
Language - English
Office Productivity,Oracle,Database Administration
Lectures -174
Quizzes -8
Duration -15.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Goals
- Understand Database Concepts:
Develop a foundational understanding of database systems, focusing on the relational model and its advantages in business data management. - Learn Data Modeling Techniques:
Gain the ability to design Entity-Relationship (ER) models and convert them into relational schemas for effective database design. - Master SQL:
Acquire skills to write SQL queries for data definition, manipulation, and control, including complex joins, subqueries, and functions.
Prerequisites
- Basic Computer Literacy:
Students should be familiar with using computers, operating systems, and basic file management. - Introductory Programming Knowledge (Preferred but not mandatory):
Exposure to basic programming or logical thinking skills (using any language like C, Python, etc.) will be helpful for understanding query logic. - Mathematical and Analytical Skills:
Basic analytical thinking and logical reasoning abilities are essential for understanding data structures and query operations.
Curriculum
Check out the detailed breakdown of what’s inside the course
BASIC CONCEPTS
37 Lectures
-
DBMS - Course Overview
03:46
03:46
-
DBMS - Introduction
02:53
02:53
-
DBMS - Database System Applications
03:14
03:14
-
DBMS - Database System Versus File System
09:46
09:46
-
DBMS - Data Abstraction
04:12
04:12
-
DBMS - Instances and Schemas
04:52
04:52
-
DBMS - Database Users and User Interfaces
03:47
03:47
-
DBMS - Database Administrator
04:27
04:27
-
DBMS - Data Models
08:22
08:22
-
DBMS - Database Languages
05:05
05:05
-
DBMS - Database System Structure
07:50
07:50
-
DBMS - Entity and Entity Set
04:27
04:27
-
DBMS - Attribute and Domain
06:49
06:49
-
DBMS - Keys Super, Candidate, Primary, Alternate
09:13
09:13
-
DBMS - Keys Foreign, Partial, Secondary
10:00
10:00
-
DBMS - Keys Unique, Surrogate, Composite
07:01
07:01
-
DBMS - Mapping Cardinalities
03:16
03:16
-
DBMS - Relationship and Relationship Sets
10:07
10:07
-
DBMS - Entity Relationship Diagram
05:15
05:15
-
DBMS - Symbols in ER-Diagram
03:38
03:38
-
DBMS - Mapping Cardinalities in ER-Diagram
05:59
05:59
-
DBMS - ER-Diagram With Role-Indicators
03:02
03:02
-
DBMS - ER-Diagram With Ternary Relationship
02:24
02:24
-
DBMS - Weak Entity Set With Total Participation
06:55
06:55
-
DBMS - Specialization and Generalization
05:14
05:14
-
DBMS - ER-Diagram With Aggregation
04:18
04:18
-
DBMS - ER-Diagram With Existence Dependency
04:32
04:32
-
DBMS - Forming Schemas From ER-Diagram
11:09
11:09
-
DBMS - Case Study on Banking System
07:40
07:40
-
DBMS - Question Solve on ER-Diagram - 1
02:14
02:14
-
DBMS - Question Solve on ER-Diagram - 2
02:02
02:02
-
DBMS - Question Solve on ER-Diagram - 3
02:05
02:05
-
DBMS - Question Solve on ER-Diagram - 4
03:16
03:16
-
Quiz
-
Quiz 2
-
Reading on Basic Concepts
DATABASE INTEGRITY AND NORMALISATION
41 Lectures
STRUCTURES QUERY LANGUAGE (SQL)
72 Lectures
TRANSACTIONS AND CONCURRENCY MANAGEMENT
28 Lectures
DISTRIBUTED AND CLIENT SERVER DATABASES
14 Lectures
Instructor Details
Tutorialspoint
Simple and Easy Learning
Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.
The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.
40 million readers read 100 million pages every month
Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!
We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now