Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Tuesday, October 11, 2016

WEB202 – 1-Day Implementing iOS and Android Push Notifications

Push notification is one of the most interesting topics in mobile development. Using push notifications, you can keep your users up-to-date on the latest happenings, regardless of whether the user is using your application or not.

In this 1-day course, you will learn how to implement push notifications in iOS and Android, as well as learn how to create your own backend push provider so that you have ultimate control on what you want to push to your users, as well as who to push to and when you want to push the notifications.

Please note the following:

  • This course will cover both the iOS and Android platforms, so you need a Mac. 
  • You need to bring along an iOS and Android device. Simulator/emulator will not work.
  • For iOS, you need to register for the paid iOS developer program (US$99/year)
  • For server-side development, we will use Node.js, Python, and MySQL

Wednesday, July 06, 2016

Server-Side Programming Series of Courses


Saturday, October 10, 2015

Programming Internet of Things (IoT) Series


We have just launched our Programming Internet of Things (IoT) series. Check out the course calendar to view the schedules and outlines. 


Monday, June 22, 2015

WEB103 -Web Developing using PHP and MySQL - now comes with Raspberry Pi 2

With the increasing adopting of Internet of Things (IoT) applications, the upcoming PHP and MySQL Programming course now comes with a Raspberry Pi 2. Using the Raspberry Pi 2, you will now deploy your PHP and MySQL applications on it so that it is now ready to support your IoT applications. What's more, you will learn how to use PHP together with Python to send push notifications to your iOS and Android devices.
Course Fee
S$1297 (nett; no GST)
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Thu Sep 17 2015 CONFIRMEDFri Sep 18 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Canada, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand. 

Tuesday, June 16, 2015

IOT101 - Internet of Things (IoT) Programming

We had a great IOT course yesterday! It was a fun and exciting 2-day course where participants tried interfacing the Raspberry Pi 2 with various sensors and sending the data to a MySQL database backend. Participants also learned how to network multiple Raspberry Pis with sockets programming in Python and built a smoke detection system that raises an alarm when the smoke level reaches a particular threshold.

If you have missed yesterday's run, no worries! Here are the next 2 runs of the course:
Course Fee
S$1897 (nett; no GST)
Comes with an IOT Kit worth more than $400's worth of Raspberry Pi and various sensors
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Thu Sep 10 2015Fri Sep 11 2015PDF
Thu Oct 01 2015Fri Oct 02 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Canada, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand.

Monday, June 01, 2015

IOT Course - Measuring Distances using the Ultrasonic Sensor

The Ultrasonic Sensor is a distance sensor that works using a ultrasonic transmitter and receiver.  You can use it to monitor for movement up to a distance of 4m. Perfect for projects that require distance monitoring as well as collision avoidance.

In the upcoming IOT Programming course in June, you will learn how to connect the Ultrasonic sensor to your Raspberry Pi and record its measurements to a MySQL database using Python code.
Course Fee
S$1897 (nett; no GST)
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Mon Jun 15 2015 CONFIRMEDTue Jun 16 2015PDF
Thu Sep 17 2015Fri Sep 18 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Canada, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand.

Tuesday, April 21, 2015

Training courses for your company

Looking for an in-house training to jumpstart your developers on a particular technology? We can help!

Our training methodology is simple - "you learn most when you have to do it". All our training courses focus heavily on hands-on training. Participants are expected to write code and learn how to debug their apps to make them work. Through this process of learning-by-doing, participants are able to absorb the topics quickly and get productive immediately.

If you have 5 developers or more, it would be economical for you to arrange for in-house training, where we can customize the topics based on your project requirements. If not, you can always send your staff to attend one of our many open enrolment courses:


We have successfully trained developers in the following regions:

  • Singapore
  • Thailand
  • Norway
  • Denmark
  • United States of America (USA)
  • Hong Hong
  • Taiwan
  • China
  • Japan
  • Indonesia

Check out the following links for the list of courses that we have available:




NEW COURSE - IOT101 – 2-Day Programming the Internet of Things (IOT) - $1897

Internet of Things (IoT) has been the buzzword for the recent years and is set to explode in the year of 2015. IoT is a network of objects or “things” that are interconnected by exchanging data with one another. These “things” are
typically sensors or devices that have their own dedicated uses – for example, motion sensors, gas sensors, beacons, barometers, etc. The real value of IoT is in the use of the data collected – analysis can be made on the data collected to analyze trends/shifts in atmospheric pressure, temperature, humidity, etc.

In this course, participants will learn how to build various IoT systems by using the Raspberry Pi as the base collection point. The Raspberry Pi is an excellent candidate for IoT projects because it can run a full Web server and database server. Participants will learn how to create projects that save the data onto MySQL databases, and access them remotely through the Web using the PHP programming language.

Course fee includes the IOT Starter Kit containing all the various sensors, devices, and Raspberry Pi used in the course. Participants will be able to bring back the IOT Starter Kit for their own use.

Topics
• Programming languages covered
    o Crash course on PHP and MySQL
    o Crash course on Python
• Systems you will build
    o How to build a Student Attendance System using NFC (Near Field Communication)
    o How to build a Proximity Sensing System using beacons
    o How to build a Surveillance System using Webcams
    o How to build a Smoke/Gas Detection System using smoke/gas sensors
    o How to build a Motion Detection System using motion sensor and pi-cam
    o How to build a Short Text Display System using LED panels and a breadboard
• You will learn
    o How to write data collected from devices into a MySQL database
    o How to access the data from the Web using PHP
    o How to write Python scripts to build the various IoT systems
Course Fee
S$1897 (nett; no GST)
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Mon Jun 15 2015Tue Jun 16 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Canada, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand.

Tuesday, February 10, 2015

Advanced iOS - CloudKit Programming course

Want to write cloud-based iOS apps but not familiar with server side programming such as PHP, ASP.NET, and such? CloudKit solves this problem but providing a set of APIs that allow applications to store data and access them remotely on iCloud. Instead of writing your backend services (and database routines) to store your data, CloudKit provides a transparent way to store your data efficiently and securely. What's more, CloudKit supports remote notification so that when data stored on the cloud is modified, your application automatically receives push notifications so that you always have the most up-to-date data.

Come and join us in this one-day course on CloudKit Programming.
Course Fee
S$699 (nett; no GST)
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Tue Feb 24 2015Tue Feb 24 2015PDF
Wed Mar 04 2015Wed Mar 04 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Canada, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand.

Thursday, January 22, 2015

HRD101 - Getting Started with Raspberry Pi

If you have always been intrigued by the Raspberry Pi, this is your best chance to get your hands dirty and discover the cool projects you could do with this US$40
computer.

Among the various topics you will learn, you will also learn how to:
1. Build a surveillance system using a Webcam
2. Build a video streaming server
3. Build a Web server using Apache, PHP,  and MySQL
4. Build a RSS News Feed Reader using an external LCD screen

Course Fee
S$799 (nett; no GST)
If your company is sponsoring you for the training, your company can enjoy 400% tax deductions/ allowances and/or 60% cash payout for investment in innovation and productivity improvements under the Productivity and Innovation Credit (PIC) scheme. For more details, check out the Productivity and Innovation Credit page. 
Schedules
Start DateEnd DateDetailsCategory
Thu Mar 26 2015Thu Mar 26 2015PDF
Venue
Bayview Hotel Singapore
30 Bencoolen Street
Singapore 189621  

If your company requires in-house training, you can contact us to customize the topics to meet your training requirements. We train worldwide! We have conducted customized classes in the United States, Norway, Denmark, Japan, China, Hong Kong, Taiwan, and Thailand.

MySQL Tip - Sorting date represented as a string

Sometimes, when designing your database table, you may use a string format to represent a date. For example, to represent Nov 5, 2014, you might use the format DD/MM/YYYY, resulting it to be stored as 05/11/2014.

However, when retrieving multiple rows contain dates, this might pose a problem when it comes to sorting the items based on dates.

To resolve this, convert the date string to datetime value using the MySQL STR_TO_DATE() function, together with the format string representing the date. The following statement allows you to sort the date correctly:

SELECT * FROM TABLE ORDER BY STR_TO_DATE(STARTDATE, '%d/%m/%Y')";

Tuesday, January 06, 2015

WEB103 - Web Development using PHP and MySQL - Developing RESTful Services

The WEB103 - Web Development using PHP and MySQL course will now include coverage of how to develop RESTful services using PHP!

You will learn the fundamentals of how REST services are designed and created, and what's more, you will learn how to consume the REST service that you have created using:
1. A client-side app using JavaScript
2. A server-side app using PHP
3. A mobile app using iOS
4. A mobile app using Android

Click the button below to check the schedule.

Sunday, January 04, 2015

Learn Web Development using PHP and MySQL

While most of the attentions have been placed on mobile development in recent years, server-side development has always played an important role in mobile-enabling enterprise applications. One of the favourite tools for server-side development is PHP.

PHP is an easy to learn language and is freely available for most web servers and platforms. Together with the world's most popular open source database - MySQL, PHP powers some of the world's most popular web sites, such as Facebook, Google, Yahoo, and more.

In this course, you will learn how to develop web applications using PHP and MySQL. This course is lab intensive, and at the end of the course you would be able to create the following applications:

1. A membership system where users can login, or register as a new user.
2. An online polling application
3. An AJAX applications connected to a PHP application
4. A JSON Web services
5. iOS and Android applications that consumes a JSON service developed using PHP and MySQL


In addition, this course would also cover how to get started with Amazon Elastic Cloud (EC2), and how to deploy the applications you have built onto Amazon EC2.

Check the course schedules below!

Saturday, September 13, 2014

Schedule for Oct to Dec 2014 Released

I am happy to announce the new schedule for courses from Oct to Dec 2014.

Sep 2014
Sun
Mon
Tue
Wed
Thu
Fri
Sat

1
2
3
4
5
6

7
8
S$699/pax
9-10
S$1,097/pax
11
S$699/pax
12
S$699/pax
13

14
15-16
S$1,097/pax
17
S$699/pax
18-19
S$1,495/pax

20

21
22-23
S$1,097/pax
24-25
S$1,097/pax
26
S$699/pax
27
28
29-30 Sep, 1 Oct
S$1,695/pax




Oct 2014

Sun
Mon
Tue
Wed
Thu
Fri
Sat

29-30 Sep, 1 Oct
S$1,695/pax
2
S$699/pax
3
4

5
6
7-8
S$1,097/pax
9-10
S$1,097/pax

11

12
13-14
S$1,097/pax
15
16-17
S$1,395/pax
18

19
20
21
22
23
24
25

26
27
28
29
30
31



Nov 2014
Sun
Mon
Tue
Wed
Thu
Fri
Sat






1


2
3
4
5
6
7
8


9
10-11
S$1,097/pax
12-13
S$1,097/pax
14
15


16
17
18
19
20
S$699/pax
21
S$699/pax
22


23


24
25
26
27
28
29
30








Dec 2014

Sun
Mon
Tue
Wed
Thu
Fri
Sat

1-2
S$1,097/pax
3-4
S$1,097/pax
5
S$699/pax
6


7
8-9
S$1,097/pax
10
S$699/pax
11
S$699/pax
12
13


14
15
16
17


18
19
20

21

22-23
S$1,495/pax
24


25
26
S$699/pax
27
28

29-30
S$1,097/pax
31