Data IT Workplace Skills for Advanced Positions of DA / BA / BSA / Dev / QA / PM

                     [ 0.0.0.0 ]  Data IT Practical Industrial Skills Training Progeam [ link ]
                     [ 0.1.0.0 ]  Ontario Open Data Project Layout [ link ]
                     [ 0.2.0.0 ]  Typical Data Extracting, Transformation, and Loading ( ETL ) Process [ link ]
                     [ 0.2.1.0 ]  ETL sample codes [ link ]
                     [ 0.2.2.0 ]  Update Yahoo stock daily change rate - query with inner join [ link ]
                     [ 0.2.3.0 ]  Update Yahoo stock daily change rate - cursor on stored procedure [ link ]
[ 1.0.0.0 ]  Backend Tech
         [ 1.1.0.0 ]  Sql basics [ link ]
                 [ 1.1.1.0 ]  Select .. from .. order by
                 [ 1.1.2.0 ]  Case when
                 [ 1.1.3.0 ]  From dual
                 [ 1.1.4.0 ]  Group by
                 [ 1.1.5.0 ]  Union and union all
                 [ 1.1.6.0 ]  Limit
                 [ 1.1.7.0 ]  Sub query
                 [ 1.1.8.0 ]  Inner join and outer join
                     [ 1.1.8.1 ]  Inner join [ link ]
                     [ 1.1.8.2 ]  outer join [ link ]
                 [ 1.1.9.0 ]  Aggregation functions ( count, max, min, avg, sum )
                 [ 1.1.10.0 ]  Useful functions
                     [ 1.1.10.1 ]  cast()
                     [ 1.1.10.2 ]  concat()
                     [ 1.1.10.3 ]  group_concat()
                     [ 1.1.10.4 ]  date()
                     [ 1.1.10.5 ]  datediff()
                     [ 1.1.10.6 ]  trim()
                     [ 1.1.10.7 ]  upper(), lower()
                     [ 1.1.10.8 ]  now()m timestamp(), today()
                     [ 1.1.10.9 ]  instr()
                     [ 1.1.10.10 ]  substr()
                     [ 1.1.10.11 ]  STR_TO_DATE() [ link ]
                 [ 1.1.11.0 ]  dynamic sql [ link ]

         [ 1.2.0.0 ]  Sql DML
                 [ 1.2.1.0 ]  Update
                 [ 1.2.2.0 ]  Update table join
                 [ 1.2.3.0 ]  Insert into
                 [ 1.2.4.0 ]  Insert into select
                 [ 1.2.5.0 ]  Delete
                 [ 1.2.6.0 ]  Truncate
                 [ 1.2.7.0 ]  Drop
                 [ 1.2.8.0 ]  Transaction [ link ]

         [ 1.3.0.0 ]  Sql DDL
                 [ 1.3.1.0 ]  Create table
                 [ 1.3.2.0 ]  Create view
                 [ 1.3.3.0 ]  Create trigger [ link ]
                     [ 1.3.3.1 ]  trigger example png [ link ]
                 [ 1.3.4.0 ]  Create function [ link ]
                 [ 1.3.5.0 ]  Create stored procedure
                     [ 1.3.5.1 ]  Mysql Exception handling [ link ]
                 [ 1.3.6.0 ]  Loop [ link ]
                 [ 1.3.7.0 ]  cursor [ link ]
                 [ 1.3.8.0 ]  create primary key, foreign kry, unique key
                 [ 1.3.9.0 ]  create table using increamental ID column
                 [ 1.3.10.0 ]  ER Diagram [ link ]

         [ 1.4.0.0 ]  Upload data utility

         [ 1.5.0.0 ]  Administration
                 [ 1.5.1.0 ]  Create user
                 [ 1.5.2.0 ]  Assign privilege
[ 2.0.0.0 ]  Middle Tier Tech [ link ]
         [ 2.1.0.0 ]  JDBC [ link ]

         [ 2.2.0.0 ]  server-side process of http request with parameters [ link ]

         [ 2.3.0.0 ]  Create XML and http output

         [ 2.4.0.0 ]  Create JSON and http output [ link ]

         [ 2.5.0.0 ]  http read xml and covert to json and http output

         [ 2.6.0.0 ]  Web App Model ? View - Control workflow

         [ 2.7.0.0 ]  J2EE, JSP import, embed

         [ 2.8.0.0 ]  Java library

         [ 2.9.0.0 ]  Ant build [ link ]

         [ 2.10.0.0 ]  Jar, war

         [ 2.11.0.0 ]  OAuth 2.0 Token receiving

         [ 2.12.0.0 ]  plsql build xml / external_sqL_build_csv [ link ]
[ 3.0.0.0 ]  Frontend Tech
         [ 3.1.0.0 ]  Html basic structure [ link ]

         [ 3.2.0.0 ]  Useful html tags
                 [ 3.2.1.0 ]  <a>
                 [ 3.2.2.0 ]  <p>
                 [ 3.2.3.0 ]  <div>
                 [ 3.2.4.0 ]  <span>
                 [ 3.2.5.0 ]  <br>
                 [ 3.2.6.0 ]  <table>
                 [ 3.2.7.0 ]  <ul>
                 [ 3.2.8.0 ]  <iframe>
                 [ 3.2.9.0 ]  <h1>
                 [ 3.2.9.0 ]  <hr>
                 [ 3.2.9.0 ]  <pre>
                 [ 3.2.10.0 ]  <INPUT> [ link ]

         [ 3.3.0.0 ]  CSS / javascript

         [ 3.4.0.0 ]  Post / get requests

         [ 3.5.0.0 ]  DOM / Event
                 [ 3.5.1.0 ]  Document Object Model (DOM) [ link ]

         [ 3.6.0.0 ]  Online form [ link ]
                 [ 3.6.1.0 ]  SQL injection

         [ 3.7.0.0 ]  JQuery [ link ]
                 [ 3.7.1.0 ]  JQuery selectors [ link ]
                 [ 3.7.2.0 ]  JQuery event and handler [ link ]

         [ 3.8.0.0 ]  AngularJS [ link ]

         [ 3.9.0.0 ]  Ajax call [ link ]

         [ 3.10.0.0 ]  Google chart [ link ]

         [ 3.11.0.0 ]  Bootstrap [ link ]

         [ 3.12.0.0 ]  Google Map API [ link ]
                 [ 3.12.1.0 ]  Demo [ link ]
                 [ 3.12.2.0 ]  Example codes [ link ]

         [ 3.13.0.0 ]  CSS animation [ link ]

         [ 3.14.0.0 ]  OAuth 2.0 Token receiving [ link ]

         [ 3.15.0.0 ]  Ajax call receiving data and then save as file

         [ 3.16.0.0 ]  awesome font
                 [ 3.16.1.0 ]  lntroduction [ link ]
                 [ 3.16.2.0 ]  icons [ link ]

         [ 3.17.0.0 ]  html color [ link ]
[ 4.0.0.0 ]  Application
         [ 4.1.0.0 ]  Online CSV read and update database
                 [ 4.1.1.0 ]  in R [ link ]
                 [ 4.1.2.0 ]  in Java [ link ]

         [ 4.2.0.0 ]  Job Scheduling

         [ 4.3.0.0 ]  Java J2SE

         [ 4.4.0.0 ]  Eclipse

         [ 4.5.0.0 ]  Java basics
                 [ 4.5.1.0 ]  Java app vs. library [ link ]
                 [ 4.5.2.0 ]  user-defined exception [ link ]
                 [ 4.5.3.0 ]  Class vs. object [ link ]
                 [ 4.5.4.0 ]  Object create and close
                     [ 4.5.5.1 ]  memoory leak
                 [ 4.5.6.0 ]  Class / Sub class
                 [ 4.5.7.0 ]  Class inheritance [ link ]
                 [ 4.5.8.0 ]  Class composition
                 [ 4.5.9.0 ]  Constructor [ link ]
                 [ 4.5.10.0 ]  Public / private, get / set function
                 [ 4.5.11.0 ]  Static method
                 [ 4.5.12.0 ]  Java interface [ link ]
                 [ 4.5.13.0 ]  Synchronized methid [ link ]
                 [ 4.5.14.0 ]  Multi-thread, thread Safe [ link ]
                     [ 4.5.14.1 ]  Sample codes [ link ]

         [ 4.6.0.0 ]  Excel and VBA [ link ]
                 [ 4.6.1.0 ]  VBA - 1 [ link ]
                 [ 4.6.2.0 ]  VBA - 2 [ link ]
                 [ 4.6.3.0 ]  VBA - 3 [ link ]
                 [ 4.6.4.0 ]  VBA sample code [ link ]

         [ 4.7.0.0 ]  Using R: Download csv and update to database / schedule job
                 [ 4.7.1.0 ]  R - 1 [ link ]
                 [ 4.7.2.0 ]  R - 2 [ link ]
                 [ 4.7.3.0 ]  R project [ link ]

         [ 4.8.0.0 ]  Oracle APEX [ link ]
                 [ 4.8.1.0 ]  Intro Lesson [ link ]