Due to popular demand we have made our SQL Course public! The first course will be 22nd – 24th February 2012 in Brighton. Call us on 01273 622272 for more details.
SQL stands for Structured Query Language.
SQL is an ANSI (American National Standards Institutes) standard that allows you to access and manage relational database management systems (RDBMS).
You can use SQL to update and retrieve data from a database using commands such as ‘Select’, ‘Insert, ‘Update’, ‘Drop’, ‘Delete’ and ‘Create’.
There are a number of common database management systems that use SQL, you may use one without actually understanding what SQL is!
These are the most common RDBMS database programs:
- MySQL
- Microsoft SQL Server
- Microsoft Access
- Oracle
So, SQL is a language used for accessing and modifying databases, but what can you use it for?
You can use SQL to:
- Delete records
- Execute queries
- Insert records
- Retrieve data
- Set permissions on tables, procedures, and views
- Update records in a database
With SQL you can create:
- Databases
- Stored procedures in a database
- Tables within databases
- Views in a database
SQL language is sub-divided into a number of language elements. These include:
- Clauses - components of statements and queries
- Expressions - produce scalar values or tables consisting of columns and rows of data
- Predicates - used to specify conditions that can be evaluated to three-valued lgoic or Boolean truth values and are used to limit the effects of statements and queries or change program flow
- Queries - the most important use of SQL, these are used to retrieve data
- Statements - these may control program flow, sessions, transactions, connections or diagnostics
SQL language can be tricky to master as it operates differently within different database management systems. Our SQL training course is great for learning all about SQL and how to use it. The three day course combines theory with hands-on, practical sessions including exercises to provide delegates with a working knowledge of SQL.
Why learn SQL?
Why should you consider SQL Training? Read the rest of "What is SQL?"
