Publication date: April 27, 2009 | ISBN-10: 0596520832 ISBN-13 :978-0596520830 | Version: 2
Updated for the latest database management systems – including MySQL6.0, Oracle 11g, Microsoft SQL Server 2008 – the Getting Started Guide will help you quickly up and running SQL. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL base.
Each chapter describes a separate SQL key concepts or technology lessons, illustrations and annotated examples. The exercises at the end of each chapter let you practice the skills learned. With this book, you will:
Quick moving through SQL basics and learn some of the advanced features,
Using SQL data report generation, processing and retrieval of data
Using SQL schema statements to create database objects such as tables, indexes and constraints,
Understanding of the data set of queries, interaction and understanding of the importance of subqueries
Data conversion and processing SQL built-in functions, and use conditional logic data report
Knowledge of SQL is a must for interacting with data. By learning SQL, you’ll quickly learn how to put the power and flexibility of this language.
Show more
