| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910457711903321 |
|
|
Autore |
Wilton Paul <1969-> |
|
|
Titolo |
Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Indianapolis, IN, : Wiley, c2005 |
|
|
|
|
|
|
|
ISBN |
|
1-280-25346-0 |
9786610253463 |
0-7645-9632-2 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (521 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
"Programmer to programmer"--Cover. |
|
|
|
|
|
|
Nota di contenuto |
|
Beginning SQL; About the Authors; Credits; Contents; Acknowledgments; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p. wrox. com; Chapter 1: Introduction to SQL; A Brief History of Databases; Structured Query Language (SQL); Database Creation; Creating, Altering, and Deleting Tables; Good Database Design; Creating the Example Database; Summary; Exercises; Chapter 2: Entering Information; Inserting New Data; Inserting Data into the Case Study Database; Updating Data; Deleting Data |
SummaryExercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises |
Chapter 6: Grouping and Aggregating DataGrouping Results; |
|
|
|
|
|
|
|
|
|
|
|
Summarizing and Aggregating Data; Using the HAVING Clause with GROUP BY Statements; Summary; Exercises; Chapter 7: Selecting Data from Different Tables; Joins Revisited; Combining Results Sets with the UNION Operator; Summary; Exercises; Chapter 8: Queries within Queries; Subquery Terminology; Subqueries in a SELECT List; Subqueries in the WHERE Clause; Operators in Subqueries; Correlated Subquery; Subqueries Used with Other Statements; Summary; Exercises; Chapter 9: Advanced Queries; Updating the Database; Tackling Difficult Queries |
Top Tips for Efficient QueriesSummary; Exercises; Chapter 10: Views; Introducing Views; Summary; Exercises; Chapter 11: Transactions; Introducing Transactions; Transaction Logs; Locks; Isolation Levels; Problem Examples; Revisiting the Example Code; Summary; Exercises; Chapter 12: SQL Security; Security Concepts; Summary; Exercises; Chapter 13: Database Tuning; Tuning Hardware; Tuning SQL; Tuning Tips; Summary; Exercises; Appendix A: Exercise Answers; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12 |
Chapter 13Appendix B: Setting Up and Using the Five Database Systems; Installing and Using MySQL Version 4.1; Installing and Using IBM DB2; Installing and Using Microsoft Access XP; Installing and Using Microsoft SQL Server 2000; Installing and Using Oracle 10g; Appendix C: Initial Data Setup; Category Table; MemberDetails Table; Location Table; FavCategory Table; Films Table; Attendance Table; Index |
|
|
|
|
|
|
Sommario/riassunto |
|
Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendixPaul Wilton is a successful Wrox ""Beginning"" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particu |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Record Nr. |
UNINA9910785515703321 |
|
|
Autore |
Caringella Susan |
|
|
Titolo |
Addressing rape reform in law and practice [[electronic resource] /] / Susan Caringella |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
New York, : Columbia University Press, c2009 |
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (367 p.) |
|
|
|
|
|
|
Disciplina |
|
345.02532 |
345.73/02532 |
345.7302532 |
|
|
|
|
|
|
|
|
Soggetti |
|
Rape - United States |
Sex crimes - United States |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
Description based upon print version of record. |
|
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references and index. |
|
|
|
|
|
|
Nota di contenuto |
|
Frontmatter -- Contents -- Acknowledgments -- 1. Background to Rape Reform -- 2. Legal Change Sweeps the Nation -- 3. Failures and Successes -- 4. Avenues for and Attitudes About Victims -- 5. The Legal Landscape -- 6. Affirmative Consent Reform Models -- 7. Consent and Voluntariness, Agreement/Nonconsent and Involuntariness, Nonagreement -- 8. Presumptive Nonagreement -- 9. Mens Rea -- 10. Applying Recklessness and Negligence -- 11. Defenses -- 12. Sexual Assault Under Duress and Fraud -- 13. Reforming Rape Reforms -- 14. Discussion of the Model Array -- 15. Advantages of a Paradigm Shift -- 16. Recommendations Complementing the Model Rape Law -- 17. Moving Forward -- Notes -- References -- Index |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
The first comprehensive book on rape since Susan Brownmiller's Against Our Will and Susan Estrich's Real Rape, this volume probes every aspect of rape law and the discrepancies between ideal law (on the books) and real law (in action). Susan Caringella canvasses the success and failure of reform in the United States, as well as Australia, Britain, Canada, and New Zealand, and assesses alternative perspectives on rape reform, making use of theoretical models, court cases and statistical data. She uniquely delineates a creative model for |
|
|
|
|
|
|
|
|
|
|
change while addressing the discretion that undermines efforts at change. This includes charging the accused and plea bargaining, confronting a lack of transparency and accountability in implementing law, and acquiring funding for such changes. |
|
|
|
|
|
| |