Posted on June 24, 2013 by orbital

Modern applications ranging from enterprise to social network applications are essentially designed and implemented based on the widely-adopted three-tier architecture, in which user interface, functional process logic and data storage/access are developed and maintained as independent modules.

For tomorrow’s Mission Control, we shall go through basic concepts and techniques in designing and implementing the data storage and data access component for those applications.

In the process, we will learn about various sub-phases of database design including conceptual, logic and physical design.  We also have some hands-on practice on designing databases with a CASE tool (RISE Editor), and working with a popular open-source database management system (MySQL).

The following pieces of software will be used in this mission control:

1.) RISE Editor for drawing ERDs (Entity Relationship Diagram)

http://www.risetobloome.com/clickonce/riseeditor/riseeditor.htm

2.) WAMPServer for developing three-tier applications

http://www.wampserver.com/en/

Posted on June 13, 2013 by orbital

Hi all:

As the IDA  / Google Developer Group Meet-Up on Cloud SQL is happening at Blk 71 overlapping exactly at 6-9pm on Tuesday evening, we’re postponing Tam’s session on basic databases for a week.

Head on over to the Cloud SQL Workshop at Blk 71 instead!  Make sure to register for it (see the details in the previous post)

Photo Credits: Gustavo da Cunha Pimenta @ Flickr http://www.flickr.com/photos/guspim/

Posted on June 13, 2013 by orbital

Dear all Orbital students:

We have been in talks with the InfoComm Development Authority of Singapore (IDA) to have them over to talk about the data.gov.sg initiative.  They have also told us that they are in the midst of organizing some events that might be of interest to all of you.  You may want to consider joining in these two events happening next week (of course, please log your attending hours as part of your Orbital timesheet, as with everything else). Some of these events are happening at Blk 71 (again!).

[Snip — what follows is from IDA]

A.      Google Cloud SQL Workshop on 18^th June 2013 (Tuesday)

We will be working with developer groups in Singapore to bring to you workshops which incorporate the latest technologies with government data.

The first of our workshops will be a collaboration effort between IDA and the Google Developer’s Group :

B.      Tech Talk on Entrepreneurship and Civic Innovation 

Join us for an evening with speakers from Google Ventures and Washington DC’s iStrategy Labs. Innovators in their own right, Bridgette and Peter will share tips on how developers and start-ups bring their solutions forward by dreaming big and aiming high.

Agenda:

• “Google, Entrepreneurship and Innovation” by Bridgette Beam, Global Entrepreneurship Manager, Google ventures
• “Citizen Innovation for Smarter Cities” by Peter Corbett, Chief Executive Officer, iStrategy Labs
• “Sharing on Apps4SG Competition and an upcoming Hackathon –  Looking for the brightest and most creative minds in Singapore to help improve the way we live, study, work and play” by data.gov.sg, IDA
• Q&A with Bridgette and Peter

Posted on June 13, 2013 by orbital

For tomorrow’s Mission Control, we will be going over two common web application vulnerabilities (including some live examples, Demo God willing) and their mitigations.

In the process, you will learn a little bit about cookies, sessions, password storage, and several web development and debugging tools that can make your life easier as a developer, or form part of your arsenal as an attacker.

The talk is rather unlikely to be recorded. Parts of the presentation containing personal information that was magically obtained may be omitted due to their sensitive nature.

Update: If you attended yesterday’s Mission Control session, you might be interested in these links: http://qxcg.net/how-websites-are-broken-resources.html.

Photo Credits: KatieJean97 @ Flickr http://www.flickr.com/photos/katiejean97/

Posted on June 3, 2013 by orbital

Min will be covering Prezi, a zoomable editor, as well as open HTML5 alternatives.

We’ll also be examining best practices for Prezi, and finding and correctly attributing sources for photos, sounds that you can embed into your presentations.

It’ll be held at SR3 from 6-8pm today.  Feel free to join us virtually via Hangouts and on Askbot.  See you then.

For your reference the list of Mission Control sessions can be found here.

Posted on May 21, 2013 by orbital

Min will be giving a short tutorial and hands-on for Twitter Bootstrap — the CSS framework that is useful for giving a pretty decent look for most websites.  A key part of Bootstrap is in its responsive design, making sites look decent on small resolutions (low res smartphones) as well as big ones (your 30″ Apple Thunderbolt Display).

This is a beginner level session — applicable to any web-based project.

The Mission Control Session will be held tentatively at SR3 from 6-8pm next week; please check back with us in IVLE and Askbot for updates.

UPDATE: We’ve gotten permission from Blk 71 to host it at their space!!  Come join us over at Blk71’s Seminar Room 1.  Click on the event venue Image on the right for Google Maps info.

Post event update — Re-Recording done

For those of you who missed it, or were a bit confused about it; you can watch the re-recording I’ve done of the show here.