Archive for the ‘databases’ category

MySQL Replication

August 19th, 2011 Michael DorfLeave a comment

You’ve finally done it: your MySQL database has gotten so large that it simply isn’t working on one machine anymore. You’ve tweaked it, you’ve optimized it, you’ve gotten it to the point where your system simply can’t read fast enough to accommodate the number of reads. Is it time to move to a NoSQL solution? Possibly, but even then, you’ll need a temporary solution to keep your site running smoothly during the transition phase! It’s time to add more MySQL servers to help handle the load. It’s time to use Replication! Replication is a great way to increase the amount of… View full post »

No comments »

Categories: mysql

Tags: mysql

PHP & MySQL Best Practices for Rock-Solid Applications

March 11th, 2011 Michael DorfLeave a comment 1 comment

PHP and MySQL are often the preferred technologies for building web applications because they allow you to build robust web applications very rapidly. This rapid development, however, sometimes leads to code that is hard to maintain, doesn’t scale well or performs poorly. Fortunately, there are a few things that you can do early in your application development cycle that will keep your application from developing problems. Follow these PHP/MySQL best practices to build rock-solid applications. Also, keep in mind in general that a bit of extra time invested upfront in keeping your code easily maintainable will save… View full post »

1 comment »

Categories: mysql, php

Tags: best practices, mysql, php, php framework, php frameworks, scalable web applications, web development

PostgreSQL 9.0 Offers Many New Features

December 10th, 2010 Michael DorfLeave a comment

I’ve always loved PostgreSQL. It is my database of choice these days and I use it with both CakePHP and with the Django framework for Python. PostgreSQL has always had a very robust feature set and was one of the first truly ACID compliant open source databases. With the recent release of version 9, PostgreSQL has added a slew of requested features that truly put it above the rest. The biggest new feature in Postgres 9.0 is streaming replication. As many have noted, third party solutions for this have existed for some time but now there is… View full post »

No comments »

Categories: postgresql

Tags: database, postgresql

Data Mining with MySQL – Finding Value in Numbers

July 24th, 2010 Michael DorfLeave a comment 1 comment

When it comes to full scale database analysis, many servers have integrated software packages such as SSIS for Microsoft and dedicated business intelligence tools from SAP, SAS and other forms. Analyzing data with open source technology however requires a bit more work when it comes to implementing an end to end Business Intelligence (BI) tool. While there are a variety of ways to export MySQL data into software packages that can handle modeling, it is important to understand how the process works and the technology required. How MySQL can work with PMML Working with broad patterns and intuition on raw database technology… View full post »

1 comment »

Categories: data mining, mysql

Tags: data mining, mysql

Optimizing MySQL Queries

May 28th, 2010 Michael DorfLeave a comment

MySQL is a very capable database server. It powers numerous web sites and applications and is so widely used that it was etched as the “M” in LAMP platform. One of the reasons MySQL has become so popular is that it can be extremely fast, particularly in cases where data is primarily being read such as web sites. Even with all its strengths, it is possible for a developer to right a bad query that slows down the database or for the volume of data to reach a point where a normally speedy query becomes quite slow…. View full post »

No comments »

Categories: databases, mysql, sql

Tags: mysql, sql

PHP Interview Questions and Tips

April 24th, 2010 Michael DorfLeave a comment 3 comments

So you’ve been slinging resumes for a while and now you have an interview for an awesome PHP job. While part of the interview will be the typical job interview, you should also be prepared for a technical interview. Technical interviews are often given to determine how well you truly know the technologies with which you’ll be working. There are numerous books and articles to help you prepare for the job interview portion but very little has been said on preparing for a PHP technical interview. General PHP Questions The first type of questions you’ll be asking in a… View full post »

3 comments »

Categories: mysql, php

Tags: mysql, php, php and mysql

MySQL Caching Techniques

April 5th, 2010 Michael DorfLeave a comment

MySQL is an incredibly powerful and robust database which is why it powers so many web sites and web applications today. However, even the best database often needs additional help to keep up with the high volume demands of popular sites or web applications. MySQL is no exception. One way that many developers squeeze additional performance from MySQL is through caching in order to reduce the number of queries hitting the database. There are a number of techniques for caching MySQL queries. Cache Types File-based Cache The simplest system for MySQL caching is a file based system. In… View full post »

No comments »

Categories: mysql

Tags: caching, mysql

Secure Your Database

March 12th, 2010 Michael DorfLeave a comment

What must one do to protect the company’s biggest asset – its data? That’s a frequently asked question today that has no right or wrong answer! The solution is based on a number of different variables, such as, what is your database vendor, what is the purpose of your database, does your database store credit card information, who manages your database, and others. Obviously, there is no single approach to securing your database. However, these are the general best practices utilized in he industry to protect a database system. Stay Up-to-date Be proactive in staying up-to-date on all current vulnerabilities related to the… View full post »

No comments »

Categories: databases

Tags: database vulnerabilities, protect database, secure database

Understanding Database Vulnerabilities

March 11th, 2010 Michael DorfLeave a comment

Database is one of the most integral components of any system, and keeping data both secure and accessible is a demanding task every business is facing today. One of the more recent trends in enterprise security has been the movement away from protecting the perimeter of the network to protecting data at its source. Today’s corporate environment must provide access to data not only to its employees, but also to partners and customers located on separate networks, potentially thousands of miles away. In order to protect the database system, one must first understand its vulnerabilities. In general, database… View full post »

No comments »

Categories: databases

Tags: database security, sql, vulnerabilities

Upcoming Training
Feb 06-07 Tomcat Administration
Feb 13-15 PHP, JavaScript, Ajax and jQuery
Feb 27-29 Web Development with PHP/MySQL
Feb 28-29 Networking Fundamentals
Mar 09 Cloud Computing Introduction
- Classroom - Online - Webinar - Confirmed!
Don’t Miss Subscriber-only Content!
Join our newsletter to get exclusive tutorials, latest posts, free courses, and much more!

Name:
Email:

We respect your email privacy
Recent Client Testimonials
- The Apache Trainer was extremely knowledgeable and personable to make the experience worth the time, expense and effort.
  - Rick, GTech
- It was just what I needed!
  - Brian, EMC
- I enjoyed the exposure to Eclipse and exploring interactions within the Android environment.
  - Hollis, TCI
- This course was excellent! Guy Cole was able to create a great learning environment. He is technical, eloquent, and funny all at the same time. I'd take this course again any time!
  - Regina, IBM
- I learned a great deal in just a days' Networking Fundamentals Course. Boris, you made my day...
  - Artem, Microsoft Corporation
- I come from a Java background, and Android seems natural for me to pick up. Guy made the transition from Java to Android very easy. He is a very good teacher. I enjoyed this training.
  - Leonid
- The instructor was very knowledgeable, also in the iOS area, what enabled me to get answers about platform differences and similarities.
  - Adam, Roche
- Instructor Guy Cole was excellent!
  - Intel
- I liked the interactive approach the Guy used during chapter demos and sample app. We all shared our products and learned from each others' blunders. ;-)
  - Derek, Verizon
- Like the teacher shared with us his experience and insights.
  - Echo, Disney
- Good introduction to Android development with lots of practical examples. Instructor is knowledgeable and jovial.
  - Kyocera
- This course could easily have taken longer than two days, but Boris did an awesome job breaking it down into a shorter course. He explains and demonstrates extremely well!
  - Gregory, LSI
- Boris, you were just fantastic at delivering this course to us! Hope Italy treated you as well in return!
  - Paolo, Telecom Italia
- Android Application Development class is cutting edge. It covers best of both worlds - the basics and advanced SDK functions. The project is very relevant to the course.
  - Josh, Stanford University
- Good practical android course. Lots of material but if you pay attention in class you will get your money's worth. Instructor knows his stuff.
  - Gene, Verizon
- Serge has good knowledge and answers all the questions.
  - harsh
- Guy Cole is both an expert Android instructor and a great entertainer. I thoroughly enjoyed this course!
  - Chris, Rockwell Collins
- Guy is a great "guy", and did an excellent job presenting the material and ensuring people "got" it. I looked at bootcamps provided by a number of organizations, and this one was the most thorough, and had the least fluff. I don't think I've ever been as pleased with a course.
  - Winston
- Instructor was knowledgeable, systematic and responsive to questions. I have enjoyed the course and have learned a lot about Hadoop. GoToMeeting is an effective medium for presentations and was used very well for communication and resolving problems.
  - Lubomir, EMC
- The Android Application Development course was very well delivered and left me with a wealth of real code I can use at work.
  - Vlad, Wells Fargo
- Serge, Boris, thank you very much. Very good class!
  - EMC
- Serge was willing and able to jump off the scheduled presentation and answer specific questions relevant to our organization, which really helped answer some important questions we had.
  - Bill, 4Info
- This was an intense 3-day course. The great part though is you don't need to remember everything. As long as you complete the class project, you will learn many valuable lessons. I highly recommend this course!
  - Pradeep, US Government
- Instructor is knowlegable and capable of answering questions w/o "parking" them.
  - EMC
- Good interaction over online chat w/ the instructors and others, kept an otherwise potentially dreary online experience quite interesting.
  - Ganesh, EMC Corporation
- Goal of training met , in terms of the course objectives set my course managers
  - CPT Peter Johnson, U.S.ARMY 53A ISM course
- A lot of great examples! The instructor is an Android expert and skillful presenter.
  - Krystian, Roche Polska
- Guy is a knowledgeable instructor and skillful presenter. He made this course really come together with exercises and practical project. I hope he teaches other courses!!!
  - Andrew, Kyocera
- The Android App Development class was very effective for me. In just two days, I learned enough material to get me started on my own. Instructor and facility were both top notch!
  - Shekhar, MIPS Technologies
- I am an experienced OOP programmer/developer, and I believe that the programming examples were extremely relevant. Mr. Cole put in much effort and ensured that the programming templates were relevant and workeable.
  - MAJ Jarrod, Fort Gordon School of Information Technology
- Instructor knew all details and explained everything with extreme patience
  - Kyocera
- Instructor very knowledgeable and amicable. Class materials well suited to stated goal.
  - Preston, Intel
- I really liked the exercises where we were asked to do some coding and assignments. Also the last day hands on lab was really good and enjoyed it throughly!
  - Intel

Recent Articles
agile ajax android apache apple blueprint book reviews cakephp cisco cloud computing databases data mining drupal google google adwords google analytics hadoop html5 iphone java jquery lamp microsoft mysql netapp networking open-source owasp php php 5 postgresql python ruby on rails security seo software development sql uncategorized virtualization web development web hosting

	Android Training		Apache Training
	Agile Training		Cloud Computing
	Drupal Training		Hadoop Training
	HTML5 Training		Java Training
	Linux Training		Network Training
	PHP Training		Tomcat Training
	Security Training		Virtualization

Your Information Technology Trainers

Archive for the ‘databases’ category

Don’t Miss Subscriber-only Content!