MySQL Essential Training

Harness The Power Of MySQL The Exercise Files A Brief Overview Of SQL Database Organization

Selecting Rows Selecting Columns Counting Rows

Inserting Data Updating Data Deleting Data Joining Queries Across Tables

Finding Databases, Tables, And Columns What Are Data Types The CREATE TABLE Statement Numeric Types Date And Time Types String Types Enumeration Types The SERIAL Type Alias

String Concatenation Numeric Conversions Trimming And Padding Case Conversion Substrings Soundex Comparison Operators Logical Operators Arithmetic Operators Operator Precedence The CASE Statement The IF Function String Comparisons Regular Expressions

Value Functions Basic Math Simple Trigonometry Logarithms Radians And Degrees String Contatenation Quote Marks Integer Division Comments Thank You