Oracle Database 12c R2 SQL: Using Basic SELECT statements

Oracle SQL 12c    |    Beginner
  • 12 videos | 59m 17s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)
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

  • 3m 49s
    During this video, you will learn how to use basic SELECT statements. FREE ACCESS
  • 7m 32s
    After completing this video, you will be able to recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus. FREE ACCESS
  • Locked
    3.  Arithmetic Expressions
    3m 57s
    Upon completion of this video, you will be able to describe and use arithmetic expressions in SQL. FREE ACCESS
  • Locked
    4.  Operator Precedence in Arithmetic Expressions
    4m 47s
    To apply the standard order of precedence in SQL arithmetic expressions, find out how to do so. FREE ACCESS
  • Locked
    5.  NULL Values
    3m 4s
    In this video, you will learn how NULL values are defined in SQL and how they affect arithmetic expression outcomes. FREE ACCESS
  • Locked
    6.  Column Aliases
    4m 21s
    In this video, learn how to define column aliases in the SELECT statement. FREE ACCESS
  • Locked
    7.  Concatenation Operator
    3m 34s
    In this video, you will learn how to use the concatenation operator to create a character expression in the SQL statement output. FREE ACCESS
  • Locked
    8.  Literal Character Strings
    5m 1s
    Learn how to use literal character strings in a SELECT statement. FREE ACCESS
  • Locked
    9.  WHERE Clause
    9m 2s
    Upon completion of this video, you will be able to describe when to use the WHERE clause. FREE ACCESS
  • Locked
    10.  Duplicate Rows
    4m 4s
    In this video, you will learn how to eliminate duplicate rows from SQL statement output using the DISTINCT keyword. FREE ACCESS
  • Locked
    11.  Displaying Table Structure
    2m 24s
    Learn how to display the structure of a table using the SQL*Plus DESCRIBE command. FREE ACCESS
  • Locked
    12.  Exercise: Retrieving Data Using SQL Statements
    7m 43s
    In this video, you will learn how to select data from different tables, describe tables, perform arithmetic calculations, and specify column names using aliases. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Journey How to Transform Tables with SQL
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Book Practical Oracle SQL: Mastering the Full Power of Oracle Database

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 74 users Rating 4.6 of 74 users (74)
Course Oracle Database 12c R2 SQL: Managing Schema Objects
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)