Cargando…

Sams Teach Yourself SQL in 24 Hours, 7th Edition

In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security. This Seventh Edition is thoroughly revised and reorganized for faster learning and a deeper under...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Stephens, Ryan (Autor), Jones, Arie (Autor), Plew, Ronald R. (Autor)
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Sams, 2021.
Edición:1st edition.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a22000007a 4500
001 OR_on1285526165
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu||||||||
008 211117s2021 xx o 000 0 eng d
040 |a AU@  |b eng  |c AU@  |d ORMDA  |d OCLCO  |d OCLCF  |d OCLCQ 
020 |z 9780137543168 
020 |z 9780137543120 
024 8 |a 9780137543168 
029 0 |a AU@  |b 000070164977 
029 1 |a AU@  |b 000072036195 
035 |a (OCoLC)1285526165 
037 |a 9780137543168  |b O'Reilly Media 
050 4 |a QA76.73.S67 
082 0 4 |a 005.75/65  |2 23 
049 |a UAMI 
100 1 |a Stephens, Ryan,  |e author. 
245 1 0 |a Sams Teach Yourself SQL in 24 Hours, 7th Edition  |h [electronic resource] /  |c Stephens, Ryan. 
250 |a 1st edition. 
264 1 |b Sams,  |c 2021. 
300 |a 1 online resource (504 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
500 |a Includes Coverage of Oracle and Microsoft SQL Implementations In just 24 lessons of one hour or less, SQL in 24 Hours, Sams Teach Yourself , Seventh Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security. The straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what youve 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 and exercises help you test your knowledge and stretch your skills. Notes and tips point out shortcuts and solutions. Learn how to Define efficient database structures and objects Normalize raw databases into logically organized tables Edit relational data and tables with DML Manage transactions Write effective, well-performing queries Categorize, summarize, sort, group, and restructure data Work with dates and times Join tables in queries, use subqueries, and combine multiple queries Master powerful query optimization techniques Administer databases and manage users Secure databases and protect data Use views, synonyms, and the system catalog Extend SQL to the enterprise and Internet Master important Oracle and Microsoft extensions to ANSI SQL Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available. 
542 |f Copyright © Sams 
550 |a Made available through: Safari, an O'Reilly Media Company. 
588 |a Online resource; Title from title page (viewed December 27, 2021) 
520 |a In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security. This Seventh Edition is thoroughly revised and reorganized for faster learning and a deeper understanding of modern SQL development. Based on standardized SQL throughout, it teaches using new sample code based on the free, easy-to-use Oracle Database Express (XE). You'll find more hands-on examples than ever, culminating in an all-new Bonus Exercises Workshop with even more real-world practice. This guide's straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, from transactions and joins to complex data retrieval using views and subqueries. 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 and exercises help you test your knowledge and stretch your skills. Notes and tips point out shortcuts and solutions. Learn how to... * Master core relational database concepts, SQL concepts, and language components * Clearly understand your data * Set up databases and plan efficient database designs * Define entities and relationships, establish data structures, and create database objects * "Normalize" raw databases into logically organized tables * Edit relational data and tables and manage transactions * Write effective, well-performing queries * Categorize, summarize, sort, group, and restructure data * Work with dates and times * Join tables in queries, use subqueries, and combine multiple queries * Optimize performance with indexes and other techniques * Administer databases and manage users * Secure databases and data. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a SQL (Computer program language) 
650 0 |a Database management. 
650 0 |a Relational databases. 
650 6 |a SQL (Langage de programmation) 
650 6 |a Bases de données  |x Gestion. 
650 6 |a Bases de données relationnelles. 
650 7 |a Database management.  |2 fast  |0 (OCoLC)fst00888037 
650 7 |a Relational databases.  |2 fast  |0 (OCoLC)fst01093575 
650 7 |a SQL (Computer program language)  |2 fast  |0 (OCoLC)fst01102869 
700 1 |a Jones, Arie,  |e author. 
700 1 |a Plew, Ronald R.,  |e author. 
710 2 |a Safari, an O'Reilly Media Company. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780137543168/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP