Page 11 - US Services Brochure

Core Foundation ModulesAll consultants undergo an initial 3 weeks of foundation training which includes professional skills, SQL and UNIX.Professional Skills• Interview techniques • Communication skills • Conflict resolution• Assertiveness at work • Time management• Presentation skills• Effective report writing• Improving personal successSQL• Table joins, queries• Data types• SQL best practice• Functions and procedures • DDL, DML, DCL• Statements, schema, syntax • NormalizationUNIX• Functions, parameters and variable scope• Grep and regular expressions• Use of the vi editor• Piping and redirection• Writing shell scripts• File permissions• I/O streams• Conditionals• LoopsAdditional Foundation Modules May IncludeFinance• Introduction to financial services • Financial assets and markets• Equities• Bonds• Derivatives• Investment funds• Taxation, investment wrappers andtrusts• Other financial retail products • Trade lifecycle• RiskWeb Apps Design• HTML5 • CSS3• UML• XML• XSD• Responsive web designExcel VBA• Excel - basics• Arithmetic, text and date functions • Lookup functions• WHATIF analysis• Pivot tables and pivot charts• Conditional formatting• Array functions• Aggregation functions• VBA Excel object model• VBA subroutines and functionsOnce completed, our consultants progress to training on their specific stream within the business or technical pathways.11