Structured Query Language (SQL)

A brief background to SQL

SQL is the standardised language for database management. SQL started in the early seventies It was actually invented by a DR E Codd, who described a model for Relational Databases. The product was developed further by IBM. Other companies also brought their own Relational Database Management Systems to the market, amongst others, Oracle and Ingress. IBM later released DB2.

Today SQL is a standard, open language. It is widely implemented in many Database Management Systems. It has no direct corporate ownership. The commercial acceptance of SQL required a set of standards. These are set out in the ANSI (American National Standards Institute) standard SQL 99.

SQL compliant with this standard is referred to as ANSI SQL

Many vendors add their own features to the implementation of SQL in their Database Management Systems. Though many of these additional features are powerful, they impact on the portability of the product. It is therefor advisable to stay as close to ANSI-SQL (pure sql) as is possible.

Today some of the major players in the SQL market are

• IBM - DB2
• Microsoft (SQL Server)

Others include Oracle, Computer Associates and Sybase.

Learn SQL scripting and programming

We offer a number of SQL resources to help you master this universal language.

• SQL Examples and Tutorials
• SQL Powerbuilder implementation
• SQL Ebook
• Other resources

Some Utility Resources

It is always great to have a nifty text editor for coding, whether it be program script or HTML script. The one i like is EditPad Pro. The lighter version is available for free and you can download it here

Download EditPad Lite

Another product i find useful is Active Ebook Compiler. I use it to write manuals and ebooks. The generated executable files can then be distrubuted to users.

Tell me more about Active Ebook Compiler