MySQL Mentor: General MySQL Syntax

• EXAM CRAM: GENERAL MYSQL SYNTAX FOR DEVELOPERS

Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words

• Schema Object Names (Identifiers)
• Identifier Qualifiers
• Identifier Case Sensativity
• Lower Case table names override
• Problems with Column Aliases
• Keywords and Reserved Words

Identify MySQL data type properties and appropriate usage

• Data Types
• Storage Requirements
• Data Type Default Values
• Fractional Seconds New in 5.6
• Numeric Type Arributes
• Timestamp Initialization

Recognize and use common functions and expressions for all MySQL data types

• Functions and Operators

Identify and use comment syntax

• Comment Syntax

Describe and utilize prepared statements

• Preapred Statement Syntax

Describe transactions and transaction isolation levels and the impact they have on database behavior

• START TRANSACTION, COMMIT, and ROLLBACK Syntax
• Transactions and Atomic Operations"
• Transaction Isolation Level Index
• SQL Modes