Skip to content
VJ Classes

One place to learn science, commerce, arts, computers and life skills

database

A database stores data in an organised way so that it can be searched, updated and protected. SQL, the Structured Query Language, is the standard way to talk to relational databases: to create tables, add records, ask questions and prepare reports. MySQL, PostgreSQL, SQL Server, Oracle and SQLite all use their own versions of it.

In India, almost every system that holds records depends on a database: school results, bank accounts, railway bookings, shop billing and online stores. SQL is part of school computer science and of nearly every computing degree, which makes it one of the most useful skills to learn early.

What you will study

  • What a database is, and why plain files are not enough
  • Tables, rows, columns, keys and relationships
  • Database design: ER diagrams and normalisation
  • SQL basics: CREATE, INSERT, SELECT, UPDATE and DELETE
  • Filtering, sorting, grouping and aggregate functions
  • Joins and subqueries
  • Constraints, views, indexes and transactions
  • Backup, user permissions and a first look at NoSQL databases

Where it helps

  • School: CBSE Computer Science and Informatics Practices both teach databases and SQL in the senior classes, with MySQL as the usual tool.
  • College: BCA, MCA, B.Sc Computer Science and B.Tech courses have a database management paper with an SQL lab.
  • Exams: GATE Computer Science and UGC NET Computer Science include the relational model, normalisation, SQL and transactions.
  • Jobs: back-end developers, data analysts, testers and report writers use SQL almost every day.
  • Freelancing: SQL helps with website back ends, report building and organising records for small businesses.

How to study it well

  • Install a free database such as MySQL or SQLite and run every query yourself.
  • Create a small realistic database, such as students and courses or shop sales, and ask it twenty different questions in SQL.
  • Before writing a join, sketch the two tables and mark the matching column.
  • Learn normalisation by fixing a messy table step by step, not by memorising the definitions.

Common questions

Is SQL a programming language? It is a query language. You describe the data you want and the database works out how to fetch it. It does not replace a general programming language, but it works beside one.

Which database should I start with? Any of the popular ones is fine, because the core of SQL is much the same everywhere. MySQL and SQLite are easy to install and are used in many courses.

Related subjects

Courses in Databases & SQL

Databases & SQL By Vinu Jaglan

Databases and SQL: Design and Queries

9 lessons Beginner 1 hr 44 min

Free practice tests