2015 Edition. Perfect for end users, analysts, data scientists, and app developers, this best-selling guide will get you up and running with SQL, the language of databases. You'll find general concepts, practical answers, and clear explanations of what the various SQL statements can do. Hundreds of examples of varied difficulty encourage you to experiment and explore. Full-color SQL code listings help you see the elements and structure of the language. You can download the sample database to follow along with the author's examples. - Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.- Learn the core language for standard SQL, and variations for the most widely used database systems.- Organize your database in terms of the relational model.- Master tables, columns, rows, and keys.- Retrieve, sort, and format data.- Filter the data that you don't want to see.- Convert and manipulate data with SQL's built-in functions and operators.- Use aggregate functions to summarize data.- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.- Create, alter, and drop tables, indexes, and views.- Insert, update, delete, and merge data.- Execute transactions to maintain the integrity of your data.- Avoid common pitfalls involving nulls.- Troubleshoot and optimize queries.- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable. ContentsIntroduction1. Running SQL Programs2. The Relational Model3. SQL Basics4. Retrieving Data from a Table5. Operators and Functions6. Summarizing and Grouping Data7. Joins8. Subqueries9. Set Operations10. Inserting, Updating, and Deleting Rows11. Creating, Altering, and Dropping Tables12. Indexes13. Views14. Transactions
This book will teach you what you need to know about JDBC and SQL, so that you can design and program database applications that can reach users around the world. Unlike other books aimed at systems programmers writing JDBC drivers, this book addresses the needs of the application developer.
This handbook teaches readers how to use the SQL programming language to retrieve and analyze database information, and to create and edit database objects. Fehily presents a clear explanation of the relational database model and SQL syntax in the first few chapters, then launches into tasks that will let readers get comfortable using SQL right away.
This cookbook of advanced techniques is for anyone who knows the basics of SQL and wants to move beyond simple SELECT-FROM-WHERE queries. You'll find solutions to problems that analysts, app developers, and database programmers often face, from simple tasks, like picking random rows, to complex operations, like traversing hierarchies. Each recipe includes a discussion of the underlying logic, important concepts, and best practices. Take full advantage of standard (ANSI/ISO) SQL, or use DBMS-specific features that dramatically extend the power of standard SQL. Use the scores of code examples directly in real-world DBMS applications, or as a source of insight for related problems. - Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.- Implement cross-platform solutions in standard SQL, or DBMS-specific solutions for your particular system.- Full-color SQL code listings help you see the elements and structure of the language.- Download the sample database and code listings to follow along with the author's examples.- Plenty of tips, tricks, and timesavers.- Fully cross-referenced, linked, and searchable. ContentsIntroduction1. Running SQL Programs2. Calculating Running Statistics3. Generating Sequences4. Finding Sequences, Runs, and Regions5. Limiting the Number of Rows Returned6. Assigning Ranks7. Calculating a Trimmed Mean8. Picking Random Rows9. Handling Duplicates10. Creating a Telephone List11. Retrieving Metadata12. Working with Dates13. Calculating a Median14. Finding Extreme Values15. Changing Running Statistics Midstream16. Pivoting Results17. Working with Hierarchies
Get up to speed fast with SQL, the language of databases. Bestselling author Chris Fehily teaches you just the parts of SQL that you need to know. Quick, learn-by-example lessons start with simple data retrieval and sorting, move on to filtering and grouping, and then build to more-advanced topics, including joins, subqueries, views, and transactions. Whether you're an analyst, developer, data scientist, or Microsoft Office user, you'll find straightforward, practical answers. You can download the sample database to follow along with the examples. - Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access. - Learn the core language for standard SQL, and variations for the most widely used database systems. - Organize your database in terms of the relational model. - Master tables, columns, rows, and keys. - Retrieve, sort, and format data. - Filter the data that you don't want to see. - Convert and manipulate data with SQL's built-in functions and operators. - Use aggregate functions to summarize data. - Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata. - Create, alter, and drop tables, indexes, and views. - Insert, update, delete, and merge data. - Execute transactions to maintain the integrity of your data. - Avoid common pitfalls involving nulls. - Troubleshoot and optimize queries. - Plenty of tips, tricks, and timesavers. - Fully cross-referenced, linked, and searchable. Contents 1. Introduction 2. Database Basics 3. SQL Basics 4. Retrieving Data from a Table 5. Sorting Rows 6. Filtering Rows 7. Combining and Negating Conditions 8. Pattern Matching 9. More Ways to Filter Rows 10. Operators and Functions 11. Working with Functions 12. Evaluating Conditional Values 13. Summarizing Data 14. Grouping Data 15. Joining Tables 16. Working with Joins 17. Subqueries 18. Combining Queries 19. Inserting Rows 20. Updating and Deleting Rows 21. Creating and Changing Tables 22. Indexes 23. Views 24. Transactions A. The Sample Database B. Running SQL Programs C. Data Types
Learn the best way of writing code to run inside a relational database. This book shows how a holistic and set-oriented approach to database programming can far exceed the performance of the row-by-row model that is too often used by developers who haven’t been shown a better way. Two styles of programming are encountered in the database world. Classical programming as taught in many universities leads to an atomic, row-oriented, and procedural style inspired by the structured models of programming. In short, many application developers write in the relational database exactly like in the user interface. The other style of programming is holistic, data set oriented, and coded mainly in SQL. This is the style of the database developer. The set based and holistic style of development is not promoted enough in universities, and many application developers are not fully aware of it. There are many performance issues all over the world in relational databases due to the use of the atomic and inappropriate style of programming. This book compares the two styles, and promotes the holistic style of development as the most suitable one. Examples are given to demonstrate the superiority of a set-based and holistic approach. Compares the two styles of development Shows the performance advantages of set-based development Solves example problems using both approaches Who This Book Is For Two Styles of Database Development is aimed at application developers willing to adapt their programming styles in return for better-performing applications. It’s for students and new developers wanting to position themselves as having database expertise and build a reputation for developing highly-performant database applications.
SQL Database Programming Grab this GREAT physical book now at a limited time discounted price! The ability to use SQL (Structured Query Language) is a hugely powerful skill. This book is aimed at complete beginners, and will take you through all of the steps needed to master SQL. You will learn how to use databases, the different SQL features, why you need to learn these skills, and how they can be used practically! You will be taken step by step through all of the features of SQL database programming, and by the completion of this book you will have all of the basics, as well as some advanced skills mastered! Here Is What You'll Learn About... What Is SQL SQL Basics & Commands SELECT In Action More SELECT Features And Uses Different Database Functions Troubleshooting Much, Much More! Order your copy of this fantastic book today!
This book effectively explains the concept of PL/SQL programming. It gives short yet complete description of the PL/SQL programming concepts and explains them step by step. This book provides core information that every PL/SQL developer should know to write PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle exceptions. Loaded with lots of examples and illustrations to explain concepts, this book would help you learn PL/SQL programming with minimal effort.
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And our Beginner's Course to Learning SQL Programming in a weekend offers the straightforward practical answers you need to help you do your job.