If you’re having trouble keeping track of your business, you may want to have a look at SQL Server 2000 For Developers Part 1. With this product, you can build databases that will help you keep track of, for example, your debtors or creditors.
You can perform any number of queries on your sales records. For example, you may want to know how many debtors you have in any one city or, you could pull out from your sales database all those debtors who owe you more than say, $10, 000.00.
Perhaps you have a website or an on-line catalogue that subscribers browse through before making purchases. With SQL Server 2000, you can organize all your data (for example, the names of subscribers, where they live, how much they owe, and so on) into a database that will allow you to retrieve this information efficiently whenever you might need it!
All this information and more could be at your finger tips with the help of SQL Server!
Today, we review LearnKey’s ‘SQL Server 2000 For Developers Part 1’ CD-ROM set, which comprises 3 sessions and a total of 9 hours of training. Mary Chipman and Andy Baron, Senior Consultants with MCW Technologies, a Microsoft Solution Provider, take you through the sessions, showing you how to create, manipulate, secure and maintain efficient databases.
For a quick overview of the topics covered in ‘SQL Server 2000 For Developers Part 1,’ click here.
For those of you who have never taken a course via CD, this may take some getting used to. It certainly took me a while to get comfortable with! You’ll probably want to take the course in a quiet area as it will require all your attention, especially if you are new to SQL (Structured Query Language). Also, you may find it a little strange listening to Mary and Andy explaining the material and not being able to interrupt and ask a question when, or if, you don’t quite understand something.
With my headphones on, I found it difficult to focus all my attention on my computer monitor, and to listen to the instructors’ explanations. In fact, the instructors’ monotones almost put me to sleep!
…So I removed my headphones and turned on the speakers. This did the trick for me! I felt more comfortable, and concentrating on what was being explained was much easier.
OK, so despite the monotone, once you get accustomed to the format, the CD-ROM set is actually a wonderful learning tool. You can pace yourself and backup to anything that you don’t quite understand or, anything that you might have missed because you got distracted when the phone rang.
The animated screen captures and graphics presentations are excellent as well. With these features not only do you get precise instructions, but you also get to see exactly what buttons you need to click when installing SQL Server, or when you’re creating databases and selecting or deleting items from your databases.
In the first CD, Mary gives you a brief introduction to SQL Server 2000 and shows you how to install and configure SQL Server. Andy Baron then talks about Relational Database Design, which is about organizing facts for efficient retrieval. He gives a detailed description of tables and how information is organized in each table. His definitions of relations, tuples, candidate keys, and so on are clear and easy to understand.
In the second CD, Andy shows you how to create a database on SQL Server 2000. He takes you through a step-by-step demonstration on how to enter values into tables, and how to set constraints on your data. Andy then explains how to create a relationship between 2 tables and furthermore, how to retrieve data from your database.
The third CD demonstrates how you can retrieve items from your database wherein the retrieved items are sorted or grouped according to specific criteria that you set when making your selections.
Andy also shows you how to do joins, where you retrieve data from multiple tables. Finally, he demonstrates how you can insert and delete data from existing tables by using SQL (Structured Query Language) statements.
All said and done, this CD pack is worth every penny! For beginners, you can learn SQL in just a matter of hours! I, for one, would have appreciated this product while taking the SQL database class back at school!
For the Single User, this CD Course (includes 3 CDs) costs $315.00. However, if you’re interested in purchasing the CD Course for Multiple Users, you would be looking at a cost of $785.00.
LearnKey is a provider of self-paced training solutions to enterprises worldwide. Its expert-led courseware is available in four different delivery platforms: Network, Online, CD-ROM, and Video so you can choose the best solution for your needs.
You can visit LearnKey by clicking here
murdok provides free highly informative newsletters for web developers, IT professionals and small business owners. We deliver 50 million email newsletters per month and have over 4,000,000 unique opt-in subscribers. From our extensive range of email newsletters we can provide you with a selection of newsletters that best meet your interests.
