MZANSI AND UNAJIMU

SQL Tutorial ❮ Home Next ❯ SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teac...

TUTORIAL HOME SQL Quick Reference From Omegas ❮ Previous Next ❯ SQL Statement Syntax AND / OR SELECT column_name(s) FROM table_name WHERE co...

Toggle navigation TUTORIAL HOME SQL Quiz ❮ Previous Next ❯ You can test your SQL skills with Omegas' Quiz. The Test The test contains 25...

Toggle navigation TUTORIAL HOME SQL General Data Types ❮ Previous Next ❯ A data type defines what kind of value a column can contain. SQL Ge...

Toggle navigation TUTORIAL HOME SQL Data Types for Various DBs ❮ Previous Next ❯ Data types and ranges for Microsoft Access, MySQL and SQL S...

Toggle navigation TUTORIAL HOME SQL Operators ❮ Previous Next ❯ SQL Arithmetic Operators Operator Description Example + Add Try it - Subtrac...

Toggle navigation TUTORIAL HOME SQL Date  Functions ❮ Previous Next ❯ MySQL Date Functions The following table lists the most important buil...

Toggle navigation TUTORIAL HOME SQL NULL  Functions ❮ Previous Next ❯ SQL ISNULL(), NVL(), IFNULL() and COALESCE() Functions Look at the fol...

TUTORIAL HOME SQL Hosting ❮ Previous Next ❯ SQL Hosting If you want your web site to be able to store and retrieve data from a database, you...

Toggle navigation TUTORIAL HOME SQL Functions ❮ Previous Next ❯ SQL has many built-in functions for performing calculations on data. SQL Agg...

Toggle navigation TUTORIAL HOME SQL Views ❮ Previous Next ❯ SQL CREATE VIEW Statement In SQL, a view is a virtual table based on the result-...

Toggle navigation TUTORIAL HOME SQL Injection ❮ Previous Next ❯ An SQL Injection can destroy your database. SQL in Web Pages In the previous...

Toggle navigation TUTORIAL HOME SQL DROP TABLE  Statement ❮ Previous Next ❯ The SQL DROP TABLE Statement The DROP TABLE statement is used to...

Toggle navigation TUTORIAL HOME SQL AUTO INCREMENT  Field ❮ Previous Next ❯ AUTO INCREMENT Field Auto-increment allows a unique number to be...

Toggle navigation TUTORIAL HOME SQL GROUP BY  Statement ❮ Previous Next ❯ The SQL GROUP BY Statement The GROUP BY statement is often used wi...

Toggle navigation TUTORIAL HOME SQL CREATE INDEX  Statement ❮ Previous Next ❯ SQL CREATE INDEX Statement The CREATE INDEX statement is used ...

Toggle navigation TUTORIAL HOME SQL DEFAULT  Constraint ❮ Previous Next ❯ SQL DEFAULT Constraint The DEFAULT constraint is used to provide a...

TUTORIAL HOME SQL FOREIGN KEY Constraint ❮ Previous Next ❯ SQL FOREIGN KEY Constraint A FOREIGN KEY is a key used to link two tables togethe...

Toggle navigation TUTORIAL HOME SQL CHECK  Constraint ❮ Previous Next ❯ SQL CHECK Constraint The CHECK constraint is used to limit the value...

Toggle navigation TUTORIAL HOME SQL NOT NULL  Constraint ❮ Previous Next ❯ SQL NOT NULL Constraint By default, a column can hold NULL values...