Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • Learning Materials
  • Recommended Readings
  • Supplementary Readings

Was this helpful?

Database Management System and SQL

This is a tutorial series on Database Management System (DBMS) and Structured Query Language (SQL) published via GitBook.

Learning Materials

Recommended Readings

  • Database System Concepts, Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Seventh Edition, 2019, McGraw-Hill

  • Fundamentals of Database Systems, Ramez Elmasri, and Shamkant Navathe, Seventh Edition, 2016, Addison-Wesley

  • An Introduction to Database Systems, C. j. Date, Eighth Edition, 2004, Pearson

Supplementary Readings

  • Introduction to Database Management System, Atul Kahate, 2004, Pearson

  • Introduction to Database Management System, Aditya Mittal, and Satinder Bal Gupta, Second Edition, 2017, University Science Press

  • Concepts of Database Management System, Shefali Naik, 2014, Pearson

NextIntroduction to Database

Last updated 6 months ago

Was this helpful?