Allen, Christopher. creator text xxu New York McGraw Hill 2004 monographic eng

print

xv, 395 p. : ill. ; 24 cm. Contents: Database basics: Introduction to databases: What exactly is a database? -- How is a database different from a spreadsheet? -- How will knowing this will help you? -- History of SQL -- SQL command categories -- Storing and retrieving data: The basics: Putting your toe in the water -- Creating tables -- Inserting data - additional techniques -- Viewing data - additional techniques -- Advanced data manipulation: Limit which records you select -- Change the order of records -- Show only unique values -- Select from DUAL -- Modify data in a table -- Remove records from a table -- Transaction control -- Controlling SQL *plus: Edit commands -- Copy and paste -- Clear the SQL *plus environment -- Produce more readable output -- Spool output to disk -- SQL script file -- Advanced SQL: SQL functions: Commonly used single - row functions -- Commonly used group functions -- Using indexes and constraints: Indexes -- Ensure data integrity: Constraints -- Relationships between tables -- Write subqueries -- Other useful oracle techniques: Transfer data between tables --Rename a table -- Alter a table's structure -- Other database objects -- Create programs using PL / SQL: Introduction to PL / SQL: What is PL/SQL -- Structure of PL /SQL block -- Create a simple PL / SQL procedure -- PL / SQL variables and consonants -- Control structures in PL / SQL -- Error handling -- More PL / SQL tools: Coding conventions -- More on PL / SQL and oracle server interaction -- Timing operations -- PL /SQL packages -- Triggers. Christopher Allen. Includes index. QA76.73.P258 A451 0072255404 120711