Extra

• Table of Contents

Basic SQL Commands

Creating a Database and Tables

Creating databases and tables is the first step in organizing your data. Let's break down the commands and concepts involved.

CREATE DATABASE

The CREATE DATABASE command is used to create a new database. A database is a collection of tables and other objects that store and organize data.

Syntax:

CREATE DATABASE database_name;

Example: Imagine you’re setting up a database for a Telugu movie rental store. You would start by creating a database named TeluguMoviesDB:

CREATE DATABASE TeluguMoviesDB;

Real-life Example: Think of CREATE DATABASE as setting up a new file cabinet for organizing all the documents related to your project. Just like you would name a file cabinet, you give your database a name that reflects its purpose.

CREATE TABLE

The CREATE TABLE command is used to create a new table within a database. A table is a collection of related data held in a structured format within a database. It consists of rows and columns.

Syntax: