Structured Query Language (SQL)

A query is a more powerful type of filter that can gather information from multiple table in a relational database. For eg. The query can include field names such as "customer" and "city" from a customer table and "order date" from the order table as follows:

Some database systems provide social windows or forms for creating queries. Because of similar structure of almost all databases, a common type of query language is developed. In mid 1970's a language called Structured English Query Language (SEQUEL) was developed by mainframe database developers. Later SEQUEL was changed to SQL with some improvement in it. SEQUEL and SQL are the English like query language that allow user to query a database without much knowing about the underlying database.

Because SQL is such a powerful tool, most of the PC based DBMS have the SQL query tool but they can have some variation of the SQL with some extra feature added to it. Example of SQL implemented database systems are ORACLE, SYBASE, MYSQL, Microsoft Access etc.

In validation to SQL, PC based database sometime use a query programming language called XBASE. like SQL, XBASE is somewhat English like, but it is more complicated because its command cover the full range of database activities not just queries.

QBE (Query by Example) is another form of query but it uses the graphical interface to query the database. with QBE, we specify the search criteria by typing values or expression into the fields of QBE form or grid.

Basic Structure

SELECT field1, field2, .....

FROM table name

WHERE condition

Query from on table

SELECT name, phoneno

FROM stud_detail

WHERE sec="A"

Query from two tables pub and title

SELECT pub_name, title

FORM pub, title

WHERE pub.pubid = title.pubid

Comments

Important Questions of Data Structure and Algorithm (DSA)

. 1. What is Data structure? Explain different operations to be performed on data structure. 2. Define stack as ADT. Convert P+Q-(R*S/T+U) - V*W into infix expression to postfix. 3. Define Queue. Explain its type with example. 4. Difference between stack and Queue. 5. Difference between Linear Queue and circular Queue. 6. Write an algorithm to enqueue and dequeue data element in a circular queue. 7. Define Linked List. Explain its type. How does double linked List is different from circular linked List. 8. What is recursion and recursive function? write a recursive function to compute Fibonacci number. 9. What is an AVL tree ? Create an AVL tree from the following data: 18, 12, 14, 8, 85, 25, 31, 24, 27 10. Define B-tree? How to insertion and deletions of elements can be done in a B-tree. 11. Create an B-tree from the following Data: ...

BCA Math II old question model solution

. BCA Math II question model 2018: BCA Math II question model 2019: BCA Math II question model 2020:

Define LAN and WAN

. Local Area Network (LAN) A LAN is a network that is used for communicating among computer devices, usually within an office building or home. LAN’s enable the sharing of resources such as files or hardware devices that may be needed by multiple users • • Is limited in size, typically spanning a few hundred meters, and no more than a mile. Is fast, with speeds from 10 Mbps to 10 Gbps. Requires little wiring, typically a single cable connecting to each device. Has lower cost compared to MAN’s or WAN’s. LAN’s can be either wired or wireless. Twisted pair, coax or fiber optic cable can be used in wired LAN’s. Advantages of LAN : The data is transferred at an extremely faster rate in local Area Network. Local area network (LAN) provides higher security. Disadvantages of LAN : Initial cost of installing local area network is quite high. Unauthorized user can access critical data of an organization in case LAN ad...

Computer Engineering

Search This Blog