CBSE COMPUTER SCIENCE

Hello SHUNMUGA SUNDARAM S, There is no need for students to buy any fancy CUET ed-tech course or do coaching. Syllabus we know is the same as of Class 12. Only reduced portions are new. So we have prepared a thin concise *Educart Final Revision CUET Book* to revise concepts, adjust to the difficulty level of NTA CUET and cover reduced portions too. *CUET 2023 FINAL REVISION:-* https://amzn.to/3lHn3Uh You can recommend these books to your students 🙂 *-Prashun* *Educart*

#Interface Python with MySQL : Employee Details import mysql.connector as mcr cn = mcr.connect(host='localhost',user='root',password='admin') #cn = mcr.connect(host='127.0.0.1',user='root',password="admin",database='company') cr = cn.cursor() cr.execute('create database if not exists company') cr.execute("use company") cr.execute("create table if not exists employee(empno int, name varchar(20), dept varchar(20),salary int)") print("Table Created Successfully...") cn.commit() while True: opt=int(input("1. ADD RECORD 2. UPDATE RECORD 3.DELETE RECORD 4. SEARCH 5.DISPLAY 6.EXIT : ")) if opt==1: #INSERTING A RECORD e = int(input("Enter Employee Number :")) n = input("Enter Name :") d = input("Enter Department :") s = int(input("Enter Salary :")) query="insert into employee values({},'{}','{}',{})".format(e,n,d,s) #query="insert into employee values(%s,'%s','%s',%s)"%(e,n,d,s) cr.execute(query) cn.commit() print("A RECORD INSERTED...") elif opt==2: #UPDATING A RECORD e=int(input("Enter employee number to be updated ")) s=int(input("Enter salary to be updated ")) query="update employee set salary={} where empno={}".format(s,e) #query="update employee set salary=%s where empno=%s"%(s,e) cr.execute(query) print("A Record Updated ") cn.commit() elif opt==3: #DELETING A RECORD e=int(input("Enter employee number to be deleted")) query="delete from employee where empno={}".format(e) cr.execute(query) print("Record(s) Deleted ") cn.commit() elif opt==4: #SEARCHING A RECORD e=int(input("Enter employee number to be searched")) query="select * from employee where empno={}".format(e) #query="select * from employee where empno=%s"%(e) cr.execute(query) result = cr.fetchall() if cr.rowcount==0: print("Record not found") else: print("EMPNO","NAME","DEPARTMENT","SALARY") for row in result: print(row[0],row[1],row[2],row[3]) cn.commit() elif opt==5: #DISPLAYING RECORDS query="select * from employee" cr.execute(query) result = cr.fetchall() print("EMPNO","NAME","DEPARTMENT","SALARY") for row in result: print(row[0],row[1],row[2],row[3]) cn.commit() elif opt==6: #CLOSING DATABASE cn.close() print("File closed successfully...") break else: print("Invalid OPtion...")

DataFrame-1 1. https://docs.google.com/forms/d/e/1FAIpQLScn1QDIA55ElQFZNvMOks5CRd9WPCOxdugumwV2BPmG1LZ2Pw/viewform?usp=sf_link 2. https://forms.gle/ndhGrTccxY6TjtCi6 DataFrame-2 1. https://docs.google.com/forms/d/e/1FAIpQLSePUlz02L0Jf9SIKwN6hmCf-jz0RZJG4iltXnFEpABEYfKVgQ/viewform?usp=sf_link 2. https://forms.gle/qa3cXLzB5MwekQbD9 DataFrame-3 1. https://docs.google.com/forms/d/e/1FAIpQLSd3lbDzFLktF5uD8HwEQc7oZwL7oti-sRkaLQJO1OuH7qDALw/viewform?usp=sf_link 2. https://forms.gle/rYk1ez6gwwsdHptz7 DataFrame-4 1. https://docs.google.com/forms/d/e/1FAIpQLScYDcXdCUs_11LuvPA_NeTWDcKbybf6F-vbGFI53wBYwvLtVA/viewform?usp=sf_link 2. https://forms.gle/o7Qo2rTxSwWkXwfk6 DataFrame-5 1. https://docs.google.com/forms/d/e/1FAIpQLSde_ULhfyszxbzMixSOaA_vCezSo4qr6luBJNSGD2pi0qVWgQ/viewform?usp=sf_link 2. https://forms.gle/BNU84Lu8dU3WJ2AC8

COMPUTER SCIENCE WITH PYTHON ONLINE MCQ TEST Python Basics 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfwkh38h6uFGRIUqsD_gWtC0LatfwtYWXb-6Cd7WS5c8KbvcA/viewform?usp=sf_link 2. https://forms.gle/Czxgqb6p9N34hLsX9 Python Basics 002- 1. https://docs.google.com/forms/d/e/1FAIpQLScguFCbVkCc8ifNMljY77f90agvQxjd64PjydiBHEMDk29QqQ/viewform?usp=sf_link 2. https://forms.gle/gih7FNGas4nX5tDV7 Python Basics 003- 1. https://docs.google.com/forms/d/e/1FAIpQLSfH6n41FHNkRSWP9ZSpQjKOAo9jS5yobQAhC1xWRniPqPgS8A/viewform?usp=sf_link 2. https://forms.gle/Fsft6dDag1gTGRZn8 Revision Tour-1 - 1. https://docs.google.com/forms/d/e/1FAIpQLSdPSGBYh7-UpgW3hYQWKTMUJXe4PTVmEnXUSZakDI9_c_T4VA/viewform?usp=sf_link 2. https://docs.google.com/forms/d/e/1FAIpQLSdPSGBYh7-UpgW3hYQWKTMUJXe4PTVmEnXUSZakDI9_c_T4VA/viewform?usp=sf_link List Object 001 1. https://docs.google.com/forms/d/e/1FAIpQLSc0dwUC6srssrHItlbmcO_qWvGAOcIXamC86GW3UDkOY2M14Q/viewform?usp=sf_link 2. https://forms.gle/qcPbd9HifatcybkT7 String Object 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfCe2ZBO52G7eb3pAoNtmq1ZMugmg_hKSIxvHgs0myEJKn5zQ/viewform?usp=sf_link 2. https://forms.gle/WbG1RiEsPYUvBWpi8 Dictionary Object 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfoL1be5aUKQW4f_aCoWUOqR5aoil9-tOIT3YRi61qEMHlFxA/viewform?usp=sf_link 2. https://forms.gle/LvemwL6kqjaeGne4A Computer Concepts 1. https://docs.google.com/forms/d/e/1FAIpQLSc4JP77T5JZKhKRL6F4l1jE7-W-HBIlKtNu6hrQNHfqQi4xZQ/viewform?usp=sf_link 2. https://forms.gle/UPV6QRAo5HAqMvyW7 Binary File Operation 1. https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link 2. https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8 TEST THROUGH TELEGRAM 1. Python Basics-1 t.me/QuizBot?start=ayrNqFKS 2. Python List-1 t.me/QuizBot?start=eowBkzeL 3. Python List-2 t.me/QuizBot?start=k8DYZ3Oa 4. Python List-3 t.me/QuizBot?start=Smn9ThxH 5. Python FILE HANDLING -1 t.me/QuizBot?start=nQD1Q3kG 6. Python FILE HANDLING -2 t.me/QuizBot?start=vx12PVG3 7. Python FILE HANDLING -3 t.me/QuizBot?start=7VvdcQtz 8. Python FILE HANDLING -4 t.me/QuizBot?start=MnPrt2v4 9. Python FILE HANDLING -5 t.me/QuizBot?start=ohtwqD6S 10. Model Set t.me/QuizBot?start=mr6DO8hs Binary File Operation 1. https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link 2. https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8 Pandas – Series-1 1. https://docs.google.com/forms/d/e/1FAIpQLScX53p5BhiMBrGjoCepoYNY0gsNwqwN1_n1mhMYJyT3dRaC4Q/viewform?usp=sf_link 2. https://forms.gle/SbdMp3DtcYsNm1gv5 Pandas – Series-2 1. https://docs.google.com/forms/d/e/1FAIpQLSfe9Aib_MalEBIqfzcQ2kGKNuOc2BQe4_du247YVbgi0JYVxw/viewform?usp=sf_link 2. https://forms.gle/AM2y68xh5Py2MrGN9 Pandas – Series-3 1. https://docs.google.com/forms/d/e/1FAIpQLSd2ZBHaebAbLTQXNy1ra5HzvbLPSVQkaTWB8KKXjFgu7ho6vQ/viewform?usp=sf_link 2. https://forms.gle/K6PabiCbuxQuSCvU6 Pandas – Series-4 1. https://docs.google.com/forms/d/e/1FAIpQLSfjzip1pbIuard6v4ypwWEHCva1c2XYs5XbhPjl7O8mZ5dUcg/viewform?usp=sf_link 2. https://forms.gle/kTJ4zRdnYu4LpFZU8

Binary File Operation 1. https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link 2. https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8

Binary File Operation https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8