SQL in easy steps
By: Mike McGrath
Series: In easy steps; In easy steps
Publisher: Computer Step
Published: 2005
Place of publication: Southam, Warwickshire
Language: eng
Number of pages: 192
ISBN-13: 9781840782967
Subjects: SQL (Computer program language); Relational databases; Database management
Description: 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.
Notes: "Data storage & manipulation for Windows and Linux"--Cover.
Table of contents: title: 1. Introducing SQL : What is SQL? ; Making SQL queries ; Installing MySQL on windows ; Installing MySQL on Linux ; Installing an ODBC driver ; Microsoft query tool; title: 2. Getting started with SQL : Introducing databases ; Exploring databases ; Creating a database ; Deleting a database ; Running SQL scripts in MySQL; title: 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; title: 4. Inserting data into tables : Inserting complete rows ; Including a columns list ; Inserting selected data ; Updating data ; Changing specific data ; Deleting data; title: 5. Retrieving data from tables : Retrieving a column ; Retrieving multiple columns ; Retrieving a row ; Copying retrieved data ; Inserting multiple selected fields; title: 6. Sorting retrieved data : Sorting a column ; Sorting multiple columns ; Sorting by column position ; Setting the sort direction; title: 7. Simple data filtering : Making comparisons ; Comparing a single value ; Comparing a range of values ; Seeking non-matches ; Finding null values; title: 8. Complex data filtering : Comparing multiple values ; Comparing alternative values ; Comparing alternative lists ; Specifying the evaluation order ; Matching strings ; Matching characters ; Matching regular expressions; title: 9. Generating calculated fields : Concatenating fields ; Trimming padded spaces ; Using aliases ; Making arithmetical calculations; title: 10. Manipulating data : Introducing functions ; Text functions ; Numeric functions ; Date and time functions ; System functions; title: 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; title: 12. Making complex queries : Using sub-queries ; Sub-query calculated fields ; Combining queries ; Handling duplicate rows ; Sorting combined query results; title: 13. Joining database tables : What are joins? ; Creating a join ; Joining multiple tables ; Creating self joins ; Creating natural joins ; Creating outer joins; title: Appendix : SQL statements; title: SQL reserved words.