| |
Course Fee:
$998.00
Course Time: 2 Days, 9am - 4pm
Overview
-
Databases and Database Models –
-
SQL
Objects & Tools Overview
SQL
Language Components – Overview
-
Data
Definition; Control; Manipulation; Language
Data
Manipulation
-
Select
Syntax
-
Result
Set
-
Simple
Select Examples
-
The
‘Order By’ Clause
Data
Types – Numeric, Character, Temporal
-
Exact
vs. Approximate Numeric
-
Math
Functions, Precedence and Extensions
-
Numeric
Conversions
-
String
Manipulation and String Functions
-
String
Conversions
-
Date
time Data types
Expression
-
What
can be in an Expression?
-
Types
and Examples of Expression – Numeric, Character, Date
-
Select
Statements with Expression
-
Constants and Columns
-
Naming Select Columns and Aliases
|
|
