Detailed Notes: Interface Python with SQL Database | Computer Science for Grade 12 PDF Download

 Page 1


SQL
SQL is an acronym of Structured Query Language.It is a
standard language developed and used for accessing and
modifying relational databases.
The SQL language was originally developed at the IBM research
laboratory in San José, in connection with a project developing
a prototype for a relational database management system
called System R in the early 70s.
SQL is being used by many database management systems.
Some of them are:
?MySQL
?PostgreSQL
?Oracle
?SQLite
?Microsoft SQL Server
Page 2


SQL
SQL is an acronym of Structured Query Language.It is a
standard language developed and used for accessing and
modifying relational databases.
The SQL language was originally developed at the IBM research
laboratory in San José, in connection with a project developing
a prototype for a relational database management system
called System R in the early 70s.
SQL is being used by many database management systems.
Some of them are:
?MySQL
?PostgreSQL
?Oracle
?SQLite
?Microsoft SQL Server
Advantages of using SQL
? Interactive Language-This language can be used for
communicating with the databases and receive answers to the
complex questions in seconds.
? Multiple data views-The users can make different views of
database structure and databases for the different users.
? Portability-SQL can be used in the program in PCs, servers,
laptops, and even some of the mobile phones and even on
different dbms softwares
? No coding needed-It is very easy to manage the database
systems without any need to write the substantial amount of
code by using the standard SQL.
? Well defined standards-Long established are used by the SQL
databases that is being used by ISO and ANSI. There are no
standards adhered by the non-SQL databases.
SQL
Page 3


SQL
SQL is an acronym of Structured Query Language.It is a
standard language developed and used for accessing and
modifying relational databases.
The SQL language was originally developed at the IBM research
laboratory in San José, in connection with a project developing
a prototype for a relational database management system
called System R in the early 70s.
SQL is being used by many database management systems.
Some of them are:
?MySQL
?PostgreSQL
?Oracle
?SQLite
?Microsoft SQL Server
Advantages of using SQL
? Interactive Language-This language can be used for
communicating with the databases and receive answers to the
complex questions in seconds.
? Multiple data views-The users can make different views of
database structure and databases for the different users.
? Portability-SQL can be used in the program in PCs, servers,
laptops, and even some of the mobile phones and even on
different dbms softwares
? No coding needed-It is very easy to manage the database
systems without any need to write the substantial amount of
code by using the standard SQL.
? Well defined standards-Long established are used by the SQL
databases that is being used by ISO and ANSI. There are no
standards adhered by the non-SQL databases.
SQL
MySQL is currently the most popular open source
database software. It is a multi-user, multithreaded
database management system. MySQL is especially
popular on the web. It is one of the parts of the very
popular LAMP platform. Linux, Apache, MySQL and PHP
or WIMP platform Windows,Apache,MySQL and PHP .
MySQL AB was founded by Michael Widenius (Monty),
David Axmark and Allan Larsson in Sweden in year 1995.
SQL
Page 4


SQL
SQL is an acronym of Structured Query Language.It is a
standard language developed and used for accessing and
modifying relational databases.
The SQL language was originally developed at the IBM research
laboratory in San José, in connection with a project developing
a prototype for a relational database management system
called System R in the early 70s.
SQL is being used by many database management systems.
Some of them are:
?MySQL
?PostgreSQL
?Oracle
?SQLite
?Microsoft SQL Server
Advantages of using SQL
? Interactive Language-This language can be used for
communicating with the databases and receive answers to the
complex questions in seconds.
? Multiple data views-The users can make different views of
database structure and databases for the different users.
? Portability-SQL can be used in the program in PCs, servers,
laptops, and even some of the mobile phones and even on
different dbms softwares
? No coding needed-It is very easy to manage the database
systems without any need to write the substantial amount of
code by using the standard SQL.
? Well defined standards-Long established are used by the SQL
databases that is being used by ISO and ANSI. There are no
standards adhered by the non-SQL databases.
SQL
MySQL is currently the most popular open source
database software. It is a multi-user, multithreaded
database management system. MySQL is especially
popular on the web. It is one of the parts of the very
popular LAMP platform. Linux, Apache, MySQL and PHP
or WIMP platform Windows,Apache,MySQL and PHP .
MySQL AB was founded by Michael Widenius (Monty),
David Axmark and Allan Larsson in Sweden in year 1995.
SQL
MySQL Features
Open Source & Free of Cost:
It is Open Source and available at free of cost.
? Portability:
Small enough in size to instal and run it on any types of Hardware and
OS like Linux,MS Windows or Mac etc.
? Security :
Its Databases are secured & protected with password.
? Connectivity
Various APIs are developed to connect it with many programming
languages.
? Query Language
It supports SQL (Structured Query Language) for handling database.
SQL
Page 5


SQL
SQL is an acronym of Structured Query Language.It is a
standard language developed and used for accessing and
modifying relational databases.
The SQL language was originally developed at the IBM research
laboratory in San José, in connection with a project developing
a prototype for a relational database management system
called System R in the early 70s.
SQL is being used by many database management systems.
Some of them are:
?MySQL
?PostgreSQL
?Oracle
?SQLite
?Microsoft SQL Server
Advantages of using SQL
? Interactive Language-This language can be used for
communicating with the databases and receive answers to the
complex questions in seconds.
? Multiple data views-The users can make different views of
database structure and databases for the different users.
? Portability-SQL can be used in the program in PCs, servers,
laptops, and even some of the mobile phones and even on
different dbms softwares
? No coding needed-It is very easy to manage the database
systems without any need to write the substantial amount of
code by using the standard SQL.
? Well defined standards-Long established are used by the SQL
databases that is being used by ISO and ANSI. There are no
standards adhered by the non-SQL databases.
SQL
MySQL is currently the most popular open source
database software. It is a multi-user, multithreaded
database management system. MySQL is especially
popular on the web. It is one of the parts of the very
popular LAMP platform. Linux, Apache, MySQL and PHP
or WIMP platform Windows,Apache,MySQL and PHP .
MySQL AB was founded by Michael Widenius (Monty),
David Axmark and Allan Larsson in Sweden in year 1995.
SQL
MySQL Features
Open Source & Free of Cost:
It is Open Source and available at free of cost.
? Portability:
Small enough in size to instal and run it on any types of Hardware and
OS like Linux,MS Windows or Mac etc.
? Security :
Its Databases are secured & protected with password.
? Connectivity
Various APIs are developed to connect it with many programming
languages.
? Query Language
It supports SQL (Structured Query Language) for handling database.
SQL
Types of SQL Commands
? DDL (Data Definition Language)
To create database and table structure-commands    
like CREATE , ALTER , DROP etc.
? DML (Data Manipulation Language)
Record/rows related operations.commands like  
SELECT...., INSERT..., DELETE..., UPDATE.... etc.
? DCL (Data Control Language)
used to manipulate permissions or access rights to the  
tables. commands like GRANT , REVOKE etc.
? Transactional control Language.
Used to control the transactions.commands like    
COMMIT, ROLLBACK, SAVEPOINT etc.
SQL