[go: up one dir, main page]
Scribd
Upload
28 views3 pages

SQL Handwritten Notes

The document provides an overview of SQL (Structured Query Language), detailing its purpose for accessing and manipulating databases. It outlines the capabilities of SQL, including executing queries, retrieving, inserting, updating, and deleting records, as well as creating databases, tables, and stored procedures. Additionally, it introduces RDBMS (Relational Database Management System) as the foundation for SQL and modern database systems like MS SQL Server.

Uploaded by

11222737raushan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
28 views3 pages

SQL Handwritten Notes

The document provides an overview of SQL (Structured Query Language), detailing its purpose for accessing and manipulating databases. It outlines the capabilities of SQL, including executing queries, retrieving, inserting, updating, and deleting records, as well as creating databases, tables, and stored procedures. Additionally, it introduces RDBMS (Relational Database Management System) as the foundation for SQL and modern database systems like MS SQL Server.

Uploaded by

11222737raushan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Topics covered

D SQL
2 Nomenclature
3 Data Integrity
4 Data normalization
5 Data types
6 Types of SQL commands

7 DDL Data Definition Language


8 DML Data Manipulation Language
9 DOL Data Query language
10 WHERE clause

ID Operators
Compassion
Arithmetic

Bitwise
Compound
Logical
Like In Between
Introduction to SQL

SQL is a standard language for accessing


and manipulating databases

what is SQL

SQL stands for structured Query language


SQL lets you access and manipulate
databases
SQL is an ANSI American national
standards institute standard

what can SQL do


SQL can execute queries against a database
SQL can retreive data from database
SQL can insert records in a database

SQL can update records in a database


SQL can delete records from a database
Sac can create new databases

SQL can create new tables in a database

SQL can create stored procedures in


a database
SQL can create views in a Database
SQL can set permissions on tables procedures
and views

SQL is standard but there are different


versions of SQL language However to be

compliant they all support major commands

SQL
e
Create Database

I
Insert
Update
Delete
Select

SQL is not case sensitive language

what is RDBMS

RDBMS Relational Database Management


system
RDBMS is the basis for SQL and for all

modern database systems like MS SQL Server

You might also like