Learning SQL

Learning SQL is an introductory guide to SQL, the language used to work with data in a database. It is written for people who want to write database applications, carry out administrative tasks, or produce reports. Each chapter is a self-contained lesson on one key idea or technique, with illustrations and annotated examples. The book moves from the basics to several advanced features. Along the way it covers data statements, schema statements, queries and subqueries, built-in functions, and conditional logic. Exercises at the end of every chapter let readers practise what they have learned.

Why You Should Read?

• Learn how to use SQL data statements to generate, manipulate, and retrieve the data stored in a database.
• Create database objects such as tables, indexes, and constraints by using SQL schema statements.
• Understand how data sets interact with queries and why subqueries are so important.
• Practise each new skill with the exercises at the end of every chapter, after studying the annotated examples.