Browsing Tag

sql

Sort by

Nettuts+ Quiz #11: Do You Know SQL?

Nettuts+ Quiz #11: Do You Know SQL?

on Mar 17th 2012 with 82 comments

In 2012, we plan to take our quizzes to a whole new level with ones aimed at all languages and catering to all competencies and tastes. This month, we’re covering a little SQL.

With more frameworks being bundled with an ORM, SQL is quickly becoming a lost art and is mostly relegated to the nerdiest of our clan — those pesky database people. Why not take today’s quiz and see whether you DB-chops have really gone the way of the dodo?

(Continue)


This entry is part 11 of 11 in the The Official Nettuts+ Quizzes Session
Quick Tip: Working with MySQL and SUM
videos

Quick Tip: Working with MySQL and SUM

on Aug 31st 2010 with 36 comments

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.

(Continue)

A Deeper Look at Advanced Select Queries: New Premium Tutorial
plus

A Deeper Look at Advanced Select Queries: New Premium Tutorial

on Jul 22nd 2010 with 7 comments

To a 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. In this tutorial, we are going to build upon the excellent quick tip of working with MySQL and INNER JOIN recently posted and crack open the real power of a SELECT statement. Become a Premium member to access this tutorial, and all of the other fantastic articles and screencasts across all of the Tuts sites.

(Continue)

Quick Tip: Working with MySQL and INNER JOIN
videos

Quick Tip: Working with MySQL and INNER JOIN

on Jul 5th 2010 with 60 comments

In today’s video quick tip, we’ll go over when and why to use JOINs when working with your databases.

(Continue)

An Introduction to MySQL 5: Views

An Introduction to MySQL 5: Views

on Jul 2nd 2010 with 26 comments

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.

(Continue)

Quick Tip: “Popular Posts By Comment Count” SQL Query in WordPress
videos

Quick Tip: “Popular Posts By Comment Count” SQL Query in WordPress

on May 2nd 2010 with 50 comments

You might have noticed that the Tuts+ sites have a section on the home page where we list the most popular posts of the month, according to comment count. While there are numerous plugins available, it’s always best to write the code yourself if you can. Too much abstraction is never a good thing! Luckily, once we learn how to query WordPress’ database, tasks like this become a cinch!

(Continue)

Visual Database Creation with MySQL Workbench

Visual Database Creation with MySQL Workbench

on Apr 14th 2010 with 84 comments

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.

(Continue)

SQL for Beginners Part 3: Database Relationships

SQL for Beginners: Part 3 – Database Relationships

on Jan 13th 2010 with 71 comments

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.

(Continue)

preview

SQL for Beginners Part 2

on Dec 22nd 2009 with 53 comments

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.

(Continue)

SQL for Beginners
basix

SQL for Beginners

on Dec 16th 2009 with 104 comments

Most modern web applications today interact with databases, usually with a language called SQL. Lucky for us, this language is quite easy to learn. In this article, we are going to start with some basic SQL queries and use them to interact with a MySQL database.

(Continue)

Page 1 of 212