PC Pro 1999 February/DPPCPRO0299.ISO/February/Delphi/Runimage/INTRBASE/BIN/TUTORIAL.CNT

Microsoft Windows Help File Content | 1996-05-16 | 2.9 KB | 68 lines

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