Critical Skill 4.1 Learn the SQL Statement ComponentsDDLDMLCritical Skill 4.2 Use Basic Insert and Select StatementsInsertSelectCritical Skill 4.3 Use Simple Where ClausesA Where Clause with and/orThe Where Clause with NOTThe Where Clause with a Range SearchThe Where Clause with a Search ListThe Where Clause with a Pattern SearchThe Where Clause: Common OperatorsCritical Skill 4.4 Use Basic Update and Delete StatementsUpdateDeleteCritical Skill 4.5 Order DataCritical Skill 4.6 Employ Functions: String, Numeric, Aggregate (No Grouping)String FunctionsNumeric FunctionsAggregate FunctionsCritical Skill 4.7 Use Dates and Data Functions (Formatting and Chronological)Date FunctionsSpecial Formats with the Date Data TypeNested FunctionsCritical Skill 4.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, SelfInner JoinsOuter JoinsProject 4-1 Join Data Using Inner and Outer JoinsProject 4-2 Join Data Using ANSI SQL JoinsSelf-JoinsCritical Skill 4.9 Learn the Group By and Having ClausesGroup ByHavingProject 4-3 Group Data in Your Select StatementsCritical Skill 4.10 Learn Subqueries: Simple and Correlated Comparison with JoinsSimple SubqueryCorrelated Subqueries with JoinsCritical Skill 4.11 Use Set Operators: Union, Intersect, MinusUnionUnion AllIntersectMinusProject 4-4 Use the Union Function in Your SQLCritical Skill 4.12 Use ViewsCritical Skill 4.13 Learn Sequences: Just Simple StuffCritical Skill 4.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering ExceptionsLinkage to Entity ModelsTypesDeferredCritical Skill 4.15 Format Your Output with SQL *PlusPage and Line SizePage TitlesPage FootersFormatting ColumnsProject 4-5 Format Your SQL OutputWriting SQL*Plus Output to a FileChapter 4 Mastery Check