Andrew BurgessOct 15, 2013Lessons: 16Length: 1.5 hours

Next lesson playing in 5 seconds

Overview
Transcript

4.4 A Practical Look at SQLite: Part 1

All this theory is great, but let’s do some practical work. In this screencast, we create a table, a view and perform all four CRUD operations.

References

SQLite download

1.Introduction
1 lesson, 01:31

2.History and Terms
3 lessons, 17:06

2.1
A History Mini-Lesson
04:09

2.2
Codd's Twelve Commandments
08:21

3.Relational Components
5 lessons, 38:40

3.3
Foreign Keys and Relationships
07:46

4.Database Usage
6 lessons, 29:50

4.2
Database Servers and Users
03:08

4.3
Designing a Data Model
04:55

4.4
A Practical Look at SQLite: Part 1
07:13

4.5
A Practical Look at SQLite: Part 2
06:44

4.6
Other Database Models
01:41

5.Conclusion
1 lesson, 00:18

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

Relational Databases

Next lesson playing in 5 seconds

4.4 A Practical Look at SQLite: Part 1

1.Introduction
1 lesson, 01:31

1.1
Introduction
01:31

2.History and Terms
3 lessons, 17:06

2.1
A History Mini-Lesson
04:09

2.2
Codd's Twelve Commandments
08:21

2.3
Terminology
04:36

3.Relational Components
5 lessons, 38:40

3.1
Data Types
08:07

3.2
Primary Keys
07:36

3.3
Foreign Keys and Relationships
07:46

3.4
Normalization
07:31

3.5
Queries
07:40

4.Database Usage
6 lessons, 29:50

4.1
Views
06:09

4.2
Database Servers and Users
03:08

4.3
Designing a Data Model
04:55

4.4
A Practical Look at SQLite: Part 1
07:13

4.5
A Practical Look at SQLite: Part 2
06:44

4.6
Other Database Models
01:41

5.Conclusion
1 lesson, 00:18

5.1
Conclusion
00:18

Relational Databases

Next lesson playing in 5 seconds

4.4 A Practical Look at SQLite: Part 1

1.Introduction1 lesson, 01:31

2.History and Terms3 lessons, 17:06

3.Relational Components5 lessons, 38:40

4.Database Usage6 lessons, 29:50

5.Conclusion1 lesson, 00:18

1.Introduction
1 lesson, 01:31

2.History and Terms
3 lessons, 17:06

3.Relational Components
5 lessons, 38:40

4.Database Usage
6 lessons, 29:50

5.Conclusion
1 lesson, 00:18