{"id":728,"date":"2013-03-27T09:32:22","date_gmt":"2013-03-26T22:32:22","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=728"},"modified":"2013-03-27T09:32:22","modified_gmt":"2013-03-26T22:32:22","slug":"sql-in-mysql-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/sql-in-mysql-primer-tutorial\/","title":{"rendered":"SQL in MySql Primer Tutorial"},"content":{"rendered":"
\"SQL<\/a>

SQL in MySql Primer Tutorial<\/p><\/div>\n

<\/p>\n

Transcript:<\/p>\n

<\/strong><\/p>\n

SQL is a language designed to find and create and update and delete information from a
\n database.<\/p>\n

Each of the database products such as MySql, SQL Server, Oracle, Access, Advantage
\n and DB2 have their own form of SQL. In Oracle’s case there is a pretty
\n sophisticated extension of SQL called PL\/SQL containing many more logic “smarts”.<\/p>\n

In this tutorial<\/a> we will be looking at MySql SQL using phpMyAdmin interface.<\/p>\n

Major functionality in SQL can be categorized under:<\/p>\n

SELECT
\nINSERT
\nUPDATE
\nDELETE<\/p>\n

… other major bits of functionality fall under …<\/p>\n

CREATE
\nALTER<\/p>\n

… but we will tackle those another day, along with concepts like …<\/p>\n

GRANT
\nDENY<\/p>\n

Let’s go …\n<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n