Yorkville High School Computer Science Department
Yorkville High School Computer Science Department on Facebook  Yorkville High School Computer Science Department Twitter Feed  Yorkville High School Computer Science Department on Instagram

Yorkville High School Computer Science

ASSIGNMENTS: No Current Assignments

Web Design II for Developers :: Lessons :: SQL

SQL

SQL is a non-procedural langauge used to access information from a database. You will be using a version of SQL called MySQL in this class.

Complete the following tutorials from the W3Schools website. You should take no more than four class periods to do so.

SQL Intro
SQL Syntax
SQL Select
SQL Select Distinct
SQL Where
SQL And, Or, Not
SQL Order By
SQL Insert Into
SQL Update
SQL Min and Max
SQL Count, Avg, and Sum
SQL Like
SQL Wildcards
SQL In
SQL Between
SQL Joins
SQL Inner Join
SQL Create Database
SQL Create Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Index
SQL Auto Increment

PHP and SQL

SQL Quiz

Yorkville High School Computer Science Department on Facebook Yorkville High School Computer Science Department Twitter Feed Yorkville High School Computer Science Department on Instagram