Introduction
  • Introduction
  • Welcome to Udemy
Install Oracle Express Edition and SQL Developer
  • Download Oracle Express Edition
  • Install Oracle Express Edition
  • Download and Install Oracle SQL Developer
Opening Oracle SQL Developer
  • Connect to Database
  • Solving the "The network adaptor cannot establish the connection" error
The SELECT, FROM and WHERE clauses
  • The SELECT and FROM clauses
  • Renaming fields
  • Using the AS keyword
  • Semicolons and comments
  • The WHERE clause
The GROUP BY, HAVING and ORDER BY clauses
  • The GROUP BY clause
  • The HAVING clause, and information about error messages.
  • The ORDER BY clause
  • Remembering the order of the clauses
  • Practice Activity Number 1
  • Practice Activity Number 1 - The Solution
What's Next?
  • What should you learn, and resources for you
  • Bonus video - Learn more, and save money!
  • Bonus lecture - Here's the link for more
  • Thank you for watching