Getting Started with SQL

Name: Getting Started with SQL
Author: Thomas Nield

A Hands-On Approach for Beginners

Specificaties

Paperback, 134 blz. | Engels

O'Reilly | 1e druk, 2016

ISBN13: 9781491938614

Rubricering

Hoofdrubriek : Computer en informatica

Juridisch :

O'Reilly 1e druk, 2016 9781491938614

Verwachte levertijd ongeveer 16 werkdagen

38,97

In winkelwagen

Samenvatting

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

Specificaties

ISBN13:9781491938614

Taal:Engels

Bindwijze:paperback

Aantal pagina's:134

Uitgever:O'Reilly

Druk:1

Verschijningsdatum:23-2-2016

Hoofdrubriek:Computer en informatica

Inhoudsopgave

1. Why Learn SQL?
-What Is SQL and Why Is It Marketable?
-Who Is SQL For?

2. Databases
-What Is a Database?
-Exploring Relational Databases
-Why Separate Tables?
-Choosing a Database Solution
-Lightweight Databases
-Centralized Databases

3. SQLite
-What Is SQLite?
-SQLiteStudio
-Importing and Navigating Databases

4. SELECT
-Retrieving Data with SQL
-Expressions in SELECT Statements
-Text Concatenation
-Summary

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

6. GROUP BY and ORDER BY
-Grouping Records
-Ordering Records
-Aggregate Functions
-The HAVING Statement
-Getting Distinct Records
-Summary

7. CASE Statements
-The CASE Statement
-Grouping CASE Statements
-The “Zero/Null” CASE Trick
-Summary

8. JOIN
-Stitching Tables Together
-INNER JOIN
-LEFT JOIN
-Other JOIN Types
-Joining Multiple Tables
-Grouping JOINs
-Summary

9. Database Design
-Planning a Database
-The SurgeTech Conference
-Primary and Foreign Keys
-The Schema
-Creating a New Database
-CREATE TABLE
-Setting the Foreign Keys
-Creating Views
-Summary

10. Managing Data
-INSERT
-DELETE
-TRUNCATE TABLE
-UPDATE
-DROP TABLE
-Summary

11. Going Forward

Appendix A: Operators and Functions
Appendix B: Supplementary Topics