DBWebApplications 





Finding, Filtering, Sorting  «Prev  Next»
Lesson 7

Single Table Access Conclusion

This module discussed how to find the data you need when it resides in a single table.

Terms and concepts
This module introduced you to the following key terms and concepts:
  1. Filter
  2. Filter by Form
  3. Filter by Selection
  4. Filter For
  5. Find
  6. Sort

Apply Filters Sorts to Database - Exercise
Put your data to the test by filtering the Consulting database.
Apply Filters Sorts to Database - Exercise


Simple Models of Neurons

These are much simpler than real neurons, but they are still complicated enough, to allow us to make neural nets, that do some very interesting kinds of machine learning. In order to understand anything complicated, we have to idealize it. That is, we have to make simplifications that allow us to obtain an understanding on how it might work. With atoms, for example, we simplify them as behaving like little solar systems. Idealization removes the complicated details that are not essential for understanding the main principles. It allows us to apply mathematics, and to make analogies to other familiar systems. And once we understand the basic principles, it is easy to add complexity, and make the model more faithful to reality. We have to be careful when we idealize something, not to remove the characteristic that is giving it its main properties. It is often worth understanding models that are known to be wrong, as long as we do not forget they're wrong. For example, a lot of work on neural networks uses neurons that communicate real values rather than discrete spikes of activity, and we know cortical neurons do not behave in this way, but it is still worth understanding systems such as these, and in practice they can be very useful for machine learning.
a2 + b2 = c2