دوره آموزشی مقدماتی Oracle Database (مفاهمیم پایه و عملیاتی در محیط های کاری)

مهندس محمدحسین قربانی

تدریس به صورت حضوری و آنلاین

ویژگی دوره:

پس از پایان دوره بیش از 90% مفاهیم تدریس شده در محیط های عملیاتی و کاری بکار گرفته خواهد شد (بدون پیش نیاز)

سرفصلها:

1- Oracle Keys, Constraints and Indexes
Primary Keys Create, Alter, Drop, enable and disable primary keys
Foreign Keys Create, drop, enable and disable foreign keys
Unique Constraints Create, alter, drop, enable and disable unique constraints
Check Constraints Create, alter, drop, enable and disable check constraints
Indexes Create, rename and drop indexes(performance tuning)

2- Oracle Programming
Functions Create and drop functions
Procedures Create and drop procedures
Triggers Create, drop, enable, and disable triggers
Declaring Variables Declare variables and constants
Exception Handing Exception handling in code
Loops and Conditional statements FOR Loops, WHILE Loop, IF-THEN-ELSE and others
Sequences (Autonumber) Create and drop sequences
Transactions Commits and Rollbacks
Comments within SQL How to create comments within your sql statement

3- Oracle System Tables
Oracle system tables and descriptions

4- Oracle Comparison Operators
Comparison Operators Operators such as =,<>,!=,>,<,and so on

5- Oracle Query Types
SELECT statement Retrieve records from a table
INSERT statement Insert records into a table
INSERT ALL statement Insert multiple records into one or more tables
UPDATE statement Update records in a table
DELETE statement Delete records from a table
TRUNCATE TABLE statement Delete all records from a table (no Rollback)
UNION Operator Combine 2 results sets (Remove duplicates)
UNION ALL operator Combine 2 results sets (includes duplicates)
INTERSECT operator Intersection of 2 result sets
MINUS operator Result set of one minus the result set of another
Subqueries A query within a query

6- Oracle Joins
Inner and Outer joins

7- Oracle Aliases
ALIASES Create a temporary name for a column or table

8- Oracle Clauses
DISTINCT Clause Retrieve unique records
FROM Clause List tables and join information
WHERE Clause Filter results
ORDER BY Clause Sort query results
GROUP BY Clause Group by one or more columns
HAVING Clause Restrict the groups of returned rows