Open Web Training

Introduction to SQL

Prerequisites: Some Database Experience; this may from PHP 101 or equivalent.

Title	SQL101: Introduction to SQL
Duration	1 Day
Prerequisites	Some experience with Database This may be gained in the PHP101 course.

SQL (Structured Query Language) is the language used to communicate with Relational Databases such as MySQL, PostGreSQL, SQLite as well as the commercial Oracle and MS SQL Server.

This course covers the basics of managing databases and data using SQL. Variations between popular versions are covered, as well as techniques for extracting and manipulating data.

Students who have done the PHP 101 course will already have covered some elementary SQL, but will benefit from having a more formal and more in-depth understanding of the SQL itself.

Core Technologies

HTML & HTML5More: HTML is language behind every Web Page. Every Web Site is a collection of Web Pages, all of which use the HTML language for their content and markup. Even pages generated using other scripting languages such as PHP are produced using HTML.
CSS & CSS3More: CSS is used to add style to web pages. It can be used to enhance the visual appearance of pages, as well as to add more sophisticated layout and effects.
JavaScriptMore: JavaScript is a language designed to add scripting capabilities to a Web page. While HTML is static (it is designed to display fixed data on a page, and, to some extent to collect data from the user), JavaScript can process or even change the contents of the page.
PHPMore: PHP is the most popular Server Scripting language. It is used to drive many of the largest web sites in the world, and is used to produce dynamic web sites, often driven by a database such as MySQL
SQLMore: SQL (Structured Query Language) is the language used to communicate with Relational Databases such as MySQL, PostGreSQL, SQLite as well as the commercial Oracle and MS SQL Server.