Includes: Coverage of Oracle & Microsoft SQL Implementations In just 24 lessons of one hour or less Sams Teach Yourself SQL in 24 Hours Sixth Edition helps you use SQL to build effective databases efficiently retrieve data & manage everything from performance to security This book's straightforward step-by-step approach shows you how to work with database structures objects queries tables & more In just hours you will be applying advanced techniques including views transactions web connections & powerful Oracle & SQL Server extensions Every lesson builds on what you've already learned giving you a rock-solid foundation for real-world success Step-by-step instructions carefully walk you through the most common SQL tasks Practical hands-on examples show you how to apply what you learn Quizzes & exercises help you test your knowledge & stretch your skills Notes & tips point out shortcuts & solutions Learn how to Define efficient database structures & objects Normalize raw databases into logically organized tables Edit relational data & tables with DML Manage transactions Write effective well-performing queries Categorize summarize sort group & restructure data Work with dates & times Join tables in queries use subqueries & combine multiple queries Master powerful query optimization techniques Administer databases & manage users Secure databases & protect data Use views synonyms & the system catalog Extend SQL to the enterprise & Internet Master important Oracle & Microsoft extensions to ANSI SQLRegister your product at informitcomregister for convenient access to downloads updates & corrections as they become available