The State of the CIO -- 2007

No organization of any size can operate efficiently without information technology (IT) -- the use of technology in managing and processing information. Larger organizations employ Chief Information Officers (CIOs) to coordinate this effort.

CIO magazine surveyed more than 500 CIOs on various topics for the 2007 version of their annual report called The State of the CIO. Since Web-related projects are coordinated, either directly or indirectly, through IT departments, Web professionals should be aware of the challenges facing today's IT leaders. Let's review a summary of the survey results.

More than half of CIOs expect to add full-time staff in 2007. The top three skills most in demand are the following:

• project management (52%)
• application development (50%)
• database management (39%)

Web professionals with expertise in these areas can get the attention of CIOs with documented experience in one or more of these three areas.

Web-related technology solutions were rated lower on the list of skill sets in demand:

• Web services (32%)
• Website development (26%)

Web-related technologies that are part of Web services include XML and SOAP.

CIOs need help. They are swamped with work citing the biggest barrier to job effectiveness as follows:

• Overwhelming backlog of requests/projects

The best way for Web professionals to help CIOs with this backlog is to provide solutions that help CIOs meet their expectations for 2007. When asked "What impact do you expect IT will have in the year ahead?" CIOs responded as follows:

• Enable business innovation (54%)
• Reduce business costs (48%)
• Improve customer (external) satisfaction (48%)
• Create competitive advantage (38%)

Web professionals should consider setting goals for the New Year to document how their Web projects meet the above four criteria. By quantifying these results you can get the attention of business leaders and create your own competitive advantage in the marketplace.

Before your next meeting with a business leader to discuss a Web project download and review a copy of the 2007 State of the CIO survey. The 16-page summary is free, but registration is required. By understanding the IT needs of an organization you will be in better position to solve problems, overcome objections and land the assignment.

Outlook 2007, Part 2

This article is the second of a two-part series [ view Part 1 ] on career prospects for Web designers and developers in 2007. In Part 2 of Outlook 2007 we'll take a closer look at the demand for technology professionals and identify three skill sets that Web professionals should focus on developing in the New Year.

According to 2007 Job Forecast, a survey of more than 2,600 hiring managers and human resource professionals in private sector companies, 40 percent report they will increase their number of full-time, permanent employees in 2007. Information Technology is one of the areas that employers will be recruiting for the most (13 percent of respondents). For a detailed evaluation of corporate hiring plans access 2007 Annual Job Forecast (pdf) available from CareerBuilder.com.

A closer look at the information technology (IT) marketplace reveals that skilled IT professionals are in demand. According to the Robert Half Technology 2007 Salary Guide, one and a half million new computer and IT-related jobs will be created between 2004 and 2014. The Salary Guide helps identify the specific skills required to fill those job in 2007 and what the salaries are likely to be for Web professionals with those skills.

The IT positions in the United States that are expected to experience greater than average demand in 2007 are as follows:

• Software Developers
• Web Developers
  
• Data Warehouse Managers
  
• Project Managers
  
• Application Architects

"Web developers are in high demand as web-based tools, services and applications – collectively referred to as Web 2.0 – gain popularity among companies of all sizes and industries," according to the Salary Guide.

Three areas that Web professionals should focus on developing in 2007 that relate directly to the five in-demand areas are as follows:

• programming skills
  
• database expertise
  
• project management experience

Access the Robert Half Technology Website to obtain a FREE copy of the 2007 Salary Guide.

A closer look at the IT hiring landscape can be gleamed from the Robert Half Technology IT Hiring Index and Skills Report , a survey of more than 1,400 Chief Information Officers (CIOs) from companies with more than 100 employees.

Here are the skill sets that are most in demand by CIOs at large companies:

• Microsoft Windows administration (Server 2000/2003) (77%)
  
• network administration (Cisco, Nortel, Novell) (71%)
  
• database management (Oracle, SQL Server, DB2) (63%)

On the programming side these larger companies tend to be more Microsoft-centric with 23% of CIOs reporting demand for Microsoft-specific skills (i.e. ASP.NET). Open source Web programming skills (i.e. PHP) were not reported to be in demand at these larger companies.

Here's the three-step plan for career development in 2007:

1. seek opportunities to develop project-management skills -- the ability to develop a project plan and deliver on that plan in a timely and cost-effective manner


2. develop programming skills -- ASP.NET if you are focusing on larger companies; PHP (open source) if your target market is smaller organizations


3. develop database skills -- Oracle, SQL Server, DB2 if you are focusing on larger companies; MySQL (open source) if your target market is smaller organizations
   

By developing a project plan to improve two skills -- one programming skill and one database skill -- your skill set will expand, your confidence will grow and your marketability will improve.

Here's wishing all of my readers a healthy and prosperous New Year!

Outlook 2007, Part 1

This article is the first of a two-part series [ View Part 2 ] on career prospects for Web designers and developers in 2007. In Part 1 of Outlook 2007 we'll take a broad view of the economy and identify one area of development that Web technology professionals should learn more about in the New Year.

One snapshot of the economy comes from Chief Executive Officers (CEOs) of large corporations with more 10 million total employees. They predict slow steady growth for the first half of 2007.

Here are a few key findings from a recent survey of 124 CEOs:

• nearly 70% expect sales to increase over the next six months
  
• more than one third expect employment at their U.S. operations to increase

The biggest concern among CEOs:

• more than 50% cited the rising cost of health care as the greatest cost pressure facing their business

The implications from this survey are clear: workers should continue to find employment opportunities during the first half of 2007, but don't be surprised if an increasing number of these opportunities take the form of contract work without benefits.

Complete details are available in the quarterly CEO Economic Outlook Survey available from the Business Roundtable.

For a closer look at job opportunities within the information technology sector, let's see what Chief Information Officers (CIOs) have to say. The Forrester/ITAA U.S. Tech Sector Index reached a five and a half year high in its most recent quarterly survey. "Improved profits and surprisingly optimistic CIOs drove the index to its highest level since Q1 2001," according to a five-page report summary.

However, the IT sector is going through a period of "refinement and digestion." According to the report, " . . . the current period . . . should end around 2008, and it is becoming clearer that Web 2.0, software-driven computing will likely lead the charge."

While the report did not define Web 2.0 the implication is that Web professionals with knowledge and experience in designing and developing database-driven Web applications will fair well in 2007 and 2008.

On a local level, here are two opportunities to connect with technology leaders to learn more about their perspectives on the technology economy in Massachusetts:

• What's Next for The Digital State in 2007, sponsored by MITX -- Wednesday, January 17
  
• IT Futures Forum, sponsored by BATEC -- Friday, February 2

In Outlook 2007, Part 2 we'll take a closer look at the demand for technology professionals and identify three skill sets that Web professionals should focus on developing in the New Year.

Happy Birthday CSS

Cascading Style Sheets (CSS) celebrated its 10-year anniversary this week. In an unrelated event Adobe Systems launched CSS Advisor, a community-driven Website. Designers and developers who use CSS will want to take a look at this free service. The location acts as a central repository for cross-browser/cross-platform CSS issues and solutions.

CSS Advisor is currently in public beta and is available to anyone with an Adobe login and password. Registration is free. The site helps professionals in the following three areas:

• Find solutions to CSS and browser compatibility issues
  
• Share solutions and workarounds you've discovered with the community
  
• Comment on and improve existing solutions
  

The plan is for CSS Advisor to be incorporated into the next version of Dreamweaver where it will automatically detect CSS compatibility issues in your code and take you to the proper page on the CSS Advisor site.

While you are at the Adobe Website check out the Dreamweaver Developer Center. Articles, tutorials and downloads cater to a wide range of developer experience from Building your first CSS site to Adobe Spry, a new Ajax framework available for download. If you are new to Ajax, check out the Spry Demos Gallery.

To learn more about CSS Advisor, access an InfoWorld article. Also, check out editorial commentary at Digital Media Online.

Internet Explorer 7: CSS Support

With the recent release of Microsoft's Internet Explorer 7 (IE7) for Windows, Web designers and developers may finally get relief from the challenge of cross browser compatibility. Or will we?

To provide the Web development community with answers, O'Reilly Media, Inc. has just released a document that details support for Cascading Style Sheets (CSS) in the new IE7. Here are a few topics covered in this timely report:

• Flaws in IE6
• Fixes in IE7
• What you won't find in IE7
• Hacks and Workarounds in IE7
  

In addition the document presents a rationale for how quickly IE7 might replace IE6 as the primary browser that the vast majority of Internet users will use to view Web pages. For example, IE7 is now the second most popular Web browser surpassing both Firefox 1.5 and Firefox 2.0 in November.

Every Web professional should be current on issues related to design and development for different operating systems and browser products. If you'd like to learn more, Releasing CSS: How I Learned to Stop Worrying and Love IE7 is available for purchase and instant download. The investment in this 69-page document is only $10.

[Full Disclosure: As the publisher of this blog I have no financial arrangement with O'Reilly Media, Inc. and do not benefit financially or otherwise from recommending its products. I have been searching the Internet for the past month to recommend resources to help designers and developers identify challenges and solutions relating to the recent release of both IE7 and Firefox 2 and have concluded that this is the most comprehensive product available at this time.]

Microsoft Vista/Office Launch Tour

Windows Vista is the highly touted, long overdue operating system from Microsoft. It will eventually replace Windows XP.

Office 2007 is Microsoft's latest upgrade to the Office 2003 suite of productivity tools which includes Word, Excel, PowerPoint and Outlook, among other programs.


Microsoft wants to tell you all about Windows Vista and Office 2007 and has reserved the Boston Convention & Exhibition Center for one giant marketing extravaganza! Boston is the fourth stop on a planned 15-city tour designed to promote the first simultaneous upgrade of Microsoft's operating system and Office suite since 1995.

The giveaways are usually top of the line. The party is free. And space is limited. So act now if you would like to attend Ready for a New Day: Launch Tour 2007 on Wednesday, January 24, 2007.

Boston Market -- December

The Monster Local Employment Index for Boston reached a new high in October. "In addition to heightened seasonal demand for retail workers, the index for Boston showed an increase in online job opportunities in IT, science and engineering professionals," according to a Monster press release.

If you are a recent college graduate your prospects of finding a quality job are especially good according to Job Outlook 2007, an annual survey published by the National Association of Colleges and Employers (NACE).

"This marks the fourth straight year that employers have projected percentage increases in the double digits," says a NACE representative. According to the survey, employers plan to target the following degree areas to fill positions:

• business
• engineering
• computer-related

Not all computer-related skills are valued equally by employers, however. The job market analysis below reveals which computer-related skills are most in-demand in the greater Boston area [ along with the number of jobs listed for that skill at BostonWorks.com ].

The following skills are typically associated with Web Design:

• Photoshop [ 67 ]
  
• CSS [ 67 ]
  
• Flash [ 52 ]
  
• Dreamweaver [ 35 ]
  
• XHTML [ 18 ]
  

The following skills are typically associated with Web Development:

• XML [ 238 ]
• ASP [ 182 ]
  
• JavaScript [ 118 ]
  
• ASP.NET [ 104 ]
  

The following skills are typically associated with data management:

• Oracle [ 390 ]
  
• SQL [ 447 ]
  
• SQL Server [ 214 ]
  

Web design skills continue to lag behind Web programming skills. Database skills (including XML) continue to be in highest demand by Boston area employers. Average salaries reflect this demand curve and are listed below:

• Graphic Artist / Designer | $45,000
• Web Designer | $46,500
• Senior Web Designer | $48,000
• Webmaster | $57,000
• Web Programmer | $65,000
• Web Developer | $65,000
• Database Administrator (DBA) | $85,000

For a more complete list of skills, along with direct access to job postings at both BostonWorks.com and Monster.com, review Boston Market -- 4th Quarter, 2006.

100 Million to One

Now that there are more than 100 million Websites on the Internet, how do you get search engines to find yours?

What if you have more than one website that you manage? Wouldn't is be efficient if there were just one process to help streamline the task of having the major search engines find the most current information on the websites you manage?

Google has such a process and Yahoo! and Microsoft have agreed to support it. It's called Sitemaps. Google's Webmaster Help Center provides an introduction to Sitemaps and links to other webmaster tools.

The process is fairly simple:

1. create an XML file
2. place it on your Web server
   

Visit Sitemaps.org for details. The Protocol page will show you how to create the XML file and the FAQ page will show you where to place the file on the server.

To learn more access Search Giants Find Common Ground for Webmasters from NewsFactor.com.

NOTE: Approximately 85% of all searches are processed through Google, Yahoo! and Microsoft search engines.

Boston Market -- November

Monster.com released its Employment Index for October and reported a three-month upward trend in job postings indicating "continued strong demand for IT professionals across the country". The Index including design professionals also participated in the three-month upward trend.

While this report confirms a strong job market for technology workers, not all technology workers are valued the same. For example, a new free salary service from CareerBuilder.com called CBSalary.com provides an insight into pay scales for workers with Internet and database skills. Check out the following average salaries in the greater Boston area:

• Web Designer | $40,000
• Graphic Artist / Designer | $43,000
  
• Senior Web Designer | $55,500
  
• Web Programmer | $63,250
  
• Web Developer | $63,250
  
• Webmaster | $63,250
  
• Database Administrator (DBA) | $80,000

From this simple analysis Web programming skills command a 50% pay premium over Web design skills. Database skills command a 100% pay premium over Web design skills.

What about the demand for these skills? Once again a similar trend emerges.

Listed below are several skills typically associated with Web Design [ along with the number of jobs listed for that skill at BostonWorks.com ]:

• Photoshop [ 74 ]
• CSS [ 72 ]
• Flash [ 48 ]
• Dreamweaver [ 34 ]
• XHTML [ 13 ]

Listed below are several programming skills that are more typically associated with Web Development:

• ASP [ 337 ]
• XML [ 262 ]
• JavaScript [ 145 ]
• ASP.NET [ 142 ]
• JSP [ 106 ]

In addition, here are a few skills typically associated with Database Administration:

• Oracle [ 523 ]
• SQL [ 519 ]
• SQL Server [ 273 ]

The demand trends and the compensation trends track each other as follows:

• Web Designer [ lower demand → lower pay ]
• Web Developer [ moderate demand → moderate pay ]
• Database Administrator [ higher demand → higher pay ]
  

If you are looking to upgrade your skills consider one of the following FREE online courses enrolling later this month at the HP Learning Center:

• Introduction to Programming
• Microsoft® ASP.NET: Building Applications

Web Research: A Look in the Mirror

If job candidates use the Internet to identify jobs and research companies why can't companies use the Internet to research job candidates?

A survey of 1,150 hiring managers reveals the following Web tools that are used in the candidate screening process:

• one-in-four use Internet search engines
• one-in-ten search social networking sites

Check out these staggering findings:

• More than half (51%) of candidates are excluded from receiving an offer after the hiring manager performs an Internet search
• Nearly two thirds (62%) of candidates are excluded after a search of social networks

What does the Internet say about you? Have you googled yourself lately? What kind of "digital dirt" can be unearthed on your MySpace or Facebook site?

To learn the leading reasons for being dismissed as a candidate access a press release of the survey results from CareerBuilder.com. Also listed are three steps you can take to safeguard your online persona.

If you are looking to use the Web to present a favorable image to prospective employers consider the following list of reasons that hiring managers found to help confirm their decision to hire a candidate:

• candidate’s background information supported their professional qualifications for the job (64%)
  
• candidate was well-rounded, showed a wide range of interests (40%)
  
• candidate had great communication skills (34%)
  
• candidate’s site conveyed a professional image (31%)
  
• researcher got a good feel for the candidate’s personality, could see a good fit within the company culture (31%)
  
• other people posted great references about the candidate (23%)
  
• candidate was creative (23%)
  
• candidate received awards and accolades (19%)

What the Web says about you can land you in a bigger cubicle on the road to the corner office or in the grandstand as you watch others accepting better paying jobs and wonder why you are not receiving offers.

Salary Guide -- 2007

The following technology roles are expected to be in high demand in 2007:

• software developer
• web developer
• data warehouse manager

These roles require expertise in programming and database management which confirms the findings in Boston Market -- 4th Quarter, 2006 as follows:

• High demand -- database skills (SQL)
• Moderate demand -- programming skills (ASP, JavaScript & ASP.NET)
  
• Low demand -- design skills (XHTML, CSS & Flash)

The annual base compensation ranges for the top three in-demand roles are as follows:

• Software developers [ $60,250 -- $94,750 ]
  
• Web developers [ $54,750 -- $81,500 ]
  
• Data warehouse managers [ $85,500 -- $113,500 ]
  

The industries forecasting particularly strong demand for IT professionals in 2007 include the following:

• financial and business services
• insurance
• technology
• healthcare
• manufacturing

Additional technology roles and their expected salary ranges include the following:

• Project managers [ $72,750 - $106,250 ]
  
• Quality assurance analysts [ $52,250 - $74,500 ]
  
• Applications architects [ $80,000 - $112,750 ]
  
• Network security administrators [ $69,750 - $98,500 ]
  
• IT auditors [ $69,250 - $97,000 ]
  

A press release of the Robert Half Technology 2007 Salary Guide is available for review. You can also register to receive a FREE copy of the guide along with other resources including a Glossary of Job Descriptions.

WebAwards -- 2006

The WebAwards for 2006 have been announced in the tenth annual competition for outstanding web site development. The awards are coordinated by the Web Marketing Association which was founded in 1997 to help set a high standard for Internet marketing and web development. More than 2,300 web sites were reviewed in this year's competition.

Entries were judged on the following criteria:

• design
• copy writing
• innovation
• content
• interactivity
• navigation
• use of technology

The four WebAward levels are as follows:

• Best of Show
• Best of Industry
• Outstanding Website
• Standard of Excellence

Web developers can use these award-winning websites to benchmark design standards and to stimulate design ideas.

The design firms with offices in the Boston area that won awards at this year's competition included the following:

• Avenue A | Razorfish
• Boston Web Design
  
• OTOi
  
• Valassis

The Best of Show (overall winner) award went to the TBS: Department of Humor Analysis website.

Listed below are the Best of Industry award winners in 96 industry categories:

• Advertising > Spot Runner
• Advocacy > Live with It
• Airline > American Airlines - We Know Why You Fly
• Application Service Provider > Offermatica
• Architecture > VMDO Architects
• Arts > Houston Theater District
  
• Associations > National Clearinghouse for Educational Facilities
• Auction > Leading B2B Online Auction Marketplace
• Automobile > Una Noche IS
• B2B > Bottlerocket Post
• Bank > Wachovia Championship 17
• Beverage > KING JAMES
• Biotechnology > Cara Therapeutics
• Blog > Bannerblog
• Broadcasting > USA Network
• Brokerage > Spotting/Seizing Opportunity
• Catalog > L.L.Bean, Inc.
• Computer: Hardware > Broadcom
  
• Computer: Retailer > Dell Home/Home Office
• Computer: Software > See Windows Vista Website
• Construction > PAF Painting
• Consulting > Landor Associates
• Consumer Goods > Merillat
• Credit Union > Union America Mortgage
• Design > Experience Wonder You
• Directory or Search Engine > Best Specialty Search Engine
• Diversified Business > First Quality
• Education > Discover Antarctica
• Electronics > Z5 Digital Audio Player
• Email > Monk-e-Mail
• Employment > Dice.com Being IT
• Energy > Edison International
• Entertainment > Barrio RBK
• Events > Rogers FIFA World Cup 06
• E-Zine > The Gospel of Judas
• Faith-based > Dallas Theological Seminary
• Family > The Great Family Cookbook Project
• Fashion > Bikkembergs Football
• Financial Services > Chase card with Blink
• Food Industry > Coca Cola BlaK
• Game Site > Knights of the old Republic
• General Interest > Noxzema Site Redesign
• Government > National Library of Scotland
• Health Care > Kaiser Permanente Interactive Health Plan Advisor
• Healthcare Provider > J&D Dental
• Home Building > BUILDER Online
• Hotel and Lodging > ExperienceMarriott.com
• Information Services > Help Desk II
• Institutional Services > Parents Program at the University of Denver
• Insurance > Blue Shield of California
• Interactive Services > It's a Wonderful Internet
• International Business > FedEx Global Trade Manager
• Internet Service Provider > EV1Servers
• Intranet > Merrill Lynch Intranet: WorldNet
• Investment > BetterInvesting Website Redesign
• Investor Relations > AirTran e-Annual
• Legal > Yanowitch Law, P.A.
• Leisure > San Manuel Indian Bingo & Casino
• Magazine > Resort Living Online Magazine
• Manufacturing > My1stop Printing
• Marketing > Silvertip Resort
• Media, Photography > Slate Magazine
• Medical Equipment > Guidant.com
• Medical > WebMD
• Military > TodaysMilitary.com
• Movie > Walk the Line DVD Official Website
• Music > Metzler Violin
• Mutual Fund > Cohen & Steers
• News, Newspaper > NYTimes.com
• Non-Profit > VH1 Save The Music/P&G brandSAVER
• Online Community > YourMembership.com
• Other > Refinery Corporate Website
• Pharmaceuticals > CVS Medicare Expert
• Political > The Wall Street Journal's OpinionJournal.com
• Portal > SonyATV.com
• Professional Services > Hire Jeffrey
• Public Relations > PRWeb.com
• Publishing > Arcadia Publishing
• Radio > Radio Margaritaville
• Real Estate > coldwellbanker.com
• Regional > New York's Tech Valley
• Restaurant > Montage Studio
• Retail > RBK Music
• School > St. George's School
• Shopping > ShopLocal
• Small Business > BusinessWeek Online - Small Biz
• Sports > Soloflex, Inc. Microsite
• Technology > MediaMax, powered by Streamload
• Telecommunication > TELUS Mike Microsite
• Television > TBS: Department of Humor Analysis
• Toy & Hobby > MJ Trim
• Transportation > Freedom of the Seas
  
• Travel > RIU Cancun Portal
• University > The Road to Xavier
  

Additional winners in the categories of "Outstanding Website" and "Standard of Excellence" can be identified via searching the WebAwards Website.

Boston 4 -- Detroit 1

Detroit may have made it to the World Series this year, but Boston continues to be a great place to find work.

According to the latest job posting data there are several large metropolitan areas with a higher than average ratio of online ads per 100 persons in the labor force. The national average is 1.62 per 100. The above average metro areas include the following:

• San Diego (3.96)
• San Francisco (3.90)
• San Jose (3.84)
• Seattle-Tacoma (3.68)
• Boston (3.53)

The metropolitan area with the lowest number of online job ads per 100 persons in the labor force:

• Detroit (0.81)

So, Boston outpaces Detroit four to one in job creation.

While the report did not specify the type of jobs, nor did the study evaluate the quality of those postings, it's clear that the top metro areas are also high technology centers. It seems likely that a higher percentage of these postings require technology skills. A summary of The Conference Board Help-Wanted OnLine Data Series is available for review.

The findings in this analysis were confirmed by the Monster Local Employment Index (pdf) for September which reported that online job postings in the greater Boston area are at an all-time high "driven by elevated demand for workers in business, financial and creative services."

While new online job postings are up between seven percent (Monster) and 20 percent (Conference Board) from the same time last year, not all is rosy on the job front. The Chief Executives' Confidence Measure, for example, is at its lowest level in nearly five years. The survey of 100 business leaders from a wide range of industries reveals expectations for a lackluster pace of growth from now into the beginning months of 2007, but growth none-the-less.

While Boston might be a much better place to look for work than Detroit, finding a quality job that matches your skill set could be a challenge. If you are in the job market because you are either on a losing team or are currently a free agent, perhaps you need to acquire some new skills during the off season. For a thorough evaluation of the technology skills most in demand in the free agent market, review Boston Market -- 4th Quarter, 2006.

IT Labor Hard to Find

Two new job market studies confirm the conclusions from Boston Market - 4th Quarter. A brief summary of the Boston area Web technology job market:

• High demand -- database skills (SQL)
• Moderate demand -- programming skills (ASP, JavaScript & ASP.NET)
  
• Low demand -- design skills (XHTML, CSS & Flash)
  

The first finding confirms the high demand for database skills. More than 70 percent of CIOs state that the technical skill set most in demand is database management (Oracle, SQL Server, DB2). In addition, 30 percent of CIOs now claim that "IT labor is hard to find and keep." For details access Robert Half Technology IT Hiring Index and Skills Report and the CIO Magazine Tech Poll (pdf).

The second finding confirms the moderate demand for programming skills. MonsterTRAK, the student division of Monster.com, announced the five hottest occupations for recent graduates based on entry level job postings. The fifth hottest job market is for entry-level programmers. A complete list can be accessed from a Monster.com press release.

If you are new to databases, the Microsoft Office suite of productivity tools offers desktop software to help you get started. Microsoft Access is one of those programs that is installed on most computers, but few people ever receive training on how to use it. The HP Training Center offers Microsoft Access 2003: Introduction, a FREE online course that begins Thursday, October 12. If you do not own Office, you can download a FREE trial version.

Once you are familiar with the Access interface you can practice writing Structure Query Language (SQL) statements. The ability to understand and implement SQL statements is a core skill required for transforming a static website into a data-driven website. W3Schools offers FREE SQL Tutorial.

Boston Market -- 4th Quarter, 2006

"Online Job Demand" in Boston rose to its highest level in August following two months of seasonally reduced activity according to the Monster Local Employment Index (pdf). "Double-digit year-over-year growth rates in online job activity for management, business and financial operations, creative, IT and science occupations suggest that the Boston metropolitan area remains a hot market for professional jobseekers," according to a company press release.

An analysis of the Boston area Web technology job market reveals the following:

• High demand -- database skills (SQL)
• Moderate demand -- programming skills (ASP, JavaScript & ASP.NET)
  
• Low demand -- design skills (XHTML, CSS & Flash)

Let me explain how I arrived at this conclusion:

Beantown Web monitors IT jobs (Web-related jobs to be specific) on a monthly basis via the "Boston Market" series of postings. At the beginning of every quarter Beantown Web conducts a more thorough TACK analysis. TACK stands for Tools, Acronyms, Containers, and Knowledge:

• Tools -- software programs used in Web design and development
• Acronyms -- languages used in Web design and development
• Containers -- database programs used to store information
• Knowledge -- certifications that indicate proficiency in a specific technology area

One way to gauge the current job demand is through a keyword search on specific technology skills at selective online job sites. Beantown Web monitors two sites: BostonWorks and Monster. Keywords are then grouped into one of the four TACK categories.

A few of the common keywords associated with Web design and Web development jobs are included in the listings below. The numbers in parentheses indicate the number of job postings that list that keyword in the job description. [ First number: BostonWorks.com ][ Second number: Monster.com ]:

Tools (software)

• Photoshop [ 76 ][ 236 ]
• Flash [ 55 ][ 54 ]
• Dreamweaver [ 49 ][ 75 ]
• Visual Studio [ 39 ][ 95 ]

Acronyms (languages)

• SQL [ 607 ][ 1000 ]
• HTML [ 429 ][ 648 ]
• XML [ 257 ][ 570 ]
• ASP [ 336 ] [ 416 ]
• JavaScript [ 173 ][ 304 ]
• ASP.NET [ 153 ][ 184 ]
• JSP [ 111 ] [ 201 ]
• CSS [ 75 ][ 175 ]
• PHP [ 45 ][ 86 ]
• Ajax [ 36 ][ 77 ]
• XHTML [ 20 ][ 36 ]
  

Containers (databases)

• Oracle [ 586 ][ 1000 ]
• SQL Server [ 250 ][ 491 ]
• MS Access [ 72 ][ 111 ]
• MySQL [ 39 ][ 84 ]
• DB2 [ 46 ][ 111 ]
  

Knowledge (certifications)

• The demand for certified professionals varies by discipline. All things being equal certification helps to distinguish you from your competition. Microsoft Salary Survey reveals that a certification can help get your foot in the door, but advancement depends on experience. An appropriate certification entry point for Web design and Web development professionals is Certified Internet Webmaster (CIW).
  

Here are a few additional observations from this quarter's analysis:

• HTML listings are 20 times more prevalent than XHTML listings
• XML listings are 10 times more prevalent that XHTML listings
• Closed-source database listings (Oracle & SQL Server) are at least five times more prevalent than open-source database listings (MySQL)
  

To maneuver your career for future success (TACK through the winds of constant technology change) consider the following four suggestions:

• HTML -- list HTML on your resume, as well as, XHTML
  
• XML -- upgrade your skill set to include XML (XHTML's parent language)
  
• SQL -- develop a solid understanding how to access data from a database
  
• JavaScript -- develop a solid understanding of basic programming skills
  

Here are two recommended training courses for October:

• XML: Introduction
• JavaScript: Web Programming Basics

Both courses are available for FREE compliments of the HP Learning Center. Classes begin Thursday, October 12.

New England Technology Fast 50

The annual New England Technology Fast 50 ranks technology, media, telecommunications and life sciences companies located in New England by revenue growth over five years.

This year's Fast 50 marks the program's 10th anniversary -- a period that corresponds to the Tech Bubble, Bust and Recovery. Several companies on this year's list are notable for their stellar repeat performances.

Seven consecutive appearances:

• Unica Corporation (Waltham)

Six consecutive appearances:

• eCopy, Inc. (Nashua, NH)
• iBasis, Inc. (Burlington)
• Network Engines, Inc. (Canton)

A special category called "Rising Star" recognizes the fastest growing technology, media, telecommunications and life sciences company based on revenue growth over three years (2003 - 2005). This year's "Rising Star":

• Sepaton, Inc. (Marlboro)
  

If you are in the job market and have solid technology skills and experience, then the Fast 50 is a good place to focus your search. Fast growing technology companies generally need fast moving technology professionals to help them grow.

The complete New England Technology Fast 50 company ranking follows:

1. Litle & Co. (Lowell)
2. Arbor Networks, Inc. (Lexington)
3. Compete, Inc. (Boston)
4. Idenix Pharmaceuticals (Cambridge)
5. Data Intensity, Inc. (Waltham)
6. Constant Contact (Waltham)
7. Agiltron, Inc. (Woburn)
8. Evergreen Solar, Inc. (Marlboro)
9. Coley Pharmaceutical Group, Inc. (Wellesley)
10. Picis Inc. (Wakefield)
11. athenahealth, Inc. (Watertown)
12. Salary.com, Inc. (Waltham)
13. Vistaprint (Lexington)
14. CardioTech International, Inc. (Wilmington)
15. Jets International (Quincy)
16. iRobot Corporation (Burlington)
17. NeuroMetrix, Inc. (Waltham)
18. Inverness Medical Innovations, Inc. (Waltham)
19. Cubist Pharmaceuticals, Inc. (Lexington)
20. ImmunoGen, Inc. (Cambridge)
21. OpenPages, Inc. (Waltham)
22. Click Tactics, Inc. (Waltham)
23. Network Engines, Inc. (Canton)
24. Infoscitex Corporation (Waltham)
25. Buyerzone.com, Inc. (Watertown)
26. Smarter Living, Inc. (Charlestown)
27. ITA Software, Inc. (Cambridge)
28. ViaCell, Inc. (Cambridge)
29. BridgeLine Software, Inc. (Woburn)
30. Double-Take Software (Southborough)
31. Curis, Inc. (Cambridge)
32. Sentillion, Inc. (Andover)
33. Sepracor Inc. (Marlborough)
34. Deploy Solutions, Inc. (Auburndale)
35. Outcome Sciences, Inc. (Cambridge)
36. InteQ Corporation (Bedford)
37. Palomar Medical Technologies, Inc. (Burlington)
38. Virtusa Corporation (Westborough)
39. Matritech, Inc. (Newton)
40. Clinical Data, Inc. (Newton)
41. Repligen Corporation (Waltham)
42. iCAD, Inc. (Nashua, NH)
43. Eze Castle Software (Boston)
44. Unica Corporation (Waltham)
45. Nucryst Pharmaceuticals Corp. (Wakefield)
46. Nuance Communications, Inc. (Burlington)
47. Bentley Pharmaceuticals, Inc. (Exeter, NH)
48. IPG Photonics Corporation (Oxford)
49. eCopy, Inc. (Nashua, NH)
50. iBasis, Inc. (Burlington)
    

The Technology Fast 50 program is presented by Deloitte & Touche, Mass High Tech, and others.

OneWebDay

Friday September 22 marks the inaugural OneWebDay. According to the event organizer, "If you can't imagine life without the Web, you should celebrate OneWebDay, because it really has changed everything."

Susan Crawford, OneWebDay organizer, envisions holding worldwide celebrations similar to Earth Day events. This year's events will be concentrated in Boston and New York and in other cities across the United States and around the world.

The Boston event will feature the inventor of the World Wide Web, Tim Berners-Lee. The New York City event will feature Craig's List founder, Craig Newmark.

Organizers are encouraging people to do the following:

• upload videos for viewing on Dabble.com
• post photos to Flickr for a giant online collage (see FAQ for details)
• blog about what they are doing to mark the occasion and explain how the Web has changed their lives (see FAQ for details)
  

If you live in the greater Boston area and want to have lunch in Cambridge with the man who made the Web possible, then access the OneWebDay wiki for details. Lunch includes free pizza and beer.

Update from the Boston event coordinator:

PLEASE NOTE: Tim Berners-Lee will NOT be in attendance; we'll be recording a short video with our thanks to share with him online.

Note: Access a review of the day's activities at TechWeb.