Sams Teach Yourself SQL in 24 Hours

0.0

This edition will mainly consist of updating ANSI SQL references to implement the newer 2003 standard with the 2006 XML add-on. This will also include updating references to MySQL content as the 5.0 version of the database supports more ANSI-compliant commands. Other sections have been added that would include newer functions within the ANSI standard that are supported as well.For Sale in Indian subcontinent onlyFeaturesSQL is the foundation for querying databases; anyone working with databases regularly needs to learn SQL This book helps anyone get up to speed on SQL fast - with no previous experience required Fully updated for the most recent SQL standards Each chapter builds on the previous one with real world examples and hands on exercisesContentsPart I: A SQL Concepts Overview Welcome to the World of SQL Part II: Building Your Database Defining Data Structures Managing Database Objects The Normalization Process Manipulating Data Managing Database Transactions Part III: Getting Effective Results from Queries Introduction to the Database Query Using Operators to Categorize Data Summarizing Data Results from a Query Sorting and Grouping Data Restructuring the Appearance of Data UnderstandingDates and Times Part IV: Building Sophisticated Database Queries Joining Tables in Queries Using Subqueries to Define Unknown Data Combining Multiple Queries into One Part V: SQL Performance Tuning Using Indexes to Improve Performance Improving Database Performance Part VI: Using SQL to Manage Users and Security Managing Database Users Managing Database Security Part VII: Summarized Data Structures Creating and Using Views and Synonyms Working with the System Catalog Part VIII: Applying SQL Fundamentals in Today’s World Advanced SQL Topics Extending SQL to the Enterprise, the Internet, and the Intranet Extensions to Standard SQL Part IX: Appendixes