Página InicialGruposDiscussãoMaisZeitgeist
Pesquisar O Sítio Web
Este sítio web usa «cookies» para fornecer os seus serviços, para melhorar o desempenho, para analítica e (se não estiver autenticado) para publicidade. Ao usar o LibraryThing está a reconhecer que leu e compreende os nossos Termos de Serviço e Política de Privacidade. A sua utilização deste sítio e serviços está sujeita a essas políticas e termos.

Resultados dos Livros Google

Carregue numa fotografia para ir para os Livros Google.

A carregar...

Learning SQL

por Alan Beaulieu

Outros autores: Ver a secção outros autores.

MembrosCríticasPopularidadeAvaliação médiaDiscussões
282195,094 (3.75)Nenhum(a)
As data floods into your company, you need to put it to work right away-and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work. - Move quickly through SQL basics and several advanced features - Use SQL data statements to generate, manipulate, and retrieve data - Create database objects, such as tables, indexes, and constraints with SQL schema statements - Learn how datasets interact with queries; understand the importance of subqueries - Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements.… (mais)
Nenhum(a)
A carregar...

Adira ao LibraryThing para descobrir se irá gostar deste livro.

Ainda não há conversas na Discussão sobre este livro.

On the whole I was very impressed with this book. It is, in my opinion, a very well paced tutorial introduction to working with SQL. In order to make examples that the reader can try out on their own computer and get the same results as the book, it is based throughout on MySQL (which is freely available), although it sticks as closely as possible to standard SQL and, where the common database managers (MySQL, Oracle, and Microsoft SQL Server, at any rate) diverge it provides notes about the differences and suggests references for further reading. Also, in order to avoid confusing the novice with details of too many different databases it uses a single database (for a bank) in all the examples. A copy of this database is available to download from the publisher's website, making it possible to try out all the examples and exercises in the book.

I have a few minor niggles. Firstly, there are a few places where the data in the version of the DB that I downloaded from the website seems to diverge from the version used in the book (most notably in the employee start dates), so a few of the queries don't produce the same results. Secondly, there are a few topics (such as user-defined variables) that get sneaked into some of the examples and exercise solutions without a proper explanation in the text (at least not one that I could find, having read the entire book fairly carefully and consulted the index). Thirdly, the book talks about MySQL 6.0 as the current version, while in February 2010 (some months after it was published) the most up-to-date version I could find was 5.5 - evidently 6.0 was pulled at the Alpha stage of development and has not yet been reintroduced (this is not a major problem, as everything covered in the book seems to work fine with MySQL 5). Finally, it's slightly Windows-centric as it does a couple of times refer to "your Windows box" and never mentions any other operating systems apart from a couple of references to mainframes. Fortunately I know my way round Linux well enough not to be phased by the lack of installation instructions for MySQL, but it could be an issue for less experienced users of non-Windows OSes. ( )
1 vote magnuscanis | Feb 16, 2010 |
"Learning SQL [second edition] does a good job of keeping things simple and to the point, never obfuscating topics in language likely to dazzle you. ... The best way to learn about SQL, and useful long after you've read it. 10/10"
adicionada por legallypuzzled | editarLinux Format, Andrew Hudson (Dec 25, 2009)
 
"Perhaps this book should have been called Get Better at SQL ... because it goes into every nook and cranny of SQL. ... [T]he examples are primarily focused on MySQL. ... Not an easy read, but packed with learning and great value for money. (7/10)"
adicionada por legallypuzzled | editarLinux Format, Paul Hudson (Jun 1, 2006)
 

» Adicionar outros autores (3 possíveis)

Nome do autorPapelTipo de autorObra?Estado
Alan Beaulieuautor principaltodas as ediçõescalculado
Demarest, RebeccaIlustradorautor secundárioalgumas ediçõesconfirmado
Futato, DavidDesignerautor secundárioalgumas ediçõesconfirmado
Montgomery, KarenDesigner da capaautor secundárioalgumas ediçõesconfirmado
Tem de autenticar-se para poder editar dados do Conhecimento Comum.
Para mais ajuda veja a página de ajuda do Conhecimento Comum.
Título canónico
Título original
Títulos alternativos
Data da publicação original
Pessoas/Personagens
Locais importantes
Acontecimentos importantes
Filmes relacionados
Epígrafe
Dedicatória
Primeiras palavras
Citações
Últimas palavras
Nota de desambiguação
Editores da Editora
Autores de citações elogiosas (normalmente na contracapa do livro)
Língua original
DDC/MDS canónico
LCC Canónico

Referências a esta obra em recursos externos.

Wikipédia em inglês

Nenhum(a)

As data floods into your company, you need to put it to work right away-and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work. - Move quickly through SQL basics and several advanced features - Use SQL data statements to generate, manipulate, and retrieve data - Create database objects, such as tables, indexes, and constraints with SQL schema statements - Learn how datasets interact with queries; understand the importance of subqueries - Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements.

Não foram encontradas descrições de bibliotecas.

Descrição do livro
Resumo Haiku

Current Discussions

Nenhum(a)

Capas populares

Ligações Rápidas

Avaliação

Média: (3.75)
0.5
1
1.5
2 2
2.5
3 8
3.5
4 10
4.5 1
5 5

É você?

Torne-se num Autor LibraryThing.

 

Acerca | Contacto | LibraryThing.com | Privacidade/Termos | Ajuda/Perguntas Frequentes | Blogue | Loja | APIs | TinyCat | Bibliotecas Legadas | Primeiros Críticos | Conhecimento Comum | 207,205,125 livros! | Barra de topo: Sempre visível