An edition of SQL in easy steps
(2005)
SQL in easy steps
by Mike McGrath
Share
×Close
This guide instructs the reader how to create and administer databases using SQL. SQL is the standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux.
Check nearby libraries
Buy this book
Previews available in: English
| Edition | Availability |
|---|---|
1
|
aaaa
|
Book Details
Table of Contents
1. Introducing SQL : What is SQL? ; Making SQL queries ; Installing MySQL on windows ; Installing MySQL on Linux ; Installing an ODBC driver ; Microsoft query tool
2. Getting started with SQL : Introducing databases ; Exploring databases ; Creating a database ; Deleting a database ; Running SQL scripts in MySQL
3. Creating database tables : Exploring database tables ; Creating a table ; Deleting a table ; Table data types ; Table field modifiers ; Setting the primary key ; Altering a table
4. Inserting data into tables : Inserting complete rows ; Including a columns list ; Inserting selected data ; Updating data ; Changing specific data ; Deleting data
5. Retrieving data from tables : Retrieving a column ; Retrieving multiple columns ; Retrieving a row ; Copying retrieved data ; Inserting multiple selected fields
6. Sorting retrieved data : Sorting a column ; Sorting multiple columns ; Sorting by column position ; Setting the sort direction
7. Simple data filtering : Making comparisons ; Comparing a single value ; Comparing a range of values ; Seeking non-matches ; Finding null values
8. Complex data filtering : Comparing multiple values ; Comparing alternative values ; Comparing alternative lists ; Specifying the evaluation order ; Matching strings ; Matching characters ; Matching regular expressions
9. Generating calculated fields : Concatenating fields ; Trimming padded spaces ; Using aliases ; Making arithmetical calculations
10. Manipulating data : Introducing functions ; Text functions ; Numeric functions ; Date and time functions ; System functions
11. Grouping table data : Finding summary values ; Counting rows ; Discovering total values ; Working with distinct values ; Creating data groups ; Filtering grouped data ; Sorting filtered group data
12. Making complex queries : Using sub-queries ; Sub-query calculated fields ; Combining queries ; Handling duplicate rows ; Sorting combined query results
13. Joining database tables : What are joins? ; Creating a join ; Joining multiple tables ; Creating self joins ; Creating natural joins ; Creating outer joins
Appendix : SQL statements
SQL reserved words.
Edition Notes
"Data storage & manipulation for Windows and Linux"--Cover.
Classifications
The Physical Object
ID Numbers
Community Reviews (0)
Feedback?
| September 16, 2021 | Edited by ImportBot | import existing book |
| May 9, 2021 | Created by ImportBot | import new book |