Hostingheaderbarlogoj
Join InMotion Hosting for $3.49/mo & get a year on Tuts+ FREE (worth $180). Start today.
Advertisement

Databases

  • Databases
    Getting Started with MongoDB - Part 1Preview
    268 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
    59 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…
  • Databases
    Quick Tip: A Fast Overview of Querious (MySQL Manager)200x200
    In today's video quick tip, we'll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works -- without being too complicated or overwhelming in the way that PHPMyAdmin might be for some. Read More…
  • Databases
    Introduction to MySQL Triggers200x200
    6 shares
    Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They're one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.Read More…
  • Databases
    Visual Database Creation with MySQL WorkbenchWorkbenchstart
    44 shares
    In today's tutorial, you'll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we'll review how to use MySQL Workbench, a cross-platform, visual database design tool.Read More…
  • Databases
    SQL for Beginners: Part 3 - Database RelationshipsPreview
    31 shares
    Today, we continue our journey into the world of SQL and relational database systems. In this part three of the series, we'll learn how to work with multiple tables that have relationships with each other. First, we will go over some core concepts, and then will begin working with JOIN queries in SQL.Read More…
  • Databases
    SQL for Beginners Part 2Preview
    6 shares
    It is important for every web developer to be familiar with database interactions. In part two of the series, we will continue exploring the SQL language and apply what we've learned on a MySQL database. We will learn about Indexes, Data Types and more complex query structures.Read More…
Advertisement
Advertisement