Head first SQL / by Lynn BieghleyMaterial type: TextSeries: Head first seriesPublication details: New Delhi : O'Reilly Shroff Publisher & Distributers Pvt.Ltd, 2012cDescription: xxxv, 571 p. : ill. 24 cmISBN: 9788184043686 (pbk)Subject(s): SQL (Computer program language)DDC classification: 005.756
|Item type||Current library||Call number||Status||Date due||Barcode||Item holds|
|Books||Namal Library Computer Science||005.756 BEI-H 2012 193 (Browse shelf (Opens below))||Checked out||05/14/2021||193|
Data and tables: a place for everything -- The select statement: Gifted data retrieval -- Delete and update: A change will do you good -- Smart table design: Why be normal? -- Alter: Rewriting the past -- Advanced select: Seeing your data with new eyes -- Multi-table database design: Outgrowing your table -- Joins and multi-table operations: Can't we all just get along? -- Subqueries: Queries within queries -- Outer joins, self joins, and unions: New maneuvers -- Constraints, views, and transactions: Too many cooks spoil the database -- Security: Protecting your assets.
Presents an instructional guide to SQL which uses humor and simple images to cover such topics as the structure of relational databases, simple and complex queries, creating multiple tables, and protecting important table data.