logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Programación / Oracle
Harvard vía Coursera
GRATIS

Oracle SQL Exam Prep

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    Siempre Abierto

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • SQL and Table Design
    • In this module, we'll introduce you to the course and discuss which topics we'll cover. We'll also explore why SQL is a powerful tool to use and some of it's uses. Then, we'll explore table design and schemas.
  • SQL Database Terms
    • In this module, we'll explore some of the key terms you'll need to know when building SQL Databases. We will compare and contrast the ANY and ALL operators, distinguish between COMMIT and ROLLBACK, and explore pseudocolumns. We will also give examples for some of these terms.
  • Key Constraints and the USING Clause
    • In this module, we'll review primary and foreign keys, delving a little more into their constraints. We'll also explore the USING clause and what it is used for.
  • Functions, Subqueries, Pseudocolumns, and Views
    • In this module, we'll take a look at INSTRING and SUBSTRING functions and demonstrate naming a column using an alias. We will also explore subqueries and take another look at pseudocolumns. Lastly, we'll discuss views and compare them with materialized views.
  • Practice Certification Quiz
    • The following ungraded quiz will help you practice what you have learned before taking the Oracle SQL Certification Exam.