Advertisement

Databases

  • Web Development
    Node.js for BeginnersPreview
    272 shares
    Event-driven programming can be overwhelming for beginners, which can make Node.js difficult to get started with. But don't let that discourage you; In this article, I will teach you some of the basics of Node.js and explain why it has become so popular.Read More…
  • Web Development
    Building Web Applications from Scratch with LaravelMain image
    152 shares
    In this Nettuts+ mini-series, we'll build a web application from scratch, while diving into a great new PHP framework that's rapidly picking up steam, called Laravel — a simple and elegant PHP 5.3 framework. First up, we'll learn more about Laravel, and why it's such a great choice for your next PHP-based web application.Read More…
  • PHP
    PHP Database Access: Are You Doing It Correctly?Php pdo
    197 shares
    We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This article will fix that! To put it plainly, if you're still using PHP's old mysql API to connect to your databases, read on!Read More…
  • PHP
    Why you Should be using PHP's PDO for Database AccessPdo
    305 shares
    Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. As of PHP 5.1, there's a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!Read More…
  • Databases
    Getting Started with MongoDB - Part 2Preview
    40 shares
    Ready to continue learning about MongoDB, one of the coolest technologies for web developers? In this second part of the series, we move on from the basics, on to advanced queries - with conditional operators - and MapReduce.Read More…
  • Databases
    Getting Started with MongoDB - Part 1Preview
    267 shares
    Ready to get in and start learning about MongoDB, one of the coolest technologies for web developers? In this new series, you'll go from beginner to pro and be able to use Mongo just as easily as MySQL in your web apps. But first, let's look at the basics.Read More…
  • Databases
    An Introduction to Stored Procedures in MySQL 5200x200
    58 shares
    MySQL 5 introduced a plethora of new features - stored procedures being one of the most significant. In this tutorial, we will focus on what they are, and how they can make your life easier.Read More…
  • Databases
    Quick Tip: Working With MySQL and SUMCode
    In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also provide a performance improvement.Read More…
  • Databases
    A Deeper Look at Advanced Select QueriesCode
    2 shares
    To the SQL novice, joins can be intimidating and somewhat frustrating. Even when you think you have the query nailed, along comes an unexpected result which make you throw up your arms in surrender to the SQL gods.Read More…
  • Databases
    Quick Tip: Working with MySQL and INNER JOINCode
    2 shares
    In today’s video quick tip, we’ll go over why and when to use JOINs when working with your databases.Read More…
  • Databases
    An Introduction to MySQL 5: Views200x200
    9 shares
    The MySQL 5 series introduced quite a few changes. Triggers and stored procedures were two of the big ticket items. One of the lesser known additions, at least from the amount of writing on the subject, is the introduction of views. While after a quick look at MySQL views, you might not see the obvious advantages, they're there if you dig into them just a bit.Read More…
  • Databases
    Profiling MySQL Queries with phpMyAdminCode
    I have used phpMyAdmin for over a decade. In my early years with the tool, I simply needed something that could show me table structure and quickly give me the data inside. As my needs have grown, so have the tools included with phpMyAdmin which keeps me coming back as my primary MySQL tool, even with optimization.Read More…
Advertisement
Suggested Tuts+ Course
Getting Started With Sequel$15
Advertisement