Database Fundamentals
  • Introduction
  • Choosing a GUI
  • Connecting to our Database
  • Connection Properties
  • Database Tables Explained
  • Creating a Database Table
  • Inserting Records
  • Exercise: Inserting Records
  • Data Types
  • Dropping a Table
  • Start Querying your data using SELECT
  • Counting Records
  • You have access to other databases! Check it out!
  • Previewing your records
  • Filtering records and numeric data types
  • Filtering records using Greater Than operator
  • Filtering records using Less Than operator
  • Using the BETWEEN condition
  • Counting a subset of records
  • Intro to AND
  • Solutions to Exercise
  • Using the OR condition
  • Sorting data with ORDER BY
  • Ordering by ordinal column
  • Solutions to Excercise
  • The LIKE operator
  • The NOT LIKE operator
  • THE IN operator
  • Solutions to Excercise
  • Using MIN and MAX
  • Rounding and other Arithmetic
  • Solution to Excercise
  • End of Part I