Computer Science C.B.S.E syllabus
A data structure in python can be defined as a structure which can holds related data. In other words we can say that data structure is a way of storing, organizing and fetching data in computer. There are four data structure in python : List Tuple Dictionary Set We will learn that how List can be implemented…
It is a sequence of immutable objects. It is just like list. Difference between the tuples and the lists is that the tuples cannot be changed unlike lists. Lists uses square bracket where as tuples use parentheses. Questions on Tuples
FULL FORMS OF THE FOLLOWING NETWORKING TERMS: SSL– Secure Sockets Layer IMAP– Internet Message Access Protocol FTP– File transfer protocol- WiFi– Wireless Fidelity HTTPs– Hyper Text Transfer Protocol Secure WAP– Wireless Application Protocol VoIP– Voice Over Internet Protocol SMTP– Simple Mail Transfer Protocol TDMA– Time Division Multiple Access CDMA– Code Division Multiple Access TCP/IP– Transmission…
CONSTRAINTS: A Constraint is a condition or checks applicable on a field or set of fields. Constraints are also known as integrity constraints because they applied to maintain data integrity. Two types of constraints: Column constraints: Apply only to individual columns. Table constraints: Apply to group of one or more columns. Syntax: CREATE TABLE…
LIST An ordered collection of data items / elements Built in data structure in which individual element can be accessed using its position i.e. index value Represented using [] and elements are separated by comma Mutable data structure Index in the list starts from 0 for first element i.e. forward…
Dictionary Unordered collection of items / elements. Each item has two parts – key : value A mapping between key and it’s value, separated by colon (:) Items are enclosed in {} and separated by comma. Are optimized to retrieve data using key. So key (values) should be unique. They can be…
MySQL Python Connectivity Commands #CREATE DATABASE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″) mycursor=mydb.cursor() mycursor.execute(“CREATE DATABASE SCHOOL”) # SHOW DATABASE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″) mycursor=mydb.cursor() mycursor.execute(“SHOW DATABASE”) for x in mycursor: print (x) # CREATE TABLE import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″,database=”student”) mycursor=mydb.cursor() mycursor.execute(“CREATE TABLE FEES (ROLLNO INTEGER(3),NAME VARCHAR(20),AMOUNT INTEGER(10));”) # SHOW TABLES import mysql.connector mydb=mysql.connector.connect(host=”localhost”,user=”root”,passwd=”12345″,database=”student”) mycursor=mydb.cursor() mycursor.execute(“SHOW TABLES”) for x in…
Loop Types There may be a situation, when you need to execute a block of code several times. In general, statements are executed sequentially: The first statement in a function is executed first, followed by the second, and so on. Programming languages provide various control structures that allow for more complicated execution paths. A loop…
FUNCTION– A function is a programming block of codes that is used to perform a single, related task. It only runs when it is called. We can pass data, known as parameters, into a function. A function can return data as a result. We have already used some python built-in functions like print(), etc. But…
Here you will get all videos on all class XI Python concepts from the beginning like from downloading to executing simple programs. How to install Python …
