Learning SQL
Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. 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 fundamentals.\ Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated...
Search in google:
SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.
PrefaceChapter 1: A Little BackgroundChapter 2: Creating and Populating a DatabaseChapter 3: Query PrimerChapter 4: FilteringChapter 5: Querying Multiple TablesChapter 6: Working with SetsChapter 7: Data Generation, Conversion, and ManipulationChapter 8: Grouping and AggregatesChapter 9: SubqueriesChapter 10: Joins RevisitedChapter 11: Conditional LogicChapter 12: TransactionsChapter 13: Indexes and ConstraintsChapter 14: ViewsChapter 15: MetadataER Diagram for Example DatabaseMySQL Extensions to the SQL LanguageSolutions to ExercisesColophonAlan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.
\ From Barnes & NobleThe Barnes & Noble Review\ Don’t just skim SQL’s surface: Gain a real understanding of what it can do -- in less than 300 pages. \ Alan Beaulieu’s Learning SQL starts with all the background you need: No SQL or database experience is required. In the first few chapters, you’ll walk through creating and populating your first database. (Download MySQL and follow along.) You’ll write basic queries, filter data, query multiple tables, work with sets, use built-in functions. Gradually, you’ll move to more complex tasks: grouping, aggregates, and subqueries; even joins, transactions, and indexes.\ Beaulieu’s examples are tested with MySQL, Oracle, and SQL Server (and should work fine with most recent databases). The result: a book that’ll work in any environment, whether you’re building applications, working as an admin, or just trying to coax a database into coughing up the right information. Bill Camarda, from the November 2005 Read Only\ \ \
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
