Video icon 64
Learning to code? Skill up faster with our practical video courses. Start your free trial 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