SAS Training: SAS SQL
|
Summary
|
|
|||||||||||||||||
SAS Training: SAS SQL
SAS Training: SAS SQL
SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System benefit from this course in SAS SQL.
This course covers Proc SQL in detail, concentrating on the use of SQL for existing SAS Programmers. Traditional SAS Data steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.
Interested in this SAS Training: SAS SQL course? Contact SAS Training here to find out more
If you want to find out more about SAS Training: SAS SQL, you can make an information request below and the school will contact you with further information.
Suitability and application
To participate in this SAS Training: SAS SQL course, delegates should have taken the SAS Fundamentals course and have some experience of SAS programming.
Find out if this SAS Training: SAS SQL course is suitable for you by Requesting Information here
SAS Training: SAS SQL course outline
The course includes the following modules:
- Q1 Introduction to Proc SQL
- Q2 Selecting Data
- Q3 Combining Data
- Q4 Creating Data
Introduction to Proc SQL
Concepts
The SAS Data Model
Workshop Session
The Select Statement
Controls and Enhancements
Analysis on Groups
Syntax Summary
Workshop Session
Inner Joins
Outer Joins
Other Joins
Subqueries
Set Operations
Workshop Session
Creating Tables, Views and Indexes
Changing Data in Tables
Changing the Structure of Tables
Further Topics
Workshop Session
Delivery Options
Public Courses
Our public SAS training schedule is ideal for customers who do not have training facilities or for small groups and individuals who wish to attend training away from their offices. All Amadeus public events are held at our training centre, Mulberry House, a recently renovated Victorian building which is located in a tranquil setting overlooking Church Green, Witney Oxfordshire. Our training room is equipped with the latest hardware, software and demonstration equipment.
On-Site Training
You can benefit from the familiarity of existing systems and data by holding a SAS training course at your offices. As the course is exclusive to your organisation, delegates can interact with peers and discuss and ask questions specific to your day to day activities. Our standard course curriculum can be delivered or you can create a customised course tailored to your organisations needs.
Amadeus have extensive experience in delivering standard and customised SAS training programs to customers who have offices throughout the UK and across the globe.
Expenses
The cost of this SAS Training: SAS SQL is £325 per delegate - find out more here.
Amadeus Software Limited
Amadeus Software has over 20 years of expertise in providing SAS training, with an international reputation for exceptional trainers, high quality course materials and continuous professional development.
We offer essential SAS Fundamentals courses, through to more Advanced Programming Techniques, Graphics, Reporting and Statistics. All our courses are highly interactive and we actively encourage delegate participation. They are delivered by our own expert SAS certified training team in small groups to ensure individual attention.
We are dedicated to providing excellent quality and effective SAS training courses focused on improving SAS business performance.
Blended Learning Approach
Amadeus Software has a Blended Learning Approach in which both classroom and online training programmes are available to ensure maximum effectiveness for delegates, while ensuring maximum cost-effectiveness for your organisation. Delivery Options available are:
- Public Training
- On-site Training
- e-Learning
Training courses are classroom based and are a mixture of demonstration sessions and workshop sessions. Courses can be customised to suit your requirements.
Why Choose Amadeus for your SAS Training?
Trainers
'The best course instructor I have had for SAS training, clear, knowledgeable, calm and helpful' Pfizer - Macro and GPLOT
- Full time SAS Consultants
- Experienced and have used SAS for many years
- Use SAS on a daily basis as well as teaching
- Are SAS certified
- Follow an internal training programme
- Bring real world experience to the classroom
- Understand the importance of a practical approach
Course Materials
'Good course notes and exercises. Instructor knew the course content very well.'
HBOS - SAS Programming
- Structured in modules enabling us to incorporate any degree of customisation
- Organised into sessions, lectures and workshops
- Colour training materials
- Courses are written from many years of experience
- Fully indexed
- Packed full of examples and SAS techniques
- Good reference material to use back in the workplace
- Update On a regular basis controlled by our ISO9001:2000 Quality Procedures
Show all courses with
Amadeus Software Limited
Request information - obligation free
Contact information for Amadeus Software Limited
Amadeus Software Limited
OX28 4AZ Witney, Oxfordshire
Phone no: +44 (0) 1993 848010 
www.amadeus.co.uk
Contact Amadeus Software Limited
To request information from SAS Training: SAS SQL, please fill out the following details:
