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.
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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.