Notes
Notes - notes.io |
mon / fri = 4to 9
sat / sun = 9to 9
gauri ji computer scientest
dr faridan umrani iitb
rajiv jha game designer expert
investors:
india
cilcon valley
beginer classes
144 classes
classes per week 3
ar ajmented reality used by hackers
html
xhtml
doc type
mysql- how tostart
features data type -4-n-s-date nd time -b
main things done - app,slots,website
-Html
-Head
-title
-body these 4 tags will be used to do coading
html is a itself a tag<HTML>
</HTML>
beginer classes
144 classes
classes per week 3
ar ajmented reality used by hackers
-html
-xhtml- xtenisible
-doc type- documentry type <!DOCTYPE>
-mysql- my structure query language -- native language of sql
-sql is adata base language
=how to start my sql - start- all programe -mysql-mysql server-5.1-mysql command line client
my sql is a open source software
sql is free of cost
features of my sql=
=cost-free
=performance-fast
=simplicity
=scalability hold data deply upton 1 mb
=high performance can cover full index
=data security
=application support java / c+ / php
it is a main platform on which we will work data related work will be done here
it is also related dbms -data base management system
my sequal coding is used to creat website
=data types in mysql
-numeric- data type---- discription
- bit - 1-64 bits wide
- bigint - 9223372036854775808/807 (value in -)
- boolean -its a flag either 0 or 1 >on/off
-decimal - dec .025 to .1528
- double - Floting values are double
-float - single
- integers --2147483648to 647 unsigned values 0 to 4294967295
- real - 4 bytes floating point
-string -char -fiuxed lenth string / 1 to 255 characters / size specified / create time / by deafult character will be 1
-enum -64 k (kites)
-longtext - max size 4 gb
-medium text - 16k (kites0
-set - set will only accept zero / pre defined sets upto 64 strings
-text - variable lenth of the text will be 64 k
-tiny text - same but size will be 255 bytes
-varchar - variable character same as charecter but stores just the text size will be in max (infinity)
-date nd time
special date type for storage of date nd time values
data type description
-date - 1000-01-01 to 9999 -12-31
-date time - xcombination of date time
-time stamp - functionally equivelent to date time ( but with small range)
-time -HH:MM:SS
-year - A 2 or 4 digit yr , 2 digit yr support ranger of 70 (1970)to 69 (2069) 4 digit yr support range of 1901 to 2155
-booelean nd binary data will be same
binary data type is uesd to store all sort of data
which includes:
- images, graphics , animations,and word processor doc .
data type description
- BLOB - 64 K
- MEDIUM BLOB -16 MB
- LONG BLOB -4 GB
- TINY BLOB -255 BYTES
BLOB STAnds for = binary large object
= NUL VALUES
a nul value is not same as zero or blank untouched values / unavailable /unrecognised/unsigned / unknown
features data type -4-n-s-date nd time -b
main things done - app,slots,website
-Html
-Head
-title
-body these 4 tags will be used to do coading
html is a itself a tag<HTML>
</HTML>
=Hyper link
-{web page _ redirect _web page}
* WAMP
-windos
-apache
-mysql
-php
*MPEG_ {moving picture expert group }
*LINKING-{connecting 2 or more pages on internet}
-types
-internal link- {already exist in the system}
-external link-{web page (hyper linking)}
*DBMS
_DATA--INPUT--PROCESSOR--OUTPUT--INFORMATION
*COMMENTS
-non executable statments that are used to understand a program or can be used to read a program.
-TYPES OF COMMENTS
-single line comment-{starts with// {//means END OF CURRENT LINE]}
-Multiple line comment - {starts with /* and ends with*/}
/* calculate
sum of two numbers*/
*SIGNS IN CODING AND THEIR MEANINGS-
OPERATOR MEANING
= = Equal to
!= not eaqual to
< less than
<= less than equal
> greater than
>= greater than equal to
= = = strictly equal
! = = strictly not equal
& & logical and
" logical or
"
! logical not
*PLSQL- [PROCEDURAL LANGUAGE STRUCTURE OUERY LANGUAGE ]
-server as an extention for sql {uesd for RDBMS}{ORACLE IS A SERVER THAT MANAGES DBMS AND RDBMS}
pl/sql
#bockstructure
=D - Declare # ( user defined exceptions memory variables )
=B - begin #(plsql sql statments)
=E - exception#HANDLING OF ERRORS THAT ARISES DURING THE EXECUTION OF CODE BLOCK
=E - end OF PLSQL BLOCK STRUCTURE
# begin and end is mendatory and rest are optional.
SOFTWARE= it is a set of program that is designed to perform a particular task
there are twotypesof software
=system software- it is software which helps to run a computer
=application software-
=ARPANET-advance reserche project agency network
=VIRUS- vital-information resources under seize
=Hyper link
-{web page _ redirect _web page}
* WAMP
-windos
-apache
-mysql
-php
*MPEG_ {moving picture expert group }
*LINKING-{connecting 2 or more pages on internet}
-types
-internal link- {already exist in the system}
-external link-{web page (hyper linking)}
*DBMS
_DATA--INPUT--PROCESSOR--OUTPUT--INFORMATION
*COMMENTS
-non executable statments that are used to understand a program or can be used to read a program.
-TYPES OF COMMENTS
-single line comment-{starts with// {//means END OF CURRENT LINE]}
-Multiple line comment - {starts with /* and ends with*/}
/* calculate
sum of two numbers*/
*SIGNS IN CODING AND THEIR MEANINGS-
OPERATOR MEANING
= = Equal to
!= not eaqual to
< less than
<= less than equal
> greater than
>= greater than equal to
= = = strictly equal
! = = strictly not equal
& & logical and
" logical or
"
! logical not
*PLSQL- [PROCEDURAL LANGUAGE STRUCTURE OUERY LANGUAGE ]
-server as an extention for sql {uesd for RDBMS}{ORACLE IS A SERVER THAT MANAGES DBMS AND RDBMS}
pl/sql
#bockstructure
=D - Declare # ( user defined exceptions memory variables )
=B - begin #(plsql sql statments)
=E - exception#HANDLING OF ERRORS THAT ARISES DURING THE EXECUTION OF CODE BLOCK
=E - end OF PLSQL BLOCK STRUCTURE
# begin and end is mendatory and rest are optional.
SOFTWARE= it is a set of program that is designed to perform a particular task
there are twotypesof software
=system software- it is software which helps to run a computer
=application software-
=ARPANET-advance reserche project agency network
=VIRUS- vital-information resources under seize
=Hyper link
-{web page _ redirect _web page}
* WAMP
-windos
-apache
-mysql
-php
*MPEG_ {moving picture expert group }
*LINKING-{connecting 2 or more pages on internet}
-types
-internal link- {already exist in the system}
-external link-{web page (hyper linking)}
*DBMS
_DATA--INPUT--PROCESSOR--OUTPUT--INFORMATION
*COMMENTS
-non executable statments that are used to understand a program or can be used to read a program.
-TYPES OF COMMENTS
-single line comment-{starts with// {//means END OF CURRENT LINE]}
-Multiple line comment - {starts with /* and ends with*/}
/* calculate
sum of two numbers*/
*SIGNS IN CODING AND THEIR MEANINGS-
OPERATOR MEANING
= = Equal to
!= not eaqual to
< less than
<= less than equal
> greater than
>= greater than equal to
= = = strictly equal
! = = strictly not equal
& & logical and
" logical or
"
! logical not
*PLSQL- [PROCEDURAL LANGUAGE STRUCTURE OUERY LANGUAGE ]
-server as an extention for sql {uesd for RDBMS}{ORACLE IS A SERVER THAT MANAGES DBMS AND RDBMS}
pl/sql
#bockstructure
=D - Declare # ( user defined exceptions memory variables )
=B - begin #(plsql sql statments)
=E - exception#HANDLING OF ERRORS THAT ARISES DURING THE EXECUTION OF CODE BLOCK
=E - end OF PLSQL BLOCK STRUCTURE
# begin and end is mendatory and rest are optional.
SOFTWARE= it is a set of program that is designed to perform a particular task
there are twotypesof software
=system software- it is software which helps to run a computer
=application software-
=ARPANET-advance reserche project agency network
=VIRUS- vital-information resources under seize
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
