28 Beginner’s Tutorials for Learning about MySQL Databases

Developing and programming with databases is a huge step onto a large plateau of information. Nobody starts out with MySQL and masters the software in a week. Not only do you need to learn setting up DBs and tables, but also the SQL language itself.

This rough road was very difficult to traverse maybe 5 or 10 years ago. But there is much more information online today which is generally very helpful. Thus I have scoured through Google and put together 28 of my personal favorite MySQL tutorials for newbies. You can learn all the basics of setting up a database and connecting into your own application. But additionally if you have any questions or comments on the gallery, feel free to share with us in the discussion below.

Pagination SQL Server vs MySQL

22 Photo Effect Photoshop Tutorials

In this post we have collected 22 creative photo effect photoshop tutorials. Enjoy! If you like these photo effect tutorials you might also want to check out our previous post below.

35 Amazing Photo Effect Photoshop Tutorials

Realistic Makeup Application in Photoshop

Code a Mobile-Friendly HTML5 Video Stream with Multiple Sources

New media on the Internet has gone through a rigorous process of quality control and best practices for web developers. Back just a few years ago Flash video was the most prominent solution. But with HTML5 support in all modern browsers the solution to embedding audio/video media has become a lot less complicated.

In this tutorial I want to explore how we can build a very simple webpage for embedding mobile-responsive HTML5 video. I have included two versions of the page – one with standard HTML5 video and the other using Video.js. The HTML is almost identical which shows how much progress HTML video has made in a few short years. But you can check out a demo of both pages from the links I’ve included below.

Preview Screen HTML5 Video Stream MP4/WebM

Dynamic TinyURL Links Generator using jQuery

There are so many web applications available for shortening URLs to share online. TinyURL is one of the originals and has been around longer than I can even remember. Their service is always online and it works perfectly for translating into tweets or posts on Facebook.

In this tutorial I want to build a mini-app which will generate tiny URLs right from your web browser. You could install this script on any domain and you’ll be able to generate dynamic links using Ajax without even refreshing the page! Their service doesn’t have a detailed API but it’s enough that we can pass a full URL and get the tiny version back as a result. And that’s just enough functionality for this app to hold some value when hosted on a 3rd party website.

TinyURL Links Generator with Ajax - preview

Build a User Settings Dropdown Menu with jQuery

There are many social networking websites designed with a specific layout in mind. User profile pages are some of the more complex designs included with a community-based network. You’ll often have access to edit user profile settings, subscriptions, and e-mail options. I want to create such a simple menu for a minimalist Digg-style layout.

In this tutorial I have actually built two working demo pages. The first runs on jQuery to fade the menu in and out as you hover. The 2nd demo is built using just CSS effects which display the submenu using the :hover selector. It’s even easier to combine both methods for legacy support – however at that point I’d recommend the CSS-only methodology. But you can see for yourself in the live demo examples and build this yourself by following my code below.

jQuery sub-menu navigation dropdown

Animating Colored Ajax Comments with jQuery

There are plenty of social networking websites today where you can find dynamic Ajax-based comments. This system is more usable because you don’t need to refresh the page every time you post something new. However setting up a whole database for user comments from scratch can be difficult.

In this tutorial I want to look at using jQuery just for animating custom comments. The form will submit each post anonymously and won’t save anything to a local database. The effects are only for show – but you can easily adopt the dynamic code into a system such as Wordpress, vBulletin, Joomla!, or even your own custom backend.


45 Useful 3DS Max Tutorials For Reference

3DS Max is widely used to produce cool 3D models or animations. 3DS Max is mainly used by visual effects artists, visualization specialists to design and game developers. Creativity with good texture and appropriate materials should be used to obtain a realistic effect. After obtaining a realistic effect, light effect should be placed in a natural position to witness proper effects. Multiple lights could also be used to enhance and stimulate the objects that surround the model. Thus, with appropriate approaches, you can achieve great 3DS Max models.

Nowadays, many 3DS Max tutorials are available for creating 3D models and visualization effects to allow artists and designers to rise faster for production. In this post I will share with you an overview of 3DS Max Tutorial that will surely inspire you. Have fun!

1. The making of rage over babylon

This tutorial will covers the major points of producing this image, starting with the planning and covering the modeling, texturing, rendering, lighting and compositing.


How to Code a jQuery Rolodex-Style Countdown Ticker

I’m sure many of you are familiar with how an office rolodex works. You have a series of cards with contact information which you can flip over to sort through alphabetically. These are most common in the office settings because businesses must to keep in touch with so many different people. Although the value is in translation into a web interface, we can still use this idea to create a really neat timer effect.

More specifically I have seen a couple countdown widgets on landing pages. These are numbering systems for websites which count down to a specific launch date. You could alternatively use this code to create a live clock on your website – there are so many uses available! Check out my simple tutorial below and see if you can implement a similar ticker into any future web projects.

jQuery Rolodex count down timer ticker - demo screenshot