Training MySQL di Bandung – SISINDOTEK

SISINDOTEK IT Training Bandung

DTB-05 – MYSQL Server DBA Fundamental
Biaya : Rp 4.600.000 (Non Residential) | Rp 5.750.000 (Residential)
Durasi : 4 Hari, Start : 9, 16, 23, 30 April 2012, Lokasi : Hotel Bintang Bandung

Fasilitas Standar : Penginapan** Kamar Hotel per Peserta, Breakfast** + 2x coffee break + Lunch **, Buku Panduan, Training Kit , Laptop/ peserta , Software Pendukung, Sertifikat , Flash Disk, Souvenir
Waktu Training : 09.00 – 17.00 WIB (diselingi 2x coffee break + Lunch)
Note :(**) Hanya untuk Paket Residential

INHOUSE TRAINING : Rp 700.000/ Peserta/ Hari (Minimal 3 Peserta),
Diskon 10% untuk peserta group > 5
Informasi dan ketentuan Inhouse Training hubungi : 022-71242266 atau 0812.8733.1966 , info

Silabus Training MS. Office 2010 – SISINDOTEK

SISINDOTEK SILABUS

Microsoft® Office 2010
(WORD, EXCEL, POWERPOINT)
Durasi : 7 jam x 4 Hari (28 Jam)

Deskripsi : Microsoft Office 2010 merupakan produksi Microsoft® Corporation, sebuah paket program aplikasi popular untuk kebutuhan user perkantoran baik kebutuhan dasar ataupun kebutuhan tingkat lanjut untuk bisnis dan manajerial, Microsoft Office menjadi sangat popular dikarenakan kemudahan dalam penggunaannya dan berjalan dengan sempurna di Operating system yang popular juga yaitu win xp atau Win seven.Aplikasi popular yang terdapat di dalam MS. Office 2010 dan sering digunakan dalam kegiatan sehari hari antara lain : MS. Word, MS. Excel dan MS. Power Point

Tujuan Training : 1. Peserta mampu menggunakan aplikasi MS. Word, Excel, dan Power Point dengan memanfaatkan fasilitas fasilitas yang ada didalamnya secara maksimal untuk produktifitas dan efisiensi pekerjaan

Target Peserta : – Umum/ Mahasiswa

Prasyarat : – Semua pengguna computer dapat mengikuti training ini

Materi Training : MS Word
• Membuat Dan Menyimpan Dokumen Kerja

• Menjalankan Microsoft Word 2010
• Pengenalan Interface/Tampilan Word 2010
• Membuat Dokumen Baru Dalam Microsoft Word 2007
• Menyimpan Dokumen Kerja
• Menutup Dokumen Kerja
• Mengedit Dokumen Kerja Dan Memformat Huruf

• Membuka Dokumen Kerja Yang Telah Di Simpan
• Memilih Teks Yang Akan Di Format/Edit
• Memindahkan Dan Menduplikasi Teks
• Memformat Huruf/Font
• Mengatur Perataan Paragraf
• Membuat Numbering

• Membuat Bullet
• Mengatur Jarak Baris/Spasi Baris
• Mengatur Jarak Paragraf, Orientasi Halaman Dan Menyisipkan tanggal
• Mengatur Jarak Antar Paragraf.
• Mengatur Jarak Indentasi (Jarak Teks Terhadap Margin).

• Mengatur Margin, Ukuran Dan Orientasi Halaman/ Page Size
• Menambahkan tanggal dalam dokumen
• Mencari Teks, Halaman, Menggabungkan Dokumen Dan Menggunakan Format Kolom.
• Mencari (Find) Dan Mengganti (Replace) Teks

• Berpindah Ke Halaman Tertentu
• Menggabungkan Dua Dokumen Atau Lebih
• Bekerja Dengan Header & Footer Dan Menyisipkan Simbol Dan Nomor Halaman
• Membuat Header Dan Footer
• Menghapus Header Dan Footer

• Menyisipkan Simbol
• Menyisipkan Nomor Halaman
• Mencetak Dokumen Dengan Format Tertentu
• Membuat Dan Menghapus Tabel, Konversi Teks Ke Tabel Dan Tabel Ke Teks
• Membuat Tabel
• Menghapus Tabel

• Mengkonversi Table Ke Teks
• Mengkonversi Teks Ke Tabel
• Memanipulasi Tabel
• Mengatur Border Dan Shading Tabel
• Menyisipkan Baris Dan Kolom Pada Tabel
• Menghapus Baris Dan Kolom Tabel

• Mengatur Tinggi Baris Dan Lebar Kolom
• Menggabungkan Dan Memisahkan Baris Dan Kolom Tabel
MS. Excel
• Mengenal Program Microsoft Excel dan mampu mengoperasikan program teersebut dengan baik
• Paham materi macam-macam data dalam Program Microsoft Excel

• Mampu menyisipkan kolom, baris, cell dan lembar kerja Microsoft Excel
• Paham materi tentang macam-macam cell dalam program Microsoft Excel
• Mengerti tentang fungsi Tanggal dan Waktu
• Paham materi tentang Fungsi Logika dan mengerti penerapan rumus tersebut dalam soal

• Mengerti Fungsi campuran anatara Fungsi Logika IF,AND dan OR
• Dapat mengatur setup halaman pada lembar kerja Microsoft excel
• Dapat memberi header dan footer pada lembar kerja
• Dapat mengatur sheet pada lembar kerja

• Dapat mengerti tentang fungsi vlookup
• Mengenal dan jelas tentang fungsi campuran vlookup dan string
• Dapat mengerjakan tentang fungsi Hlookup
• Dapat menggunakan conditional formatting dalam suatu soal

• Dapat mengatur standar kelengkapan program Microsoft excel khusus
• Dapat membuat grafik serta mempercantik tampilan grafik
• Memahami cara menyaring data dengan fasilitas auto filter
• Dapat mencetak document dengan baik dan mengatur tampilan hasil cetakan

MS. Power Point
• Menjalankan Power Point
• Menciptakan Presentasi
• Membuat Slide dengan gambar, clipart, tabel, grafik atau obyek lainnya
• Mengenal Tombol-Tombol Pengatur Pandangan.
• Normal View, Slide Sorter View, Slide Show View

• Menukarkan Posisi Slide
• Menghapus Slide
• Menduplikasi Slide
• Menyisipkan Slide
• Menambahkan Latar Belakang Slide
• Menggunakan Template
• Mengatur Skema Warna untuk semua Slide

• Menyimpan dan mengamankan Slide Presentasi

Training Lanjutan yang Disarankan : Microsoft Excel Advanced for Business, Accounting & Management

Training MS Office 2010 di bandung

Informasi Training MS Office di sisindotek

MSO-01 – Microsoft Office 2010 (WORD, EXCEL, POWERPOINT)
Biaya : Rp 4.600.000 (Non Residential) | Rp 5.750.000 (Residential)
Durasi : 4 Hari, Start : 9, 16, 23, 30 April 2012, Lokasi : Hotel Bintang Bandung

Fasilitas Standar : Penginapan** Kamar Hotel per Peserta, Breakfast** + 2x coffee break + Lunch **, Buku Panduan, Training Kit , Laptop/ peserta , Software Pendukung, Sertifikat , Flash Disk, Souvenir
Waktu Training : 09.00 – 17.00 WIB (diselingi 2x coffee break + Lunch)
Note :(**) Hanya untuk Paket Residential

INHOUSE TRAINING : Rp 700.000/ Peserta/ Hari (Minimal 3 Peserta),
Diskon 10% untuk peserta group > 5
Informasi dan ketentuan Inhouse Training hubungi : 022-71242266 atau 0812.8733.1966 , info

Jadwal IT Training April 2012 – SISINDOTEK Bandung

Berikut daftar pelatihan IT / IT Training di bandung (sisindotek) bulan April 2012

API-02 – Building Integrated Map Website with PHP MySQL and Google Map API V.3
3 Hari , Start : 16,23,30 April 2012

CON-01 – Project Management Methodologies With Microsoft Project 2010
4 Hari , Start : 9, 16, 23, 30 April 2012

DTB-01 – Oracle 11 PL/SQL and DBA Fundamental
4 Hari , Start : 9, 16, 23, 30 April 2012

DTB-02 – SQL Server 2008 DBA Fundamental
4 Hari , Start : 9, 16, 23, 30 April 2012

DTB-03 – Building Database Application with MS. Office Access 2010
4 Hari , Start : 9, 16, 23, 30 April 2012

DTB-04 – MS. Office Access 2010 VBA Macro programming
4 Hari , Start : 9, 16, 23, 30 April 2012

DTB-05 – MYSQL Server DBA Fundamental
4 Hari , Start : 9, 16, 23, 30 April 2012

GRA-03 – Building Interactive Web Layout with Adobe Fireworks CS
3 Hari , Start : 16,23,30 April 2012

GUI-01 – Building PHP MySQL – AJAX Web Application with Adobe Dreamweaver CS
4 Hari , Start : 9, 16, 23, 30 April 2012

MOB-01 – Mobile Application Development for Android
4 Hari , Start : 9, 16, 23, 30 April 2012

MOB-02 – HTML 5 for Mobile Application Development
4 Hari , Start : 9, 16, 23, 30 April 2012

MSO-02 – Microsoft Excel Advance for Business, Accounting and Management
2 Hari , Start : 2,9,23 Apr 2012

MSO-03 – Microsoft Excel Visual Basic for Application (VBA-Macro)
3 Hari , Start : 16,23,30 April 2012

PRG-05 – Building PHP MySQL-AJAX web application with Jquery
4 Hari , Start : 9, 16, 23, 30 April 2012

Fasilitas Standar : Penginapan** Kamar Hotel per Peserta, Breakfast** + 2x coffee break + Lunch **, Buku Panduan, Training Kit , Laptop/ peserta , Software Pendukung, Sertifikat , Flash Disk, Souvenir
Waktu Training : 09.00 – 17.00 WIB (diselingi 2x coffee break + Lunch)
Note :(**) Hanya untuk Paket Residential

INHOUSE TRAINING : Rp 700.000/ Peserta/ Hari (Minimal 3 Peserta),
Diskon 10% untuk peserta group > 5
Informasi dan ketentuan Inhouse Training hubungi : 022-71242266 atau 0812.8733.1966 , info@sisindotek,com

SQL Server 2012 new features

SQL Advent Recap and What is coming in SQL Server 2012 recap

In case you missed these, here is a recap of the SQL Advent and the SQL Server 2012 posts

SQL Advent Recap

Day 1: Date and time
In this post I covered the new date, datetime2 and time datatypes
Day 2: System tables and catalog views
In this post we took a look what the replacements are for the all system tables and also gave you a table with the new catalog view/compatibility view equivalent of the old system table
Day 3: Partitioning
In this post I looked at partitioning in pre sql 2005 days by showing you how to create partitioned views. I also showed you how to user partitioned function in sql 2005 and up
Day 4: Schemas
In this post I show you what schemas are and how they can help with security and logical grouping of objects
Day 5: Common Table Expressions
The Common Table Expressions post showed you what Common Table Expressions are and how they can be used to simplify your code
Day 6: Windowing functions
The Windowing functions post showed you how to do different kinds of rankings
Day 7: Crosstab with PIVOT
This post was all about pivoting/transposing/crosstabbing data with the PIVOT operator, also was shown how to do it dynamically
Day 8: UNPIVOT
This post showed you how to use UNPIVOT to get the reversed effect of PIVOT
Day 9: Dynamic TOP
The dynamic TOP post showed you how to do dynamic TOP without dynamic SQL or SET ROWCOUNT
Day 10: Upsert by using the Merge statement
This post was all about how to use MERGE to do an UPSERT (Update if it exists otherwise insert)
Day 11: DML statements with the OUTPUT clause
This post showed the usefulness of the OUTPUT clause
Day 12: Table Value Constructor
This post showed you how to use Table Value Constructor
Day 13: DDL Triggers
The DDL trigger post showed you how to use DDL triggers and also explained why you might want to use them
Day 14: EXCEPT and INTERSECT SET Operations
This post was all about the two new SET Operations EXCEPT and INTERSECT
Day 15: Joins
This post showed you how to use the newer ANSI SQL JOIN syntax and also showed you what was deprecated
Day 16: CROSS APPLY and OUTER APPLY
Shown was how to use APPLY with derived tables as well as functions
Day 17: varchar(max)
In this post I showed you why varchar(max) is much better than the text data type
Day 18: Table-valued Parameters
I showed you how to use Table-valued Parameters to pass around tables
Day 19: Filtered Indexes
In this post I showed you how to create a filtered index and why it can be beneficial in your database
Day 20: Indexes with Included Columns
On this day I showed you how to cover you query by using Indexes with Included Columns
Day 21: TRY CATCH
Error handling go better in SQL Server 2005 and I show you how to use TRY CATCH
Day 22: Dynamic Management Views
In this post I show how you can use Dynamic Management Views to get all kinds of information about your server and databases
Day 23: OBJECT_DEFINITION
The OBJECT_DEFINITION covers ways to get the text of an object and also show you why it is better than sp_helptext or syscomments
Day 24: Index REBUILD and REORGANIZE
This post is all about rebuilding and reorganizing(defragmenting) indexes

What is coming in SQL Server 2012

First look at SQL Server Management Studio Denali
In this post I show you what the new SQL Server Management Studio which is based on Visual Studio 2010 looks like
A first look at sequences in SQL Server Denali
Sequences finally made it into SQL Server, this post will show you how to use sequences
Screenshots of the new look and feel of BIDS in Denali
Business Intelligence Development Studio has a new look and feel, SSIS has never looked better
Debugging In SQL Server Denali
Debugging got much better in SQL Server 2012, this post will look at some of the new things
Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging
With OFFSET N ROWS FETCH NEXT N ROWS ONLY paging has never been easier
Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object
The sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object data management views makes it easy to find out what a proc or SQL statement returns
A Quick look at the new IIF function in Denali CTP3
SQL Server now has the IIF statement, this is just shorthand for CASE but it will make for shorter code
A Quick look at the new EOMONTH function in SQL Server Denali CTP3
The EOMONTH function will give you the last date of the month
DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3
With DATEFROMPARTS and DATETIMEFROMPARTS you can construct a date by passing in a bunch of integers
ColumnStore Index limitations in SQL Server Denali CTP3
Some limitation that the current version of ColumnStore Index have
Concat function in SQL Server Denali CTP3
Finally SQL Server 2012 has the Concat, this is something other RDBMSes had for years
Format function in SQL Server Denali CTP3
Formatting has never been easier, no need to use style parameters anymore
SQL Server Columnstore Index FAQ wiki page published
Columnar storage is new in SQL Server 2012, make sure to read the wiki for all your questions
TRY_CONVERT in SQL Server Denali CTP3
Before converting, use TRY_CONVERT that will tell you if the value can be converted to the data type you want
SQL Server Code Name “Denali” CTP3 Product Guide available for download
There is some cool documentation available, this includes white papers and videos
Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing
Looks like OLE DB has run its course, ODBC is the new thing

Oracle Date Time, Convert Timestamp to Char

SISINDOTEK TIPS

Just a picture of 99% of the date variations listed in the book, although I’m saving timestamps for another post.

The Easy Way
Select To_Char(Sysdate,’DL’ ) DL /* long date */
, To_Char(Sysdate,’DS’ ) DS /* short date */
, To_Char(Sysdate,’TS’ ) TS /* short time */
, To_Char(Sysdate,’DS TS’) DSTS /* short date, time */
From Dual;
DL | DS | TS | DSTS

HTML 5 Geolocation

12 Cool HTML5 Geolocation Idea

Knowing the location of your users can help boost the quality of your Web site and the speed of your service. In the past, users had to actively input their location and submit it to a site, either by typing it, using a long drop-down list, or clicking a map. Now, with the HTML5 Geolocation API, finding your users (with their permission) is easier than ever. Figure 1 shows a Web site using geolocation to determine the location of a user, represented in latitude and longitude. The numbers can easily be translated into something more understandable, such as the street name or city.

Showing a User’s Location with the Help of Geolocation
Figure 1 Showing a User’s Location with the Help of Geolocation

Imagine how useful your site could be if it provided online timetables for all public transportation in a particular city. Using geolocation, the site could recommend optimal travel routes to get people where they’re going as quickly as possible. Desktop users could get their start location sorted by proximity to their computer. Mobile users trying to get home after a night out could quickly find the closest bus stop within walking distance. These possibilities and more are just an API away.

Scenarios for Using the Geolocation API

Here are 12 simple scenarios that illustrate how a Web site can accommodate users and customize their experience by taking their location into account. Some of them might seem obvious, but the small things often make the biggest differences.

  1. Public transportation sites can list nearby bus stops and metro locations.
  2. Late night out? Taxi or car service Web sites can find where you are, even if you don’t know.
  3. Shopping sites can immediately provide estimates for shipping costs.
  4. Travel agencies can provide better vacation tips for current location and season.
  5. Content sites can more accurately determine the language and dialect of search queries.
  6. Real estate sites can present average house prices in a particular area, a handy tool when you’re driving around to check out a neighborhood or visit open houses.
  7. Movie theater sites can promote films playing nearby.
  8. Online games can blend reality into the game play by giving users missions to accomplish in the real world.
  9. News sites can include customized local headlines and weather on their front page.
  10. Online stores can inform whether products are in stock at local retailers.
  11. Sports and entertainment ticket sales sites can promote upcoming games and shows nearby.
  12. Job postings can automatically include potential commute times.

How Geolocation Works

Technically speaking, a PC or a mobile device has several ways to find out its own location (hopefully, in the same place as the user).

  • GPS is the most accurate way to determine positioning, but it’s less energy efficient than other options and sometimes requires a lengthy startup time.
  • A-GPS (assistive GPS) uses triangulation between mobile phone towers and public masts to determine location. Although not as precise as GPS, A-GPS is sufficient for many scenarios.
  • Mobile devices that support Wi-Fi access points can use hotspots to determine the user’s location.
  • Stationary computers without wireless devices can obtain rough location information using known IP address ranges.

When it comes to sharing the physical location of users, privacy is a serious concern. According to the Geolocation API, “user agents must not send location information to Web sites without the express permission of the user.” In other words, a user must always opt in to share location information with a Web site. Figure 2 shows a typical message requesting a user’s permission. For more information about ensuring security with the Geolocation API, see Security and privacy considerations.

Sample User Permission Request
Figure 2 Sample User Permission Request

Three Simple Functions

Are you ready to incorporate geolocation into your Web site? You need to learn only three simple functions to master the entire API, which resides within the geolocation object, an attribute of the Navigator object. (Learn more about the geolocation object here.)

The getCurrentPosition function gets the user location one time. It takes two arguments in the form of callbacks: one for a successful location query and one for a failed location query. The success callback takes a Position object as an argument. It optionally takes a third argument in the form of a PositionOptions object.


  1. navigator.geolocation.getCurrentPosition(locationSuccess, locationFail);
  2. function locationSuccess(position) {
  3. latitude = position.coords.latitude;
  4. longitude = position.coords.longitude;
  5. }
  6. function locationFail() {
  7. alert(‘Oops, could not find you.’);
  8. }

The Position object contains the properties shown in Figure 3.

Figure 3 Properties of the Position Object

Property Value Unit
coords.latitude double degrees
coords.longitude double degrees
coords.altitude double or null meters
coords.accuracy double meters
coords.altitudeAccuracy double or null meters
coords.heading double or null degrees clockwise
coords.speed double or null meters/second
timestamp DOMTimeStamp like the Date object

The watchPosition function keeps polling for user position and returns an associated ID. The device determines the rate of updates and pushes changes in location to the server.

The clearWatch function stops polling for user position. It takes the ID of watchPosition as an argument.

Presenting Location Data: Geodetic or Civic

There are two ways of presenting location data to the user: geodetic and civil. The geodetic way of describing position refers directly to latitude and longitude. The civic representation of location data is a more human readable and understandable format.

Each parameter has both a geodetic representation and a civic representation, as illustrated in Figure 4.

Figure 4 Examples of Geodetic and Civic Data

Attribute Geodetic Civic
Position 59.3, 18.6 Stockholm
Elevation 10 meters 4th floor
Heading 234 degrees To the city center
Speed 5 km / h Walking
Orientation 45 degrees North-East

When using the Geolocation API, you get the geodetic data back from the functions. Presenting location data in raw numbers is rarely friendly or useful. Online services, such as Bing Maps and Yahoo GeoPlanet can help you translate between the two presentation modes.

Browser Support

Internet Explorer Firefox Chrome Opera Safari iPhone Android Windows Phone
Internet Explorer 9+ Firefox
3.5+
Chrome
5+
Opera
10.6+
Safari
5+
iPhone
3+
Android
2+
Windows Phone 7.5+

Figure 5 Browsers that support the HTML5 Geolocation API

Even though geolocation works in all the major browsers (Figure 5), you still have to take into account the scenarios in which location can’t be provided. For example, a user might be running an older browser or have hardware that doesn’t include positioning devices, or simply might not want to automatically share location information. The location detected could even be incorrect. In such situations, you should always include an alternative or a fallback method so users can enter or change their location manually.

Geolocation in Action

Copy and paste the example code in Figure 6 and save it as an HTML file. Open it in your favorite browser and follow the two-step instructions on the Web site to see the Geolocation API draw a blue circle around your current location.

Figure 6 Using the Geolocation API


  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4. <title>Geolocation demo</title>
  5. <meta charset="utf-8" />
  6. </head>
  7. <body>
  8. <h1>Geolocation demo</h1>
  9. <p>
  10. Find out approximately where you are.
  11. </p>
  12. <p>
  13. Step 1: <button onclick="GetMap()">Show map</button>
  14. </p>
  15. <p>
  16. Step 2: When prompted, allow your location to be shared to see Geolocation in action
  17. </p>
  18. <div id="mapDiv" style="position: relative; width: 800px; height: 600px;"></div>
  19. <script type="text/javascript" src="http://ecn.dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=7.0"></script>
  20. <script type="text/javascript">
  21. var map = null;
  22. function GetMap() {
  23. /* Replace YOUR_BING_MAPS_KEY with your own credentials.
  24. Obtain a key by signing up for a developer account at
  25. http://www.microsoft.com/maps/developers/ */
  26. var cred = "YOUR_BING_MAPS_KEY";
  27. // Initialize map
  28. map = new Microsoft.Maps.Map(document.getElementById("mapDiv"),
  29. { credentials: cred });
  30. // Check if browser supports geolocation
  31. if (navigator.geolocation) {
  32. navigator.geolocation.getCurrentPosition(locateSuccess, locateFail);
  33. }
  34. else {
  35. alert(‘I\’m sorry, but Geolocation is not supported in your current browser. Have you tried running this demo in IE9?’);
  36. }
  37. }
  38. // Successful geolocation
  39. function locateSuccess(loc) {
  40. // Set the user’s location
  41. var userLocation = new Microsoft.Maps.Location(loc.coords.latitude, loc.coords.longitude);
  42. // Zoom in on user’s location on map
  43. map.setView({ center: userLocation, zoom: 17 });
  44. // Draw circle of area where user is located
  45. var locationArea = drawCircle(userLocation);
  46. map.entities.push(locationArea);
  47. }
  48. // Unsuccessful geolocation
  49. function locateFail(geoPositionError) {
  50. switch (geoPositionError.code) {
  51. case 0: // UNKNOWN_ERROR
  52. alert(‘An unknown error occurred, sorry’);
  53. break;
  54. case 1: // PERMISSION_DENIED
  55. alert(‘Permission to use Geolocation was denied’);
  56. break;
  57. case 2: // POSITION_UNAVAILABLE
  58. alert(‘Couldn\’t find you…’);
  59. break;
  60. case 3: // TIMEOUT
  61. alert(‘The Geolocation request took too long and timed out’);
  62. break;
  63. default:
  64. }
  65. }
  66. // Draw blue circle on top of user’s location
  67. function drawCircle(loc) {
  68. var radius = 100;
  69. var R = 6378137;
  70. var lat = (loc.latitude * Math.PI) / 180;
  71. var lon = (loc.longitude * Math.PI) / 180;
  72. var d = parseFloat(radius) / R;
  73. var locs = new Array();
  74. for (x = 0; x <= 360; x++) {
  75. var p = new Microsoft.Maps.Location();
  76. brng = x * Math.PI / 180;
  77. p.latitude = Math.asin(Math.sin(lat) * Math.cos(d) + Math.cos(lat) * Math.sin(d) * Math.cos(brng));
  78. p.longitude = ((lon + Math.atan2(Math.sin(brng) * Math.sin(d) * Math.cos(lat), Math.cos(d) – Math.sin(lat) * Math.sin(p.latitude))) * 180) / Math.PI;
  79. p.latitude = (p.latitude * 180) / Math.PI;
  80. locs.push(p);
  81. }
  82. return new Microsoft.Maps.Polygon(locs, { fillColor: new Microsoft.Maps.Color(125, 0, 0, 255), strokeColor: new Microsoft.Maps.Color(0, 0, 0, 255) });
  83. }
  84. </script>
  85. </body>
  86. </html>

If you run the code as is, your location will be shown along with a message about invalid credentials, as shown in Figure 7. To get a result without the warning text (Figure 8), you need to replace YOUR_BING_MAPS_KEY with your own key, which is generated when you sign up for a Bing Maps Developer account.

Geolocation Demo Mapping a Location without a Valid Key
Figure 7 Geolocation Demo Mapping a Location without a Valid Key

Geolocation Demo Mapping a Location after Inserting a Valid Key
Figure 8 Geolocation Demo Mapping a Location after Insertinga Valid Key

To see other examples of geolocation, which map your location using a push pin, visit IE Test Drive or attend an HTML5 Web Camp.

PHP: Remove Everything But Letters And Numbers – Reg Expressions

PHP: Remove Everything But Letters And Numbers – Reg Expressions

I always forget this PHP function, but I’m finding myself regularly needing it. I thought I’d just jot it down for my own reference and for anyone else who might need it.

Function: ereg_replace

What this function basically does is remove all characters from a string which isn’t a letter or a number. It can be a very cool function for error checking. Regular expression functions like this enable you to search for patterns within a string.

1
2
3
$string = "remove ever^&amp;thing but *&amp;^*&amp;%£ letters &amp; numbers*&amp;^*";
$cleansedstring = ereg_replace("[^A-Za-z0-9]", "", $string );
echo $cleansedstring;

$cleansedstring should output: removeeverthingbutlettersnumbers

I used “[^A-Za-z0-9]” to remove every chracter that isn’t a letter or number, but here are some different matches:

[abc] a, b, or c
[a-z] Any lowercase letter
[^A-Z] Any character that is not a uppercase letter
(gif|jpg) Matches either “gif” or “jpeg”
[a-z]+ One or more lowercase letters
[0-9\.\-] any number, dot, or minus sign
^[a-zA-Z0-9_]{1,}$ Any word of at least one letter, number or _
([wx])([yz]) wy, wz, xy, or xz
[^A-Za-z0-9] Any symbol (not a number or a letter)
([A-Z]{3}|[0-9]{4}) Matches three letters or four numbers

You should note that because regular expressions are more powerful than regular functions, they are also slower. You should only use regular expressions if you have a particular need. Out of curiosity, does anyone know a less taxing function of getting the same result, or are regular expressions the most suitable option for stripping everything but numbers and letters?

For a more indepth explanation, here’s an awesome tutorial on Using Regular Expressions.

Silabus Training ANDROID Development di Bandung

SISINDOTEK (IT Training Center Bandung) menyediakan pelatihan atau training Android di bandung untuk anda yang tertarik mengembangkan aplikasi berbasis Android. Training yang kami selenggarakan sangat special karena anda tidak hanya mengenal konsep dan mengenal cara membuat aplikasi Android namun anda juga belajar bagaimana cara melakukan distribusi Android Anda via google market.

Berikut informasi training Android yang kami selenggarakan :

MOB-01 – Mobile Application Development for Android
Biaya : Rp 4.600.000 (Non Residential) | Rp 5.750.000 (Residential)
Durasi : 4 Hari, Start : 2,16, 23 April 2012, Lokasi : Hotel Bintang Bandung

Fasilitas Standar : Penginapan** Kamar Hotel per Peserta, Breakfast** + 2x coffee break + Lunch **, Buku Panduan, Training Kit , Laptop/ peserta , Software Pendukung, Sertifikat , Flash Disk, Souvenir
Waktu Training : 09.00 – 17.00 WIB (diselingi 2x coffee break + Lunch)

Note :(**) Hanya untuk Paket Residential

INHOUSE TRAINING : Rp 700.000/ Peserta/ Hari (Minimal 3 Peserta),
Diskon 10% untuk peserta group > 5
Informasi dan ketentuan Inhouse Training hubungi : 022-71242266 atau 0812.8733.1966 , info@sisindotek,com

SILABUS ANDROID TRAINING

Mobile Application Development for Android
Durasi : 7 jam x 4 Hari (28 Jam)

Deskripsi : Android merupakan salah satu Mobile OS yang diproduksi oleh Google, perkembangan Android sangat cepat seiring berkembangnya teknologi ponsel dimana handphone tidak lagi sekedar digunakan sebagai media untuk call dan text (sms) tapi lebih jauh lagi berfungsi sebagai computer super mini yang dikenal sebagai Smartphone. Selain itu cepatnya perkembangan Android dikarenakan teknologi open source yang dibawanya.

Tujuan Training : 1. Peserta mengenal teknologi android
2. Peserta tahap persiapan sebelum memulai pembuatan sebuah aplikasi android
3. Peserta memahami penggunaan bahasa pemograman pendukung pembuatan aplikasi Android (HTML 5, JSON, CSS, JQuery, Java)
4. Peserta mengetahui cara built sebuah aplikasi android dan menguploadnya ke google market

Target Peserta : – Web Programmer
– Mobile Application Developer
– Umum/ Mahasiswa

Prasyarat : – Disarankan telah mengetahui basic HTML

Materi Training : I. Introduction
Android, the world’s most popular mobile platform
More than Just a Call
The Secret of fast development
The difference between Mobile Application and Mobile Websites
Android

II. Creating Your First Android Mobile Application
Introduction of Jquery Mobile
Dreamweaver Easy Simulator or Emulator Setup
Mobile Start
Content CSS (Cascading Style Sheet)
Mobile App CSS Theme
Change Theme in Dreamweaver

III. Setting Up Android Work Enviroment
Android Preparation
Application Folder
Manage Folder Site
Download SDK
Setup the Application
Manage AVD
Android Emulator

IV. Building Android Mobile App from Scratch
Create DIV Page
Create Nav Bar for multiple pages
History Back Button
Page Transition
Add columns
Create List
Image List
Creating Map and Compass
Connecting the application to database

V. Build The application
Google Market Publishing Rule

Training Lanjutan yang Disarankan : Mobile Application Development for IOS iphone

SISINDOTEK – IT Training & Solution Provider Jl. Sukasenang VI-6B Bandung – Jawa Barat 40124
Tel. 022-71242266 , SMS. 0812.8733.1966
info , YM. sisindotek
www.sisindotek.com , facebook.com/sisindotek , twitter.com/sisindotek