SQL Queries: All-in-One

Course objective

Gain a broader knowledge and skills in SQL Queries. You will learn everything, such as executing a simple query, performing a conditional search, working with functions, organizing data, retrieving data from multiple tables, and much more. After completing this course you will be qualified to work with database queries related jobs, such as data engineer and data administrator.

What is included

  • Pre and post assessment
  • Flashcards and quizzes
  • Virtual labs
  • Study planner
  • Certification of completion

Course outline

  1. Executing a simple query
  2. Performing a conditional search
  3. Working with functions
  4. Organizing data
  5. Retrieving data from multiple tables
  6. Exporting query results
  7. Using subqueries to perform advanced querying
  8. Manipulating table data
  9. Manipulating the table structure
  10. Working with views
  11. Indexing data
  12. Managing transactions
  13. Appendix A