Andrew BurgessOct 16, 2012

FREELessons: 21Length: 2.3 hours

Next lesson playing in 5 seconds

Overview
Transcript

4.3 Ordering and Grouping Records

So for, every set of records that we’ve pulled via a query has been given to us in the order that they stored in the database. Again, we could depend on a different programming language to organize things, but there’s no reason to do that, because SQL gives us the ability to order results.

1.Introduction
1 lesson, 01:23

1.1
Introduction
01:23

2.Basic SQL Usage
5 lessons, 26:27

2.1
Setting Up Our Environment
09:59

2.2
Creating Database
03:28

2.3
Creating Tables
03:44

2.4
Adding Data to the Database
04:31

2.5
Selecting Records
04:45

3.Intermediate SQL Concepts
5 lessons, 30:18

3.1
Data Types
08:46

3.2
Primary Keys
07:05

3.3
Altering Tables
07:12

3.4
Deleting Tables and Records
02:24

3.5
Updating Records
04:51

4.Selecting Records
4 lessons, 34:55

4.1
Where Clauses
08:57

4.2
Choosing a Number of Records
04:15

4.3
Ordering and Grouping Records
06:44

4.4
Subqueries and Joins
14:59

5.SQL Grab-Bag
5 lessons, 42:41

5.1
Aliases
06:07

5.2
Foreign Keys and Relationships
07:35

5.3
SQL Functions
08:46

5.4
MySQL and PHP
11:02

5.5
GUIs
09:11

6.Conclusion
1 lesson, 02:16

6.1
Conclusion
02:16

Andrew Burgess

Hi! I'm Andrew Burgess, and I'm a connoisseur of all things programming. I'm from near Toronto, Canada, and I've been fooling around with computers for nearly my whole life, both hardware and software. Right now, I'm finishing up a computer science degree. For almost a decade now, I've been playing around with over a dozen programming languages on several different platforms, from JavaScript to Java, from Ruby to Befunge. My favourite has always been JavaScript. I've always enjoyed writing, so when I discovered Tuts+ in 2009, I was excited to start writing tutorials. Since then, I've been writing tutorials and producing screencasts for Tuts+. Right now, I'm a course instructor and I produce mostly JavaScript-related courses. Maybe you've seen Building a Web App from Scratch with Angular.js or Node.js from Scratch; that's me! I've also written a few ebooks, like Getting Good with Git, Getting Good with JavaScript, and, more recently, Backbone.js Blueprints.

andrew8088

SQL Essentials

Next lesson playing in 5 seconds

4.3 Ordering and Grouping Records

1.Introduction1 lesson, 01:23

2.Basic SQL Usage5 lessons, 26:27

3.Intermediate SQL Concepts5 lessons, 30:18

4.Selecting Records4 lessons, 34:55

5.SQL Grab-Bag5 lessons, 42:41

6.Conclusion1 lesson, 02:16