|
| SQL Tutorials-one |
| Tuesday, November 25, 2008 |
Tutorial Section
1) SELECT:
In which we query the BBC country profile table.
2a) More practice with SELECT:
Additional practice of the basic features using a table of Nobel Prize winners.
2b) SELECT in SELECT:
In which we form queries using other queries.
3) SUM and COUNT:
In which we apply aggregate functions. [more the same]
4) The JOIN operation:
In which we join two tables; ttms and country. [previously music tutorial]
5) More JOIN operations:
In which we join actors to movies in the Movie Database.
6) Using Null:
In which we look at teachers in departments. [previously Scottish Paliament]
7) Self join:
In which we join Edinburgh bus routes to Edinburgh bus routes.
Reference Section: how to...
1) SELECT:
How to read the data from a database.
2) CREATE and DROP:
How to create tables, indexes, views and other things. How to get rid of them.
3) INSERT and DELETE
How to put records into a table, change them and how to take them out again.
4) DATE and TIME
How to work with dates; adding, subtracting and formatting.
5) Functions
How to use string functions, logical functions and mathematical functions.
6) Users
How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
7) Meta Data
How to find out what tables and columns exist. How to count and limit the rows return.
Error Messages
Some error messages from SQL engines |
posted by Win Your Dreams @ 8:51 PM  |
|
|
|
|
| About Me |
Mission: To provide the best e-learning portal, which provide the basics to win your dreams
|
| Previous Post |
|
| Archives |
|
| News Links |
|
|
| More from WYD |
| Powered by |
 |
|
Back to Home
Join Us ???
Team Info
Xtras
Gallery
Supporters