Course Code: rshiny
Duration: 14 hours
Course Outline:

*** Day one ***

 build a Shiny app 2h

        Introduction to R & Shiny

        Understand the architecture

        Use the template

        Inputs and Outputs

        Assemble inputs into outputs

 Customize appearance 3h

        Work with the HTML UI

        UI Layout

        UI Inputs

        UI Outputs

        Add static content

        Create a layout

        Assemble layers of panels

        Use a prepackaged layout

        Style with CSS

Exercise one 15m

Graphics & visualization 1h        

       Shiny Gadgets

        Interactive plots

        Dashboards

        Draw Rotatable 3D Charts

       

 *** Day Two ***

 Customize reactions 3h

        What is Reactivity?

        Reactive values

        Reactive functions

        Display output with render*()

        Modularize code with reactive()

        Prevent reactions with isolate()

        Trigger code with observeEvent()

        Action buttons

        observeEvent()

        observe()

        Delay reactions with eventReactive()

        Manage state with reactiveValues()

Exercise two 15m

Data              3h

        Local & Remote

        Database basics - dplyr and DBI

        SQL injection prevention

         Using the pool package

         Using dplyr and pool to query a database

         Persistent data storage in Shiny apps