References on SQL database

Introduction to SQL

--SQL is a standard language for accessing and manipulating databases.

What is SQL?

  1. SQL stands for Structured Query Language
  2. SQL lets you access and manipulate databases
  3. SQL is an ANSI (American National Standards Institute) standard
  4. What Can SQL do?
  5. SQL can execute queries against a database
  6. SQL can retrieve data from a database
  7. SQL can insert records in a database
  8. SQL can update records in a database
  9. SQL can delete records from a database
  10. SQL can create new databases
  11. SQL can create new tables in a database
  12. SQL can create stored procedures in a database
  13. SQL can create views in a database
  14. SQL can set permissions on tables, procedures, and views
  15. SQL is a Standard - BUT....
> Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language.

> However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note Note:  Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

Using SQL in Your Web Site

To build a web site that shows data from a database, you will need:

An RDBMS database program (i.e. MS Access, SQL Server, MySQL)

To use a server-side scripting language, like PHP or ASP
To use SQL to get the data you want
To use HTML / CSS
RDBMS
RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables.



A table is a collection of related data entries and it consists of columns and rows.

Comments

Post a Comment

Popular posts from this blog

Advantages and disadvantages of USE CASE diagram

ADVANTAGES The use cases are mainly composed of narrative text. Hence, unlike many other modeling techniques, the non technical stake holders (e.g. customers, end users, salesperson etc) are also able understand the model for the software system. This means that feedback can be obtained at a very early stage of the development from the customers and the end users. Another major advantage of use case modeling is that it requires the identification of exceptional scenarios for the use cases. This helps in discovering subtle alternate requirements in the system. The use case model can be utilized in several other aspect of software development as well, e.g. Cost Estimation, Project Planning, Test Case Preparation and User Documentation. The use case diagram provides a comprehensive summary of the whole software system in a single illustration. DISADVANAGES  They do not capture the non-functional requirements easily. There might be a learning curve for the developer and/or
Read more

Microsoft Toolkit 2.5.4 Windows and Office Activation

Image
Did you ever get in trouble for activation key of windows or office because that is already on the block? If the answer is yes, maybe Microsoft Toolkit can help you, if the answer is no, this article can be used as an additional information that may be useful in the days to come. So, the above problem can be solved by using one of the activation tools available in the market. Temporary  disable   your  Anti-Virus protection . ( Some of virus guard will never allow MS Toolkit to modify system registry and activate any Microsoft product !) Download Microsoft Toolkit 2.5.4 From  Here . Unzip and install. Choose the product you want to get activated and wait a few seconds. Restart your PC and enjoy a fully activated Office/Windows. Re enable your Anti-Virus protection. Why the toolkit? Microsoft toolkit is a combination of all activators. Auto KMS and EZ activator modules are built in to provide a perfect activation algorithm. Also toolkit support manually call activat
Read more

How to Set Up a Counter Strike LAN Game

Three Methods:Counterstrike 1.6CS:GOCS:Source If you've got a big LAN party coming up, or maybe an extra computer lying around the house, try turning it into a dedicated server for painless LAN gaming. Follow this guide to get your dedicated server running, and your LAN gaming underway. Ad Method 1 of 3: Counterstrike 1.6 1 Register for a dedicated server account on Steam. You will need to run your dedicated server from a separate account, or you will not be able to connect to your own server. You do not need to add any games to this account, the game files are not necessary to run the server. Ad 2 Install Half-Life Dedicated Server. This program can be found by clicking the Library menu in Steam, and selecting Tools from the dropdown menu. Browse the list for Half-Life Dedicated Server (HLDS). The server program will require about 750MB of hard disk space. Half-Life Dedicated Server is provided free, even if there are no Half-Life purchases on the account. 3 Run t
Read more