Database Technology - Sql Essentials For Database Building

Database Design, Relational Algebra, Calculus and Querying

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)

Requirements

Basic Computer Science Knowledge

Description

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.

Overview

Section 1: Introduction to Database Management System

Lecture 1 Introduction to Database Management System

Section 2: Characteristics of Database Management System

Lecture 2 Characteristics of Database Management System

Section 3: Actors and Workers

Lecture 3 Actors and Workers

Section 4: Types of Database Model

Lecture 4 Types of Database Model

Section 5: Three Schema Architecture

Lecture 5 Three Schema Architecture

Section 6: Key and Non Key Attributes

Lecture 6 Key and Non Key Attributes

Section 7: Types of Data modelling

Lecture 7 Types of Data modelling

Section 8: Phases of Database Design

Lecture 8 Phases of Database Design

Section 9: ER MODEL Notations Part 1

Lecture 9 ER MODEL Notations Part 1

Section 10: ER MODEL Notations Part 2

Lecture 10 ER MODEL Notations Part 2

Section 11: ER MODEL Notations Part 3

Lecture 11 ER MODEL Notations Part 3

Section 12: ER MODEL Notations Part 4

Lecture 12 ER MODEL Notations Part 4

Section 13: Relational Model Notation

Lecture 13 Relational Model Notation

Section 14: Relational Algebra Part 1

Lecture 14 Relational Algebra Part 1

Section 15: Relational Algebra Part 2

Lecture 15 Relational Algebra Part 2

Section 16: Relational Calculus

Lecture 16 Relational Calculus

Section 17: Aggregate functions in SQL

Lecture 17 Aggregate functions in SQL

Section 18: Stored Procedures Part 1

Lecture 18 Stored Procedures Part 1

Section 19: Stored Procedures Part 2

Lecture 19 Stored Procedures Part 2

Section 20: Stored Procedures Part 3

Lecture 20 Stored Procedures Part 3

Section 21: sql introduction

Lecture 21 sql introduction

Section 22: DDL Part 1

Lecture 22 DDL Part 1

Section 23: DDL Part 2

Lecture 23 DDL Part 2

Section 24: DDL Part 3

Lecture 24 DDL Part 3

Section 25: DML Part 1

Lecture 25 DML Part 1

Section 26: DML Part 2

Lecture 26 DML Part 2

Section 27: DQL

Lecture 27 DQL

Section 28: ALTER Query Processing

Lecture 28 ALTER Query Processing

Section 29: add drop rename Query Processing

Lecture 29 add drop rename Query Processing

Section 30: compound search conditions

Lecture 30 compound search conditions

Section 31: compound search conditions part 2

Lecture 31 compound search conditions

Section 32: Null and Not Null Query Processing

Lecture 32 Null and Not Null Query Processing

Section 33: SQL hands on Part 1

Lecture 33 SQL

Section 34: SQL hands on Part 2

Lecture 34 SQL

Section 35: SQL hands on Part3

Lecture 35 SQL

Section 36: SQL hands on Part4

Lecture 36 SQL

Section 37: SQL hands on Part5

Lecture 37 SQL

Section 38: SQL hands on Part6

Lecture 38 SQL

Section 39: SQL hands on Part7

Lecture 39 SQL

Section 40: SQL hands on Part8

Lecture 40 SQL

Section 41: SQL hands on Part9

Lecture 41 SQL

Section 42: SQL hands on Part10

Lecture 42 SQL

Section 43: SQL hands on Part 11

Lecture 43 SQL

Section 44: SQL hands on Part 12

Lecture 44 SQL

Section 45: SQL hands on Part 13

Lecture 45 SQL

Section 46: SQL Hands on Part 14

Lecture 46 SQL

Section 47: SQL Hands on Part 15

Lecture 47 SQL

Section 48: SQL Hands on Part 16

Lecture 48 SQL

Section 49: SQL Hands on Part 17

Lecture 49 SQL

Section 50: SQL Hands on Part 18

Lecture 50 SQL

Section 51: SQL Hands on Part 19

Lecture 51 SQL

Section 52: SQL Hands on Part 20

Lecture 52 SQL

Section 53: SQL Hands on Part 21

Lecture 53 SQL

Section 54: SQL Hands on Part 22

Lecture 54 SQL

Section 55: SQL Hands on Part 23

Lecture 55 SQL

Beginners