Database Design, Relational Algebra, Calculus and Querying
In current business world, Database plays a vital role in managing the information of any environment. Day by Day data grows enormously for all the environments. At the same time, it is necessary to decide what are all the data required in the future for the environment. In this regard, it is essential for each and every environment to maintain a Database Management System in order to maintain their own databases. The Database Management System is a computerized system allows the users to create and manage a database. A Database Management System enables the user to define, construct, manipulate and share databases among several users and applications The Database management system has various advantage over traditional file processing approach such as Single repository maintains data, User access through queries, transactions and application programs, structure of data files is stored in the DBMS catalog separately from the access programs. The Database Management System further explored as Relational Database Management System. Here Data is viewed as existing in two dimensional tables known as relations. Various Database Management System technologies are used to perform operations on databases. In our course, Structured Query Language (SQL) will be explored to perform the operations in database as it is more popular in the Database world.
What you’ll learn
- Understand the fundamentals of Database Management Systems, schema and languages.
- Conceive the database design process through Entity Relational model and Relational Model.
- Understand the fundamentals of Relational algebra, calculus and query processing.
- Familiarize the queries using Structured Query Language (SQL).
Course Content
- Introduction to Database Management System –> 1 lecture • 9min.
- Characteristics of Database Management System –> 1 lecture • 11min.
- Actors and Workers –> 1 lecture • 6min.
- Types of Database Model –> 1 lecture • 10min.
- Three Schema Architecture –> 1 lecture • 9min.
- Key and Non Key Attributes –> 1 lecture • 10min.
- Types of Data modelling –> 1 lecture • 10min.
- Phases of Database Design –> 1 lecture • 7min.
- ER MODEL Notations Part 1 –> 1 lecture • 6min.
- ER MODEL Notations Part 2 –> 1 lecture • 7min.
- ER MODEL Notations Part 3 –> 1 lecture • 5min.
- ER MODEL Notations Part 4 –> 1 lecture • 7min.
- Relational Model Notation –> 1 lecture • 7min.
- Relational Algebra Part 1 –> 1 lecture • 11min.
- Relational Algebra Part 2 –> 1 lecture • 10min.
- Relational Calculus –> 1 lecture • 15min.
- Aggregate functions in SQL –> 1 lecture • 11min.
- Stored Procedures Part 1 –> 1 lecture • 10min.
- Stored Procedures Part 2 –> 1 lecture • 7min.
- Stored Procedures Part 3 –> 1 lecture • 9min.
- sql introduction –> 1 lecture • 2min.
- DDL Part 1 –> 1 lecture • 7min.
- DDL Part 2 –> 1 lecture • 9min.
- DDL Part 3 –> 1 lecture • 3min.
- DML Part 1 –> 1 lecture • 10min.
- DML Part 2 –> 1 lecture • 6min.
- DQL –> 1 lecture • 7min.
- ALTER Query Processing –> 1 lecture • 12min.
- add drop rename Query Processing –> 1 lecture • 10min.
- compound search conditions –> 1 lecture • 9min.
- compound search conditions part 2 –> 1 lecture • 7min.
- Null and Not Null Query Processing –> 1 lecture • 6min.
- SQL hands on Part 1 –> 1 lecture • 6min.
- SQL hands on Part 2 –> 1 lecture • 12min.
- SQL hands on Part3 –> 1 lecture • 5min.
- SQL hands on Part4 –> 1 lecture • 5min.
- SQL hands on Part5 –> 1 lecture • 5min.
- SQL hands on Part6 –> 1 lecture • 12min.
- SQL hands on Part7 –> 1 lecture • 6min.
- SQL hands on Part8 –> 1 lecture • 7min.
- SQL hands on Part9 –> 1 lecture • 10min.
- SQL hands on Part10 –> 1 lecture • 11min.
- SQL hands on Part 11 –> 1 lecture • 8min.
- SQL hands on Part 12 –> 1 lecture • 10min.
- SQL hands on Part 13 –> 1 lecture • 11min.
- SQL Hands on Part 14 –> 1 lecture • 17min.
- SQL Hands on Part 15 –> 1 lecture • 13min.
- SQL Hands on Part 16 –> 1 lecture • 7min.
- SQL Hands on Part 17 –> 1 lecture • 6min.
- SQL Hands on Part 18 –> 1 lecture • 7min.
- SQL Hands on Part 19 –> 1 lecture • 6min.
- SQL Hands on Part 20 –> 1 lecture • 5min.
- SQL Hands on Part 21 –> 1 lecture • 5min.
- SQL Hands on Part 22 –> 1 lecture • 6min.
- SQL Hands on Part 23 –> 1 lecture • 14min.
Requirements
In current business world, Database plays a vital role in managing the information of any environment. Day by Day data grows enormously for all the environments. At the same time, it is necessary to decide what are all the data required in the future for the environment. In this regard, it is essential for each and every environment to maintain a Database Management System in order to maintain their own databases. The Database Management System is a computerized system allows the users to create and manage a database. A Database Management System enables the user to define, construct, manipulate and share databases among several users and applications The Database management system has various advantage over traditional file processing approach such as Single repository maintains data, User access through queries, transactions and application programs, structure of data files is stored in the DBMS catalog separately from the access programs. The Database Management System further explored as Relational Database Management System. Here Data is viewed as existing in two dimensional tables known as relations. Various Database Management System technologies are used to perform operations on databases. In our course, Structured Query Language (SQL) will be explored to perform the operations in database as it is more popular in the Database world.