CBSE Class 12 Informatics Practices - Python and SQL

About the Course

• Prepare the students of CBSE Class 12 Informatics Practices (Subject Code - 065) Python Programming.
• Covers basics of Python concepts from Class 11 as well.
• Regular Tests and Assignments and Grades will be provided through UrbanPro Platform.

Course Content

Essential Python (10 Hours)

• Basic constructs of a program using Python programming language — program structure, identifiers, variables, flow of control, advanced data types like Lists and Dictionaries.
• Handling data using specialised Python library called NumPy — concept of single and multi-dimensional Array.

Database & SQL (05 Hours)

• Concepts of data, database, and relational database management system using MySQL.
• Structured query language — data definition, data manipulation and data querying.
• SQL Queries: Querying database using the Structured Query Language by applying SQL functions including aggregate functions.

Python for Data Handling & Visualization (15 Hours)

Data Handling:

• The popular Python library called Pandas has been introduced.
• The important data structures of Pandas – Series and DataFrame have been covered in details
• Basic data handling and data analysis using Pandas.

Data Visualisation:

• The Pandas library called Pyplot.
• Demonstrates how to generate high quality graphs and charts from Python using the Pyplot tool.