Getting Started with SQL: a hands-on approach for beginners/ Thomas Nield
Publication details: Mumbai: O'Reilly Media, 2016Description: xiii,117 pages, 23 cmISBN:- 9783030109189
- 23 005.7565 N667
| 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 |
Browsing ISI Library, Kolkata shelves Close shelf browser (Hides shelf browser)
| No cover image available | ||||||||
| 005.7565 F944 Guide to SPSS/PC+ | 005.7565 M648 Informix basics | 005.7565 M648 Informix basics | 005.7565 N667 Getting Started with SQL: a hands-on approach for beginners/ | 005.7565 R816 Oracle PL/SQL: by example / | 005.757 B932 Object-oriented multidatabase systems | 005.757 C166 Fuzzy and uncertain object-oriented databases |
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.
