LEARNING SQL
Product Description
Updated for the stylish database direction systems — including MySQL 6.0, Oracle 11g, and Microsoft’s SQL Server 2008 — this preceding pass module intend you up and streaming with SQL quickly. Whether you requirement to indite database applications, action administrative tasks, or create reports, Learning SQL, Second Edition, module support you easily officer every the SQL fundamentals. Each chapter presents a self-contained warning on a key SQL construct or technique, with numerous illustrations and annotated examples. Exercises at the modify of apiece chapter permit you training the skills you learn. With this book, you will:
- Move apace finished SQL principle and see individual modern features
- Use SQL accumulation statements to generate, manipulate, and regain data
- Create database objects, much as tables, indexes, and constraints, using SQL plan statements
- Learn how accumulation sets interact with queries, and see the grandness of subqueries
- Convert and cook accumulation with SQL’s built-in functions, and ingest contingent system in accumulation statements
Knowledge of SQL is a staleness for interacting with data. With Learning SQL, you’ll apace see how to place the noesis and plasticity of this module to work.