Lessons:21Length:2.3 hours
- Overview
- Transcript
5.5 GUIs
If you’re not comfortable on the command line (or even if you are), there are several graphical user interfaces that you might want to check out.
Resources- Sequel Pro (Mac)
- Querious (Mac)
- SQLyog (Mac/Windows)
- Navicat (Mac/Windows)
- Adminer (PHP script)
- PHPMyAdmin (PHP script built into MAMP / WAMP)
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