Introduction of DBMS

 03 Sep  Admin

  • Introduction of DBMS

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.

Characteristics of DBMS

  • Provides security and removes redundancy
  • Self-describing nature of a database system
  • Insulation between programs and data abstraction
  • Support of multiple views of the data
  • Sharing of data and multiuser transaction processing
  • DBMS allows entities and relations among them to form tables.
  • It follows the ACID concept ( Atomicity, Consistency, Isolation, and Durability).
  • DBMS supports multi-user environment that allows users to access and manipulate data in parallel.

What is the need of DBMS?

Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.

Purpose of Database Systems

The main purpose of database systems is to manage the data. To manage the data we need to store this data somewhere where we can add new data, delete unused data, update outdated data, retrieve data.

Read More

Links

03 Sep Admin

?? link ??? text ?? image ???? ?? ??? ?? click ???? ?? ?? ????? page ?? redirect ?? ??? ???? ??? ?? ?? ?? ???? link ?? ???? cursor ?? ???? ?? ?? ?? ?? clickable hand icon ??? convert ?? ???? ??? Links ?? ????? basically ?? page ?? ????? page ?? ???? ?? ??? ???? ???? ??? Links web ?? ?????? ?? roads ???? ???  

HTML ??? link create ???? ?? ??? tag ???? ???? ???? ??? ??? anchor tag ??? ???? ??? ?? tag ?? ???? basic attributes href ?? target ???? ??? ?? ????? attributes ?? ???? ??? ???? ????? ??? ??? 

href 

?? attribute ?? ?????? ?? ?? page ?? address define ???? ?? ?? ?? link ?? click ???? ?? show ???? ????? ???  

href = “page-Address”

target 

target – ?? attribute ?? ?????? ?? ?? frame define ???? ?? ???? ?? ?? page ?? ???? ????? ??? ?? attribute optional ???? ??? ??? ?? ??? define ???? ???? ?? ?? page new tab ??? open ???? ??? ?? attribute ?? ??? predefined values ???? ?? ??????? ?? use ?? ???? ???? 

target = “frame-Name”
  • _blank – ?? ?? ?? value define ???? ?? ?? ???? webpage new tab ?? window ??? open ???? ??? 
  • _self – ?? ?? ?? value define ???? ?? ?? ???? webpage ??? tab ?? frame ?? open ???? ?? ?????? link ?? click ???? ??? ??? 
  • _parent – ?? value webpage ?? parent frame ??? open ???? ??? 
  • _top – ?? value ?? ?????? web page full document ??? open ???? ??? 
  • customFrame – ?? ??? ?? ?? ??? frame define ?? ???? ??? ??? ???? ?? webpage ??? ?? open ?????                  

Creating links in HTML 

???? ?? ???? ???? ????? ?? HTML ?? ?????? link create ???? ?? ??? ?? tag ???? ???? ??? ???? ?? ??? ???? ??? ???? ???? ???? ?? ?? ????? ???? ???? ???? ?? tag ?? normal structure ????? ???      

Links ?? ?? ???? page ?? according configure ?? ?? ???? ??? ???? ?? ?? apply ?? ???? ?? ?? ?? ?? ??? link ?? mouse ?? ???? ?? ???? color green ?? ???? ?? mouse ????? ?? red ?? ????? ?? ?? ?? style tag ?? ?????? ?? ???? ??? ???? ??? ?? a ?? ??? condition colon ????? define ???? ??? ???? ???? ??? ???? ???? ?? ??? ??? ???? ?????? ?? CSS ???? tutorials ??? ??? ???? ???  Condition Explanation  a:link?? condition ??? link first time web page ?? show ???? ???  a:visited?? condition ??? link ???? visit ?? ?? ???? ???? ???  a:hover?? condition ??? link ?? cursor ?? ???? ???? ???  a:active?? ?? ???? link ?? click ???? ?? ?? ?? link active ???? ???
Read More

Styling HTML Text

03 Sep Admin

Text ?? style ???? ?? ??? ???? ?? ???? color change ???? ?? font family change ???? ??? ?? ??? CSS ?? ???? ???? ???? ??? 

Changing text color 

???? ?? tag ?? text ?? color change ???? ?? ??? ?? CSS ?? color property ???? ???? ??? ?? ???? ??? colon ????? color ?? ??? ???? ??? 

<p style=”color:red”>This text will be red. </p>


Changing font family 

Text ?? font family change ???? ?? ??? ?? font family property ???? ???? ?? ?? value ?? ??? ??? font family ?? ??? ???? ???
 

<p style=”font-family:Arial”> This text will be in Arial </p>

Changing text size 

Text ?? size change ???? ?? ??? ?? font size property ???? ???? ?? ?? value ?? ??? ??? ?? size ?? ????? ?? ?? ???? ???
 

<p style=”font-size: 45″> This size is changed by style tag. </p>

Changing text position 

Text ?? position change ???? ?? ??? text align property ???? ?? ???? ?? ?? value ?? ??? ??? ?? left, right ?? center pass ?? ???? ???
 

<p style=”text-align:center”> This position is change by style tag</p>
Read More

Attributes

03 Sep  Admin

Attributes ?? ?????? ?? tags ?? ???? according configure ?? ???? ??? Attributes ?? ????? starting tag ??? define ???? ???? ??? ????? define ???? ?? ?????? ???? ???? ?? ??? ??? ????? ?? HTML tags ???? ?? ?? ???? attributes ???? ??? ?? name ?? value ?? pair ??? ???? ???? ???

<tagName attrName=”value”> some text here.</tagName>


Common HTML attributes 

Attributes advanced configuration ?? ??? ???? ???? ???? ??? ???? ?? ?? default page background ???? ????? ?? ???? ???? according change ?? ???? ??? ??? ?? ?? ??? default text color ???? ????? ?? ?? ??? ?? change ?? ???? ??? Attributes ?? ???? ???? ???? ?? simple ??? ?? ???? ??? ???? ????? ?? ????? attribute ??? ??? ???? ???? ??? 

???? ???? HTML ??? commonly ???? ???? ???? attributes ?? list ?? ?? ??? ???  

 Attribute Explanation  Example  

 id  
HTML document ??? ???? tag ?? uniquely identify ???? ?? ??? id attribute ???? ???? ???? ??? ?????? 2 tags ?? id same ???? ?? ???? ???    
 <p id=”mypara”> 

 class 
?? attributes tags ?? ??? ??? class ??? categories ???? ?? ??? ???? ???? ???? ??? ???? ?? tags ?? class ?? ?? ???? ??? 
 <h1 class=”java”> 

 title  
???? tag ?? tittle ???? ???? ?? ??? title attribute ???? ???? ???? ???   
 <p title=”Hello”> 

 style 
?? attribute ?? ?????? ?? tag ?? style rules apply ?? ???? ???   <p style=”color:red”>  
Read More

Simple HTML program

3 Sep   Admin

My Page

My First Web Page

 
Tag  Explanation  
<html> </html>???? ?? HTML file ?? ?????? ??? tag ?? ?? ???? ??? ?? tag ??????? ?? ?? ?? file ?? HTML file ??? ???? ??? tags ?? tag ?? ???? ??? ??? ?? tag program ??? ???? ???? ??? close ???? ???? ???       
 <head></head>?? tag ??? document ?? ???? ??? information ???? ??? ??? ?? ??? ???? web page ??? script apply ???? ?? ?? ?? ?? ??? tag ?? ???? define ?? ???? ??? ?? tag ????? HTML tag ?? ???? ??? ???     
 <title></title>?? tag ?? ?????? web page ?? title display ???? ???? ??? ?? tag ????? head tag ?? ???? ??? ???     
<body></body>?? ?? text body tag ??? ???? ??, program ?? interpret ???? ?? ??? ??? display ???? ???? ??? ?? tag head tag ?? close ???? ?? ??? ??? ??? ???    
Read More

HTML tags

03 Sep Admin

?? HTML file tags ?? text ?? combination ???? ??? HTML tags ?? HTML elements ?? ??? ???? ??? ??? ???? tags ?? concept ??? ? ???? ?? ?? HTML ????? ?? ??? ???? ??? Basically tag ?? ????? ?? ?? text ?? ??? ???? ???? ???

?? tag ?? specific purpose define ???? ??? ?? task ?? ??? ??? ??? tags ????? ?? ??? ???? ?? tag ?? 2 part ???? ??? Opening tag ?????? ??? ????? ???? ??? ???? interpreter ?? ?? ??? ?? ???? ?? ?? ?? ???? ???? ???? ??? Opening tag ?? ??? ?? text ???? ???? ?? ??? ?? ?? tag apply ?? ??? ??? ???? ??? closing tag ???? ???? ???

Closing tag ?? interpreter ?? ??? ???? ?? ?? ?? tag ?? ????? ???? ?? ??? Closing tag ?? opening tag ?? differentiate ???? ?? ??? closing tag ??? forward slash ????? ???? ??? Tags ?? basic structure ???? ???? ?? ??? ???
 

<tagName>   text   </tagName>
Read More

HTML versions

03 Sep  Admin

?? ?? HTML ?? ???? ?? version industry ??? ? ???? ?? ???? ???? ??? ???? ???? ?? ??? ??? 
 

HTML 1.0 

?? HTML ?? ???? version ??? ?? ??? ???? ?? ??? ?? language ?? ???? ??? ????? ?? ?? HTML ?? ???? limited ??? 

HTML 2.0 

?? version ??? HTML 1.0 ?? ??? features ??? ?? version ?? ??? ?? HTML website develop ???? ?? ???????? ?????? ?? ???? ???

HTML 3.0

?? version ?? ??? ?? HTML ???? popular ?? ???? ??? ?? version ??? browsers ?? ??? compatibility problem ???? ?? ??? ?? ?? version ?? ??? ???? ??? ??? 

HTML 3.2 

?? version ??? ????? version ?? ??? ??? ?? tags add ???? ??? ?? ?? time ?? ?? W3C ?? website development ?? ??? HTML ?? standard ????? ???? ???  

HTML 4.01

?? version ??? ??? ?? tags ?? ??? ?? cascading style sheet ?? ?? introduce ???? ??? ??? ?? ??? HTML ???? ??? modern language ?? ???? ??|

HTML 5.0

?? HTML ?? latest version ??? ????? multimedia support ?? ??? ??? ?? tags provide ???? ?? ??? HTML5 ?? ???? ??? ?? ???? ??????? ?? HTML5 in Hindi tutorial ?? ??????? ?? ???? ???  

XHTML

?? version HTML 4.01 ?? ??? ??? ??? ????? HTML ?? ??? XML ?? add ???? ??? ???    

Read More

CSS ─ Syntax

A CSS comprises of style rules that are interpreted by the browser and then applied to the corresponding elements in your document. A style rule is made of three parts:

Selector: A selector is an HTML tag at which a style will be applied. This could be any tag like or etc.

Property: A property is a type of attribute of HTML tag. Put simply, all the HTML attributes are converted into CSS properties. They could be color, border, etc.

Value: Values are assigned to properties. For example, color property can have the value either red or #F1F1F1 etc.

Syntax– selector { property: value }

Example: You can define a table border as follows:
table{ border :2px solid #C00; }

Here table is a selector and border is a property and the given value 2px solid #C00 is the value of that property.

Read More

Advantages of CSS

  • CSS saves time – You can write CSS once and then reuse the same sheet in multiple HTML pages. You can define a style for each HTML element and apply it to as many web pages as you want.
  • Pages load faster – If you are using CSS, you do not need to write HTML tag attributes every time. Just write one CSS rule of a tag and apply it to all the occurrences of that tag. So, less code means faster download times.
  • Easy maintenance – To make a global change, simply change the style, and all the elements in all the web pages will be updated automatically.
  • Superior styles to HTML – CSS has a much wider array of attributes than HTML, so you can give a far better look to your HTML page in comparison to HTML attributes.
  • Multiple Device Compatibility – Style sheets allow content to be optimized for more than one type of device. By using the same HTML document, different versions of a website can be presented for handheld devices such as PDAs and cellphones or for printing.
  • Global web standards – Now HTML attributes are being deprecated and it is being recommended to use CSS. So it’s a good idea to start using CSS in all the HTML pages to make them compatible with future browsers.
Read More

Introduction of Css

Cascading Style Sheets, fondly referred to as CSS, is a simple design language intended to simplify the process of making web pages presentable.
CSS handles the look and feel part of a web page. Using CSS, you can control the color of the text, the style of fonts, the spacing between paragraphs, how columns are sized and laid out, what background images or colors are used, as well as a variety of other effects.
CSS is easy to learn and understand but it provides a powerful control over the presentation of an HTML document. Most commonly, CSS is combined with the markup languages HTML or XHTML.

Read More