Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Image from Google Jackets

Getting Started with SQL: a hands-on approach for beginners/ Thomas Nield

By: Publication details: Mumbai: O'Reilly Media, 2016Description: xiii,117 pages, 23 cmISBN:
  • 9783030109189
Subject(s): DDC classification:
  • 23 005.7565 N667
Contents:
Preface -- 1. Why Learn SQL? -- 2. Databases -- 3. SQLite -- 4. SELECT -- 5. WHERE -- 6. Group by and order by -- 7. CASE Statements-- 8. JOIN -- 9. Database design -- 10. Managing Data -- 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 Query, transform, and aggregate data to make it meaningful Join tables to get a more complete view of your business data Create resilient databases with normalized design principles.
Tags from this library: No tags from this library for this title. Log in to add tags.
Holdings
Item type Current library Call number Status Date due Barcode Item holds
Books ISI Library, Kolkata 005.7565 N667 (Browse shelf(Opens below)) Available 138555
Total holds: 0

Includes index

Preface --
1. Why Learn SQL? --
2. Databases --
3. SQLite --
4. SELECT --
5. WHERE --
6. Group by and order by --
7. CASE Statements--
8. JOIN -- 9. Database design -- 10. Managing Data --
11. Going Forward --
A. Operators and functions --
B. Supplementary Topics --

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
Query, transform, and aggregate data to make it meaningful
Join tables to get a more complete view of your business data
Create resilient databases with normalized design principles.

There are no comments on this title.

to post a comment.
Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in