Unlimited Plugins, WordPress themes, videos & courses! Unlimited asset downloads! From $16.50/m
Dismiss
  1. Code
  2. SQL
Code

SQL Essentials

by
Lessons:21Length:2.3 hours
SQLDatabases
Crs 40038
For full access to all 21 lessons, including source files, subscribe with Elements.
  • 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

1.Introduction
1 lesson, 01:23

Free Lesson
1.1
Introduction
01:23

2.Basic SQL Usage
5 lessons, 26:27

Free Lesson
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
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.
Unlimited Downloads
From $16.50/month
Get access to over one million creative assets on Envato Elements.
Over 9 Million Digital Assets
Everything you need for your next creative project.
Create Beautiful Logos, Designs
& Mockups in Seconds
Design like a professional without Photoshop.
Join the Community
Share ideas. Host meetups. Lead discussions. Collaborate.
Quick LinksExplore popular categories