Oracle Database 12c R2 SQL: Using Basic SELECT statements
Oracle SQL 12c
12 Videos | 1h 4m 47s - Includes Assessment
- Earns a Badge
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
-
1.The Basic SELECT Statement3m 49s
-
2.Writing SQL Statements7m 32s
-
3.Arithmetic Expressions3m 57s
-
4.Operator Precedence in Arithmetic Expressions4m 47s
-
5.NULL Values3m 4s
-
6.Column Aliases4m 21s
-
7.Concatenation Operator3m 34s
-
8.Literal Character Strings5m 1s
-
9.WHERE Clause9m 2s
-
10.Duplicate Rows4m 4s
-
11.Displaying Table Structure2m 24s
-
12.Exercise: Retrieving Data Using SQL Statements7m 43s
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.
