Lessons:21Length:2.3 hours
- 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.Introduction1 lesson, 01:23
1 lesson, 01:23
Free Lesson 1.1Introduction01:23
Free Lesson
1.1
Introduction
01:23
2.Basic SQL Usage5 lessons, 26:27
5 lessons, 26:27
Free Lesson 2.1Setting Up Our Environment09:59
Free Lesson
2.1
Setting Up Our Environment
09:59
2.2Creating Database03:28
2.2
Creating Database
03:28
2.3Creating Tables03:44
2.3
Creating Tables
03:44
2.4Adding Data to the Database04:31
2.4
Adding Data to the Database
04:31
2.5Selecting Records04:45
2.5
Selecting Records
04:45
3.Intermediate SQL Concepts5 lessons, 30:18
5 lessons, 30:18
3.1Data Types08:46
3.1
Data Types
08:46
3.2Primary Keys07:05
3.2
Primary Keys
07:05
3.3Altering Tables07:12
3.3
Altering Tables
07:12
3.4Deleting Tables and Records02:24
3.4
Deleting Tables and Records
02:24
3.5Updating Records04:51
3.5
Updating Records
04:51
4.Selecting Records4 lessons, 34:55
4 lessons, 34:55
4.1Where Clauses08:57
4.1
Where Clauses
08:57
4.2Choosing a Number of Records04:15
4.2
Choosing a Number of Records
04:15
4.3Ordering and Grouping Records06:44
4.3
Ordering and Grouping Records
06:44
4.4Subqueries and Joins14:59
4.4
Subqueries and Joins
14:59
5.SQL Grab-Bag5 lessons, 42:41
5 lessons, 42:41
5.1Aliases06:07
5.1
Aliases
06:07
5.2Foreign Keys and Relationships07:35
5.2
Foreign Keys and Relationships
07:35
5.3SQL Functions08:46
5.3
SQL Functions
08:46
5.4MySQL and PHP11:02
5.4
MySQL and PHP
11:02
5.5GUIs09:11
5.5
GUIs
09:11
6.Conclusion1 lesson, 02:16
1 lesson, 02:16
6.1Conclusion02:16
6.1
Conclusion
02:16