Posts Tagged ‘mysql’

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

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

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
- Serge has good knowledge and answers all the questions.
  - harsh
- Goal of training met , in terms of the course objectives set my course managers
  - CPT Peter Johnson, U.S.ARMY 53A ISM course
- Instructor very knowledgeable and amicable. Class materials well suited to stated goal.
  - Preston, Intel
- 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
- Instructor knew all details and explained everything with extreme patience
  - Kyocera
- Good interaction over online chat w/ the instructors and others, kept an otherwise potentially dreary online experience quite interesting.
  - Ganesh, EMC Corporation
- 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
- 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
- Guy Cole is both an expert Android instructor and a great entertainer. I thoroughly enjoyed this course!
  - Chris, Rockwell Collins
- 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
- Serge, Boris, thank you very much. Very good class!
  - EMC
- Like the teacher shared with us his experience and insights.
  - Echo, Disney
- It was just what I needed!
  - Brian, 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
- Good introduction to Android development with lots of practical examples. Instructor is knowledgeable and jovial.
  - Kyocera
- 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
- Instructor Guy Cole was excellent!
  - Intel
- The Apache Trainer was extremely knowledgeable and personable to make the experience worth the time, expense and effort.
  - Rick, GTech
- 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
- A lot of great examples! The instructor is an Android expert and skillful presenter.
  - Krystian, Roche Polska
- I learned a great deal in just a days' Networking Fundamentals Course. Boris, you made my day...
  - Artem, Microsoft Corporation
- Instructor is knowlegable and capable of answering questions w/o "parking" them.
  - EMC
- The instructor was very knowledgeable, also in the iOS area, what enabled me to get answers about platform differences and similarities.
  - Adam, Roche
- 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
- 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 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
- 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
- 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
- I enjoyed the exposure to Eclipse and exploring interactions within the Android environment.
  - Hollis, TCI
- 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 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
- Boris, you were just fantastic at delivering this course to us! Hope Italy treated you as well in return!
  - Paolo, Telecom Italia
- 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

Posts Tagged ‘mysql’

MySQL Replication

PHP & MySQL Best Practices for Rock-Solid Applications

Data Mining with MySQL – Finding Value in Numbers

Optimizing MySQL Queries

PHP Interview Questions and Tips

MySQL Caching Techniques

Don’t Miss Subscriber-only Content!