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 statementRecognize the rules and guidelines for constructing valid sql statements in sql developer and sql*plusDescribe and use the arithmetic expressions in sqlApply the standard order of precedence in sql arithmetic expressionsIdentify how null values are defined in sql and how they affect arithmetic expression outcomesDefine column aliases in the select list
-
Use the concatenation operator to create acharacter expression in the sql statement outputUse literal character strings in a select statementUse the alternative quote (q) operator to select a quotation mark delimiterEliminate duplicate rows from sql statement output using the distinct qualifierDisplay the structure of a table using the sql*plus describe commandSelect 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
-
3m 50sUpon completion of this video, you will be able to describe and use arithmetic expressions in SQL. FREE ACCESS
-
3m 21sIn this video, learn how to apply the standard order of precedence in SQL arithmetic expressions. FREE ACCESS
-
4m 27sIn this video, you will learn how NULL values are defined in SQL and how they affect arithmetic expression outcomes. FREE ACCESS
-
3m 37sDuring this video, you will learn how to define column aliases in the SELECT statement. FREE ACCESS
-
2m 20sIn this video, you will learn how to use the concatenation operator to create a character expression in the SQL statement output. FREE ACCESS
-
2m 50sLearn how to use literal character strings in a SELECT statement. FREE ACCESS
-
2m 23sLearn how to use the alternative quote (q) operator to select a quotation mark delimiter. FREE ACCESS
-
2m 18sIn this video, find out how to eliminate duplicate rows from SQL statement output using the DISTINCT keyword. FREE ACCESS
-
2m 44sLearn how to display the structure of a table using the SQL*Plus DESCRIBE command. FREE ACCESS
-
6m 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.YOU MIGHT ALSO LIKE
Book
Job Ready SQL