Database Management System from scratch - Part 2

BY
Udemy

Learn the advanced concepts and methodologies used in data management systems in the field of computer science.

Mode

Online

Fees

₹ 3499

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The technology that is being used to administer databases and this software is called a database management system. A database management system (DBMS) offers an interface to carry out several functions, including database design, data storage, data upgrading, table manufacturing, and database security and protection. Vignesh Sekar, a software engineer, and computer science instructor, designed the Database Management System from Scratch - Part 2 certification course, which is made available by Udemy.

Database Management System from scratch - Part 2 online classes are intended for individuals who are searching for a thorough learning program to enable them to get an understanding of the methods and strategies for managing databases utilizing database management systems. Database Management System from scratch - Part 2 online training includes 9 hours of video-based resources along with articles that cover topics like database normalization, database decomposition, relational algebra, JOIN operations and much more to clear the exams like GATE, ISRO, and PGEE.

The highlights

  • Certificate of completion
  • Self-paced course
  • 9 hours of pre-recorded video content
  • 1 article
  • Learning resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 3,499
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Computer skills Database management

After completing the Database Management System from scratch - Part 2 online certification, individuals will be introduced to the core functionalities of the database management systems for database management operations in the computer science field. Individuals will explore the techniques used in database normalization and decomposition. Individuals will become familiar with Boyce Codd Normal Form and its capabilities. Additionally, individuals will learn how to use relational algebra and JOIN operations.

The syllabus

Introduction to Decomposition

  • Closure of Functional Dependency Set
  • Rough Idea of Normalization
  • Lossless Decomposition
  • Lossless Decomposition Continued
  • Problem on Lossless Decomposition
  • Attribute Preserving Decomposition
  • Functional Dependency Preserving Decomposition

Problems on Lossless, Attribute Preserving and FD Preserving Decomposition

  • Problem 1
  • Problem 2
  • Problem 3
  • Problem 4

First Normal Form

  • First Normal Form Explained
  • Problem to illustrate First Normal Form

Second Normal Form

  • Second Normal Form Explained
  • Conversion of a relation to Second Normal Form
  • Problem 1
  • Problem 2
  • Problem 2 continued
  • Advantage of following Lossless Decomposition
  • Other Formal Definitions of Second Normal Form

Third Normal Form

  • Third Normal Form Explained
  • Another way of looking at third normal form
  • Problem 1
  • Problem 2
  • Problem 3

Boyce Codd Normal Form (BCNF)

  • BCNF Explained
  • Problem 1
  • Problem 2
  • Problem 3
  • Important Result
  • Problem 4
  • Problem 5
  • Problem 6
  • Problem 6 continued
  • Problem 7
  • Problem 8

Operations of Relational Algebra

  • Introduction to Relational Algebra
  • Selection Operation
  • More points on Selection
  • Projection Operation
  • More points on Projection
  • Rename Operation
  • Union Operation
  • Intersection Operation
  • Set Difference Operation

Joins

  • Cartesian Product
  • Join Operation
  • Important Points to note
  • Natural Join
  • Cartesian Product vs Join vs Natural Join
  • Quick Summary
  • Left Outer Join and Right Outer Join
  • Full Outer Join
  • Inner Join vs Left Outer Join vs Right Outer Join vs Full Outer Join
  • Minimum and Maximum number of tuples possible

Problems on Relational Algebra

  • Problem 1
  • Problem 2
  • Problem 3
  • Problem 4
  • Problem 4 explained with example
  • Problem 5
  • Problem 5 explained with example
  • Problem 6
  • Problem 7
  • Problem 8
  • Problem 9

Bonus : How to proceed further

  • Bonus : How to proceed further

Instructors

Mr Vignesh Sekar

Mr Vignesh Sekar
Software Engineer
Freelancer

Other Bachelors

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books