Posts

Database

  9/7 ## Database - Organized collection of structured information or data. - Database is a collection of entity(also called as table). - Entity is a collection of records. ## Types of database 1) Local database (installed in PC) 2) Web database  (host, server side) ## Python support database 1) MySQL 2) Microsoft SQL server 3) Mongo DB 4) SQL lite  ## Database Library  1) PySQL 2) PyMongo ## Database Terminology 1) field-represent the record ex. name,age,etc. ## Types of fields 1) Single value field - accept only one value at a time  ex. aadhaar card, pancard 2) Multi-value field- ex.name(firstname, lastname), country(city,state) 3) Null value field(blank) ex. mobile no. ## Tuple - complete info is called tuple roll     name      city  1           A         ngp 2           B        delhi 3          ...
Post a Comment
Read more

PyCharm Setup

Image
 25/6 Ø   Steps to setup PyCharm:-   ·          Download the PyCharm interpreter and check for the version which supports your system.  ·          I have downloaded PyCharm 2021.1.2 x 64 publisher JetBrains s.r.o. version 211.7442.45   ·          Install the PyCharm interpreter in your system.   ·          Create the shortcut on desktop.   ·          After installing the PyCharm open it, it will take some time to launch.   ·          In case if the interpreter is not working go to the settings and select the desired option which is compatible with your system.       Ø   New Project:-   ·          Then after this try creating a new pro...
Post a Comment
Read more

Python Advance Concepts

  15/6  ADVANCE PYTHON CONCEPTS ## Importance of Python 1) Python Environment - Unix (Solaris, Linux, FreeBSD, AIX, HP/UX, SunOS, IRIX, etc.) - Win 9x/NT/2000 - Macintosh (Intel, PPC, 68K) 2) Python library - path :-    /usr/local/lib/pythonXX NOTE:- XX is version 3) Python in command prompt - $python - python% - C:> python ## How to create script file in python - In Unix: $python script.py - In Window: C: >python script.py ## Python IDE(Integrated Development Environment) - Unix −> IDLE is the very first Unix IDE for Python. - Windows −> PythonWin is the first Windows interface for Python and is an IDE with a GUI. ## Python Interpreter - Similar to compiler just like C. ## Python Error Handling - Error Handling is use to exception concept 1) System Exit  2) Standard Error 3) Arithmatic Error 4) Overflow Error 5) Zero Division Error 6) Eof Error 7) Keyboard Interrupt Error 8) Key Error 9) IO Error 10) Syntax Error 11) Value Error ## Python Expre...
Post a Comment
Read more

Assignments

Image
PYTHON EXAMPLES:- 1) WAP of percentage using user input. per = int(input("enter your percentage ")) if per>60:     print("First Division") elif per>50 and per<60:     print("Second Division") elif per>40 and per<50:     print("Third Division") else:     print("fail") OUTPUT:- enter your percentage 49 Third Division 2) WAP to print any no. of table using user input. i = 8 while i<=80:     print(i)     i=i+8 OUTPUT:- 8 16 24 32 40 48 56 64 72 80 3) WAP of addition, multiply, subtract of any 2 nos. a = int(input("enter any no.")) b = int(input("enter any no.")) print("Addition of two no. is ", a+b) print("Subtraction of two no. is ", a-b) print("Multiplication of two no. is ", a*b) OR print("Result of two no. is ", a+b, a-b, a*b) OUTPUT:- enter any no.15 enter any no.4 Addition of two no. is  19 Subtraction of two no. is  11 Multiplication of two no. is  60 4) WA...
Post a Comment
Read more

JavaScript

 17/5 ## HTML, CSS - These does not have event - For event we use JavaScript ## JAVASCRIPT (JavaScript) -  Javascript is an event programming -  Used in head section -  JavaScript is case sensitive - inside body tag is dynamic script syntax:-   <html> <head> <script language="JavaScript"> </script> </head> </html> ## JavaScript Statement 1) Printing statement document.write("message"); 2) Alert statement alert("message"); 3) Input statement prompt("message"); 4) Confirmed statement confirm("message"); ## JavaScript Variable Variable is a name of memory location where user can store different type of data value. ex. a=10    number variable a=10.5      decimal variable a="Ram"     string variable a=z         character variable ## Types of variable 1) Variant     int a, float b, string c, char z     (verify before storing the value)    ...
Post a Comment
Read more

HTML and CSS

Image
8/5 ## ADVANCED TOPICS:- ## Web page creation - Website is a collection of web page - Web page is collection of information - Information is collection of data - Data is a raw material ## Types of websites 1) Static website   only for information purpose 2) Dynamic website   where user can interact ## Website creating language 1) HTML  H-Hyper          reference of next page  T-Text              collection of words, symbols and characters  M-Markup       it is a library stores the definition of all tags  L-Language     mediator ## HTML syntax is called "tag" <html> </html> ## Types of tag 1) Open tag <> 2) Close tag <> </> ex. <p> <z> </z> ## HTML structure <html>  <head>   It is a optional section  </head>  <body>   Using called tag  </body> </html> ...
Post a Comment
Read more

Class & Object, Set, Exception Handling and Examples

Image
  3/5 ## Python function - Function is a small job program ## Types of function   1) Built-in (library function) 2) User defined (created by the user) ## How to create function To create a function ' def ' keyword is used. def display():     print("this is my function")      display()     output:-  this is my function ## Function argument - Argument is used inside the function bracket 1) Actual argument (calling time) 2) Formal argument (definition time) example:- def display(name):                                                                (formal argument)     print("this is my function "+ name)      display("mohan")                                    ...
Post a Comment
Read more