Notes

WHITE HAT JR.


BEGINEER<Grade1<command,loops and conditions outcome= board games and pictures
INTERMEDIATE<Grade2-4<Algorithm,Pattern,
ADVANCE<Grade 4-6
PROFESSIONAL<Grade7-9

BUILDING A SECURE ASP.NET APPLICATION
ASP: active server page building applications on secure server

THREAT MODELLING: a model that is used to identify the threats.




MYSQL= my structured query language
USet for DBMS Server 5.1

Features of MYSQL
* cost free
* fast perfomance
* Scalibility
* high perfomance(deeply embedded data upto 1MB)
* Application supports (supports all other languages as well lilke c++, java, php
* Warehouse ( stores upto 1Tb)

HOW TO START MYSQL
start<all program < MySQL SERVER 5.1 <MYSQL Line command


Data types of MYSQL
(numeric, string, date and time, boolean )
1.Numeric
1. BIT=1-64 bits wide
2.BIGINT= signed and unsigned -9223372036854775808 to +807

3.BOOLEAN=flags that indicates error
4.DECIMAL= dec (term .025 to .1528)
5.DOUBLE= double float maximum floating
6.FLOAT= single floating value like 9,8
7.INTEGER= -2147483648 to +647
8.REAL= 4 bytes floating point


2.STRING
*Char= fixed length (1-255 size specified create time default value= 1)
*ENUM=upto 64 strings ( no copyright issue)
*LONGTEXT= upto 4gb
*MEDIUM TEXT= upto 16k
*SET=accepts zero and predefined sets upto 64 strings
*TEXT= variablelength=64K
*TINY TEXT=255 bytes
*VAR CHAR= long text max limit



3. DATE AND TIME
*Date= yyyy:mm:dd
*Date & Time=
*Time=hh:mm:ss
*Time stamp= same as date and time but with a short time spaan
*year= 2 digit 70-89
= 4 digit 1970-1989


4.BOOLEAN= also called binary datta type used to store all sorts of data which includes
graphics, pictures, animations, word dprocessors, docs

BLOB=binary large objects
1.BLOB= 64 K
2.MEDIUM BLOB= 16MB
3.LONG BLOB= 4GB
4.TINY BLOB=255 bytes

Nul value: nor zero/ nor blank unsigned, unrecognizable an dunknown value

SCRIPT &PROMPT are related to hyperlinking

HYPERLINK: its a link between two webpages that redirects us from one webpage to another.
WAMP: window apache mysql php
MPEG: moving picture expert group

LINKING: connecting two or more webpages on internet
1. Internal link: link that already exist in the syatem
2. External link: link that redirects us from one webpage to another.


Features of DBMS
*data redudancy= no duplicacy
*data security and privacy
* easy sharing of data
* intergrity and uniformity of several files intoa single file
*inconsistency can be avoided


COMMENTS: non executable statments that are used to undersatnd program or can be used to read a program.
SINGLE LINE= //
MUTLIPLE LINE= /* SUM IS */
##PLSQL= Procedural structural query language (it's extension for the SQL) for RDBMS
:BLOCKSTRUCTURE
D eclare (OPTIONAL)
B egin(MANDATORY)
E xceptional (OPTIONAL)
End (mandatory) of PLSQL BLOCK STRUCTURE

BLOCK STRUCTURE

DECLARE= user defined exceptions, memory and variable
*User defined exceptions=handling of errors that arise during execution of data.
Exceptions: handle the error arise during the execution of code block.

BEGIN: SQL & PLSQL Statements



OPERATORS
== equals to
!= not equals
< less than
<= less than equal to
> greater
=> greater than equal to
=== strictly equal to
!=== strictly not equal
&& LOGICAL AND
|| LOGICAL OR
! LOGICAL AND


SOFTWARE: it is a set of program that is designed to perform a particular task.
types of software
1. System software: that help our system to run like windows, linux
2. Application software: is used for applications like whatsapp,facebook insta used to run specific tasks

*ARPANET=advance research project agency network

VIRUS: Vital information resources under seize
http: hyper text transfer protocol

WEB BROWSER: platform that is used for browsing


*Domain parts
gmail.com, yahoo.com

IP Address: size 32bits; used for internet communication, ip address is active only if it is connected to the internet.

SQLCOMMANDS
Queries that are used
GRANT: allow soemone to access our data.
REVOKE: to take back the given permissions.

USE MYSQL
Select user from user:
Syntax
GRANT
* create_user_user Identify_by_ password;
eg: create user Anjali Identify by AB
if we wanted to grant permission for a specific part
*Grant all on emp1 to xyz
revoke all on emp1 from xyz

*TRIGGERS: it defines the action that a database should take when some database related event occurs.
3 TYPES OF TRIGGERS
1.ROW: a row level will be fires each time a row in the table,when is affected by a triggered statement.
2.STATEMENT: will be fired only once on behalf of the triggering statment.
3.BEFORE/AFTER: before trigger will be fired before triggering satement and after will be fired after the triggering statement.



BLUESTACK: