Andrew BurgessOct 16, 2012Lessons: 21Length: 2.3 hours

Next lesson playing in 5 seconds

Overview
Transcript

2.3 Creating Tables

Now that we’ve created a database and told MySQL that we want to use it, we want to create a table. When creating a table, we need two things: a name for the table, and a definition of the columns of the table. At minimum, we need to tell the database the name of the column and datatype of the column.

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

2.3 Creating Tables

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