FOUNDATION YEARS
GCSE
IB
A LEVEL
LEARN TO CODE
CHALLENGES
ROBOTICS ENGINEERING
MORE
CLASS PROJECTS
Classroom Discussions
Useful Links
SUBSCRIBE
ABOUT US
CONTACT US
FOUNDATION YEARS
GCSE
IB
A LEVEL
LEARN TO CODE
CHALLENGES
ROBOTICS ENGINEERING
MORE
CLASS PROJECTS
Classroom Discussions
Useful Links
SUBSCRIBE
ABOUT US
CONTACT US
FUN WITH CODING
SQL QUICK REFERENCE
IN THIS SECTION
This section cover some of the most popular methods of manipulating, storing and accessing data from a database. Most examples are give using SQLite however the principles apply to SQL with MySQL, SQL Server, MS Access and more.
SQL SELECTION METHODS
SELECT ALL
SELECT DISTINCT
SELECT WHERE
SELECT WHERE, AND, OR, NOT
SELECT MIN AND MAX
SELECT WHERE LIKE and wildcards
select between
SQL INSERT METHOD
SQL UPDATE METHODS
SQL DELETE METHOD
SQL CREATING A DATABASE