|
Description: An interactive SQL tutorial using for users of SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access. The turorial includes In introduction to SELECT statements including joins and functions. How to create tables, indexes, views and other things. How to get rid of them. How to put records into a table, change them and how to take them out again. How to work with dates; adding, subtracting and formatting. How to use string functions, logical functions and mathematical functions. How to create users, give them access, get at other peoples tables. How to find processes and kill them.
How to find out what tables and columns exist. How to count and limit the rows return.
|