
Getting Started with SQL
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.
Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs.
You'll also learn how to:
- Explore relational databases, including lightweight and centralized models
- Use SQLite and SQLiteStudio to create lightweight databases in minutes
- Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
- Join tables to get a more complete view of your business data
- Build your own tables and centralized databases by using normalized design principles
- Manage data by learning how to INSERT, DELETE, and UPDATE records
More details
Other editions
Additional editions

Content
- Cover
- Copyright
- Table of Contents
- Foreword
- Preface
- How to Use This Book
- Conventions Used in This Book
- Using Code Examples
- O'Reilly Online Learning
- How to Contact Us
- Acknowledgments
- Chapter 1. Why Learn SQL?
- What Is SQL and Why Is It Marketable?
- Who Is SQL For?
- Chapter 2. Databases
- What Is a Database?
- Exploring Relational Databases
- Why Separate Tables?
- Choosing a Database Solution
- Chapter 3. SQLite
- What Is SQLite?
- SQLiteStudio
- Importing and Navigating Databases
- Chapter 4. SELECT
- Retrieving Data with SQL
- Expressions in SELECT Statements
- Text Concatenation
- Summary
- Chapter 5. WHERE
- Filtering Records
- Using WHERE on Numbers
- AND, OR, and IN Statements
- Using WHERE on Text
- Using WHERE on Booleans
- Handling NULL
- Grouping Conditions
- Summary
- Chapter 6. GROUP BY and ORDER BY
- Grouping Records
- Ordering Records
- Aggregate Functions
- The HAVING Statement
- Getting Distinct Records
- Summary
- Chapter 7. CASE Statements
- The CASE Statement
- Grouping CASE Statements
- The "Zero/Null" CASE Trick
- Summary
- Chapter 8. JOIN
- Stitching Tables Together
- INNER JOIN
- LEFT JOIN
- Other JOIN Types
- Joining Multiple Tables
- Grouping JOINs
- Summary
- Chapter 9. Database Design
- Planning a Database
- The SurgeTech Conference
- ATTENDEE
- COMPANY
- PRESENTATION
- ROOM
- PRESENTATION_ATTENDANCE
- Primary and Foreign Keys
- The Schema
- Creating a New Database
- CREATE TABLE
- Setting the Foreign Keys
- Creating Views
- Summary
- Chapter 10. Managing Data
- INSERT
- Multiple INSERTs
- Testing the Foreign Keys
- DELETE
- TRUNCATE TABLE
- UPDATE
- DROP TABLE
- Summary
- Chapter 11. Going Forward
- Appendix A. Operators and Functions
- Appendix A1 - Literal Expression Queries
- Appendix A2 - Mathematical Operators
- Appendix A3 - Comparison Operators
- APPENDIX A4 - Logical Operators
- APPENDIX A5 - Text Operators
- APPENDIX A6 - Common Core Functions
- APPENDIX A7 - Aggregate Functions
- APPENDIX A8 - Date and Time Functions
- Date Functions
- Time Functions
- Date/Time Functions
- Appendix B. Supplementary Topics
- APPENDIX B1 - Further Topics of Interest
- APPENDIX B2 - Improving Performance with Indexes
- Appendix B3 - Transactions
- Index
- About the Author
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.