This Course is exclusively designed for Class 12 CBSE Computer Science Student who enters this Academic year.
At the end of this course student get Very extensive knowneldge in python and 100% confidence of writing Any Python Program, Output based question and SQL Queries by themselves with easy logics.
This course will be really fun for the students by cracking many programs and they defenetly started loving the subject at the end of this course.
Course Agenda:
Python Revision Tour 1 and 2:
Tokens, Flow of Control ( Looping Statements For and While loop, Conditional Statements.
Functions, Arguments and Parameters (Keyword, Positional and Default ), Flow of execution.
File Handling, Txt File, Binary File and CSV. (Read, Write/Append, Update, Delete, Copy Operation)
Data Structure ( Stack - Push, Pop, Peek).
SQL - DDL and DML Commands, Simple Queries, Operators. Constraints (not null, unique, primary key). JOIN (Equi, Natural, Cross)
Interface of python with an SQL database: connecting SQL with Python, performing insert, update, delete queries using cursor, display data by using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount, creating database connectivity applications, use of %s format specifier or format() to perform queries
All the Best.