Home      Signup      Courses      Sign-In

  Please login to Enroll or Access the course.  
  Summary Page: Introduction to SQL: Multiple Tables and Advanced Queries

Introduction to SQL: Multiple Tables and Advanced Queries

As with any development skill in the industry, learning the core fundamentals creates a foundation. In the course, you will learn about multi-table database architecture and design; connecting several tables; and concepts using inner outer joins, equijoins, and non-equijoins. You will also learn about subqueries and advanced queries in SQL; using statements with multiple conditions and multiple joins; new operators; and functions to manage your data. This course also covers Multijoins, UNION operator, and functional dependencies. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.

Individuals interested in learning multi-layer architecture in SQL and about joins, subqueries, and functional dependencies


Multi-table Database Architecture in SQL

  • define multiple tables and describe their use in SQL
  • use SQL for the process of connecting tables
  • use FOREIGN KEY with CREATE in SQL architecture
  • describe relationships between tables and the different patterns
  • use composite keys and their relative values
  • describe the functional dependencies and their use
  • use functional dependencies in a example
  • SQL Joins and Multi-table Operations

  • use inner joins in SQL
  • use equijoins and non-equijoins and describe their differences in SQL architecture
  • use Outer Joins in SQL
  • use multiple joins and multiple conditions in SQL
  • use the UNION operator and describe how it combines results
  • Subquery – Queries Inside of More Queries

  • describe a subquery and its use in SQL
  • use query as a SELECT column in SQL
  • use correlated and noncorrelated queries in SQL
  • use a query with a natural join
  • use IN, NOT IN commands in SQL
  • use correlated query with EXISTS and NOT EXISTS operators
  • use HAVING clause in SQL with queries
  • use queries with the UPDATE statement in SQL
  • use queries with the INSERT statement in SQL
  • use queries with the DELETE FROM statement in SQL
  • Look at Advanced Queries in SQL

  • use SQL to create a more complex query
  • use SQL more efficiently with operational tips

  • df_sqli_a03_it_enus


    Home      Signup      Courses      Sign-In

      UN Global Alliance for ICT and Development ESKILLS360 IS A UN GAID FLAGSHIP INITIATIVE