Start learning with our library of video tutorials taught by experts. Get started

Foundations of Programming: Databases
Illustration by Don Barnett

Foundations of Programming: Databases

with Simon Allardice

Video: Welcome

Hi, I'm Simon Allardice, and welcome to Foundations of Programming: Databases. It really doesn't matter what programming language you use, what operating system you like, what kind of app you're building, database skills are vital. So in this course, we're going to start at the very beginning with: what is a database? Why would you want one? And what problems you are likely to run into if you don't have one? And we'll talk about the available database software options from small personal databases installed on a desktop or laptop, all the way to the current open source big data solutions like MongoDB and Hbase.
Expand all | Collapse all
  1. 2m 20s
    1. Welcome
      1m 6s
    2. What you need to know
      1m 14s
  2. 11m 50s
    1. What are databases?
      7m 41s
    2. Exploring databases and database management systems
      4m 9s
  3. 27m 42s
    1. The features of a relational database
      4m 3s
    2. Exploring unique values and primary keys
      3m 34s
    3. Defining table relationships
      5m 33s
    4. Describing many-to-many relationships
      6m 32s
    5. Transactions and the ACID test
      4m 17s
    6. Introduction to Structured Query Language (SQL)
      3m 43s
  4. 20m 1s
    1. Introduction to database modeling
      2m 40s
    2. Planning your database
      5m 46s
    3. Identifying columns and selecting data types
      7m 44s
    4. Choosing primary keys
      1m 46s
    5. Using composite keys
      2m 5s
  5. 21m 17s
    1. Creating relationships
      2m 38s
    2. Defining one-to-many relationships
      5m 52s
    3. Exploring one-to-one relationships
      3m 30s
    4. Exploring many-to-many relationships
      4m 55s
    5. Understanding relationship rules and referential integrity
      4m 22s
  6. 19m 13s
    1. Understanding normalization
      2m 3s
    2. First normal form
      4m 5s
    3. Second normal form
      4m 30s
    4. Third normal form
      4m 35s
    5. Database denormalization
      4m 0s
  7. 37m 51s
    1. Creating SQL queries
      5m 34s
    2. Creating the WHERE clause
      6m 24s
    3. Sorting query results
      2m 37s
    4. Using aggregate functions
      4m 49s
    5. Joining tables
      6m 54s
    6. Inserting, updating, and deleting
      6m 43s
    7. The data definition language
      4m 50s
  8. 26m 1s
    1. Understanding indexes
      9m 24s
    2. Understanding write conflicts
      9m 5s
    3. Understanding stored procedures and injection attacks
      7m 32s
  9. 24m 53s
    1. Desktop databases
      5m 22s
    2. Relational database management systems
      6m 29s
    3. Object-based and XML-based databases
      4m 3s
    4. NoSQL databases
      8m 59s
  10. 50s
    1. Final thoughts
      50s

Watch this entire course now —plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Foundations of Programming: Databases
3h 11m Appropriate for all Jan 25, 2013

Viewers: in countries Watching now:

Discover how a database can benefit both you and your architecture, whatever the programming language, operating system, or application type you use. In this course, explore options that range from personal desktop databases to large-scale geographically distributed database servers and classic relational databases to modern document-oriented systems and data warehouses—and learn how to choose the best solution for you. Author Simon Allardice covers key terminology and concepts, such as normalization, "deadly embraces" and "dirty reads," ACID and CRUD, referential integrity, deadlocks, and rollbacks. The course also explores data modeling step by step through hands-on examples to design the best system for our data. Plus, learn to juggle the competing demands of storage, access, performance, and security—management tasks that are critical to your database's success.

Topics include:
  • What is a database?
  • Why do you need a database?
  • Choosing primary keys
  • Identifying columns and selecting data types
  • Defining relationships: one-to-one, one-to-many, and many-to-many
  • Understanding normalization
  • Creating queries to create, insert, update, and delete data
  • Understanding indexing and stored procedures
  • Exploring your database options
Subjects:
Developer Programming Foundations Databases
Software:
Access MySQL SQL PostgreSQL MongoDB Cassandra Oracle
Author:
Simon Allardice

Welcome

Hi, I'm Simon Allardice, and welcome to Foundations of Programming: Databases. It really doesn't matter what programming language you use, what operating system you like, what kind of app you're building, database skills are vital. So in this course, we're going to start at the very beginning with: what is a database? Why would you want one? And what problems you are likely to run into if you don't have one? And we'll talk about the available database software options from small personal databases installed on a desktop or laptop, all the way to the current open source big data solutions like MongoDB and Hbase.

But we'll focus mainly on classic relational databases. What are the questions to ask, the steps to go through, the things you need to think about. And we'll talk about query languages, the actual code you'd write to get information in and out of the database. What we cover in this course, you could be using not just years but decades from now, so let's get started.

There are currently no FAQs about Foundations of Programming: Databases.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Foundations of Programming: Databases.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.