Sams Teach Yourself SQL in 24 Hours, Fifth Edition

Master all the fundamentals of modern SQL -- hands-on, step-by-step! ¿ The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases Updated to cover the latest ANSI/ISO standards, plus powerful Oracle and SQL Server extensions Covers everything fro...

Descripción completa

Detalles Bibliográficos
Otros Autores: Stephens, Ryan, author (author), Plew, Ron, author, Jones, Arie, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sams 2011.
Edición:1st edition
Colección:Sams Teach Yourself
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630121306719
Descripción
Sumario:Master all the fundamentals of modern SQL -- hands-on, step-by-step! ¿ The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases Updated to cover the latest ANSI/ISO standards, plus powerful Oracle and SQL Server extensions Covers everything from the basics through optimization, security, and enterprise techniques Step-by-step instructions, examples, quizzes, exercises, and tips In just 24 sessions of one hour or less, beginning-to-intermediate-level readers learn how to use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you learn hands-on, through practical examples based on the free, open source MySQL database. One step at a time, you discover how to define efficient database structures, objects, and tables edit data and tables manage transactions write effective queries categorize, summarize, sort, group, and restructure data use joins and subqueries manage databases, users, and security use views, synonyms, and system catalogs extend SQL to the enterprise and Internet even master important Oracle and Microsoft SQL Server extensions. Step-by-step instructions carefully walk through common questions, issues, and tasks... Q and As, Quizzes, and Exercises help you build and test your knowledge... Notes, Tips, and Cautions point out shortcuts, solutions, and problems to avoid. Each lesson builds on what you've already learned, delivering a strong real-world foundation for success with any relational database environment or application!
Descripción Física:1 online resource (504 pages)
ISBN:9780132603911
9780132603904