SQL stands for Structured Query Language. SQL is a standard language that was designed to query and manage data in relational database management systems (RDBMS). An RDBMS is a database management system that is used today in every type of desktop or web-based application.

MySQL is one of the most popular RDBMS used today and a solid understanding of SQL is critical if you want to have a successful career in web development.

This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, students will understand SQL functions, join techniques, database objects and be able to write queries and stored procedures.

Applicable Job Roles: web programmers, web application developers, database administrator, webmasters, and web project managers.

Course Objectives:

• Overview of MySQL and PHPMyAdmin
• Understand basic concepts of how a database stores information via tables
• Understanding of SQL syntax used with MySQL
• Learn how to retrieve and manipulate data from one or more tables
• Know how to filter data based upon multiple conditions
• Updating and inserting data into existing tables
• Learning how the relationships between tables will affect the SQL.
• The advantages of store procedures with storing data using variables and functions.
• How SQL can be used with programming languages like PHP to create dynamic websites for visitors.
• Review of some sample PHP projects interacting with MySQL.

• Review of MySQL and PHPMyAdmin
• Setting up your sample database and tables
• SQL Overview
• SELECT statement review
  • Filtering your data with WHERE clause
  • ORDER By clause
  • Selecting all columns

• Elements of SELECT
  • Operators of WHERE clause (=, <>, >, <, BETWEEN, LIKE, IN)
  • DISTINCT keyword
• AND & OR keywords
• Column Aliasing
• In and Between
• Updating Tables
  • UPDATE statement
  • INSERT INTO statement

• Cross Joins
• Inner Joins
• Outer Joins

• Understanding the differences between a sub query and a join
• Functions
  • Min()
  • Max()
  • Sum()
  • Now()
  • Avg()

• Variables
• Stored Procedures

• PHP basic syntax
• Executing SQL commands from PHP code.
• Sample PHP projects