With 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
Fully updated and revised to include coverage of PL/SQL and Transact SQL. this easy-to-understand guide teaches users everything they need to know from database concepts and processes to implementing security and constructing and optimizing queries. - 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