This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
Cristian Darie is a software engineer with experience in a wide range of modern technologies. He is the author of numerous books, including his popular ASP.NET C# e-commerce tutorial, his Ajax and PHP tutorial, and his search engine optimization tutorial for PHP developers. Cristian studied distributed application architectures for his Ph.D, and is getting involved with various commercial and research projects. When not planning to buy Google, he enjoys his bit of social life. If you want to say "Hi," you can reach Cristian through his personal website, www.CristianDarie.ro.
Inhaltsangabe
Understanding SQL.- Retrieving Data.- Modifying Data.- Summarizing Data.- Functions.- Combining SQL Queries.- Table Joins.- Hiding Complex SQL with Views.- Stored Procedures.- Transactions.- Security.- Working with Database Objects.- Triggers.- Appendices.
