PC World Komputer 1998 October A/Pcwk10a98.iso/Inprise/TRIAL/INTRBASE/DATA.Z/TUTORIAL.CNT

Microsoft Windows Help File Content | 1998-03-15 | 3KB | 68 lines

:Base tutorial.hlp>tutorwin
:Title InterBase Tutorial
1 InterBase Tutorial
2 Part One: Getting started with Windows ISQL
3 Introduction=IDH_TUT_INTRO
3 Starting the Windows ISQL session=IDH_TUT_STARTING
3 An overview of SQL=IDH_TUT_SQLINTRO
3 Creating a database=IDH_TUT_CREATINGDB
3 Conceptual database design=IDH_TUT_CONCEPTUAL
3 Creating tables=IDH_TUT_CREATINGTABLES
3 Primary keys and foreign keys=IDH_TUT_PRIMARYFOREIGN
3 Adding data to tables=IDH_TUT_ADDINGTABLEDATA
3 Testing referential integrity=IDH_TUT_TESTINGINTEGRITY
3 Viewing data=IDH_TUT_VIEWINGDATA
3 Modifying data=IDH_TUT_MODIFYINGDATA
3 Ending the WISQL session=IDH_TUT_ENDINGSESSION
2 Part Two: Basic data definition
3 Basic data definition=IDH_TUT_BADICDEF
3 More conceptual design=IDH_TUT_MORECONCEPT
3 Relationship modeling=IDH_TUT_RELATMODELING
3 Normalization=IDH_TUT_NORMALIZATION
3 Defining domains=IDH_TUT_DEFINEDOMAINS
3 Using data definition files=IDH_TUT_DATADEFFILES
3 Creating indexes=IDH_TUT_CREATEINDEX
3 Preventing duplicate row entries=IDH_TUT_PREVENTDUPS
3 Modifying indexes=IDH_TUT_MODIFYINDEX
3 Creating views=IDH_TUT_CREATEVIEWS
2 Part Three: Populating the database
3 Populating the database=IDH_TUT_DBPOP
3 Inserting data=IDH_TUT_INSERTDATA
3 Inserting data using column values=IDH_TUT_INSERTCOLS
3 Inserting data from an external file=IDH_TUT_INSERTEXT
3 Updating data=IDH_TUT_UPDATEDATA
3 Deleting data=IDH_TUT_DELETEDATA
3 Deleting data using a subquery=IDH_TUT_DELWITHSUBQ
3 Retrieving data=IDH_TUT_RETRIEVEDATA
2 Part Four: Retrieving data
3 Overview of SELECT=IDH_TUT_SELECTINTRO
3 Selecting from a view=IDH_TUT_SELECTVIEW
3 Removing duplicate rows with DISTINCT=IDH_TUT_REMDUPROWS
3 Using the WHERE clause=IDH_TUT_WHERE
3 Comparison operators=IDH_TUT_COMPOPS
3 Pattern matching=IDH_TUT_PATTERNMATCH
3 Logical operators=IDH_TUT_LOGICALOPS
3 Using subqueries=IDH_TUT_SUBQUERIES
3 Using aggregate functions=IDH_TUT_AGGRFUNCS
3 Grouping query results=IDH_TUT_QUERYRESULTS
3 Using the HAVING clause=IDH_TUT_HAVING
3 Using the ORDER BY clause=IDH_TUT_ORDERBY
3 Joining tables=IDH_TUT_JOINTABLES
3 Inner joins=IDH_TUT_INNERJOINS
3 Outer joins=IDH_TUT_OUTERJOINS
3 Formatting data=IDH_TUT_FORMATDATA
3 Using CAST( ) to convert data types=IDH_TUT_CAST
3 Using the string operator in search conditions=IDH_TUT_STRINGSEARCH
3 Converting to uppercase=IDH_TUT_UPPER
2 Part Five: Advanced data definition
3 Advanced data definition=IDH_TUT_ADVANCEDDEF
3 Triggers and stored procedures=IDH_TUT_TRIGSANDSTORED
3 Triggers=IDH_TUT_TRIGGERS
3 Generating unique column values with triggers=IDH_TUT_GENUNIQUE
3 Maintaining change records with a trigger=IDH_TUT_CHANGEMAINT
3 Posting an event with a trigger=IDH_TUT_POSTEVENT
3 Stored procedures=IDH_TUT_STOREDPROC
3 A simple select procedure=IDH_TUT_SELECTPROC
3 A simple executable procedure=IDH_TUT_EXECPROC
3 A recursive procedure=IDH_TUT_RECURSEPROC