archive-za.com » ZA » 2 » 2KO.CO.ZA

Total: 380

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Oracle Expert Training Course Cape Town South Africa
    Sort the rows that are retrieved by a query Using Single Row Functions to Customize Output Describe various types of functions that are available in SQL Use character number and date functions in SELECT statements Describe the use of conversion functions Reporting Aggregated Data Using the Group Functions Identify the available group functions Describe the use of group functions Group data by using the GROUP BY clause Include or exclude grouped rows by using the HAVING clause Displaying Data from Multiple Tables Write SELECT statements to access data from more than one table using equijoins and nonequijoins Join a table to itself by using a self join View data that generally does not meet a join condition by using outer joins Generate a Cartesian product of all rows from two or more tables Using Subqueries to Solve Queries Define subqueries Describe the types of problems that subqueries can solve List the types of subqueries Write single row and multiple row subqueries Using the Set Operators Describe set operators Use a set operator to combine multiple a single query Control the order of rows returned Manipulating Data Describe each data manipulation language DML statement Insert rows into a table Update rows in a table Delete rows from a table Control transactions Using DDL Statements to Create and Manage Tables Categorize the main database objects Review the table structure List the data types that are available for columns Create a simple table Explain how constraints are created at the time of table creation Creating Other Schema Objects Create simple and complex views Retrieve data from views Create maintain and use sequences Create and maintain indexes Create private and public synonyms Managing Objects with Data Dictionary Views Use the data dictionary views to research data on your objects Query various data dictionary views

    Original URL path: http://2ko.co.za/courses/oracle/oracleSQL_Expert.html (2015-12-05)
    Open archived version from archive

  • Cape Town Oracle SQL Training Course Certification 11g South Africa
    SQL statements Write a query containing the arithmetic operators Use aliases to customize column headings Create a character expression with the concatenation operator Use the quote operator q to control text strings containing the quote character Using the iSQL Plus Environment SQL statements versus iSQL Plus commands Explaining the iSQL Plus interface Interacting with script files Setting iSQL Plus Preferences Restricting Data Limit Rows Using a Selection Use the WHERE Clause List the main Comparison Conditions Use the LIKE Condition to Compare Literal Values List the Logical Conditions AND OR NOT Use Multiple Conditions in the WHERE clause Describe the Rules of Precedence Sorting Data Sort Rows with the ORDER BY Clause Use the Substitution Variable Use the iSQL Plus DEFINE Command Use the VERIFY Command SQL Functions Differentiate between Single Row and Multiple Row SQL Functions Categorize the Character Functions into Case Manipulation and Character Manipulation types Explain the Numeric Functions ROUND TRUNC and MOD List the Rules for Applying the Arithmetic Operators on Dates Use the Arithmetic Operators with Dates in the SELECT Clause Explain the DATE functions MONTHS BETWEEN ADD MONTHS NEXT DAY LAST DAY ROUND and TRUNC Explain Implicit and Explicit conversion Nest Functions to Perform Multiple Tasks in One Statement Conditional Expressions Use the CASE Expression Explain the DECODE Expression Aggregating Data Using Group Functions Categorize the Types of Group Functions Use the AVG SUM MAX MIN and COUNT Functions in a Query Utilize the DISTINCT Keyword with the Group Functions Describe how Nulls are handled with the Group Functions Create Groups of Data with the GROUP BY Clause Group Data by more than one column Avoid Illegal Queries with the Group Functions Exclude Groups of Data with the HAVING Clause Displaying Data from Multiple Tables Identify Types of Joins Retrieve Records with Natural Joins Use Table Aliases to write shorter code and explicitly identify columns from multiple tables Create a Join with the USING clause to identify specific columns between tables Use the ON clause to specify arbitrary conditions or specify columns to Join Create a Three way join with the ON clause to retrieve information from 3 tables List the Types of Outer Joins LEFT RIGHT and FULL Generating a Cartesian Product Using Subqueries Use a sub query to solve a problem Identify where sub queries can be placed in a SELECT statement Describe the types of sub queries single row multiple row Show the single row sub query operators Use the group functions in a sub query Identify illegal statements with sub queries Show the multiple row sub query operators Explain how null values are handled in sub queries Using the Set Operators Use the UNION operator to return all rows from multiple tables and eliminate any duplicate rows Use the UNION ALL operator to return all rows from multiple tables with duplicates Describe the INTERSECT operator Use the INTERSECT operator Explain the MINUS operator Use the MINUS operator List the SET operator guidelines Order results when using the UNION operator Inserting

    Original URL path: http://2ko.co.za/courses/oracle/oracle11gSQL_Fundamentals.html (2015-12-05)
    Open archived version from archive

  • Oracle PL/SQL Development Course Cape Town South Africa
    via elearning enabling 2KO students the opportunity to study courses online world wide to ensure the best training possible Oracle PL SQL Developer Certified Associates demonstrate expertise in building database centric Internet applications for both Oracle9i and Oracle Database 10g Oracle forms Developer Certified Professionals gain greater credibility a higher level of efficiency and improved job performance as application developers Associate Certification Path Advanced Professional Cert Path Option 1 Advanced Professional Cert Path Option 2 STEP 1 PASS THIS EXAM Choose one of these exams STEP 1 PRIOR CERTIFICATION Oracle PL SQL Developer Certified Associate STEP 1 PASS THIS EXAM Choose one of these exams IZO 007 Introduction to Oracle9i SQL or IZO 047 Oracle Database SQL Expert or IZO 051 Oracle Database 11g SQL Fundamentals l STEP 2 PASS THIS EXAM Oracle 11g Advanced PL SQL IZO 146 IZO 007 Introduction to Oracle9i SQL or IZO 047 Oracle Database SQL Expert or IZO 051 Oracle Database 11g SQL Fundamentals l STEP 2 PASS THIS EXAM Choose one of these exams Oracle Advanced PL SQL Developer Certified Professional STEP 2 PASS THIS EXAM Choose one of these exams IZO 147 Program with PL SQL or IZO 144 Oracle Database 11g

    Original URL path: http://2ko.co.za/courses/oracle/oraclePL_SQL_Developer.html (2015-12-05)
    Open archived version from archive

  • Oracle 11g Course Database Certification Cape Town
    Oracle Database Earning an Oracle Database certification advances and maximizes your career potential Use the knowledge skills and recognition you gain to improve your job prospects earn more money and become a more valuable employee Oracle Database technology is used by the world s leading companies to manage critical business functions systems and processes Oracle Database is the number one database in the world Over 305 000 top companies trust their critical systems to Oracle Database Oracle Database is the number one embedded database technology In fact 97 of Global Fortune 500 companies use Oracle software Well trained highly skilled database professionals who can manage critical systems are in high demand Becoming Oracle Certified The process of becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features functions and tasks Oracle Database certification teaches you how to perform complex hands on activities through labs study and practice Additionally Oracle certification exams validate your capabilities using real world scenario based questions that assess and challenge your ability to think and perform Become a Better Technologist Ultimately becoming Oracle Certified will help you become a better technologist You ll become more valuable

    Original URL path: http://2ko.co.za/courses/oracle/oracleDatabseCertification_11g_CDA.html (2015-12-05)
    Open archived version from archive

  • Black Belt Six Sigma Training Course Cape Town Johannesburg | 6 Sigma
    Using a clearly defined leadership roadmap align organization structure compensation succession planning IT resources and more Avoid the classic Six Sigma failure modes Why Six Sigma projects fail and how to keep it from happening to you Course Outline Black Belt Conversion Six Sigma Black Belt Conversion Training Course Objectives At the end of the intensive 5 day six sigma black belt training program delegates will understand and be able to Apply the principles of the Six Sigma DMAIC performance improvement model Establish the Voice of the Customer in defining the required performance standard Use a number of measurement approaches and tools to establish current performance Appropriately apply a number of advanced statistical analysis tools and techniques to establish the root cause of a problem Recognise the difference in approach and techniques for incremental and redesign improvement strategies and know how to decide on the correct approach Establish ongoing process controls and process governance structures Characteristics of a Black Belt Self Starter Excellent Communicator Influential Open Minded Creative Organised Team Player Desire to Achieve Excellence Six Sigma Black Belt Conversion Training Course Content Define Understanding Variability Project Charter Thought Mapping Basic Statistics Measure Measurement Basics Gauge R R Sampling Implementing

    Original URL path: http://2ko.co.za/courses/sixSigma/sixSigmaBlackBelt.html (2015-12-05)
    Open archived version from archive

  • Training Six Sigma Green Belt Cape Town Johannesburg
    balance sheet Set aggressive measurable business goals and achieve them Plan and execute a flawless launch within 90 days Define priorities organize teams choose partners structure enterprise wide deployments and more Sustain Six Sigma for the long term Using a clearly defined leadership roadmap align organization structure compensation succession planning IT resources and more Avoid the classic Six Sigma failure modes Why Six Sigma projects fail and how to keep it from happening to you Course Outline for 2KO International Six Sigma Green Belt Why Six Sigma Definition and Graphical View of Six Sigma Comparisons Between typical TQM and Six Sigma Programs Origins and Success Stories How to Deploy Six Sigma Leadership Responsibilities Description of the Roles and Responsibilities Resource Allocation Data Driven Decision Making Organizational Metrics and Dashboards DEFINE Project Definition Tasks Work Breakdown Structure Pareto Diagrams Process Maps Matrix Diagrams Project Charters Reporting MEASURE Tools and Objectives Measure Stage Objectives Flowcharts Process Maps SIPOC Box Whisker Plots Cause and Effect Diagrams Check Sheets Interrelationship Diagram Stem and Leaf Plots MEASURE Establishing Process Baseline Enumerative v Analytic Statistics Process Variation Benefits of Control Charts Requirements v Control Control Chart Interpretation X Bar Charts Uses Construction and Calculations Assumptions Rational

    Original URL path: http://2ko.co.za/courses/sixSigma/sixSigmaGreenBelt.html (2015-12-05)
    Open archived version from archive

  • Lean Black Belt Training Johannesburg Cape Town
    Lean Enterprise 4 P Model Principles of Lean enterprise Lean Philosophy and culture driving the organization Lean Thinking Roadmap Three Value Propositions Developing a Lean philosophy Creation of Lean culture Lean Organization Structure Gemba walks Constructing a Lean Process Value Stream Mapping Customer value proposition 8 Sources of Waste Value Stream mapping Continuous Improvement Cycle Create Process Stability Waste Elimination and Consolidation Improve Operational availability OA and Process Variability reduction Standing in Circle Standardized work Analysis 5S Workplace organization Operations layout Balancing Heijunka Quick Change over Problem Solving Culture Preventive Maintenance Dashboards Creating Continuous Flow Continuum of flow Independent Connected processes Pull system Batch Size reduction Flow Kan Ban Demand Pull Processing FIFO Process Standardization Types and Strategies of standardization 1 Point Lessons Workload Levelling Incremental levelling advanced heijunka Build a Culture that Stops to Fix problems Work teams problem Resolution cycle Jidoka Process Control Quality Control Short Interval Controls Poke yoke or mistake Proofing Problem Solving Problem solving decision matrix Lean Problem solving method Problem definition Root cause analysis Solution generation Plan Do Check Act PDCA Reflection Root Cause Analyses 5 Why Fishbone Ishikawa analysis Brains storming NGT Technique and FMEA A3 Report Components of Lean 5S Visual Control Cellular Manufacturing Jidoka Autonomous maintenance Kaizan Kaizan Blitzes Poka Yoke Mistake proofing Quick change over SMED Production Preparation Process 3P Pull Manufacturing Just in Time Standardized Work Theory of Constraints Total Productive Maintenance Training within Industry TWI Displaying Data Histograms Frequency Charts Line Graphs Run Charts Bar Charts Radar Charts Pareto Charts Kaizan Blitzes and DMAIC Methodology Overview of DMAIC methodology for complex problem solving Define Phase Objectives Steps Project Charter SIPOC Quantifying customer requirements Basic Probability Statistics Baseline performance analysis Descriptive Statistics Measures of Central Tendency Measures of Dispersion Basic Probability Measure Phase Explanation of Measurement Systems Tools for

    Original URL path: http://2ko.co.za/courses/sixSigma/sixSigmaLeanBackBelt.html (2015-12-05)
    Open archived version from archive

  • C# Programming training course Cape Town South Africa
    through Web Services Learn to create MDI applications See how to effectively deploy your Visual C applications Pre requisites Before attending this course students must JavaScript or General Programming Experience Module Outline Intro to NET Why NET The NET Framework Creating a Simple NET Application Working with the Visual Studio IDE Introducing Visual Studio 2005 Starting Visual Studio 2005 Changing Options Windows and Tabs Creating a New Project Introduction to Windows Forms NET Does Windows Adding Controls to a Form A Peek behind the Scenes Adding Event Handling Code Adding a Menu to the Form Adding Non Graphical Components Taking Advantage of the Form Event Model Handling Events Displaying Forms Creating Dialog Forms Form Events Keyboard Events Mouse Events Validating User Input Common Windows Forms Controls Investigating Windows Forms Controls Label TextBox and Button CheckBox and RadioButton ComboBox ListBox and CheckedListBox LinkLabel NumericUpdown PIctureBox and ProgressBar Exception Handling Perspectives on Exception Handling Getting Started with Exception Handling Adding a Simple Try Catch Block Unhandled Exceptions Using an Exception Object Catching Specific Exceptions Raising Errors Running Code Unconditionally Working with Strings and Dates Basic NET Data Types Working with Text The String Class Working with Dates and Times Accessing Data Overview of ADO NET Connecting to Data Executing Commands Working with Data Choosing an ADO NET Provider Data Binding Techniques Data Binding Basics Creating a Data Source Creating Data Bound Forms Data Binding Components and Controls Displaying Data from Related Tables Displaying Data from Lookup Tables Adding Search Capabilities to a Form Filtering by Values from a Lookup Table Working with Local Data Using the Data Controls Display Data using the DataGridView Control Make the Most of the DataGridView Control Understand the BindingSource and BindingNavigator Controls Handling Input Output Tasks Introducing the System IO Namespace Selecting Files Browsing for Folders Handling

    Original URL path: http://2ko.co.za/courses/other/cSharp.html (2015-12-05)
    Open archived version from archive



  •