3/6 Whitson Terrace
Edinburgh
EH11 3AY
Mobile: 07584 3... 07584 359500
Monday to Sunday: 9am - 5:30pm
SAS-BASE
For Beginners, Basic Concepts of SAS, Theories and Rules, Programming Techniques, Windowing Environment, DATA and PROC REPORT techniques for analysing the data.
SAS-ADVANCED
ODS, STAT, GRAPHICS and many more advanced workshops involving efficiencies to meet current market needs
SAS-BI
For analytics and banking, finance purposes. Introduction to EG, Customizing EG options, DI STUDIO
SAS-CLINICAL
For Clinical Research Trials, Data Management, analysing and reporting the data.
SQL- Standard language for accessing databases.
We expertise you how to use SQL to access database using commands Select, distinct, where, and , or, order by , insert, update, delete, injections, like, wildcards, in between, aliases, joins etc...
and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.
Introduction to SQL constructs
• Review of Basic SQL statements
Select
Project
Join
Describing Oracle tables
Exercise – investigate the EMP database
• Restricting row returns
Where clause
Exercise – write a sample query in the emp database
Complex Boolean logic in SQL
ROWID restrictions
Exercise – write a sample query in the emp database
Using SQL*Plus
• Creating basic reports
Exercise – format a simple query in the emp database
• Using the set commands
Adjusting line output
Setting pagesize and linesize
Echo
Feedback
Verify
termout
Exercise – set the SQL*plus environment
• Column wrapping
Exercise – add column statements
• Creating breaks and summaries
Exercise – add breaks and summaries
• Adding prompts to queries
Exercise – parametrize a SQL*Plus script
Joining Oracle tables
• Equi-join
Exercise – write an equi-join
• Outer join
Exercise – write an outer join
• Hiding joins by creating views
Exercise – create a view of a join
• Using IN, NOT IN, EXISTS and NOT EXISTS
• Sub queries
Exercise – write a sub-query
• Correlated sub-query
• Non-correlated sub-queries
Advanced SQL operators
• Between operator
• IN and NOT In operators
• Sub-queries
• EXISTS clause
• Using wildcards in queries (LIKE operator)
Aggregation in SQL
• Count(*)
• Sum
• Avg
• Min and max
• Using the group by clause
SQL access methods
• Review of Basic joining methods
• Merge join
• Hash Join
• Nested Loop join
• Advanced SQL operators
• Between operator
QL Tuning
• Introduction to rule-based optimization
• Introduction to cost-based optimization
• Collecting table and index statistics
• Using column histograms
• Changing the default optimizer modes
• Using TKPROF
• Using SQL*Trace
• SQL re-usability within the library cache
• Table high-water mark
• Table striping and table partitions
• Using EXPLAIN PLAN
• Interpreting EXPLAIN PLAN Output
• Using indexes to improve performance
• Identifying full-table scans
• Re-writing SQL queries
• Using hints to improve SQL performance
• Using parallel query to improve performance
• Tuning sub-queries
PL/SQL
Basics of PL/SQL
• PL/SQL architecture
• PL/SQL and SQL*Plus
• PL/SQL Basics
Variables
Constants
Datatypes
Error messages – user_errors and show errors
• PL/SQL wrapper utility
PL/SQL structures
• Simple blocks
• Control structures
• PL/SQL records
• Recognizing the Basic PL/SQL Block and Its Sections
• Describing the Significance of Variables in PL/SQL
• Distinguishing Between PL/SQL and Non-PL/SQL Variables
• Declaring Variables and Constants
• Executing a PL/SQL Block
Error checking – exception handling
• Defining exceptions
• Using the when others clause
• Ensuring complete error checking
• Passing error messages to calling routine
Boolean logic in PL/SQL
• Identifying the Uses and Types of Control Structures
• Constructing an IF Statement
• Constructing and Identifying Different Loop Statements
• Controlling Block Flow Using Nested Loops and Labels
• Using Logic Tables
• If-then-else structure
• Testing for numbers characters and Boolean
Cursors in PL/SQL
• Cursor basics
• Using a cursor for a multi-row SQL query
Iteration in PL/SQL
• For loop
• While loop
PL/SQL tables
• Defining PL/SQL tables
• Reasons to use PL/SQL tables
• Populating a PL/SQL table
• Retrieving from a PL/SQL table
Dynamic SQL in PL/SQL
• Introduction to the DBMS_SQL package
• Creating a dynamic SQL statement
Nested blocks in PL/SQL
• Creating nested blocks
• Understanding scope in nested blocks
Triggers in PL/SQL
• Triggers and database events
• Defining a trigger
• Timing a trigger
• Enabling and disabling a trigger
Stored procedures, functions and packages
• Basics of stored procedures
• Basics of functions
• Basics of packages
• Defining stored procedures & functions
• Function and stored procedures prototypes
• Passing arguments to functions and stored procedures
• Recompiling functions and stored procedures
• Pinning packages in the SGA with dbms_shared_pool.keep
• Package forward declaration
• Package dependency
• Package overloading
• Listing package information
Bulking in PL/SQL
• Bulk queries
• Bulk DML (forall statement)
• Using cursor attributes
• Analyzing impact of bilk operations
OTM
OTM - Oracle transportation management.
Functional
What is Logistics?
What is SCM?
What is the difference between Logistics and SCM?
Technical
How to implement SCM in OTM is specialised.
We makes you familiar to use OTM in all possible ways like configuring order base, order release, Shipments, Agents, Refnums, Remarks ....
Techno Functional
We make you techno functional consultant by making you know everything about logistics, SCM and implementing these in OTM by making you to build different types of shipments like Multi Stop, Multi Leg, Milk run, Consolidation, De-consolidation, X Dock...
We train you in all detailed courses involving website design and development
would strongly recommend, personal interest and support all through my training Regards Nav
Nav Kandy - 07/12/2013 | report this review
All fields are required. Your review will appear immediately.
SAS SAS-BI, SAS-ANALYTICS, SAS-BASE, SAS-ADVANCED, SAS-CLINICAL SQL BASICS AND ADVANCED OTM PL/SQL WEBDESIGN AND DEVELOPMENT
Price: from £100