Oracle Database 12c R2 SQL: Using Basic SELECT statements

Oracle SQL 12c
  • 12 Videos | 1h 4m 47s
  • Includes Assessment
  • Earns a Badge
Likes 41 Likes 41
Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.

WHAT YOU WILL LEARN

  • use the basic SELECT statements
    recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus
    describe and use the arithmetic expressions in SQL
    apply the standard order of precedence in SQL arithmetic expressions
    identify how NULL values are defined in SQL and how they affect arithmetic expression outcomes
    define column aliases in the SELECT list
  • "use the concatenation operator to create a character expression in the SQL statement output"
    use literal character strings in a SELECT statement
    describe when to use the WHERE clause
    eliminate duplicate rows from SQL statement output using the DISTINCT qualifier
    display the structure of a table using the SQL*Plus DESCRIBE command
    select data from different tables, describe tables, perform arithmetic calculations, and specify column names using aliases

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE