skip to content
SQL for IBM i : a database modernization guide Preview this item
ClosePreview this item
Checking...

SQL for IBM i : a database modernization guide

Author: Rafael Victória-Pereira
Publisher: Boise, ID, USA : MC Press, [2018]
Edition/Format:   eBook : Document : English : First editionView all editions and formats
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Rafael Victória-Pereira
ISBN: 9781583474501 1583474501
OCLC Number: 1019871655
Description: 1 online resource.
Contents: Intro; Title Page; Copyright; Acknowledgments; Contents; Why You Need This Book; How Can You Get More Out of the Database?; 1: Meet the UMADB: Our Example Database; The Students Table; The Courses Table; The Teachers Table; The Classes Table; The Grades Table; Just a Few Tables, and So Many Problems; In This Chapter, Youâ#x80;#x99;ve Learned â#x80;¦; 2: A Data Manipulation Language Basics Recap; Using the BETWEEN and IN Predicates; Joining Tables; The JOIN Youâ#x80;#x99;ve Been Using Without Realizing: INNER JOIN; Start Joining Tables Left and Right; â#x80;#x9C;Just Get Me Everythingâ#x80;#x9D;: FULL JOIN; A Join Summary A Handful of Column FunctionsThe COUNT Function; Finding the Minimum and Maximum Values of a Column; Sums and Averages Made Easy; The Shape-shifting CAST Function; Aggregating Data with GROUP BY; The Two Flavors of INSERT; Vanilla INSERT: Plain, Simple, and Kind of Boring; Strawberry (or Whatever Your Favorite Ice Cream Flavor Is) INSERT; Data Adjustments with UPDATE; DELETE: A Blessing and a Curse; In This Chapter, Youâ#x80;#x99;ve Learned â#x80;¦; 3: A Data Definition Language Basics Recap; Converting UMADBâ#x80;#x99;s Physical Files to SQL Tables; CREATE TABLE Fundamentals Moving a Step Closer to a Real SQL TableAdding a Unique, Self-Managed Key; Providing Proper Default Values for Optional and Audit-Related Columns; Time for Some Practice; A First Step Toward Easier Data Access: Creating a Few Simple Views; Why Do You Need Views?; How Do You Create Views?; Repeat After Me: A View Is Not a Logical File; The Missing Piece: SQL Indexes; A Side Note: Why Is It So Important to Keep the Source Statements Safe?; Exploring a Few CREATE INDEX Options; In This Chapter, Youâ#x80;#x99;ve Learned â#x80;¦; 4: Making the Database User-Friendly; Using Longer Table and Column Names Time for Some PracticeHiding Database Complexity; Using the Same Table Twice in a Query; Using Sub-queries; Using EXISTS to Omit Records on a SELECT Statement; Checking Database Consistency with the Exception Join; Time for Some (More) Practice; Using CASE to Return â#x80;#x9C;Friendlierâ#x80;#x9D; Column Values; Using CASE in the ORDER BY Clause; Using a Secondary Table to Produce Customizable Sorting Sequences; In This Chapter, Youâ#x80;#x99;ve Learned â#x80;¦; 5: Tidying Up the Database; A Quick Refresher on Relational Databases; Relational Databases and Their Use of Keys; Primary Keys; Unique Keys; Foreign Keys Table Relationship TypesUnderstanding Identifying and Non-Identifying Relationships; Referential Integrity; Entity Relationship Diagram Notation; Solving UMADBâ#x80;#x99;s Database Problems Through Normalization; Data Anomalies; Some Boring, Yet Important, Math Jargon; Introducing the Normal Forms, Academic Version; Normalizing UMADB to 3NF; Data Modeling with Visual Paradigm; Introducing Visual Paradigm Community Edition; Time for Some Practice; Creating the New and Improved UMADB; Time for Some (More) Practice; Data Modeling Is Fun, but Whereâ#x80;#x99;s the Code?
Responsibility: Rafael Victória-Pereira.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1019871655> # SQL for IBM i : a database modernization guide
    a schema:CreativeWork, schema:MediaObject, schema:Book ;
    library:oclcnum "1019871655" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/idu> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/4725231647#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:about <http://dewey.info/class/005.756/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/4725231647#Topic/computers_programming_languages_general> ; # COMPUTERS / Programming Languages / General
    schema:about <http://experiment.worldcat.org/entity/work/data/4725231647#Topic/relational_databases> ; # Relational databases
    schema:author <http://experiment.worldcat.org/entity/work/data/4725231647#Person/victoria_pereira_rafael> ; # Rafael Victória-Pereira
    schema:bookEdition "First edition." ;
    schema:bookFormat schema:EBook ;
    schema:datePublished "2018" ;
    schema:description "Intro; Title Page; Copyright; Acknowledgments; Contents; Why You Need This Book; How Can You Get More Out of the Database?; 1: Meet the UMADB: Our Example Database; The Students Table; The Courses Table; The Teachers Table; The Classes Table; The Grades Table; Just a Few Tables, and So Many Problems; In This Chapter, Youâ#x80;#x99;ve Learned â#x80;¦; 2: A Data Manipulation Language Basics Recap; Using the BETWEEN and IN Predicates; Joining Tables; The JOIN Youâ#x80;#x99;ve Been Using Without Realizing: INNER JOIN; Start Joining Tables Left and Right; â#x80;#x9C;Just Get Me Everythingâ#x80;#x9D;: FULL JOIN; A Join Summary"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/4725231647> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:name "SQL for IBM i : a database modernization guide"@en ;
    schema:productID "1019871655" ;
    schema:url <http://library.icc.edu/login?url=https://ebookcentral.proquest.com/lib/illcencol-ebooks/detail.action?docID=5219248> ;
    schema:url <http://ebookcentral.proquest.com/lib/ucm/detail.action?docID=5219248> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1687504> ;
    schema:url <http://public.eblib.com/choice/PublicFullRecord.aspx?p=5219248> ;
    schema:workExample <http://worldcat.org/isbn/9781583474501> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1019871655> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/4725231647#Person/victoria_pereira_rafael> # Rafael Victória-Pereira
    a schema:Person ;
    schema:familyName "Victória-Pereira" ;
    schema:givenName "Rafael" ;
    schema:name "Rafael Victória-Pereira" ;
    .

<http://experiment.worldcat.org/entity/work/data/4725231647#Topic/computers_programming_languages_general> # COMPUTERS / Programming Languages / General
    a schema:Intangible ;
    schema:name "COMPUTERS / Programming Languages / General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4725231647#Topic/relational_databases> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/4725231647#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/isbn/9781583474501>
    a schema:ProductModel ;
    schema:isbn "1583474501" ;
    schema:isbn "9781583474501" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.