Scribd
Upload
2 views2 pages

Class12 SQL and Python Interface

Uploaded by

Amina zakeer
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
2 views2 pages

Class12 SQL and Python Interface

Uploaded by

Amina zakeer
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

Class 12 Computer Science

SQL and Interface with SQL using Python

Database Concepts
Database, Table, Record, Field, Primary Key, Candidate Key.

SQL Basics
DDL, DML, DCL, TCL commands and their uses.

CREATE TABLE
Syntax and examples with data types.

INSERT, UPDATE, DELETE


Adding, modifying and removing records.

SELECT Queries
WHERE, ORDER BY, DISTINCT, LIMIT, BETWEEN, IN.

Aggregate Functions
COUNT(), SUM(), AVG(), MIN(), MAX().

SQL Clauses
GROUP BY, HAVING and ORDER BY.

Interface Python with SQL


Using [Link] module.

Connecting to Database
import [Link]
conn=[Link](...)

Executing Queries
[Link](), fetchone(), fetchall().

Insert Data using Python


Parameterized queries and commit().

Display Data using Python


Reading records from MySQL tables.
Important Viva Questions
Common CBSE practical and theory questions.

Thank You
Class 12 CS Revision Notes

You might also like