Q1. Create class furniture. using constructor initialize height, width and color use display method display (). Create another class chair which is inherited from furniture with the attribute legs and use display method to display all attributes.

Output : {{oops_q1_result}}

Q2. Create class rectangle, using constructor initialize length and breadth find of rectangle using method.

3.Create class circle, using constructor initialize radius and find area and perimeter of circle.

Q4. Create class the bank, using constructor take the values of account, name and balance. Create method deposit (self, amt) with one parameter amount to increase the balance, create another method withdraw (self, amt) with one parameter to decrease the balance. Create method Statement () to display all the attribute of class.

pdf

View Assignment

Q1(a). Create Dictionary of five person with data items within
                                        nested values we have name, age, birthdate.

Name :
Age :
Birthdate :

{{dictOutputq1}}

Question 1 Python Code :


                                                            - var a = { 

                                                                “p1”: {"Name": "Asf", "Age": 23, "Birthdate": "14/08/2000"}, 

                                                                "P2": {"Name": "Kulsum", "Age": 18, "Birthday”: “05/10/2005"},

                                                                "P3": {"Name": "Yusuf", "Age"; 22, "Birthdate": "06/07/2001"},
 
                                                                "P4": {"Name": “Amina", "Age": 14, "Birthdate": "16/12/2009"},
 
                                                                "P5": {"Name": "Kulsum", "Age": 18, “Birthdate": "05/10/2005"}
 
                                                                } 

                                                                print (a) 

                                                        Python Output: 

                                                            { 

                                                            “p1”: {"Name": "Asf", "Age": 23, "Birthdate": "14/06/2000"}, 

                                                            "P2": {"Name": "Kulsum", "Age": 18, "Birthday”: “05/10/2005"}, 

                                                            "P3": {"Name": "Yusuf", "Age"; 22, "Birthdate": "06/07/2001"}, 

                                                            "P4": {"Name": “Amina", "Age": 14, "Birthdate": "16/12/2009"}, 

                                                            "P5": {"Name": "Kulsum", "Age": 18, “Birthdate": "05/10/2005"} 

                                                            }


                                        (b)Display all the keys of person dictionary.

{{dictOutputq2}}
Python Code :
-print (var, keys ())
python Output:
dict_keys ([‘P1','P₂', 'P3', 'P4', 'PS'])


                                        (c) Display name of person 3.

Python code :


                                                    → print (var. get ("p3")) 

                                                    output: {"Name": "Yusuf" "Age: 22, "Birthdate": “14/06/2001”


                                        (d) Display all the values of person Dictionary.

-print (var. values ())
Output:
dict_values = ([
{"Name": "Asf", "Age": 23, "Birthdate": "14/06/2000"},
{"Name": "Kulsum", "Age": 18, "Birthday”: “05/10/2005"},
{"Name": "Yusuf", "Age"; 22, "Birthdate": "06/07/2001"},
{"Name": “Amina", "Age": 14, "Birthdate": "16/12/2009"},
{"Name": "Kulsum", "Age": 18, “Birthdate": "05/10/2005"}
]}


                                        (e) Add Sixth person in dictionary.

→ Var a2 = {"P6": {"Name": "Afsari Khan", "Age" 34", Birthdate" = "1/01/1979"}}
a· update (a2)
print (a)
Output:
{
“p1”: {"Name": "Asf", "Age": 23, "Birthdate": "14/06/2000"},
"P2": {"Name": "Kulsum", "Age": 18, "Birthday”: “05/10/2005"},
"P3": {"Name": "Yusuf", "Age"; 22, "Birthdate": "06/07/2001"},
"P4": {"Name": “Amina", "Age": 14, "Birthdate": "16/12/2009"},
"P5": {"Name": "Kulsum", "Age": 18, “Birthdate": "05/10/2005"},
"P6": {"Name": "Afsari Khan", "Age" 34", Birthdate" = "1/01/1979"}


                                        (f). Change the name Person2(pushyal).

-a ["p2"] ["Name"] = "Pushyal"
print (var)

pdf

View Assignment


                                        Q1. Create Lambda function to find out power of passed number.

→ import math.
power = lambda a: Math.issqrt (a)
print ("Power of Entered Number is: ", power (110))
output:
Power of entered number is 10.


                                        Q2. Create lambda function with two parameters to find power of 

                                        the number where 2nd number is power of first.

-import math
power = lambda a, b: a**b
print (power (a = (2), b = (3)]
Output: 8


                                        Q3. Create lambda function to find out entered no is positive negative.

{{lambdaoutputq3}}
- num = lambda a: “Positive” is a is greater than 0 else “Negative”. print (num (-1)


                                        Q4. Create lambda find out to find out biggest between two number.

{{lambdaoutputq4}}
- num = lambda a, b: “A is big” if a greater than b else “B is big”


                                        Q5. Create lambda find out to find out entered number is even or odd.

{{lambdaoutputq5}}
- num = lambda a: "Even" if a % 12 == 0 else "Old Number") print (num(3) Output: odd number


                                        Q6. Create lambda function to find Cube of a number.

Output : {{lambdaoutputq6}}
- num = lambda a: a*** print (num (3)) Output:27


                                        Q7. Create lambda function to find out eligibility of age.

Output: {{lambaOutput}} python output : {{lambaOutputExplain}}

pdf

View Assignment


                                        Q1. Using list Comprehension find out Number Divisible by 7 from 1 to 1000?

python code : - xyz = [a for a in range (7, 1001) if a % 7 == 0] print(xyz)


                                        Q2. Count Number of Spaces in string (using List Comprehension)?

python code : - strg = "kjdldmm skdjlmld kldllmkk;l nlmld kdllmdm kdjdmmd mlkmm mlm;m jlkf jmklmf " xyz = [a for a in strg if a.count(" ") ] print("Number of spaces in string : ",xyz.__len__()) output : Number of spaces in string : 11


                                        Q3. Using List Comprehension Convert all Character to upper case in list Of words?

strg1 = "kjdldmm skdjlmld kldllmkk;l nlmld kdllmdm kdjdmmd mlkmm mlm;m jlkf jmklmf " abc = [a.upper() for a in strg1 ] print("Capital Strings : ","".join(abc)) output: Capital Strings : KJDLDMM SKDJLMLD KLDLLMKK;L NLMLD KDLLMDM KDJDMMD MLKMM MLM;M JLKF JMKLMF


                                        Q4. Using list Comprehension find out Common Number in between two list?

ls = [12,2,1,43,5,3] ls2 = [2,5,8,9,43,76,1] liscompre = [a for a in ls if a in ls2] print(liscompre) output : [2, 1, 43, 5]


                                        Q5. Using List Comprehension find all Number from 12 to 1000 that has 3 in them?

[13, 23, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 43, 53, 63, 73, 83, 93, 103, 113, 123, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 143, 153, 163, 173, 183, 193, 203, 213, 223, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 243, 253, 263, 273, 283, 293, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 403, 413, 423, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 443, 453, 463, 473, 483, 493, 503, 513, 523, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 543, 553, 563, 573, 583, 593, 603, 613, 623, 630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 643, 653, 663, 673, 683, 693, 703, 713, 723, 730, 731, 732, 733, 734, 735, 736, 737, 738, 739, 743, 753, 763, 773, 783, 793, 803, 813, 823, 830, 831, 832, 833, 834, 835, 836, 837, 838, 839, 843, 853, 863, 873, 883, 893, 903, 913, 923, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 943, 953, 963, 973, 983, 993]


                                        Dictionary comprehension

# normal ls = [12,2,1,43,5,3] ls2 = [2,5,8,9,43,76,1] xyz = {x:y for (x,y) in zip(ls,ls2)} print(xyz) output: {12: 2, 2: 5, 1: 8, 43: 9, 5: 43, 3: 76} # Nested kii = ["p1","p2","p3","p4","p5","p6"] ls = ["Aseef","Shubham","Ali","Ram","Sai","Shiva"] ls2 = [2,5,8,9,43,76,1] xyz = {x:{y:z} for (x,y,z) in zip(kii,ls,ls2)} print(xyz) output: {'p1': {'Aseef': 2}, 'p2': {'Shubham': 5}, 'p3': {'Ali': 8}, 'p4': {'Ram': 9}, 'p5': {'Sai': 43}, 'p6': {'Shiva': 76}}

Intro

Map map() function returns a map object (which is an iterator) of the results after applying the given function to each item of a given iterable (list, tuple, etc.) Syntax: Map (fun, iter)

Filter The filter() method filters the given sequence with the help of a function that tests. each element in the sequence to be true or not. Syntax: filter (function, Sequence).

Reduce The reduce (fun, seq) function is used to apply a particular function passed in its argument to all the list elements mentioned in the sequence passed along. This function is defined in "functools" module.

map() Assignment


                                            Q1. Using Het map function create two power list where is power of 2nd. 

                                            - from math import * 

                                            Ls = [4,9,16, 25,36] 

                                            asf = map(lambda a: math.sqrt(a), ls) 

                                            print (list (asf)) 

                                            output: [2,3,4,5,6] 

                                            Q2. Create list of numbers using map find out even or odd numbers (using lambda). 

                                            - wc = [2,4S, 37, 38, 100] 

                                            asf = map ((lambda a: str (a) + “is Even Number" if a%2 == 0 else 

                                            str(a) + " is Odd Number ", wc) 

                                            print(list(asf))

filter() Assignment


                                            Q 1. using filter find out even numbers in loop (use lambda) 

                                            - ab = [12,33,4 4, 3, 2, 43, 65, 867, 908] 

                                            filter (lambda a: 1 if a %2== 0 else 0 ab) 

                                            print (list (ls)) 

                                            Q2. Using filter find all find all fruits in list Starting with A (use Lambda) 

                                            - ab = ["Guava", "Mango" "Banana", "Pomegranates", ”Chiku”, "Lichi"] 

                                            Ls = filter (lambda a : 1 if “e” in a else o, ab). 

                                            print (list ((s))

reduce() Assignment


                                            Q1. Using reduce find out biggest between two numbers in list (uses lambda) 

                                            -from functools import reduce. 

                                            - ab = [13,2] 

                                            Is = reduce (lambda a,b: "A is Big" if a greater than b else "B is Big", ab) 

                                            Print(ls). 

                                            Q2 find out smallest number in list using reduce. 

                                            - def asf(a, b): 

                                            ls = [a,b] 

                                            return min (ls) 
                                    
                                            ak =[12, 14, 1, 56,77] 

                                            redu = reduce (asf, ac) 

                                            print (redu) 

                                            Q3. Using reduce find out palindrome strings (use lambda). 

                                            → This question is removed by faculty

Example of File Handling

Q. Allow the user to write in file.txt and if user type exit file should get close.
- abc = input ("Do you want to write in the file? (YES/NO)")
b = ["end", "END"]
While abc == “yes” or abc == "YES":
file = open ("file.txt", "w")
asf = 1
while asf less than=5: xyz=input (" ")
file.write(xyz)
for C in xyz:
for d in b:
if c in b:
file.close()
asf = 6
asf =+ 1

Quiz Assignment Date: 8/09/23


                                            Print (“\t*** Quiz Game ***”) 

                                            print ("\t *** Your Answer in small letter hint → (a, b, c, d)
                                            ****") 

                                            11 = [
                                            "1. What is the colour of a lemon? ", 

                                            "2. What is the full form of pf”, 

                                            “3. Who is the Owner of WIPRO Company?”, 

                                            "4. Among Below which is the biggest Continent in the world?", 

                                            "5. Which is the largest animal in the world.?”, 

                                            “6. Which is the 29th State of India?”, 

                                            “7. Which continent is known as Dark Continent?", 

                                            "8. Which is the largest desert in the world?", 

                                            "9. How many letters are there in the English alphabet?" 

                                            “10. How many days are there August?"
                                            ] 

                                            l2 = ["Red" "Blue", "Green", “Yellow”], 

                                            [“Prefer Fortune", "Policy further”, “Provident Fund",
                                            "Professor Folly"], 

                                            [“Azim Premji”, “Anand Mahindra”, 

                                            Ravi Teja", "Aseef khan, Walmart John"], 

                                            ["Africa" "Asia"," Russia"," "Antarctica"], 

                                            [“Giraffe”, “Elephant”, "Gorilla", "Whale”], 

                                            ["Rajasthan", "Goa", "Uttarakhand”, “Telangana”], 

                                            [“America” "Green Land", "Switzerland", "Australia"], 

                                            [“jezail”, “Egyptian” "Arab" "Sahara”], 

                                            ["27", "21", "23", "26"], 

                                            ["28","29","30", “31”] 

                                            l3 = ["d", "c", "a", "b", "d", "d", "d", "d", "d”] 

                                            Count = 1 

                                            for a in zip (l1, l2): ← (Very Imp function) 

                                            print(a) 

                                            user = input ("Answer: ") 

                                            if user in L3: 

                                            Count += 1 

                                            if count == l3: 

                                            if count! = 10: 

                                            print (" Your Score: ", count) 

                                            elif count! = 10: 

                                            print (" Not bad you Scored!", count) 

                                            else: 

                                            print ("OOPS You failed!")

Space and then Exit Task


                                            abc = input("Start Game Yes/No?") 

                                            lst = [] 

                                            while abc == "Yes": 

                                            user = input("Enter Text : ") 

                                            part = user.split(' ') 

                                            if part: 

                                            if part[0]: 

                                            pass 

                                            if len(part) greater than 1 and part[1]=="exit": 

                                            break

Image Mapping(HTML)

Click on the computer, phone or the cup of tea to go new page and read more topic:

Article Example(HTML)

Boriwali(West)

We enable people across the globe to use I.T. optimally and efficiently through world-class I.T. training solutions. Today, Aptech students are working all over the world building knowledge corporations, communities and knowledge societies.

8 out 10

Transition(CSS)

Animation(CSS)

GoogleAPI

Output is correct Add your key

Array Assignment and Example

Assignment Using Array to Insert and Display Value

Exiting Element in Array: [10,20]

Example of 1D and 2D Array

JavaScript
Output

Events in JS (Task: Create login form which will open salary of employee)

Funtion with and without Parameter

Enter Radius to find volume of sphere without parameter
and Area of Circle(withParameter):
Enter Length and Breath to find Area of Rectangle:

RegEX

View Code

Object in JavaScript

Thread Example

WebStorage in JavaScript and Tooltip in Jquery

Local Storage Set Item

Local Storage Get Item

Check Selector in Jquery

Check and submit to see Countries

Class Selector in Jquery

Lorem ipsum dolor sit amet consectetur Span 1 adipisicing elit. Consequatur est ex repellat quas sit deleniti? Dicta, dolorum. Soluta, eum ea veniam quia necessitatibus rem, natus Span 2...reprehenderit ut molestiae accusantium quae.

Element Selector in Jquery


India	Germany	Russia	Brazil	Ladakh
France	Europe	George Washington	Paris	Hawai

Dynamic Test in Jquery

AngularJS Directives 1. Check Box to see Show/Hide using ng-hide and ng-show

Hide

Show

1.1 Test Hide and Show
Enter Age:

Not Eligible to Voting

Eligibe to Vote

2. Use of ng-repeat

{{ a.user }}
{{ duplicatetask }}

Assignment

Company Monthly Salary

First Name
Last Name
Employee ID
Job Title
Employee Salary

{{ duplicateID }}

Employee List

FirstName	{{ fstNameOUTPUT.firstNameA }}
LastName	{{ lstNameOUTPUT.lastNameA }}
ID	{{ empIDOUTPUT.employeeID }}
Title	{{ tittleOUTPUT.jobTitleA }}
Salary	{{ salaryOUTPUT.empSalaryA }}
Delete Employee

Example of API/REST API

---------API---------

---------REST API---------------

ID	Gender	Name	Age	Adrress
{{emp.id}}	{{emp.gender}}	{{emp.name}}	{{emp.age}}	{{emp.address}}

Routing in AngularJS Tab1 Tab2

Currency and Date in Angularjs

---------Currency-----------

ByDefault Currency: {{ person.salary | currency}}
European Currency: {{ person.salary | currency: 'Euro.'}}
Two Decimal Currency: {{ person.salary | currency: 'Euro.'}}

------------Date------------

Todays Date: {{ today | date}}
Short: {{ today| date:'short'}}
Medium: {{today | date:'medium'}}
ShortDate: {{today | date:'shortDate'}}
LongDate: {{today | date:'longDate'}}

Assignment

Enter Your salary:
Enter Your Bonus:
The employee deduction is(Insurance 8%) : {{ insurance = 8/100 * ans |currency:'Rs '}}
The PF Deduction is (pf 11%): {{ pf = 11/100 * ans | currency:'Rs '}}
The Bonus Addition is : {{default | currency:'Rs '}}
The Income Tax Deduction is (16%) : {{ gst = 16/100 * ans | currency:'Rs '}}
Your Final Salary is: {{finalsal() |currency:'Rs ' }}

Filter in AngularJS

Injecting Factory, Service and Constant in AngularJS

Constant in Angularjs meaning to assign value to variable which can use as value

Factory in AngularJS need factoryobj which returns a function and then return itself

Service in AngularJS doesn't need obj

Display Box (●'◡'●)	{{result}}

Dynamic Template

Custom Directive

🚩Custom Directive

🚩Isolating Scope of a Directive

From Validation in AngularJS

The input Valid state : {{myForm.myInput.$valid}}

Assignment I [group by, min(), max(), inner join, left join]


                                -- use asf;
                                -- create table emp(
                                -- empno int primary key,
                                -- ename varchar(10) default null,
                                -- job varchar(9) default null,
                                -- mgr decimal(4,0) default null,
                                -- hiredate date default null,
                                -- sal decimal default null,
                                -- comm decimal(7,2) default null,
                                -- deptno int not null,
                                -- foreign key (deptno) references dept(deptno)
                                -- );
                                -- create table dept(
                                -- deptno int primary key ,
                                -- dname varchar(14) default null,
                                -- loc varchar(133) default null
                                -- );
                                
                                -- insert into dept values(10,"Accounting","New York");
                                -- insert into dept values(20,"Research","Dallas");
                                -- insert into dept values(30,"Sales","Chicago");
                                -- insert into dept values(40,"Operations","Boston");
                                -- insert into emp value(7369,"Smith","Clerk",7002,'1980-12-17',800.00,null,20);
                                -- insert into emp value(7499,"Allen","SalesMan",7698,'1981-02-20',1600.00,300.00,30);
                                -- insert into emp value(7521,"Ward","SalesMan",7698,'1981-02-22',1250.00,500.00,30);
                                -- insert into emp value(7566,"Jones","Manager",7839,'1981-04-02',2975.00,null,20);
                                -- insert into emp value(7654,"Martin","Saleman",7698,'1981-09-28',1250.00,1400.00,30);
                                -- insert into emp value(7698,"Blake","Manager",7839,'1981-05-01',2850.00,null,30);
                                -- insert into emp value(7782,"Clark","Manager",7839,'1981-06-09',2450.00,null,10);
                                -- insert into emp value(7788,"Scott","Analyst",7566,'1982-12-09',3000.00,null,20);
                                -- insert into emp value(7839,"King","President",null,'1981-11-17',5000.00,null,10);
                                -- insert into emp value(7844,"Turner","Salesman",7698,'1981-09-08',1500.00,0.00,30);
                                -- insert into emp value(7876,"Adams","Clerk",7788,'1983-01-12',1100.00,null,20);
                                -- insert into emp value(7900,"James","Clerk",7698,'1981-12-03',950.00,null,30);
                                -- insert into emp value(7902,"Ford","Analyst",7566,'1981-12-03',3000.00,null,20);
                                -- insert into emp value(7934,"Miller","Clerk",7782,'1982-01-23',1300.00,null,10);
                                -- select * from emp;
                                -- select * from dept;
                                ------------------------------------
                                -- Solution: 
                                -- update emp set ename = "Scott" where empno = 7788;
                                -- select job as a,avg(sal) as Average_salary  from emp group by a;-- Query 1
                                -- select job as a,avg(sal) as Average_salary,dname  from emp inner join dept on emp.deptno = dept.deptno group by a;-- Query 2
                                -- select dname,min(sal) as Minimum_salary,max(sal) as Maximum_Salary,sum(sal) as Total_salary  from emp inner join dept on emp.deptno = dept.deptno ;-- Query 3
                                -- select ename,job ,sal as salary  from emp where sal greater than 3000 ;-- Query 4
                                -- select min(hiredate) as Old_EMP,max(hiredate) as Newest_EMP  from emp ;-- Query 5
                                -- select dname from emp left join dept on emp.deptno = dept.deptno where empno  greater than 2 group by dname;  -- Query 6
                                -- select  ename,job ,sal as salary ,deptno as Department_Number from emp  where sal greater than 3000 ;-- Query 7
                                -- select loc as Location,dname,sal,comm from emp inner join dept on emp.deptno = dept.deptno  group by loc having sum(sal) ;--  Pending

Assignment Given Aptech faculty: Mrs.Supriya Kulkarni

Assignment II [constraint, auto increment, update primary key]



                                -- use asf;
                                -- create table Employees_MCM(
                                -- emp_id int ,
                                -- name varchar(50),
                                -- department varchar(50),
                                -- post varchar(50),
                                -- experience int
                                -- );
                                -- insert into Employees_MCM(name,department,post,experience) values ("Rohit","IT","Junior Developer",0),("Hemanshi","Sales","Custumer Service Excecutive",2)
                                -- ,("Vasant","Website Designer","Employee",1),("Fuji","Sales","Sales Excecutive",3),("Karuna","Website Developer","Intern",1),("Rahul","Sales","Custumer Service Excecutive",2),("Abhishek","Sales","Relationship Manager",4);
                                -- insert into Employees_MCM(name,department,post,experience) values ("Fuji","Sales","Sales Excecutive",3),("Rahul","Sales","Custumer Service Excecutive",2),("Abhishek","Sales","Relationship Manager",4);
                                -- update Employees_MCM set experience=7 where name="Fuji"; 
                                
                                -- select sum(department) from Employees_MCM where department="sales";
                                -- select avg(post) from Employees_MCM limit 10; 
                                
                                -- create table customer(
                                -- custmoer_id int primary key,
                                -- department varchar(50),
                                -- orders int,
                                -- conatct_no int
                                -- );
                                -- alter table customer modify customer_id int auto_increment; 
                                -- insert into customer(custmoer_id,department,orders,conatct_no) values (1,"McSaver Meal",44,749818114),(2,"Rahul Sahani",94,749818114),(3,"Abhishek",54,989786664);
                                -- insert into customer(custmoer_id,department,orders,conatct_no) values (4,"McSaver Meal",44,749818114),(5,"Suraj Chaturvedi",23,749818114),(6,"Abhishek",56,989786664);
                                -- insert into customer(custmoer_id,department,orders,conatct_no) values (7,"McSaver Meal",44,749818114),(8,"Rajni",10,749818114),(9,"Abhishek",95,989786664);
                                -- insert into customer(custmoer_id,department,orders,conatct_no) values (10,"McSaver Meal",44,749818114),(11,"Priya",12,749818114),(12,"Abhishek",32,989786664);
                                -- drop table Employees_MCM;
                                -- select * from Employees_MCM;
                                -- alter table Employees_MCM add new_emp_id int primary key auto_increment;
                                -- alter table Employees_MCM drop constraint new_emp_id;

Assignment Given Aptech faculty: Mrs.Supriya Kulkarni

Assignment III [inner join, outer join]

-- create table Customers(
-- CustomerID int primary key,
-- CustomerName varchar(255),
-- Email varchar(255),
-- Country varchar(255)
-- );
-- create table Orders(
-- Order_id int primary key,
-- CustomerID int,
-- foreign key (CustomerID) references Customers(CustomerID),
-- OrderDate date,
-- TotalAmount decimal(10,2)
-- );
-- drop table Orders;
-- alter table Orders modify Order_id int auto_increment ;
-- select * from Customers;
-- select * from Orders;
-- insert into Orders(CustomerID,OrderDate,TotalAmount) values(1231,'2023-10-16',500);
-- delete from Orders where Order_id = 2;
-- insert into Customers values(1238,"Harry","Harry@example.com","Canada");
-- insert into Customers values(1231,"Franklyn","franklyn12@example.com","USA"),(1232,"Goblin","Goblin4@example.com","Canada"),(1233,"Harper","Look90@example.com","Agentina"),(1234,"Hobs","HObs52@example.com","Afganistan"),(1235,"Luke","Lukelyn32@example.com","Netherland");
-- select CustomerName,Email,Country,OrderDate from Customers inner join Orders on Orders.CustomerID = Customers.CustomerID;-- 1 Query
-- select CustomerName,TotalAmount from Customers inner join Orders on Orders.CustomerID = Customers.CustomerID;-- 2 Query
-- select * from Customers inner join Orders where CustomerName ;-- 3 Query;

-- select * from customers as c inner join orders as o on c.customerID=o.customerID;-- 1 query
-- select customerName, TotalAmount from customers as c inner join orders as o on c.customerID=o.customerID;-- 2 query
-- select * from customers as c left outer join orders as o on c.customerID=o.customerID where o.customerID is null;
--                 -- select * from customers as c inner join orders as o on c.customerID=o.customerID where orderDate = 2023;-- 
-- select llllk from customers as c inner join orders as o where o.customerID= c.customerID;

Assignment IV [Basic, IN, (IN,IN,OUT), INOUT, performance_schema]

Example

-- Basic -- Delimiter && -- create procedure adddata() -- begin -- set @A = 20; -- set @B = 30; -- select @A + @B; -- end && -- call adddata(); -- IN Method -- Delimiter && -- create procedure add_data_in(in a int) -- begin -- select * from department where department_id = a ; -- end && -- call add_data_in(1); -- IN,IN,OUT Method -- Delimiter && -- create procedure Add_Data_in_out(in A int,in B int,out ans int) -- begin -- set ans = A + B; -- end && -- 1.call Add_Data_in_out(45,6,@ans); -- select @ans; -- 2.set @A=87; -- set @B=17; -- call Add_Data_in_out(@A,@b,@ans); -- INOUT Method -- Delimiter && -- create procedure deptproc(inout ans int) -- begin -- select salary into ans from employeeS where employees_id = ans; -- end && -- set @ans=206; -- call deptproc(@ans); -- select @ans; -- show variables like 'performance_schema'; -- select * from INFORMATION_SCHEMA.ENGINES where ENGINE = 'performance_schema'; -- use performance_schema; -- show tables; -- desc error_log; -- select * from error_log; -- SHOW ENGINES;

Assignment Based on Procedure

Download

Calculator

Local Storage Set Item

Local Storage Get Item

Company Monthly Salary

Employee List

🚩Custom Directive

🚩Isolating Scope of a Directive

Pleasant Click