Hostingheaderbarlogoj
Join InMotion Hosting for $3.49/mo & get a year on Tuts+ FREE (worth $180). Start today.

SQL Essentials

with

In this course, Andrew Burgess will teach you the essentials of querying databases, using SQL.

1× speed

Free Preview: SQL Essentials

Introduction

01:23

1.Introduction
1 lesson, 01:23

Free Preview
1.1
Introduction
01:23

2.Basic SQL Usage
5 lessons, 26:27

Free Preview
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


Preview for SQL Essentials
Lessons:
21
Length:
2.3 hours
Categories:
Hi! I'm Andrew Burgess, a Staff Writer here on Tuts+. I've been hanging around the Tuts+ since early 2009; I discovered the site when I was looking for an introduction to jQuery. Since discovering the site, my web development skills have skyrocketed; I think that's the default experience! Now, I've been writing for Tuts+ regularly since late 2009. I've been working with the computers since I was pretty young, and with the web since 2006. I've dabbled with over a dozen programming languages, but I'm most comfortable in JavaScript and Ruby. Currently, I'm a university student, studying computer science.
+ Expand Bio- Collapse Bio