Code On Time: Learning Resources

Learning Resources

Introduction
- Premium Line-of-Business Database Apps
- Getting Started
Mobile
- Cloud On Time App
- Support
- User Guide
  - Universal Windows Platform
Touch UI
- Introduction
  - Creating Project
  - For jQuery Mobile
    - "Hello World" Single Page App
- View Styles
  - Grids, Lists, Cards
  - Charts
- Mobile
  - Full Screen Web Apps
- Appearance
- Settings
- List
  - Configuration
- Charts
- Maps
  - Adding API Key
- How It Started
  - Responsive Design
  - User Guide
    - List
    - Form
Content Management System
- Overview
- Adding CMS to an Existing Project
- Creating Single Page Apps on Demand
- Open Authentication Configuration
Deployment
- Overview
- Dedicated Server
- Azure App Service
Video Library
- Getting Started
Feature Tour
- Quick Find
- Adaptive Filtering
- Automatic Tracking of Selected Record
- Advanced Search Bar
- Multi-Level Master-Detail Pages
- Drag and Drop Development
- Tools for Excel
- Modal Action Confirmation Forms
- Data Lookup Styles
- Advanced Navigation Menus
- Interactive History
- Permalinks
- Status Bars
- Automatic Denormalization
- Many-to-Many Fields
- Validators and Converters
- Business Rules Engine
  - SQL Business Rules
  - JavaScript Business Rules
  - C# and Visual Basic Business Rules
  - Email Business Rules
- RESTful Application Server
- Reports
- Export to Spreadsheet
- Charts
Getting Started
- Creating an App
- Using the Project Designer
- Creating a Three-Level Master-Detail Page
- Rearranging Data Fields
- Designing Forms
- Configuring Charts
- Creating Many-to-Many Fields
- Creating Calculated Fields
- Implementing a Custom Action
- Refreshing Project Settings
Sample Applications
- Northwind (SQL Server)
- HR (Oracle)
- Sakila (MySQL)
- SAMPLE (DB2)
- Demo (SQLAnywhere)
- Pagila (PostgreSQL)
- Order Form
- Transactions
Project Types
- App Factory
- SharePoint Factory
- DotNetNuke Factory
- Azure Factory
- Web Site Factory
Development
- Account Manager
- Refreshing Project Settings
- Project Wizard
- Project Designer
- Project Explorer
- Tools for Excel
- Business Logic Layer
  - Denormalization Field Map
- Under the Hood
  - Working with the Baseline
- Source Control
  - Git
Data Sources
- Tables
- Complex Queries
- Stored Procedures
  - Custom Result Sets
  - Output Caching
  - Output Cache Table
  - Output Caching Script
  - Output Cache Controller
  - Using Output Cache
    - User-Defined Filters
    - Master-Detail Relationship
    - Search Bars and Dialogs
  - Optimizing Caching Strategy
Data Controllers
- Intro
- Overview
- Creation
  - From SQL Query
  - From Stored Procedure
  - Passing SQL Parameters
  - From Web Service
- Controllers
  - Status Bar
- Commands
  - Overview
- Fields
  - Overview
  - Activate If Blank
  - Allow Nulls
  - Allow Sorting
  - Allow Query-by-Example
  - Auto Complete Anywhere
  - Code Default
  - Code Formula
  - Code Value
  - Context Field
    - Static Lookup Filter Values
    - Implicit Lookup Filters with Filter Expression
    - Implicit Filters with Dynamic Access Control Rules
  - Copy
  - Data Format String
    - Standard Numeric
    - Standard Date/Time
    - Custom Date/Time
    - HTML
  - Create New
  - Format On Client
  - Items Data Controller
  - Items Data View
  - Items Style
    - Auto Complete
    - Check Box
    - Check Box List
    - Drop Down List
    - List Box
    - Lookup
    - Radio Button List
    - User Id Lookup
    - User Name Lookup
  - Length
  - Lookup Window Description
  - New Data View
  - On Demand Handler
  - Page Size
  - Read Roles
  - Search by First Letter
  - Search on Start
  - SQL Formula
  - Write Roles
- Views
  - Overview
  - Access
  - Base View Id
  - View Templates
    - Form
    - Conditional Visibility
  - Filter Expresson
  - Icons
  - Create Custom Report Template
  - Report Font
  - Report Label
  - Report Orientation
- Categories
  - Overview
  - Description
  - Wizards
- Data Fields
  - Overview
  - Columns
  - Data Format String
  - Hyperlink Format String
  - Read-Only When
  - Rows
    - Text Box
    - List Box
  - Search Mode
  - Search Options
  - Tags
  - Text Mode
  - Tooltips
  - Visible When
  - Watermark
- Action Groups
  - Overview
  - "Action Column" Scope
  - Controlling "Action Column" Presentation with CSS
- Actions
  - Overview
  - Icons
  - Batch Edit
    - Overview
    - Pre-selecting All Fields for Update
  - Client Script
  - Custom
    - Calculating Values
  - Duplicate
    - Default Behavior
    - Custom Business Rule
  - FileName
  - Navigate
  - Report
  - Report (PDF)
  - Report (Excel)
  - Report (Image)
  - Report (Word)
  - Select
    - Before, Execute, and After Phases
    - Multiple Edit Forms
  - SQL
  - Update
    - Save and Next
  - Properties
    - Confirmation
      - Simple
      - Modal Form
    - When Client Script
    - When Last Command Name
    - When View
- Styles
  - Overview
- Items
  - Overview
- Field Outputs
  - Overview
- Framework
  - Virtualization
  - Read-Only Data Access
  - Maximum Value Count
  - Increasing Command Timeout
  - Import Error Handling
  - ControllerDataSource and ObjectDataSource
- Data View Fields
- URL Parameters
- Duplicate Values in Lookups
- Database Views
- Multiple Databases
Pages
- Intro
- Overview
- Containers
  - Overview
- Controls
  - Overview
- Data Views
- Appearance
- External Url
- Layout
- Configuring Master-Detail Relationships
- Using Drag and Drop to Configure a Master-Detail Page
- Grouping Data Views in the Same Container
- Creating a Single Record Detail Page
- Custom Master Page
- Triggering Data View Refresh
- Hiding Pages From Navigation Menu
User Controls
- Extending Pages
- Interacting with the Client Library
- Custom Filter Panel
Search
- Advanced Search Bar
- Search Bar Field Modes
- Search Bar Filter Options
Data Lookup
- Dynamic Lookups
- Static Lookup Items
- Dependent Lookups
- Dependent Lookups with Cross-Reference
- Picklists
- Setting Default Values
Business Rules
- Overview
- Validators and Converters
- SQL
- C# and Visual Basic
- JavaScript
- Email
Reports
- Overview
- Creating Custom Reports
- Changing Default Report Template
- Handling "Report..." Action
- Passing Values to Custom Report Action
- Improving Reporting Performance
- Producing Report In Binary Format
Upload and Download
- Internal Storage
- External Storage
- Blob Adapters
- Changing Upload Size Limit
Security
- Role-Based
- Membership & Role Providers
  - Overview
  - SQL Server
  - MySQL
  - Oracle
  - User Manager
    - Minimal
    - Advanced
- External Authentication
- Configuring Active Directory Membership
- Fly-Over Login Window vs. Dedicated Login Page
- Custom Login Form
- Handling Login and Logout
- Password Recovery
- Multi-Tenant Applications
- Lookup of User Identity
- Capturing Current User Identity
- Logging Data Access
Workflow
- Dashboard with Summary Task Views
- Virtualization Node Set Plugins
- Conditional Data Editing
- Customizing Membership Manager
- Dynamic Lookup Items
REST
- Web App as Application Server
- Windows Client
- jQuery
- Security
- RESTful Business Rules
- Client API
EASE
- Auditing
- URL Hashing
- Geo Tagging
Client Library
- Custom Input Elements
- Assigning Input Enhancements at Runtime
- Debugging Custom Input Elements
- Handling Row Selection in a Data View
User Interface
- Form Templates
- Grid Templates
- Standard Themes
- Themes A-B
- Themes C-D
- Themes F-G
- Themes L-M
- Themes P-S
- Themes V-Y
- Custom Themes
- Tall and Wide Pages
Localization
- Automated Translation
- Localization Files
Windows Azure
- What is Windows Azure Platform?
- Creating an Account
- Creating a Database
- Configuring Azure Factory
- Converting to Web Site Factory
DotNetNuke
- Module
  - Configuration
- Configuring DotNetNuke Factory
- Using DotNetNuke Factory with DNN 5.6.3
- Custom CSS Rules
SharePoint
- Add-In
  - Configuration
- SPContext in Business Rules
- Custom CSS Rules