CompTIA Educator’s Conference, Las Vegas 2012: We’ll be there, will you?
May 23, 2012 at 1:54 pm | Posted in CompTIA | Leave a commentTags: certification training, comptia breakaway, comptia educator's conference
It’s finally official – CompTIA will hosting the CompTIA Educator’s Conference from Friday, July 27th, through Sunday, July 29th in Las Vegas, NV. If you are an educator who provides training for CompTIA certifications, this conference is for you!
I attended this conference last year, when it was part of the Breakaway conference. This year the Educator’s Conference precedes Breakaway and is actually considered a separate event. (Breakaway itself will run from July 30 to August 2.) This year’s focus will be emerging technologies, including the new A+, CompTIA Advanced Security Practitioner (CASP), Healthcare IT, and Cloud Computing exams.
Here are three reasons why I think every technology educator should attend this conference:
1) You get information from CompTIA that will help you with your classroom plans for the coming academic year.
2) You get access to authors and presenters in an intimate, classroom-like environment. These authors and presenters can provide you with ideas for your classroom as well as insight into how you prepare yourself and your students.
3) You get to network with other education professionals who have years of experience in teaching, technology, and curriculum design. If you are new to the field, the information from the other educators can help you be well on your way. If you have lots of experience, you will often get some fresh insight and cutting edge ideas that you can incorporate into your classroom.
At last year’s conference I was able to reconnect with Mike Meyers, a McGraw-Hill author and president of Total Seminars, LLC. I also met authors Mark Ciampa and Jean Andrews, both of whom are rumored to be in attendance this year. Although this year’s agenda is not yet complete, I am sure that CompTIA will include presentations on a range of topics. Not the least of which will be yours truly making my CompTIA conference presentation debut. I will share with attendees the basics of the CASP certification.
Here is the text from the e-mail that I got from CompTIA:
Dear Educator,
You are cordially invited to join classroom educators from all around the country at this year’s CompTIA Academy Educator’s Conference held in Las Vegas from July 27 – July 29, 2012.
This year the event will focus on a theme of “Emerging Technologies” and include educational forums and training sessions that spotlight the newest revision to CompTIA’s A+ certification as well as the new technologies that form the basis of several of the newest CompTIA certifications.
The conference will feature sessions on the new 2012 A+ that will be released later this year, our Security+ and CompTIA Advanced Security Practitioner certifications and our new Health IT certification.
There will also be a Publishers Expo that you can visit to learn about the latest learning materials for CompTIA certifications. Each publisher will deliver separate presentations on their products.
We’re still organizing the speaker sessions and training sessions on Saturday and Sunday- so the actual running order is not ready for publication.
Watch for the full conference agenda – Coming Soon!
The CompTIA Academy Educators Conference will be held at the Aria Hotel in Las Vegas. This year the Academy sessions will precede CompTIA’s annual Breakaway event.
Here’s the essential information you need to know.
What: CompTIA Academy Educators Conference – 2012
Where: Las Vegas, NV
Conference Hotel - Aria at City Center
Attendee hotel rate – $139 /night
When:
Friday, July 27 - 7:00 am – 3:00 pm - Travel time
Friday, July 27 - 3:00 – 7:00 pm - Sessions
Saturday, July 28 - 9:00 – 5:00 - Sessions and Training
Sunday July 28 - 9:00 am – 5:00 – Publishers Expo and Training
(session times subject to change)
CompTIA Academy Educator Conference Registration Cost
$199
Registration Website :
http://www.comptia.org/breakaway/register.aspx Please register for the $199 option with the following wording:
CAPP Academy/E2C Program only
Please note: this fee only covers the CompTIA Educators Conference 2012 scheduled Friday, July 27 – Sunday, July 29. This fee does not include Breakaway registration.
CompTIA Academy membership (free) is required to attend: www.comptia.com/academy
PLEASE BE ADVISED THAT WE ARE SHARING A REGISTRATION SITE WITH THE COMPTIA BREAKAWAY CONFERENCE. The Academy Educator Conference fee does not include admission to the Breakaway conference sessions or events.
EARLY BIRD REGISTRATION DRAWING
The first 50 paid registrations will be entered into a drawing for your choice of a
Apple iPad ($500 value) OR a $500 American Express Gift Card
The drawing will be conducted on Saturday at the event. You must be in attendance at the event to win.
I hope to see you there! I’m the presenter with the heavy southern drawl (check out my video if you don’t believe me). Sorry, but translators/subtitles will NOT be provided..LOL!
-Robin
Everything old is new again: the MCSE and MCSA are dead (long live the MCSE and MCSA)
May 14, 2012 at 8:15 am | Posted in Certification Paths, Microsoft, Vendor news | Leave a commentTags: Certification Paths, cloud certification, mcsa, mcse, MCTS, zombie certifications
Yesterday a vendor called me on the phone and said that he had a great price on the latest MCSE classes. He went on to explain that these classes taught all the latest, hottest technologies. They were so virtualized, a team of physicists argued over their very existence. They were so far up in the cloud, you needed a telescope to find your exam. Once he’d wound down the hyperbole, I asked him what operating system that the classes covered. He told me, “Windows Server 2003.”
I have news for you, buddy: Windows Server 2003 is nine years old. The problem is that MCSE, as a certification, became both the gold standard for HR staff and a synonym for the “brand” of Microsoft certification. When Microsoft retired those certifications in favor of the MCITP and MCPD and MCTS in 2005, they had problems selling the switch to die-hard certification holders. More importantly, it faced uneven adoption in the business realm. No one really jumped on the bandwagon. Human Resource managers and hiring managers still referred to MCSA and MCSE in job listings. Vendors who called me on the phone only knew “MCSE” and “MCSA.” (Sales people in my own office still do not understand the differences between MCTS and MCTIP, but at least they realized the MCSE was gone.) I’ve had students tell me they’ve applied for recent jobs that cited a MCSE as a requirement. I guess Microsoft felt the time was right to reanimate the dead MCSA and MCSE certifications.
As I’m sure you’ve heard by now–that clueless vendor had it half-right. The MCSE and MCSA are back!
The new MCSE is not your Dad’s MCSE. First of all, MCSE now stands for Microsoft Certified SOLUTIONS EXPERT, not Microsoft Certified Systems Engineer. If you attain the new and re-released MCSE, you are an expert in Microsoft solutions, not an engineer. (You are an engineer if you passed a lot of physics and calculus classes.) The new MCSA is now called Microsoft Certified SOLUTIONS ASSOCIATE, instead of Microsoft Certified Systems Administrator. That also makes more sense. If you attain the MCSA you are certified in various Microsoft solutions, but not necessarily a sysadmin.
The old MCSE made you pass several tests based on the Windows operating system plus an elective subject, like Exchange Server or SQL Server. The new MCSE currently offers certifications in MCSE – Private Cloud and MCSE SQL Server 2012. Going forward, Microsoft will offer more MCSE certifications as new versions of products are released. Look for the MCSE Data Platform certification to roll out tests in June 2012.
The new MCSA is similar the old MCSA. Microsoft currently offers certifications in MCSA Windows Server 2008 and MCSA SQL Server 2012, but will offer more MCSA certifications as new versions of products are released.
To get the MCSA: Windows Server 2008, you would have to pass the following:
- Exam 70-640 – windows Server 2008 Active Directory, Configuring
- Exam 70-642 – Windows Server 2008 Network Infrastructure, Configuring
- Exam 70-646 – Windows Server 2008, Server Administrator
Hey, wait a minute. Wasn’t there already a certification for someone who passed the above tests? Yeah, it was called the MCITP: Server Administrator on Windows Server 2008. The good news is that if you’ve been studying toward these exams, you haven’t wasted your precious certification time. The Private Cloud certification requires that you pass the following:
- Exam 70-640 – windows Server 2008 Active Directory, Configuring
- Exam 70-642 – Windows Server 2008 Network Infrastructure, Configuring
- Exam 70-646 – Windows Server 2008, Server Administrator
- Exam 70-247 – Configuring & Deploying a Private Cloud with System Center 2012 OR Exam 70-659 Windows Server 2008 R2 Virtualization
- Exam 70-246 – Configuring Monitoring and Operating a Private Cloud with System Center 2012
The 70-246 and 70-247 exams should be released this summer.
The SQL Server 2012 MCSE Server certification has two different platforms: Data Platform or Business Intelligence. To get the MCSE: Data Platform, you have to pass the following:
- Exam 70-461 – Querying Microsoft SQL Server 2012
- Exam 70-462 – Administering a Microsoft SQL Server 2012 Database
- Exam 70-463 – Implementing Data Warehouses with Microsoft SQL Server 2012
- Exam 70-464 – Developing Microsoft SQL Server 2012 Databases
- Exam 70-465 – Designing Database Solutions for SQL Server 2012
If you have a MCTIP: Database Developer 2008 certification or MCTIP: Database Administrator 2008 certification on SQL Server 2008, you can upgrade to the MCSE: Data Platform by passing the following:
- Exam 70-457 – Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 Part 1
- Exam 70-458 – Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 Part 2
- Exam 70-459 – Transition your MCTIP to MCSE: Data Platform
To get the MCSE: Business Intelligence, you have to pass the following:
- Exam 70-461 – Querying Microsoft SQL Server 2012
- Exam 70-462 – Administering a Microsoft SQL Server 2012 Database
- Exam 70-463 – Implementing Data Warehouses with Microsoft SQL Server 2012
- Exam 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012
- Exam 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012
If you have a MCTIP: Business Intelligence 2008 certification on SQL Server 2008, you can upgrade to the MCSE: Business Intelligence by passing the following:
- Exam 70-457 – Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 Part 1
- Exam 70-458 – Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 Part 2
- Exam 70-460 – Transition your MCTIP: Business Intelligence 2008 to MCSE: Business Intelligence.
These exams should be released later this year.
This would be an excellent time to answer some questions I’m sure you have.
What about your MCTS and MCTIP certifications?
Well, you will still have those, but as time goes by they will retire.
If I get a new MCSA or new MCSE certification, will I have to recertify?
You betcha, brothers and sisters. The MCSA and MCSE certification will probably last only about 3 years before you have to recertify. What constitutes recertifying? You will have to pass a test or series of tests. The MCTS and MCTIP will become like a Cisco CCNA certification, the CompTIA A+, and other certifications where you will have to recertify every three years. Microsoft wants to keep the MCSE and MCSA certifications relevant. You can read more about this policy on Microsoft’s site.
If you’re still confused, I recommend these informative videos from the Born To Learn blog:
Microsoft Certified Trainers Explain MCSE
In my next blog post, I’ll go over the new “extended matching” item types being rolled out in Microsoft’s exams. Until then, keep you nose clean and your acronyms straight.
–George Monsalvatge
Cloud computing: coming to a certification test near you (part 2)
May 8, 2012 at 8:15 am | Posted in CompTIA | Leave a commentTags: cloud certification, cloud essentials, CompTIA
Way back in 2010, I started looking into all things cloud when I attended TechEd 2010 in New Orleans. Back then, I was trying to use my crystal ball to predict just what the cloud meant to us in the certification world. Fast forward to 2012, and we are starting to see the beginnings of the cloud certification offerings, as well as cloud-centric content added to existing certifications.
CompTIA announced its new Cloud Essentials specialty certification on December 13, 2011:
“As use of the cloud expands, the demand for IT workers with cloud computing knowledge grows as well,” Terry Erdle, executive vice president, skills certification, CompTIA, said. “CompTIA Cloud Essentials is designed to bolster the cloud computing credentials of the IT workforce.”
According to the CompTIA Cloud Essentials page, a test candidate will see 50 questions and have 60 minutes to complete the exam. Here is the objective breakdown for the Cloud Essentials exam:
- 1.0 Characteristics of Cloud Services From a Business Perspective - 15%
- 2.0 Cloud Computing and Business Value – 20%
- 3.0 Technical Perspective/Cloud Types – 20%
- 4.0 Steps to Successful Adoption of Cloud Computing - 15%
- 5.0 Impact and Changes of Cloud Computing on IT Service Management - 15%
- 6.0 Risks and Consequences of Cloud Computing - 15%
While there are no books currently on the market for this certification, there are general books available on cloud computing. McGraw-Hill will release CompTIA Cloud Essentials Certification Study Guide (Exam CL0-001) in November 2012, and I anticipate other study guides will follow.
While this is the only cloud-specific test currently in the CompTIA arena, many of their other, more popular offerings, including the Security+ and CompTIA Advanced Security Practitioner (CASP) exams, now require low-level understanding of cloud computing types and terminologies.
But don’t expect Cloud Essentials to be the last you will hear about the cloud from CompTIA. Word has it that there is more to come from CompTIA in cloud computing and mobile computing as these two areas become more vital in the global marketplace.
Are any of you considering this certification? If so, are you worried about the lack of resources available that are specifically written to this certification?
Drop us a line here at Transcender, and tell us what you think. We would love to hear from you!
Until next time….
-Robin
Cloud bound? Grab your two-for-one exam voucher from Microsoft today!
April 30, 2012 at 8:59 am | Posted in Certification Paths, Microsoft | 1 CommentTags: cloud certifications, mcse
Have you been racing toward your Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) certification, only to worry that it might be redundant by the time you arrive? If so, act fast to take advantage of a FREE exam offer from Microsoft that will help convert your certification to the equivalent MCSE certification when it’s released.
To benefit from this offer, you must purchase and take any exam from one of these four technology paths by June 30, 2012:
- Windows 7
- Windows Server 8 /Private Cloud
- SQL Server 2008
- Visual Studio 2010
Next, you must request a free exam voucher from Microsoft: https://www.bsf01.com/creatives/prometric/Microsoft_TwoForOne/TwoForOne_Home.aspx?WT.mc_id=Cloud_MSL_MCPFlash_Apr#
Once the MCSE-level exam in your technology path is released, you have 90 days to use the voucher and take the exam for free. You can request up to 5 vouchers (keeping in mind you will have to pass the 5 current exams before the end of June).
Here’s a comprehensive list of the exams that you can CURRENTLY take, and receive a voucher for the corresponding 2012 or Server 8 version:
Exam 70-680 : TS: Windows 7, Configuring
Exam 70-686 : PRO: Windows 7, Enterprise Desktop Administrator
Exam 70-685 : PRO: Windows 7, Enterprise Desktop Support Technician
Exam 70-640 : Windows Server 2008 Active Directory, Configuring
Exam 70-642 : Windows Server 2008 Network Infrastructure, Configuring
Exam 70-646 : Windows Server 2008, Server Administrator
Exam 70-647 : PRO: Windows Server 2008, Enterprise Administrator
Exam 70-643 : TS: Windows Server 2008 Applications Infrastructure, Configuring
Exam 70-659 : TS: Windows Server 2008 R2, Server Virtualization
Exam 70-432 : TS: Microsoft SQL Server 2008, Installation and Maintenance
Exam 70-433 : TS: Microsoft SQL Server 2008, Database Development
Exam 70-448 : TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-450 : PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
Exam 70-451 : PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Exam 70-452 : PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Exam 70-511 : TS: Windows Applications Development with Microsoft .NET Framework 4
Exam 70-513 : TS: Windows Communication Foundation Development with Microsoft .NET Framework 4
Exam 70-515 : TS: Web Applications Development with Microsoft .NET Framework 4
Exam 70-516 : TS: Accessing Data with Microsoft .NET Framework 4
Exam 70-518 : PRO: Designing and Developing Windows Applications Using Microsoft .NET Framework 4
Exam 70-519 : PRO: Designing and Developing Web Applications Using Microsoft .NET Framework 4
MERGE your application to improve performance
April 23, 2012 at 2:09 pm | Posted in Oracle, Technical Tips | Leave a commentTags: Oracle, tech tips
Hello, Oraclites. Have you taken a look at the new (well, relatively new) MERGE command that is now part of ANSI SQL? In many cases, incorporating the MERGE command into your application can replace writing a 10 to 20 line program in PL/SQL. And that will lead to significantly improved performance. This is definitely one of those cases where “less is more.”
How does MERGE work?
The MERGE command functions as either an INSERT command or an UPDATE command all in one, depending upon a condition that you specify. And just like INSERT and UPDATE, the new MERGE command is a DML command. If you totally hose your data trying out the new MERGE command, you can do a ROLLBACK. No harm, no foul.
Here’s an example that everyone can probably relate to. WIDGETS Incorporated has 10,000 active and inactive employees, and thus 10,000 rows in the emp table. The column status contains an I for inactive employees, and an A for active employees.
Here is the description of the emp table:
id NUMBER(5) PRIMARY KEY name VARCHAR2(20) NOT NULL dept VARCHAR2(10) NOT NULL salary NUMBER(10,2) hire_date DATE status CHAR(1)
There’s also a new_emp table created by HR and used nightly to update the emp table. HR assigns a new unique ID to new employees who have never worked for WIDGET before, but those who have are reassigned their previous ID. The number of rows in new_emp varies night by night, but averages around 20 rows. Usually one or two out of the 20 represents a rehire. The structure of the new_emp table is exactly the same as the emp table; only the data is different.
What HR wants to do, and the MERGE command allows them to accomplish, is to add the personnel data for a new hire who has never before worked for the company, and assign that employee a status of A (for active). In the same pass through the data, the command should update the emp table by locating inactive employees who have been rehired. When those records are found, the status should be changed from Inactive to Active, and the starting salary when this person is rehired should be updated in his or her row in the emp table. We’ll take care of updating the other columns later.
MERGE INTO emp E USING (SELECT id, name, dept, salary FROM new_emp) N ON (e.id = n.id) WHEN MATCHED THEN UPDATE SET E.dept = N.dept, E.salary = N.salary, E.hire_date = sysdate, E.status = ‘A’ WHEN NOT MATCHED THEN INSERT VALUES (N.id, N.name, N.dept, N.salary, SYSDATE, ‘A’);
This should solve their problem! The merge (either Inserts or Updates) are going to happen to the emp table. We are going to use the data returned by the SELECT to compare each returned row with each row in emp to determine if the values of id are equal. If they are, we’ll do the update in the “WHEN MATCHED” clause. If they aren’t equal, we’ll do the INSERT in the “WHEN NOT MATCHED” clause.
That’s pretty neat, and what’s really great is we don’t need to write a program to accomplish it. Furthermore, we can deal with all the rows in a single pass of the data.
If you like this, take a look at multitable INSERTS, another great feature for developers and DBAs.
–Bob the OrclTestGuy
Cloud computing: coming to a certification test near you (part 1)
April 16, 2012 at 1:21 pm | Posted in Vendor news | 2 CommentsTags: cloud certification
The latest overused buzzword in our industry is ”cloud”. Microsoft has a Cloud. HP has a Cloud. Amazon has one. Apple has one, but they call it the iCloud (how i-riginal?).
The fundamental purpose of the cloud is to provide on-demand data and services via your network connection instead of providing (or sourcing) it locally via physical hardware. The cloud service provider determines what types of resources are available to you based on your user account type, permissions, and fees. You may be a cloud end user that’s focused on data storage, a business cloud user focused on providing services and data storage to employees, or a cloud engineer who needs to know the infrastructure behind building and maintaining a cloud.
Major cloud players
Amazon Elastic Compute Cloud (Amazon EC2) allows you to launch instances on varieties of Linux or Windows operating systems loaded with your custom application environment for a specific fee structure. (In case you are wondering, it’s cheaper to use Linux than Windows in the EC2 cloud.)
Apple’s iCloud is your “magic hard drive”. It can store all your music, photos and other content from your PC, iPad, iPhone, iPod,or whatever iOS-based device you may have. Apple will keep all your email, contacts and calendars for all your devices without forced synchronization. According to Apple, they will store 20,000 of your songs for a year for only $25.00 so you don’t have to keep all those Widespread Panic or Black Crowes vinyl LPs in your basement. (Vinyl may sound a whole lot better than digital, but it’s tough to store without a cool dry place.)
Microsoft is not too interested in storing your vacation photos from Myrtle Beach or mp3s. Microsoft’s cloud strategy is to offer services like Exchange, Office, SharePoint, and Lync to integrate in a cloud environment. With Office 365, a user can have access to Office applications, like Word, Excel, and PowerPoint, that are not installed locally on the user’s PC, but are downloaded and licensed from the cloud. Exchange Online is a hosted messaging solution based on Microsoft Exchange. SharePoint online centrally stores and allows you to share documents and information with your colleagues and customers. Lync is the next generation of Office Communications Server, which provides an infrastructure for enterprise instant messaging, presence, file transfer, peer-to-peer and multiparty voice and video calling, web conferencing and PSTN connectivity.
VMware, of course, was practically in the cloud already with its virtualization solutions. Instead of focusing on the end consumer, VMware products are aimed at the IT cloud architect who manages cloud infrastructure, public cloud services, hybrid cloud services, and private cloud services for organizations.
Certifying that your head is in the cloud(s)
So far, major cloud certification plans have been announced by CompTIA, Microsoft, VMware, and various smaller players. Some heavyweights, like Cisco and VMware, have incorporated strong cloud-based skills into new and existing certifications.
Here’s a quick overview of certifications from major vendors. Look for more information in the coming months as tests are rolled out.
Cloud Part One: Microsoft
These new Microsoft Cloud services will require new skills. According to the IDC, over 33% of software purchases will be delivered through the cloud. To survive in this new world, you will need to have cloud skills. Microsoft’s Cloud Services: Training and Certification Overview page covers exams in four functional areas:
- Infrastructure management – MCSE Private Cloud
- Software development - Microsoft Exchange Server 2010, Microsoft SharePoint 2010, and Microsoft Lync Server 2010
- Database management – Azure Developer
- Services management - MCSE: Data Platform
If you are a developing or building cloud-based applications using Windows Azure, you can achieve your MCPD: Windows Azure Developer certification by passing three tests:
- Exam 70-513 TS: Windows Communication Foundation Development with Microsoft .NET Framework 4
- Exam 70-516 TS: Accessing Data with Microsoft .NET Framework 4
- Exam 70-583 PRO: Designing and Developing Windows Azure Applications
If you are prepping for the MCITP: SharePoint Administrator 2010 certification, it consists of the following tests:
- Exam 70-667 TS: Microsoft SharePoint 2010, Configuring
- Exam 70-668 PRO: Microsoft SharePoint 2010, Administrator
The 70-667 and 70-668 SharePoint exams are being updated to include cloud-related skills. As per Microsoft, 70-667 and 70-667 was updated to cover SharePoint 2010 SP1 and Office 365 as of January, 2012.
If you are prepping for any of the Exchange 2010 certifications that include exams 70-662 or 70-663, we expect those exams will be updated to include cloud-related skills.
The problem with adding cloud-related skills to an existing exam is that a lot of the exam prep materials listed on the Preparation Materials tab of the prep guide for these exams have not been updated to include cloud related skills. A lot of the Microsoft Press and third-party materials have not been updated either. If you are prepping for an exam that you know or suspect might be impacted by Microsoft’s Cloud Services make sure that you thoroughly research your topics. Do not rely solely on the materials that you received from a training class or the prep guide that you bought from your book retailer. Look at the Skills Measured tab on the prep guide for the exam and use the Internet to research the latest on the topics that are being covered on the exam. TechNet is a great resource for the latest info that may be on an exam. If you are not familiar with the Skills Measured tab of the prep guide for a particular exam, it’s a smart place to start! Here is where you find what the heck is on the test. The manual you got from the Microsoft Official Curriculum training class or the 700-page book you bought from Amazon may or may not include this information.
Look for an overview of cloud-focused certifications from VMware, Cisco, and CompTIA part 2 of this post. Until then, happy cloud computing!
–George Monsalvatge
Cisco CCNA Flash Card mobile app released for Android; A+ app updated for all platforms
April 10, 2012 at 3:42 pm | Posted in Transcender news | Leave a commentTags: ccna, mobile app
Following the success of the TranscenderFlash CompTIA A+ flash card app, we’ve rolled out our first Cisco CCNA flash card study app (640-822, ICND Part 1). For now the app is only available on the Android platform, but we’ll be rolling out an iTunes release next month.
Google Play : http://bit.ly/z2KA46
The app is 100% free of cost and free of ads. Here’s what you get:
- Hundreds of questions covering all exam objectives for 640-822 CISCO ICND Part 1
- Ability to sort flash cards by exam objective
- Simple and intuitive flash card interface
- Easy self-grading, answer history tracking, and session saving
- Correctly answered flash cards are removed to focus on trouble areas
- Post your success to Facebook
To those of you who tried out and commented on our A+ app: we listened! We have completely redesigned the A+ flash card interface, and used the new interface for the CCNA app. Now both apps let you select which objective you’d like to study, rather than taking you through the entire pool of questions starting with the first objective. If you have the old A+ app, upload the revision now. Here’s some screen caps to show you how both apps behave:
Download the app today, and let us know what you think!
Using Function-Based Indexes to Improve Oracle Performance
April 6, 2012 at 10:08 am | Posted in Oracle, Technical Tips | Leave a commentTags: function-based index, oracle tuning tips
There are a number of reasonably easy steps that database administrators and database developers can take to improve the performance of both an Oracle database and the applications that run against the database. Some of these steps would probably be considered the responsibility of the DBA; others would typically be handled by the application developer. Of course, there are a number of shops where the IT professional wears multiple hats, so I’ll just provide the tuning information and leave it to you to determine who in your shop might find this useful.
Function-Based Indexes
Let’s take a look at the world of indexes when it comes to speeding up data retrieval. Normally, it would be good practice to put an index on a column of a table when the following conditions are met:
- The table is relatively large.
- The column doesn’t have many nulls.
- The data in the column has good cardinality.
- There isn’t a lot of DML activity against that column going on in your database.
- Your application code often uses that column to search or sort.
- The indexed column isn’t typically involved in a mathematical expression or a function.
Take a look at this code:
SELECT student_id, major, class, advisor FROM students WHERE last_name = ‘Monsalvatge’
Assuming there are thousands of rows in the students table, and that there are very few rows where last_name is NULL, there are very few last names that are identical, last names don’t need to be updated often, and that our statement runs many times during the day, then according to the 6 rules above it would be a good idea to create a B-tree index on that column. (I wrote more about B-tree indexes in this post here.)
But now consider this situation. Suppose the way last names got entered into the table wasn’t very well controlled. Different users used different capitalization standards when they entered the last names. Some had the last name in all caps, some had it in mixed case, and others had it in all lowercase. If the last name stored in the database is ‘MONSALVATGE’ or ‘monsalvatge’ or ‘MonSalvatge’, it will not match the literal ‘Monsalvatge’ string in the SELECT statement, regardless of whether there is or isn’t an index on the last_name column.
But you’re a smart person, so you have a fix. You write your code like this:
SELECT student_id, major, class, advisor FROM students WHERE INITCAP(last_name) = ‘Monsalvatge’
Now the SELECT statement will find what it’s supposed to find regardless of how the capitalization of last_name is stored in the database. Good job!
That’s the good news, but there’s some bad news as well. Remember that index we built on the last_name column? It’s still there, but guess what? According to rules above, the column we have indexed (at least in this specific SELECT statement) is having the function INITCAP applied to the column before the WHERE clause comparison is made. When that happens, the optimizer is unable to use the index on that column. The same would be true is we performed any other manipulation or function to the last_name column.
Consider this SELECT:
SELECT student_id, major, class, advisor FROM students WHERE tuition > 5000
In this case, if the six conditions listed above are met, then you probably want an index on the tuition column. However, if there was B-tree index on the tuition column and your SELECT was written like this:
SELECT student_id, major, class, advisor FROM students WHERE tuition + 1 > 5000
then the optimizer would be unable to use that index because it has a mathematical expression on the index column (namely, add 1 dollar).
Interestingly enough, this SELECT statement is logically equivalent to the previous one:
SELECT student_id, major, class, advisor FROM students WHERE tuition > 5000 – 1
Recall from algebra class that adding 1 (one) to the left side of an equation or inequality is the same thing as subtracting 1 (one) from the right-hand side. Furthermore, the optimizer, when building the parse tree and execution plan, will be able to choose using that index on tuition, since the functions and/or mathematical work is on the other side of the equation/inequality.
So how do you solve this dilemma? If you don’t put in the function to adjust the capitalization on last name, then you won’t get all of the correct answers. That’s unacceptable! If you put the INITCAP function into your SQL statement, you will get all of the correct answers, but the performance will take a hit since the optimizer won’t be able to use the index you created on last_name.
To give you the best of both worlds, Oracle created function-based indexes. This is simply an index that is built, not on the column, but on the function or mathematical expression defined on the column. For example, to create an index on the INITCAP function applied to the last name column, you simply type the following:
CREATE INDEX my_func_indx_1 ON students(INITCAP(last_name))
And, if you want to create an index on the tuition column plus $1, you would simply type the following:
CREATE INDEX my_index ON students(tuition + 1)
You can even have more than one function-based index on the same column. For example, you might have one index on the INITCAP of last_name, and another on the UPPER of last_name.
Search your application code, and I’ll bet you that there are a number of places where these function-based indexes will speed up the performance of your queries.
Until next time,
–Bob the orcltestguy
IT Interview Tips
April 4, 2012 at 12:41 pm | Posted in Technical Tips, Transcender news | Leave a commentTags: interviewing tips, Motley Crue, resume', tattoos and piercings
A while back one of our team members ran across this LifeHacker post on IT job interviewing, provocatively titled Why I Won’t Hire You. The post stirred some spirited debate with the Transcender Team. Some of us thought it was refreshingly honest and contained valuable insights for a potential job candidate. One of us thought the author deserved a punch in the nose (metaphorically only — we’re not violent people, except where fantasy football/basketball is concerned).
Joking aside, we then sat around and discussed whether people need specific advice on interviewing for an IT job versus a non-IT job. Then we sat around and exchanged stories about people we’d actually interviewed for jobs who had made strange common-sense errors. Turns out we’ve seen it all kinds of quirks, from the classic typos-on-the-resume errors to showing up with their portfolio in a paper grocery sack.
Assuming you are qualified for the job you are applying for, you will have to go through a series of interviews. First there’s typically a screening, usually over the telephone but it can be in person where the employers will evaluate your overall fitness as a candidate. If you make it beyond the screening interview, you may go on to a series of interviews with the people in the department that will hire you — and that’s just the beginning. You might be called to dozens of interviews. Conclusion? That’s a lot of face time. So we feel there can *never* be enough tips out there to help an inexperienced (or experienced) job seeker ace an interview.
Here are some tips that might help you land the job.
If you are on time, I consider that you’re late. Arriving late does not leave a good impression. I recommend that you show up at the interview site at least 30 minutes prior to schedule. This will give you a few moments for last-minute prep for the interview. However, make sure that you check in for your interview no earlier than 10 minutes prior to the actual appointment time, because arriving too early could backfire if that person thinks you don’t value their time. So kill those extra 20 minutes in the parking lot or the reception area. While you’re there, take a sneak peak at the office environment and get a glimpse of the office culture.
It’s easy to win friends by talking about other people rather than yourself. However in an interview you need to sell yourself. Take some time before the interview and study the company that you are interviewing. Learn about the company, but don’t regurgitate the company’s website or annual report. If possible, try to learn as much about the department that will be interviewing you. You can set yourself apart from other interviewees if you can highlight your assets in relation to their specific needs. For example, if you know the company will be installing several SQL server instances and will need support, you should highlight your previous experience of managing, maintaining, backing up, and restoring databases on a SQL server. Remember, though, that the person conducting the screening interview may not be technical, so keep your experience to what is advertised in the job posting.
The days of people wearing Brooks Brothers suits and 100% cotton starched shirts may be gone. People tend to dress business casual in the workplace, and go even more casual in the IT world. To stand apart from the herd of candidates, you need to be neat and clean. You don’t have to look like you are ready to pick up your prom date at your parent’s house, but in a way, an interview is like a speed date. You need to make a good impression fast. Your date is not going to appreciate an unclean, unkempt person, or the person who over-dresses. I try to know what their office dress code is and aim to go one step above it.
In my role as a trainer I’m frequently asked about tattoos and piercings on a job candidate. I do not have a tattoo or piercing and not going to get any, but they don’t bother me. If the person can do the job and gets along with other team members, why should I care? But – and this is a big but – the person conducting the interview may not share your same view on tattoos and piercing. Many companies ask employees to keep tattoos covered in the workplace. For an interview, I recommend you cover the body art and remove piercings. An HR employee at a large company once told me, “Tattoos and piercings are not professional and we only hire professionals.” Does having a tattoo or a piercing mean that you cannot do the job? Of course not; that’s ridiculous. Do employers hire people based on looks? Well, a company cannot discriminate against you based on sex, religion, race, age or reproductive status, but they can certainly choose to not hire you based on looks. If you look like you fell into a tackle box or you have tattoos like a member of the band Motley Crue, expect the hiring company to hold that against you. It may not be fair, but it is legal.
You should expect to have some skills test, written test or combination of both in order to gain employment. I am from the school of thought that people do not intentionally lie on a resume, but they may stretch the truth. A prospective employer has the right to call you on your skills and experience. The information that you put down on a resume should be corroborated by someone else at your current job or previous job. Do not expect an employer to accept the fact that you can do a particular task because a person you work with and a person they have never met says that you can.
When I interviewed for a LAN administrator’s job, I was called back to perform a series of tasks within a 30 minute time frame in a lab the company had set up. That was the fastest 30 minutes of my life. The company wanted a highly skilled candidate that worked quickly. This was their way of weeding out candidates.
As I said before, people tend to stretch the truth on a resume, but you should not out-and-out lie. If you lie about certifications, degrees, or other items that can be checked, you will get busted. Expect to give the prospective employer a copy of your certification transcript or your certification ID number. For example, if you are certified in a Microsoft product, you will get a Microsoft Certified Professional (MCP) number which can be used by a prospective employer to check your Microsoft transcript. CompTIA, Oracle, and Cisco also issue IDs for their certified professionals. If it can be checked, do not lie about it. Even little lies will get you in trouble.
Another true story – a hiring manager had to choose between two candidates. One candidate, who was only was a casual jogger, said that he ran in the 2008 Boston Marathon and placed in his age group. The hiring manager looked this information up on the Internet and found it to not be true. That candidate did not get the job. The hiring manager said if he lied about running in the Boston Marathon, he could have lied about anything else.
Oh yeah – and pictures say a thousand words. Start vetting your social profiles — Twitter, Facebook, Google+, and so on – before you apply for jobs. Those pictures you have on Facebook may not paint a very favorable picture of yourself. Any modern employer will do a quick background check on you. Expect them to look at your Facebook page. Make sure there is nothing there that will cost you a job.
Another true story. Former Georgia Tech football coach George O’Leary was named head football coach at Notre Dame in 2001, but had to resign a few days later for resume’ padding. Although the padding was on his resume for over twenty years, he had never rechecked and updated the information. Although Coach O’ Leary has bounced back at University of Central Florida, winning conference titles, winning bowl games, and being a positive influence in the lives of young athletes, he may be remembered by some as the guy who once lost a job for resume padding — and that truly is a shame.
The demand for IT professionals is increasing. There are many challenging opportunities opening up. With a little preparation, you too can present yourself as the top notch candidate who will be hard to pass up.
CompTIA Advanced Security Practitioner (CASP): Our Experience and How It Will Help You
March 27, 2012 at 9:48 am | Posted in CompTIA, Performance-Based Testing | Leave a commentTags: casp, CompTIA, Performance-Based Testing
As many of you know, there is quite a bit of buzz over CompTIA’s Advanced Security Practitioner (CASP) exam. Last year, CompTIA launched the CASP exam as the next level in its security-related certification products. For years, IT professionals have looked to CompTIA to provide vendor-neutral certifications, the most popular of which are the A+, Network+, and Security+ certifications. But the CASP exam takes CompTIA’s offerings to the next level.
Last month, I finally had a chance to take the CASP exam. I knew going into the exam that I would see what CompTIA has called performance-based testing (PBT) items. Well, I wasn’t disappointed, as my first question on the exam was a PBT item. Overall, I thought these item types had the appropriate level of complexity and covered a wide-range of topics. So what did they look like? For the most part, they were drag-and-drop items that involved matching things up or placing items in the right location. There were others that required particular actions to be taken at a command prompt or at the server level. The only specifics I can share about these items, without violating the Non-Disclosure Agreement (NDA), is that PBT items take the WHAT from your usual multiple choice items and place the focus on the HOW or the WHERE.
For example, consider SubObjective 1.5 from the CASP Exam Guide: Distinguish among security controls for hosts. A bullet point in this SubObjective is Host hardening, which includes the Standard operating environment, Security/group policy implementation, Command shell restrictions, Warning banners, and Restricted interfaces. A possible PBT question that would fit into this SubObjective is a graphically presented task where you enable and configure the appropriate group policies for password length, password age, and password lockout.
In addition to the PBT items, the exam still includes the old stand-by multiple-choice questions. These, however, were a bit more expansive than the typical questions included in the A+, Network+, or Security+ exams. I often found myself reading and re-reading the options while trying to eliminate incorrect answers. I can remember thinking that this exam seemed much harder than the CISSP exam, not because of its length, but because of its depth. It takes those tidbits of security knowledge that all security professionals must know and expects you to APPLY them. For example, you not only need to know the different types of hacker attacks, you should know HOW to recognize the attacks which are occurring, WHAT tools to deploy to protect against those attacks, HOW to deploy them, and WHERE they should be deployed.
You can expect between 70-80 questions total, including the PBT questions. When I was done with the exam I was a little nervous, because truthfully, I felt it could have gone either way. I made an audible sigh of relief when I learned I had passed; to say that I was happy would be putting it mildly! I can’t give you my score, because CompTIA doesn’t give you one – this exam is just graded as PASS or FAIL. (But you know, maybe I didn’t really want to see that score anyway!)
So what can you do to prepare for the CASP? After you go over the exam objectives on the CompTIA Web site, I would start with CASP CompTIA Advanced Security Practitioner Study Guide by Michael Gregg and Billy Haines recently published by Sybex (an imprint of Wiley). Look for my comprehensive review of this guide in April. Next, take some time to research the day-to-day tasks of the security professional. I can assure you: if you don’t have any experience in security-related tasks, you should not take this exam until you have had some time to expose yourself to these tasks.
With that said, I can tell you that I am working diligently to create Transcender’s practice test for the CASP exam. And we will be including some interactive items that simulate what you will see in the live exam. My experience in taking this exam and working on our practice test so soon afterward can only help you, so keep an eye out for our announcement regarding our CASP practice test, which should come in May….and in the meantime, start prepping today!
-Robin
Blog at WordPress.com. | Theme: Customized Pool by Borja Fernandez.
Entries and comments feeds.







