Teach Yourself Sql In 21 Days (Paperback)

Sams Teach Yourself SQL in 21 Days
Product DescriptionWith SQL (Structured Query Language) you can create tables within a database, add and delete data, query for information, change system settings, and trigger actions based on changes to the database. Whether you're a programmer, administrator, or database designer, Teach Yourself SQL in 21 Days, Second Edition provides all the information needed to fully understand this powerful tool and use it to its fullest potential.Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity, taking your skills to new heights. Completely updated and revised, this easy-to-understand guide explores SQL, showing you how to construct and optimize queries, use stored procedures and triggers to tune a database for maximum performance, and master the fundamental concepts and features of SQL. Q&A sections, step-by-step instructions, and review sections make learning easy and fun Shows how to create tables, modify data, incorporate security features, and tune the database for optimum performance Emphasizes common database concepts, including SQL functions and queries Contents Introduction Day 1: Getting started with SQL 2 An Introduction to the Query 3 Expressions, Conditions and Operators 4 Molding Data with Built-in Functions 5 Clauses in SQL Queries 6 Joining Tables 7 Sub queries: The Embedded SELECT Statement Day 8: Database Normalization 9 Creating and Maintaining Tables 10 Controlling Data Integrity 11 Manipulating Data 12 Controlling Transactions 13 Dates and Time in SQL 14 Creating Views Day 15: Creating Indexes on Tables to Improve performance 16 Streamlining SQL Statements for Improved Performance 17 Database Security 18 Exploring the Data Dictionary System Catalog 19 Stored Procedures, Triggers and Embedded SQL 20 New Objects in the New Standard SQL 3 21 Using SQL to Generate SQL Statements