Скачать или смотреть Class-XII COMPUTER SCIENCE | SQL in Python Programming Language| NCERT | CBSE | Data Structure

Class-XII COMPUTER SCIENCE SQL in Python Programming Language according to NCERT Study Material in English by Proper Guidance.

Structured Query Language (SQL) , Installing MySQL
Data Types and Constraints in MySQL:--
1 Data type of Attribute
2 Constraints
Commonly used SQL Constraints
SQL for Data Definition
CREATE Database
2 CREATE Table
3 Describe Table
4 ALTER Table :--
A) Add primary key to a relation
B) Add foreign key to a relation
(C) Add constraint UNIQUE to an existing attribute
D) Add an attribute to an existing table
(E) Modify datatype of an attribute
F) Modify constraint of an attribute
G) Add default value to an attribute
(H) Remove an attribute
(I) Remove primary key from the table

DROP Statement
SQL for Data Manipulation
INSERTION of Records
SQL for Data Query:--
1 SELECT Statement
2 QUERYING using Database OFFICE
(A) Retrieve selected columns
(B) Renaming of columns
(C) Distinct Clause
D) WHERE Clause
E) Membership operator IN
(F) ORDER BY Clause
(G) Handling NULL Values
H) Substring pattern matching

Data Updation and Deletion
Functions in SQL
Single Row Functions, Math Functions, String Functions, Date and Time Functions, Aggregate Functions ,GROUP BY Clause in SQL, Operations on Relation,1 UNION,2 INTERSECT (∩),3 MINUS ,4 Cartesian Product (X), Using Two Relations in a Query, Cartesian product on two tables, JOIN on two tables.


Introduction to Data. Definition of Data. APPLICATIONS OF Data. Operations on Data. Concept of data and information in python data structure.
Understanding Data in python
Importance of Data
Types of Data
Structured Data and Unstructured Data
Data Collection
Data Storage
Data Processing
Statistical Techniques for Data Processing
Measures of Central Tendency : Mean, Median and Mode
Measures of Variability : Range and Standard deviation
File System.
Limitations of a File System :---
A) Difficulty in Access
B) Data Redundancy
C) Data Inconsistency
D) Data Isolation
E) Data Dependence
(F) Controlled Data Sharing
Database Management System: e MySQL, Oracle, PostgreSQL,
SQL Server, Microsoft Access, MongoDB.
File System to DBMS.
Key Concepts in DBMS :--
A) Database Schema
B) Data Constraint
C) Meta-data or Data Dictionary
(D) Database Instance
(E) Query
F) Data Manipulation
G) Database Engine

Relational Data Model:--
i) ATTRIBUTE
ii) TUPLE
iii) DOMAIN
iv) DEGREE
v) CARDINALITY
Important Properties of a Relation
Keys in a Relational Database:-
1 Candidate Key
2 Primary Key
3 Composite Primary Key
4 Foreign Key


#datascience
#dbms
#pythontutorial