The Complete SQL Course

About this course

Mastering SQL is a fundamental skill in almost any enterprise software solution. From accessing databases from within code as a developer, to querying data as an analyst, the ability to write and execute SQL is critical. Complete SQL, covers everything you need to master this critical skill.  The course is broken down into seven sections. Here's what you'll learn: Section 1 - Introduction In this introductory section, you’ll see a quick overview of relational databases, and see an example of how relational databases are comprised of tables, columns, rows, and how tables can relate to one another. Section 2 - Set Up Training Environment This section steps you through the software needed to set up your training environment that you’ll use throughout the course. You’ll see step-by-step demonstrations on how to install Oracle Database Express and Oracle SQL Developer, and you’ll create your own database. Section 3 - SQL Fundamentals These are the fundamental skills every SQL writer needs to know. You’ll learn how to: Query data from tablesSort query resultsGroup query resultsQuery from multiple tables, combining results You’ll learn about String functionsNumeric functionsDate functions Section 4 - Subqueries In this section, you’ll learn how to use query from the results of a subquery. You’ll learn how to write: In-Condition SubqueriesCorrelated SubqueriesUncorrelated SubqueriesExists Condition Subqueries Section 5 - Keys and Indexes

Course objectives

• To equip learners with fundamental SQL skills
• To enable learners to write and execute complex queries
• To provide practical experience in setting up database environments