Learning SQL

From the contents:PrefaceWhy Learn SQL?Why Use This Book to Do It?Structure of This BookConventions Used in This BookHow to Contact UsUsing Code ExamplesSafari® Books OnlineAcknowledgmentsChapter 1A Little BackgroundIntroduction to DatabasesWhat Is SQL?What Is MySQL?What s in StoreChapter 2Creating and Populating a DatabaseCreating a MySQL DatabaseUsing the mysql Command-Line ToolMySQL Data TypesTable CreationPopulating and Modifying TablesWhen Good Statements Go BadThe Bank SchemaChapter 3Query PrimerQuery MechanicsQuery ClausesThe select ClauseThe from ClauseThe where ClauseThe group by and having ClausesThe order by ClauseTest Your KnowledgeChapter 4FilteringCondition EvaluationBuilding a ConditionCondition TypesNull: That Four-Letter WordTest Your KnowledgeChapter 5Querying Multiple TablesWhat Is a Join?Joining Three or More TablesSelf-JoinsEqui-Joins Versus Non-Equi-JoinsJoin Conditions Versus Filter ConditionsTest Your KnowledgeChapter 6Working with SetsSet Theory PrimerSet Theory in PracticeSet OperatorsSet Operation RulesTest Your KnowledgeChapter 7Data Generation, Conversion, andManipulationWorking with String DataWorking with Numeric DataWorking with Temporal DataConversion FunctionsTest Your KnowledgeChapter 8Grouping and AggregatesGrouping ConceptsAggregate FunctionsGenerating GroupsGroup Filter ConditionsTest Your KnowledgeChapter 9SubqueriesWhat Is a Subquery?Subquery TypesNoncorrelated SubqueriesCorrelated SubqueriesWhen to Use SubqueriesSubquery Wrap-upTest Your KnowledgeChapter 10Joins Revisited
Outer JoinsCross JoinsNatural JoinsTest Your KnowledgeChapter 11Conditional LogicWhat Is Conditional Logic?The Case ExpressionCase Expression ExamplesTest Your KnowledgeChapter 12TransactionsMultiuser DatabasesWhat Is a Transaction?Test Your KnowledgeChapter 13Indexes and ConstraintsIndexesConstraintsTest Your KnowledgeChapter 14ViewsWhat Are Views?Why Use Views?Updatable ViewsTest Your KnowledgeChapter 15MetadataData About DataInformation_SchemaWorking

Alan Beaulieu has been designing, building, and implementing custom database applications for over 20 years. He currently runs his ownconsulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAPenvironments, Alan utilizes such Oracle features as Parallel Query,Partitioning, and Parallel Server. Alan has a Bachelor of Sciencedegree in Operations Research from the Cornell University School ofEngineering. He lives in Massachusetts with his wife and two daughters.