Sunday 23 December 2012

SQL Tutorial

SQL stands for  Structured Query Language is a special-purpose programming language designed for managing data in relational database management systems (RDBMS).
Originally based upon relational algebra and tuple relational calculus, its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
If one has knowledge of SQL then h/she can work any type of database package running in market becouse  SQL is supported by all DBMS software. So if you have knowledge of SQL then no need to worry what type of Database we have to use chilllll have a look.SQL statement are divide in three part
  • DML (Data Manipulation Language )
  • DDL ( Data Definition Language ) 
  • DCL (Data Control Language )

Tuesday 18 December 2012

News Ticker

News are a very import part of every organization. There are many types of news in any organization which need to be print in a impressive manner because It has to attract person to read news.In web development there are many way to print news but my idea is tricky.You can make your news ticker with the help of flat HTML tag no need to use any other specific software.I use MARQUEE ,DIV,TABLE to implement it take a look 


HTML Code

 <table>
        <tr>
            <td style="background-color:Aqua">News Ticker</td>
        </tr>
        <tr>
            <td style="border:solid aqua 1px">
                <div style="width:200px;height:200px">
                    <marquee direction="up" onmousemove="this.stop()" onmouseout="this.start()"  scrollamount="2">
                        <a href="#">Girfa Help</a> <br /><br />
                        <a href="#">Girfa Help</a> <br /><br />
                        <a href="#">News Three </a> <br /><br />
                        <a href="#"> Insert your news here </a><br />
                    </marquee>
                </div>
            </td>
        </tr>
    </table>

Tuesday 11 December 2012

Sorting

In computer science, a sorting algorithm is an algorithm that puts elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. Efficient sorting is important for optimizing the use of other algorithms (such as search and merge algorithms) that require sorted lists to work correctly; it is also often useful for canonicalizing data and for producing human-readable output. More formally, the output must satisfy two conditions:
  1. The output is in nondecreasing order (each element is no smaller than the previous element according to the desired total order);
  2. The output is a permutation (reordering) of the input.