-
SQL data definition statements allow you to define the structure of database such as tables, rows, columns, indexes...etc. using common SQL statements such as SQL CREATE, SQL ALTER and SQL DROP.
-
SQL statements allow you to manage data such as retrieve, update and delete using common SQL statements including SQL INSERT, UPDATE, DELETE and SELECT statements.
-
Advanced SQL tutorial covers the most common toughest SQL problems you have to deal with in database programming.
-
SQL Stored procedure section shows you how to write SQL stored procedure in Microsoft SQL Server. You can use this methodology to apply in different database vendors including Oracle, MySQL and PostgreSQL...etc.
-
SQL functions section covers common SQL functions including SQL string functions, SQL aggregate functions and SQL mathematical functions.
-
Database triggers are a kind of stored procedure which are invoked automatically by database server when predefined events occurred.
-
Database cursor was invented to work with a set of records which you want to traverse though