DataBase

+------> Column
|
+-----+-----+-+------+-+-------+-+----+
| Day       | | Name | |Present| |Ab  |
|-----------|-|------|-|-------|-|----|
|Mon        | |Moona | |P      | |    |
+Tue        |+-----------+     | | A  |
|Wed        |||Moona | |p|     | |    |
|Fri        |+-----------+     | |    | Row
|           | |      | | |     | |    |<--------+
|           | |      | | |     | |    |
|           | |      | | |     | |    |
|           | |      | | |     | |    |
+-----------+-+------+-+-|-----+-+----+
|
+-------------> This Database Table
+---------------+
|SQL SMS        |
+---------------+
Set of records
Types of DataBase
1, MYSQL - 50,000 Records
2, MSSQL - 5,00000 Records
3, MSACCESS - 15,000 Records
---------------------------------
DataBase Management
MYSQL Command line
Windows, Linux
MSSQL Command line Gui
MSSQL Server Managent Studio
--------------------------------
Shared Hosting DataBase Management
MYSQL----------|
PHP My-Admin   |
---------------|
Run as Webservice
--------------------------------------
MSSQL DataBase Management Tool
My Little-Admin
---------------------------------------
DataBase Collection
--------------------
Language of differnet Conutry
-----------------------------
DataBase User Role

------------------
MYSQL = Root
MSSQL = Alias
-------------
DataBase Permission
-------------------
MYSQL   MSSQL
-----   -----
Read    DB_Writer
Write   DB_Admin
GrantAll DB_Reader
----------------->
___________________________________________________________
IIS/Apache Permission
Run and Execute Throught under user
-----------------------------------
IIS level two of permission
1, IIS anonymous user
2, IIS Worker Process user
When we create new website in IIS Create automatically under user's
these users different for any anonymous website
-----------------------------------------------
IIS Anonymous for
-----------------|
HTML/PHP/Perl    |
-----------------|
------------------
IIS Worker Process for
---------------------|
ASP.NET/MVC          |
---------------------|
---------------------
Apache Permission's
-------------------
HTML | Under User
NoBody
------------------|
PHP/MYSQL/Perl/Cgi|
------------------|
domainname.com
under hostname user for
Apache
---------------------------->
DNS Zone
--------
Types of Dns Zones
------------------|
A Records         |
CName Records     |
MX Records        |
NS Records        |
------------------|
System Ports
-------------------
DNS Port 53
MYSQL Prot 3801
SMTP Port 25
POP3 Port 110
WebServer Http or Https port 80, 443
https plesk port 8443
http plesk port 8880