SQL (Structured Query Language) - Microsoft SQL Server - Software/Programming/Technologies - Freelance Database Systems and Web Developer I am a Freelance Microsoft Access Database and WEB Systems Developer/Programmer specialising in Database Development, Access, SQL, Foxpro. Design, Programming and Development of both local network and Internet based applications. +44 (0)20 8123 0528  

E-mail: admin@dennismcdermott.co.uk  
Home - About Me - Clients and Projects - Training - Software/Programming/Technologies - Hosting - Websites - Testimonials - Contact
 

Software / Programming Languages / Technologies

I am experienced in the following Software, Programming Languages and Technologies

Please select a Software package, Programming Language or Technology.


 
  Access 2013, 2010, 2007, 2003, 2002, 2000, 97
[View Access Projects]

ADO (ActiveX Data Objects)
Adobe Acrobat
ASP (Active Server Pages)
Auto IT
Clipper
Coral 66
CSS (Cascading Style Sheets)
dBaseIII+
Documentation
DOS Batch programming
FoxPro for DOS
General Office Software
HTML
Internet / Web Software
JavaScript
ODBC (Open Database Connectivity)
OLE DB
Operating Systems
Q&A
SQL (Structured Query Language)
VBA (Visual Basic for Applications)
VBScript
VB (Visual Basic)
VDS (Visual Dialogscript)
VFP (Visual Foxpro)
WAP (Wireless Application Protocol)
XML (Extensible Markup Language)
SQL (Structured Query Language)

SQL

Many people think that Microsoft SQL Server is SQL, this is not the case.

SQL is a special-purpose, nonprocedural language that supports the definition, manipulation, and control of data in relational database management systems. It's a special-purpose language, because you can use it only for handling databases; you can't write general-purpose applications with it. (To write an application, you have to embed SQL in some other language, and it's frequently used that way.) That's why SQL is also known as a data sublanguage. A sublanguage can be used with application languages, but it is not a fully-fledged application language. Also, a full-featured application language usually includes semantics for procedures, whereas SQL is nonprocedural. It doesn't specify how something should be done, it just specifies what should be done. In other words, SQL is concerned with results rather than procedures. By far the most important feature of SQL is that it provides access to relational databases.

I have used SQL extensively since the mid 80's, I have used it in FoxPro, Visual Basic, VBA (Visual Basic for Applications) and ASP for controlling Web based data.

 
© Dennis McDermott 2001-2017  -:-  Dennis McDermott is now Bespoke Software Development Limited