python

‍Hello World! If programming is the act of teaching a computer to have a conversation with a user, it would be most useful to first teach the computer how to speak. In Python, this is accomplished with the print statement. print (“Hello, world!”) A print statement is the easiest way to get your Python program … Read more

‍Conditionals ‍ Excercise – 1: On a coin toss if it’s Heads: India Bat’s, If it’s tails: Australia Bats Toss = “Heads”‍if Toss == “Heads”:    print (“India’s Batting”)else:    print (“Australia’s Batting”) ‍ Excercise – 2: ‍Logic of Traffic Signals: signal = “green”‍if signal == “green”:    print (“Go”) ‍ Excercise – 3: #90 or higher should get an … Read more

‍Functions ‍ Excercise – 1: ‍Function Coinflip, On a coin toss if it’s Heads: India Bat’s, If it’s tails: Australia Bats: def coinflip(Toss):   if Toss == “Heads”:       print (“India’s Batting”)   else:       print (“Australia’s Batting”) coinflip(“Heads”) ‍Excercise – 2: ‍Function that returns square of any number def square(n):      #This is Header   squared = n ** 2 … Read more

‍Lists ‍ Excercise – 1: List your Family Members in a List in this sequence: Mom, Dad, Elder One family = [“Indira”, “Madhu”, “Somu”]; if len(family) > 0:  print (“Sweet mom is ” + family[0]) #Accessing by index  print (“Caring Dad is  ” + family[1])  print (“Elder one is ” + family[2]) print (family) ‍Excercise – … Read more

‍Loops ‍ Excercise – 1: Use While to Print count 5 times count = 0‍if count < 5:  print (“Hello, I am an if statement and count is”, count) while count < 5: #Condition  print (“Hello, I am a while and count is”, count)  count += 1 ‍Excercise – 2: ‍Print Square of a numbers … Read more

‍Revision: ‍ Basics and Print Statements – Day 1 Conditionals – Day 2 Functions – Day 3 Lists – Day 4 Loops – Day 5 Revision – Day 6 ‍

‍Environment Setup and Basics‍ Installation: MySQL Community Addition:https://dev.mysql.com/downloads/mysql/MySQL Workbench https://www.mysql.com/products/workbench/ ‍ Queries Used: CREATE DATABASE students; ‍ CREATE TABLE student_info (    student_id INT PRIMARY KEY,    name VARCHAR(50),    email VARCHAR(100),   enrollment_date DATE); ‍ INSERT INTO students.student_info (student_id, name, email, enrollment_date)VALUES (1, ‘Aparna Singh’, ‘aparna@gmail.com’, ‘2022-01-01’),       (2, ‘Bharath Kumar’, ‘bharath@hmail.com’, ‘2022-01-02’); ‍ … Read more

‍ ‍Table Manipulation ‍ Queries Used:‍ CREATE TABLE table_name (  column1 datatype,  column2 datatype,  column3 datatype); — Insert into columns in order:INSERT INTO table_nameVALUES (value1, value2); — Insert into columns by name:INSERT INTO table_name (column1, column2)VALUES (value1, value2); ALTER TABLE table_nameADD column_name datatype; DELETE FROM table_nameWHERE some_column = some_value; UPDATE table_nameSET column1 = value1, column2 … Read more

‍Quiz – 1 Please attempt all the questions here: ‍ ‍ ‍ ‍