Database Software Development Videos and Tutorials: MySQL, Oracle, NoSQL
Sheeri K. Cabral of the Pythian Group goes through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. She also goes through how to recognize when you want those types of joins, and best practices for the …
Some might think of DataMapper as a better, faster, competitor to ActiveRecord. However, they would be missing on of its greatest strengths. At its core, DataMapper provides a uniform interface on top of ANY persistance layer. All thats needed is a simple adapter class that can translate the native persistance …
ADO Entity Framework can be used in ASP.NET as well. There are only minor things to keep in mind. The EntityDataSource makes using an Entity Model in ASP.NET much easier. This video demonstrates how to use Entity Framework in ASP.NET. http://msdn.microsoft.com/en-gb/vcsharp/dd565859.aspx
Amit Goyal interviews author Michael Lisin about his new book, Microsoft SQL Server 2008 Reporting Services, the comprehensive guide to SQL Server 2008 Reporting Services.
This video shows a quick example of creating a working CRUD application on top of PostgreSQL using JBoss SEAM (Java Server Faces, EJBs, and Hibernate). In 5 minutes, you use the SEAM framework to build a basic application including reverse engineering the database schema to create boiler plate code for …
Dan Colish presents SQL For the Insane – crazy SQL tricks at the November 2009 OpenSQLCamp in Portland, Oregon.