- Table View
- List View
SPSS Demystified: A Simple Guide and Reference (Third Edition)
by Ronald D. Yockey<p>Without question, statistics is one of the most challenging courses for students in the social and behavioral sciences. Enrolling in their first statistics course, students are often apprehensive or extremely anxious toward the subject matter. And while SPSS is one of the more easy-to-use statistical software programs available, for anxious students who realize they not only have to learn statistics but also new software, the task can seem insurmountable. Keenly aware of students’ anxiety with statistics (and the fact that this anxiety can affect performance), Ronald D. Yockey has written SPSS Demystified: A Simple Guide and Reference, now in its third edition. Through a comprehensive, step-by-step approach, this text is consistently and specifically designed to both alleviate anxiety toward the subject matter and build a successful experience analyzing data in SPSS. <p>Key features of the text: <p> <li>Step-by-step instruction and screenshots <li>Designed to be hands-on with the user performing the analyses alongside on their computer as they read through each chapter <li>Call-out boxes provided, highlighting important information as appropriate <li>SPSS output explained, with written results provided using the popular, widely recognized APA format <li>End-of-chapter exercises included, allowing for additional practice</li> <p> <p>Features and updates to this edition include: material updated to IBM SPSS 24 (available Fall 2016), including screenshots and data sets/end-of-chapter exercises.</p>
SPSS for Starters
by Aeilko H. Zwinderman Ton J. CleophasThis small book contains all statistical tests that are relevant for starters on SPSS. Each test is explained using a data example from clinical practice, including every step in SPSS and the main tables of results with an accompanying text with interpretations of the results and hints convenient for data reporting, i.e., scientific clinical articles and poster presentations.. In order to facilitate the use of this cookbook the data files of the examples are made available by the publisher on the Internet. For investigators who wish to perform their own data analyses from the very start the book can be used as a step-by-step guideline. They can enter their separate data or enter their entire data file, e.g., from Excel, simply by opening an Excel file in SPSS. SPSS statistical software is a user-friendly statistical software with many help and tutor pages. However, for the novices on SPSS an even more basic approach is welcome. The book is meant for this very purpose, and can be used without the help of a teacher. The authors are well-aware that this cookbook contains a minimal amount of text and a maximal technical details, but we believe that this property will not refrain students from mastering the SPSS software systematic, and that, instead, it will even be a help to that aim. Yet, we recommend that it be used together with the textbook "Statistics Applied to Clinical Trials" by Cleophas et al, 4th Edition, 2009, Springer Dordrecht.
SPSS for Starters and 2nd Levelers
by Ton J. Cleophas Aeilko H. ZwindermanFor medical and health workers this book is a must-have, because statistical methods in these fields are vital, and no equivalent work is available. For medical and health students this is equally true. A unique point is its low threshold, textually simple and at the same time full of self-assessment opportunities. Other unique points are the succinctness of the chapters with 3 to 6 pages, the presence of entire-commands-texts of the statistical methodologies reviewed and the fact that dull scientific texts imposing an unnecessary burden on busy and jaded professionals have been left out. For readers requesting more background, theoretical and mathematical information a note section with references is in each chapter. The first edition in 2010 was the first publication of a complete overview of SPSS methodologies for medical and health statistics. Well over 100,000 copies of various chapters were sold within the first year of publication. Reasons for a rewrite were four. First, many important comments from readers urged for a rewrite. Second, SPSS has produced many updates and upgrades, with relevant novel and improved methodologies. Third, the authors felt that the chapter texts needed some improvements for better readability: chapters have now been classified according the outcome data helpful for choosing your analysis rapidly, a schematic overview of data, and explanatory graphs have been added. Fourth, current data are increasingly complex and many i mportant methods for analysis were missing in the first edition. For that latter purpose some more advanced methods seemed unavoidable, like hierarchical loglinear methods, gamma and Tweedie regressions and random intercept analyses. In order for the contents of the book to remain covered by the title, the authors renamed the book: SPSS for Starters and 2nd Levelers. Special care was, nonetheless, taken to keep things as simple as possible. Medical and health professionals tend to dislike software syntax. Therefore, virtually no syntax, but, rather, simple menu commands are given. The arithmetic is still of a no-more-than high-school level. Step-by-step analyses of different statistical methodologies are given with the help of 60 SPSS data files available through the internet. Because of the lack of time of this busy group of people, the authors have given every effort to produce a text as succinct as possible.
SPSS for Windows: An Introduction to Use and Interpretation in Research
by George A. Morgan Orlando V. Griego Gene GloecknerA supplementary textbook for a graduate or undergraduate introductory course in research methods or statistics in the behavioral sciences or education. Morgan (education and human development, Colorado State U.), Orlando V. Griego (business and management, Azusa Pacific U.), and Gene W. Gloeckner (education, Colorado State U.) help students learn how to analyze and interpret research data using the Statistical Products and Service Solutions statistical software package in a Microsoft Windows environment. No background in statistics is assumed. The disk contains data files for the laboratory exercises. Annotation c. Book News, Inc., Portland, OR (booknews.com)
SPSS/PC+ Made Simple
by John HeddersonAfter twelve years of teaching SPSS, SPSSx, and SPSS/PC+, I am convinced that SPSS/PC+ is not easy for the average college student to learn. I am also convinced that it is not easy to teach from the program manuals. Students who are experienced with statistics and programming or students with a high aptitude for this type of work will learn SPSS/PC+ easily. The rest suffer. Typically, my students have scant training in statistics or programming. Often they are not comfortable with mathematics, computers, and "that sort of thing." I wrote SPSS/PC+ Made Simple to help these students and their instructors
SPSS Statistics for Data Analysis and Visualization
by Andrew Wheeler Jason Verlen Jesus Salcedo Jon Peck Keith MccormickDive deeper into SPSS Statistics for more efficient, accurate, and sophisticated data analysis and visualization SPSS Statistics for Data Analysis and Visualization goes beyond the basics of SPSS Statistics to show you advanced techniques that exploit the full capabilities of SPSS. The authors explain when and why to use each technique, and then walk you through the execution with a pragmatic, nuts and bolts example. Coverage includes extensive, in-depth discussion of advanced statistical techniques, data visualization, predictive analytics, and SPSS programming, including automation and integration with other languages like R and Python. You'll learn the best methods to power through an analysis, with more efficient, elegant, and accurate code. IBM SPSS Statistics is complex: true mastery requires a deep understanding of statistical theory, the user interface, and programming. Most users don't encounter all of the methods SPSS offers, leaving many little-known modules undiscovered. This book walks you through tools you may have never noticed, and shows you how they can be used to streamline your workflow and enable you to produce more accurate results. Conduct a more efficient and accurate analysis Display complex relationships and create better visualizations Model complex interactions and master predictive analytics Integrate R and Python with SPSS Statistics for more efficient, more powerful code These "hidden tools" can help you produce charts that simply wouldn't be possible any other way, and the support for other programming languages gives you better options for solving complex problems. If you're ready to take advantage of everything this powerful software package has to offer, SPSS Statistics for Data Analysis and Visualization is the expert-led training you need.
SPSS Statistics Workbook For Dummies
by Jesus Salcedo Keith McCormickPractice making sense of data with IBM’s SPSS Statistics software SPSS Statistics Workbook For Dummies gives you the practice you need to navigate the leading statistical software suite. Data management and analysis, advanced analytics, business intelligence—SPSS is a powerhouse of a research platform, and this book helps you master the fundamentals and analyze data more effectively. You’ll work through practice problems that help you understand the calculations you need to perform, complete predictive analyses, and produce informative graphs. This workbook gives you hands-on exercises to hone your statistical analysis skills with SPSS Statistics 28. Plus, explanations and insider tips help you navigate the software with ease. Practical and easy-to-understand, in classic Dummies style. Practice organizing, analyzing, and graphing data Learn to write, edit, and format SPSS syntax Explore the upgrades and features new to SPSS 28 Try your hand at advanced data analysis proceduresFor academics using SPSS for research, business analysts and market researchers looking to extract valuable insights from data, and anyone with a hankering for more stats practice.
SPSS Survival Manual: A Step By Step Guide to Data Analysis Using SPSS for Windows
by Julie PallantIn this fully revised edition of her bestselling text, Julie Pallant guides you through the entire research process, helping you choose the right data analysis technique for your project. From the formulation of research questions, to the design of the study and analysis of data, to reporting the results, Julie discusses basic and advanced statistical techniques. She outlines each technique clearly, with step-by-step procedures for performing the analysis, a detailed guide to interpreting SPSS output and an example of how to present the results in a report. For both beginners and experienced SPSS users in psychology, sociology, health sciences, medicine, education, business and related disciplines, the SPSS Survival Manual is an essential guide. Illustrated with screen grabs, examples of output and tips, it is supported by a website with sample data and guidelines on report writing. In this third edition all chapters have been updated to accommodate changes to SPSS procedures, screens and output in version 15. A new flowchart is included for SPSS procedures, and factor analysis procedures have been streamlined. It also includes more examples and material on syntax. Additional data files are available on the book's supporting website.
SPSS Survival Manual: A Step By Step Guide to Data Analysis Using IBM SPSS
by Julie PallantThe SPSS Survival Manual throws a lifeline to students and researchers grappling with this powerful data analysis software. In her bestselling guide, Julie Pallant guides you through the entire research process, helping you choose the right data analysis technique for your project. From the formulation of research questions, to the design of the study and analysis of data, to reporting the results, Julie discusses basic and advanced statistical techniques. She outlines each technique clearly, with step- by-step procedures for performing the analysis, a detailed guide to interpreting data output and an example of how to present the results in a report. For both beginners and experienced users in psychology, sociology, health sciences, medicine, education, business and related disciplines, the SPSS Survival Manual is an essential text. Illustrated with screen grabs, examples of output and tips, it is supported by a website with sample data and guidelines on report writing. This sixth edition is fully revised and updated to accommodate changes to IBM SPSS procedures, screens and output. It covers new SPSS tools for generating graphs and non-parametric statistics, importing data, and calculating dates.
SPSS Survival Manual
by Julie PallantThis guide book provides a reference source to enable students not only to navigate but understand statistical analysis performed in and output produced by SPSS.
The Spy In The Coffee Machine: The End of Privacy as We Know It
by Kieron O'Hara Nigel ShadboltWhat do you know about the new surveillance state that has been created in the wake of pervasive computing - that is, the increasing use of very small and simple computers in all sorts of host - from your computer to your coat? Well, these little computers can communicate via the web and form powerful networks whose emergent behaviour can be very complex, intelligent, and invasive. The question is: how much of an infringement on privacy are they? Could these intelligent networks be used by governments, criminals or terrorists to undermine privacy or commit crimes? From CCTVs to blogging, from cookies to RFID tags, we are sleepwalking into a new state of global hypersurveillance. And when even cans of Coke are connected to the internet, the risk of someone misusing this information is very high indeed. Kieron O'Hara is Senior Research Fellow in Electronics and Computer Science at the University of Southampton, UK. Nigel Shadbolt is Professor of Artificial Intelligence at the University of Southampton, UK, and was President of the British Computer Society in 2006-7.
Spy Technology (Cool Science Ser.)
by Ron FridellStealing secrets is a very old job. Spies from Europe set out to steal a precious secret from China about 1,500 years ago. At that time, the Chinese were making beautiful silk fabric. They created it from the cocoons of silkworms. No one else knew how to make it.
SQA Higher Computing Science
by Jane Paterson John WalshExam board: SQALevel: HigherSubject: Computing ScienceFirst teaching: August 2018First exams: Summer 2019Trust highly experienced teachers and authors Jane Paterson and John Walsh to guide you through the latest SQA Higher Computing Science specification (for examination from 2019 onwards).This is the most comprehensive resource available for this course, brought to you by Scotland's No. 1 textbook publisher.- Gain in-depth knowledge of the four areas of study (Software Design and Development, Database Design and Development, Web Design and Development, Computer Systems) with clear explanations of every concept and topic- Understand advanced concepts and processes as numerous examples throughout the book show the theory in action- Build the skills of analysis, design, implementation, testing and evaluation that are required for success in both the exam and the assignment- Apply the knowledge and skills developed through the course to a variety of practical tasks and end-of-chapter 'check your learning' questions- Use computing terminology confidently and accurately by consulting a detailed glossary of all key terms and acronyms
SQA Higher Computing Science
by Jane Paterson John WalshExam board: SQALevel: HigherSubject: Computing ScienceFirst teaching: August 2018First exams: Summer 2019Trust highly experienced teachers and authors Jane Paterson and John Walsh to guide you through the latest SQA Higher Computing Science specification (for examination from 2019 onwards).This is the most comprehensive resource available for this course, brought to you by Scotland's No. 1 textbook publisher.- Gain in-depth knowledge of the four areas of study (Software Design and Development, Database Design and Development, Web Design and Development, Computer Systems) with clear explanations of every concept and topic- Understand advanced concepts and processes as numerous examples throughout the book show the theory in action- Build the skills of analysis, design, implementation, testing and evaluation that are required for success in both the exam and the assignment- Apply the knowledge and skills developed through the course to a variety of practical tasks and end-of-chapter 'check your learning' questions- Use computing terminology confidently and accurately by consulting a detailed glossary of all key terms and acronyms
SQL All In One For Dummies
by Allen G. TaylorThe latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications. With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases. Cope with any issue that arises in SQL database creation and management Get current on the newest SQL updates and capabilities Reference information on querying SQL-based databases in the SQL language Understand relational databases and their importance to today’s organizations SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.
SQL All-in-One For Dummies
by Allen G. TaylorThe soup-to-nuts guide on all things SQL!SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You'll get the goods on relational database design, development, and maintenance, enabling you to start working with SQL right away!Provides an overview of the SQL language and examines how it is integral for the storage and retrieval of database informationIncludes updates to SQL standards as well as any new featuresExplores SQL concepts, relational database development, SQL queries, data security, database tuning, and moreAddresses the relationship between SQL and programming as well as SQL and XMLIf you're looking for an up-to-date sequel to the bestelling first edition of SQL All-in-One For Dummies, then this is the book for you!
SQL All-in-One For Dummies
by Allen G. Taylor Richard BlumThe most thorough SQL reference, now updated for SQL:2023 SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there’s no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts Read clear explanations of SQL code and learn to write complex queries Discover how to apply SQL in real-world situations to gain control over large datasets Enjoy a thorough reference to common tasks and issues in SQL developmentThis Dummies All-in-One guide is for all SQL users—from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.
SQL Alles-in-einem-Band für Dummies (Für Dummies)
by Allen G. Taylor Richard BlumWerden Sie zum SQL-Profi! In diesem Buch erfahren Sie alles, was es über SQL zu wissen gibt. Angefangen mit den Grundlagen und der Frage, wie Sie Datenbanken erstellen, Daten ordnen und abfragen, lernen Sie zudem Entwicklungsumgebungen für die Datenbankenprogrammierung kennen. Auch das Thema Datensicherheit kommt nicht zu kurz: So lernen Sie, wie Sie Ihre Daten und Datenbanken schützen und wie Sie typische Fehler vermeiden. Sie erfahren außerdem, wie Sie andere Sprachen, wie XML und JSON, mit SQL integrieren und wie Sie die Leistung Ihrer Datenbank analysieren und optimieren. Sie erfahren Wie Datenbanksysteme aufgebaut sind Was Sie beim Mehrbenutzerzugriff beachten sollten Welche Schnittstellen zu prozeduralen Programmiersprachen es gibt Wie Sie richtig auf Systemausfälle reagieren
SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management
by Michael Kaufmann Andreas MeierThis textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations.In the first five chapters, the authors analyze in detail the management, modeling, languages, security, and architecture of relational databases, graph databases, and document databases. Moreover, an overview of other SQL- and NoSQL-based database approaches is provided. In addition to classic concepts such as the entity and relationship model and its mapping in SQL database schemas, query languages or transaction management, other aspects for NoSQL databases such as non-relational data models, document and graph query languages (MQL, Cypher), the Map/Reduce procedure, distribution options (sharding, replication) or the CAP theorem (Consistency, Availability, Partition Tolerance) are explained.This 2nd English edition offers a new in-depth introduction to document databases with a method for modeling document structures, an overview of the document-oriented MongoDB query language MQL as well as security and architecture aspects. The topic of database security is newly introduced as a separate chapter and analyzed in detail with regard to data protection, integrity, and transactions. Texts on data management, database programming, and data warehousing and data lakes have been updated. In addition, the book now explains the concepts of JSON, JSON schema, BSON, index-free neighborhood, cloud databases, search engines and time series databases.The book includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading. It conveys an in-depth comparison of relational and non-relational approaches and shows how to undertake development for big data applications. This way, it benefits students and practitioners working across the broad field of data science and applied information technology.
SQL and Relational Theory
by C. J. DateUnderstanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as: Should database access granted be through views instead of base tables? Nulls in your database are causing you to get wrong answers. Why? What can you do about it? Could you write an SQL query to find employees who have never been in the same department for more than six months at a time? SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them? Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation? Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.
SQL and Relational Theory: How to Write Accurate SQL Code (Morgan Kaufmann Series In Data Management System)
by C. J. DateUnderstanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:Should database access granted be through views instead of base tables?Nulls in your database are causing you to get wrong answers. Why? What can you do about it?Could you write an SQL query to find employees who have never been in the same department for more than six months at a time?SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them?Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation?Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.
SQL and Relational Theory: How to Write Accurate SQL Code
by C. J. DateSQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory.Could you write an SQL query to find employees who have worked at least once in every programming department in the company? And be sure it’s correct?Why is proper column naming so important?Nulls in the database cause wrong answers. Why? What you can do about it?How can image relations help you formulate complex SQL queries?SQL supports "quantified comparisons," but they’re better avoided. Why? And how?Database theory and practice have evolved considerably since Codd first defined the relational model, back in 1969. This book draws on decades of experience to present the most up to date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL can benefit from the insights it contains. The book is product independent.
SQL Antipatterns: Avoiding the Pitfalls of Database Programming
by Bill KarwinBill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development. The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.
SQL Antipatterns, Volume 1: Avoiding The Pitfalls Of Database Programming
by Bill KarwinSQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins. No matter which platform, framework, or language you use, the database is the foundation of your application, and the SQL database language is the standard for working with it. Antipatterns are solutions that look simple at the surface, but soon mire you down with needless work. Learn to identify these traps, and craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead to poor performance and quality, and master the principles that make SQL a powerful and flexible tool for handling data and logic. Dive deep into SQL and database design, and learn to recognize the most common missteps made by software developers in database modeling, SQL query logic, and code design of data-driven applications. See practical examples of misconceptions about SQL that can lure software projects astray. Find the greatest value in each group of data. Understand why an intersection table may be your new best friend. Store passwords securely and don't reinvent the wheel. Handle NULL values like a pro. Defend your web applications against the security weakness of SQL injection. Use SQL the right way - it can save you from headaches and needless work, and let your application really shine! What You Need: The SQL examples use the MySQL 8.0 flavor, but other popular brands of RDBMS are mentioned. Other code examples use Python 3.9+ or Ruby 2.7+.
SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))
by Anthony MolinaroYou know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing outPowerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES functionPivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result setBucketization, and why you should never use that term in Brooklyn.How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniquesThe technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.