In the early 21st century, Databases play a key part in all our lives. You may not be aware of a lot of it, yet many of the actions you perform each day are recorded, filed & stored in a number of ways. Our complete economic system is based on Databases of information. Details like share values, bank-documentation & property-information are all indexed upon complex Databases, & although clearly we can still access much of this information in hard copy, electronic records are definitely more straightforward to gain access to. Your purchase history is recorded onto a database each and every time you make a payment electronically (that is by card). Your purchasing patterns are recorded so that retailers can send you loyalty vouchers for products you are likely to be buying - for example, if you've been purchasing cat food, you might be given a special price for pet insurance. A big Database is owned and operated by the DVLA - it includes every auto registration number which can then bring up the details of the make and precise model of the automobile in question. London's Congestion Charging system, and the Govt's Road Tax avoidance-scheme also key off this data, by working with the street cameras that we find almost everywhere.

With databases holding such a major role in society today, exactly what type of work can be found that relates to them? When we take the work of IT specialists, there are two key Database sectors - The 1st calls for the design and building of the software that Databases operate on, and the 2nd entails the management work required to apply the data stored on them. The Administrator (management) position is much more popular - in industry a 'Database Administrator' is more often referred to as a 'DBA'. A 'DBA' will typically be employed by a mid-size or bigger organisation, and take care of the day by day procedures of a certain database. Functions like 'security' and the backing-up of the data require managing. 'DBA's' also have to create reports for management to permit them to come to educated business decisions. They need to have gained a commercial understanding of 'SQL' - the most commonly used Database 'language'. Interrogating databases to acquire facts is standardised with 'SQL' (Structured Query Language).

Internationally, the most commonly used database-systems are Oracle and MS SQL-Server. A number of substantial installations still use the more mature 'Oracle' System, but SQL-Server is currently the favourite System in most commercial settings, & where web-based databases go it rules the roost. Since Microsoft own their SQL-Server technology, its been easily integrated into all of their platforms and programming languages, making it an easy preference for those aiming to obtain qualification & business recognition. The 'MCITP' ('Microsoft Certified IT Professional') & 'MCTS' ('Microsoft Certified Technology Specialist') programs have now replaced the older MCDBA (Microsoft Certified Database Administrator) certifications. SQL Server '08 is beginning to gain some momentum, but it really is not widely used in the commercial world just yet. For that reason, the MCITP DBA accreditation features the more popular SQL Server 2005. To achieve the complete MCITP qualification, a number of 'MCTS' modules need to be done first.

Those who make very good database professionals are almost always especially orderly, systematic & logical. They are able to work well by themselves, or as a member of a small team, and demonstrate remarkable consideration for details. Very good communication-skills are an advantage, because there'll be regular inter-action with senior managers. Database management is a very responsible job, as security demands increasingly more vigilance within this field of work. A very high standard of personal ethic & commercial dependability will undoubtedly be called for - and in a number of areas you could possibly need some sort of security-clearance. Many people who have previously been employed in business processing or accountancy normally prosper in Database Management. A number of 'DBA's' gain promotions to higher office since they inherently build their business management skill sets.

For anyone who's interested in the 'development' side, then Microsoft provide the MCITP DB Developer program. Whilst not completely extending in to database programming, this covers more to do with the preliminary rationale & set-up of databases. You might want to have a look at the Programming part of this site if you're interested in this side of Databases. All in all, you will find there's a far greater emphasis with students & employers alike on the administration of Databases. Nevertheless, if for example the Developer track is for you, it would be sensible to include the 'MCITP' DB-Developer into a broader programming training-track. As each year proceeds on, you might want to additionally think of taking the 'MCTS' qualification in 'SQL' Server 2008.

If you are beginning in the business, it could be a good idea to preface your database course with software-support training. This will equip you with some lower-level accreditations, that will help you get your first foot on the ladder, plus offer you an understanding of a different invaluable side of the business. An outstanding package for a newcomer is the MCDST ('Microsoft Certified Desktop Support Technician'). The entire vocational training-path of 'MCDST', MCTS & MCITP could be achieved in roughly one year if you are studying part-time outside of employment. However, of course, we urge caution before making any selections in isolation. Get help and advice from an industry expert to feel confident that you're entering the best training program for your needs, in terms of learning style & career choice. If you do not concentrate primarily on exactly where you want to end up, you may find yourself miles off track & thousands of pounds worse-off!

SQL Server CBT Multimedia Home-Based Courses >>