Database Management

Series of lecture in Database Management

Database management systems (DBMS) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational modelas represented by the SQL language. Sometimes a DBMS is loosely referred to as a ‘database’.

 Part1

part2

Lecture 2 Part 3

Lecture 2 Part 4

Lecture 2 Part 5

Lecture 2 Part 6

Lecture 2 Part 7

Lecture 2 Part 8

Lecture 2 Part 9