Some error occured while loading the Quick View. Please close the Quick View and try reloading the page.
SQL (Structured Query Language) 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.
SQL in easy steps, 4th edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract, and manipulate data.
SQL in easy steps, 4th edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is suitable for those with little or no experience of SQL. This book will appeal to all who need a fundamental understanding of database administration with SQL:
Free, downloadable source code is available from our website so you can check the code against your own work, and get started straight away!
- Introducing SQL
- Getting Started
- Creating Database Tables
- Inserting Data into Tables
- Retrieving Data from Tables
- Sorting Retrieved Data
- Simple Data Filtering
- Complex Data Filtering
- Generating Calculated Fields
- Manipulating Data
- Grouping Table Data
- Making Complex Queries
- Joining Database Tables
- Handy Reference
- Introducing SQL
- What is SQL?
- Make SQL Queries
- Install MySQL on Windows
- Install MySQL on Linux
- Install an ODBC Driver
- Use Microsoft Query Tool
- Summary
- Getting Started
- Introducing Databases
- Explore Databases
- Create a Database
- Delete a Database
- Run SQL Scripts
- Summary
- Creating Database Tables
- Explore Database Tables
- Create a Table
- Delete a Table
- Table Data Types
- Table Field Modifiers
- Set the Primary Key
- Alter a Table
- Summary
- Inserting Data into Tables
- Insert Complete Rows
- Include a Columns List
- Insert Selected Data
- Update Data
- Change Specific Data
- Delete Data
- Summary
- Retrieving Data from Tables
- Retrieve a Column
- Retrieve Multiple Columns
- Retrieve a Row
- Copy Retrieved Data
- Insert Selected Fields
- Summary
- Sorting Retrieved Data
- Sort a Column
- Sort Multiple Columns
- Sort by Column Position
- Set the Sort Direction
- Summary
- Simple Data Filtering
- Make Comparisons
- Compare a Single Value
- Compare a Range of Values
- Seek Non-matches
- Find Null Values
- Summary
- Complex Data Filtering
- Compare Multiple Values
- Compare Alternative Values
- Compare Alternative Lists
- Specify Evaluation Order
- Match Strings
- Match Characters
- Match Regular Expressions
- Summary
- Generating Calculated Fields
- Concatenate Fields
- Trim Padded Spaces
- Adopt Aliases
- Do Arithmetic
- Summary
- Manipulating Data
- Introducing Functions
- Text Functions
- Numeric Functions
- Date and Time Functions
- System Functions
- Summary
- Grouping Table Data
- Find Summary Values
- Count Rows
- Discover Total Values
- Work with Distinct Values
- Create Data Groups
- Filter Grouped Data
- Sort Filtered Group Data
- Summary
- Making Complex Queries
- Using Sub-queries
- Sub-query Calculated Fields
- Combine Queries
- Handle Duplicate Rows
- Sort Combined Results
- Summary
- Joining Database Tables
- What are Joins?
- Create a Join
- Join Multiple Tables
- Create Self Joins
- Create Natural Joins
- Create Outer Joins
- Summary
- Handy Reference