Getting started with SQL : a hands-on approach for beginners / Thomas Nield
Book | O'Reilly | 2016 | First edition.
Available at Gateway-Racine Campus General Collection (QA 76.73 S6.7 N5.45 2016)

Additional actions:

close
see all

Items

Location Call No. Status
Gateway-Racine Campus General Collection QA 76.73 S6.7 N5.45 2016 Available
Show fewer items

More Details

Edition
First edition.
Description
xiii, 116 pages : illustrations ; 24 cm
Note
Includes index.
Contents
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
Stiching Tables Together -- INNER JOIN -- LEFT JOIN -- Other JOIN Types -- Joining Multiple Tables -- Grouping JOINs -- Summary
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
10. Managing Data
INSERT -- Multiple INSERTs -- Testing the Foreign Keys -- DELETE -- TRUNCATE TABLE -- UPDATE -- DROP TABLE -- Summary
11. Going Forward
A. Operators and Functions
B. Supplementary Topics
Summary
Quickly master the fundamentals of SQL right in your own home, without having to use a database server environment. Ideal for business professionals as well as absolute beginners who want to acquire data proficiency, this practical guide teaches you how to pull and transform data in meaningful ways. You'll also learn how to design your own databases, using best practices in table design. Practice at home with hands-on exercises to learn SQL Leverage, SQLite and SQLiteStudio to create databases within minutes.
28.00 DPWEB (31-152-4)
Subject
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top