Author : Paul Conte
Publisher : System iNetwork
Page : 548 pages
File Size : 17,66 MB
Release : 2000
Category : Computers
ISBN : 9781882419708
IBM and the rest of the computer industry are putting most of their DBMS development efforts into SQL. This reference provides the SQL/400 skills that a successful applications developer needs and shows how to create comprehensive, complex, and professional SQL/400 databases.
Author : Rick F. van der Lans
Publisher : Pearson Education
Page : 1117 pages
File Size : 30,14 MB
Release : 2007-04-20
Category : Computers
ISBN : 0132715899
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.
Author : Michael J. Donahoo
Publisher : Elsevier
Page : 273 pages
File Size : 36,64 MB
Release : 2010-07-21
Category : Computers
ISBN : 0080489745
SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses — no matter what main text you use or what flavor of SQL is required. It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user. This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses. Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL. The approach is vendor-neutral—so very adaptable and flexible The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter. Coverage is on the key features of the language that are required to understand SQL and begin using it effectively. SQL 2003-compliant.
Author : William Durkin
Publisher : Packt Publishing Ltd
Page : 809 pages
File Size : 40,22 MB
Release : 2018-03-16
Category : Computers
ISBN : 1788479939
Build smarter and efficient database application systems for your organization with SQL Server 2017 Key Features Build database applications by using the development features of SQL Server 2017 Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queries Book Description Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. What you will learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017 Who this book is for Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book.
Author : Tim Martyn
Publisher : McGraw-Hill Companies
Page : 540 pages
File Size : 26,12 MB
Release : 1995
Category : Computers
ISBN :
This practical guide to SQL focuses on data retrieval and manipulation using the powerful AS/400 dialect. In a proven tutorial format, the authors cover a wide range of SQL material, including selecting data from a single table, using built-in functions, defining and manipulating data, and accessing multiple tables.
Author : Michael J. Donahoo
Publisher :
Page : 249 pages
File Size : 42,5 MB
Release : 2005
Category : Query languages (Computer science)
ISBN : 9788131201855
Author : Breck Carter
Publisher : Wordware Publishing, Inc.
Page : 489 pages
File Size : 41,18 MB
Release : 2004
Category : Anywhere Studio (Computer file)
ISBN : 1556225067
Companion CD includes SQL Anywhere Studio 9 Developer Edition (for Windows), all the code from the examples and full BNF from the book in HTML format!SQL Anywhere Studio 9 Developers Guide describes in detail how to administer and program SQL Anywhere, the leading relational database for mobile, distributed, and embedded applications. This book focuses on the various tasks performed during the life cycle of a typical database, such as creating tables and other schema objects, and inserting, selecting, updating, and deleting data. Additional topics include packaging SQL code into procedures, triggers, and events; distributing data across multiple databases using MobiLink; protecting the database from disaster; and tuning for performance.
Author : Eric Johnson
Publisher : Addison-Wesley Professional
Page : 445 pages
File Size : 27,54 MB
Release : 2008-06-24
Category : Computers
ISBN : 0132701537
“ A Developer’s Guide to Data Modeling for SQL Server explains the concepts and practice of data modeling with a clarity that makes the technology accessible to anyone building databases and data-driven applications. “Eric Johnson and Joshua Jones combine a deep understanding of the science of data modeling with the art that comes with years of experience. If you’re new to data modeling, or find the need to brush up on its concepts, this book is for you.” — Peter Varhol, Executive Editor, Redmond Magazine Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn’t enough: models that don’t reflect SQL Server’s unique real-world strengths and weaknesses often lead to disastrous performance. A Developer’s Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms. You’ll begin with a concise, practical overview of the core data modeling techniques. Next, you’ll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you’ll systematically transform those logical models into physical models that make the most of SQL Server’s extended functionality. All of this book’s many examples are available for download from a companion Web site. This book enables you to Understand your data model’s physical elements, from storage to referential integrity Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration Normalize data models, one step at a time Gather and interpret requirements more effectively Learn an effective methodology for creating logical models Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships Create physical models—from establishing naming guidelines through implementing business rules and constraints Use SQL Server’s unique indexing capabilities, and overcome their limitations Create abstraction layers that enhance security, extensibility, and flexibility
Author : Ken Henderson
Publisher : Addison-Wesley Professional
Page : 1076 pages
File Size : 24,24 MB
Release : 2004
Category : Client/server computing
ISBN : 9780201700473
bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson
Author : Anthony Molinaro
Publisher : "O'Reilly Media, Inc."
Page : 632 pages
File Size : 24,53 MB
Release : 2006
Category : Computers
ISBN : 0596009763
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.
