SELECT Statement, Expressions, & Operators
Oracle 12c
| Beginner
- 12 videos | 42m 20s
- Includes Assessment
- Earns a Badge
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.
WHAT YOU WILL LEARN
-
Describe and use the basic select statement
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 acharacter expression in the sql statement output
Use literal character strings in a select statement
Use the alternative quote (q) operator to select a quotation mark delimiter
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
-
4m 33sUpon completion of this video, you will be able to describe and use the basic SELECT statement. FREE ACCESS
-
3m 54sUpon completion of 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
-
3. Arithmetic Expressions3m 50sUpon completion of this video, you will be able to describe and use arithmetic expressions in SQL. FREE ACCESS
-
4. Operator Precedence in Arithmetic Expressions3m 21sIn this video, learn how to apply the standard order of precedence in SQL arithmetic expressions. FREE ACCESS
-
5. Null Values4m 27sIn this video, you will learn how NULL values are defined in SQL and how they affect arithmetic expression outcomes. FREE ACCESS
-
6. Column Aliases3m 37sDuring this video, you will learn how to define column aliases in the SELECT statement. FREE ACCESS
-
7. Concatenation Operator2m 20sIn this video, you will learn how to use the concatenation operator to create a character expression in the SQL statement output. FREE ACCESS
-
8. Literal Character Strings2m 50sLearn how to use literal character strings in a SELECT statement. FREE ACCESS
-
9. Alternative Quote Operator2m 23sLearn how to use the alternative quote (q) operator to select a quotation mark delimiter. FREE ACCESS
-
10. Duplicate Rows2m 18sIn this video, find out how to eliminate duplicate rows from SQL statement output using the DISTINCT keyword. FREE ACCESS
-
11. Displaying Table Structure2m 44sLearn how to display the structure of a table using the SQL*Plus DESCRIBE command. FREE ACCESS
-
12. Exercise: Retrieving Data Using SQL Statements6m 3sIn this video, 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.
