Oracle Database 12c R2 SQL: Using Basic SELECT statements
Oracle SQL 12c
| Beginner
- 12 Videos | 59m 17s
- 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 statementsrecognize 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 a character expression in the SQL statement output"use literal character strings in a SELECT statementdescribe when to use the WHERE clauseeliminate 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
-
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.