Search:

SQL all-in-one / by Taylor, Allen G.,author.(CARDINAL)759158; Blum, Richard,1962-author.(CARDINAL)422552;
Introduction -- BOOK 1: Getting started with SQL. Understanding relational databases ; Modeling a system ; Getting to know SQL ; SQL and the relational model ; Knowing the major components of SQL ; Drilling down to the SQL nitty-gritty -- BOOK 2: Developing relational databases. System development overview ; Building a database model ; Balancing performance and correctness ; Creating a database with SQL -- BOOK 3: Writing SQL queries. Values, variables, functions, and expressions ; SELECT statements and modifying clauses ; Querying multiple tables with subqueries ; Querying multiple tables with relational operators ; Cursors -- BOOK 4: Securing your data. Protecting against hardware failure and external threats ; Protecting against user errors and conflicts ; Assigning access privileges ; Error handling -- BOOK 5: Programming with SQL. Database development environments ; Interfacing SQL to a procedural language ; Using SQL in an application program ; Designing a sample application ; Building an application ; Understanding SQL's procedural capabilities ; Connecting SQL to a remote database -- BOOK 6: Working with advanced data types in SQL: XML, JSON, and PGQ. Using XML with SQL ; Storing XML data in SQL tables ; Retrieving data from XML documents ; Using JSON with SQL ; Exploring property graph queries -- BOOK 7: Optimizing your database. Tuning the database ; Tuning the environment ; Finding and eliminating performance bottlenecks -- BOOK 8: Appendixes. SQL:2023 reserved words ; Glossary."SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career"--
Subjects: SQL (Computer program language); Relational databases.; Database management.;
Available copies: 7 / Total copies: 10
unAPI

Blockchain : an illustrated guidebook to understanding Blockchain / by Xu, Mingxing,author.; Tian, Ying,author.; Li, Jiyue,1959-author.; He, Kui,1978-illustrator.; Liu, Jie,translator.;
Blockchain should be easy to understand, but the so-called "experts" always explain it in such a complicated way! Through 200 original illustrations, this book provides simple explanation of Blockchain technology: what Blockchain is and how it works. This book will help you, understand everything about Blockchain, including: The Origin, The Theory, The People, The Application, The Brief History of Blockchain And many more fundamental aspects of blockchain!
Subjects: Blockchains (Databases); Electronic funds transfers.; Database management.;
Available copies: 0 / Total copies: 1
unAPI

Filemaker Pro 12 : the missing manual / by Prosser, Susan.(CARDINAL)330286; Gripman, Stuart.(CARDINAL)330285;
Subjects: FileMaker pro.; Database management;
Available copies: 1 / Total copies: 1
unAPI

Data base : structured techniques for design, performance, and management : with case studies / by Atre, S.,1940-(CARDINAL)151899;
Includes bibliographical references and index.
Subjects: Database management.; Electronic data processing;
Available copies: 1 / Total copies: 1
unAPI

Databases : a primer for retrieving information by computer / by Humphrey, Susanne M.(CARDINAL)181354; Melloni, Biagio John.(CARDINAL)177462;
Bibliography: pages 311-348.
Subjects: Database management.; Information storage and retrieval systems.;
Available copies: 1 / Total copies: 1
On-line resources: Suggest title for digitization;
unAPI

Mastering Approach 3 for Windows / by Powell, James E.(CARDINAL)375541;
Subjects: Lotus Approach for Windows.; Database management.;
Available copies: 3 / Total copies: 3
unAPI

Becoming a database administrator / by Kamberg, Mary-Lane,1948-author.(CARDINAL)389476;
Includes bibliographical references (pages 73-75) and index.Wired -- Information, please -- Be prepared -- Higher education -- Looking ahead.Since the development of the World Wide Web in the 1990s, humans have been living in the Information Age. That's why one important job in the growing field of information technology is that of database administrator (DBA). A DBA is responsible for storing, backing up, and making information easy to access, as well as ensuring its security. This title uses an easy-to-understand, straightforward approach to explore the tasks DBAs perform and the education, certification, and experience required for it. It also outlines steps high school students can take to prepare for fulfilling employment requirements and tips for finding job openings in the field.
Subjects: Young adult literature.; Young adult literature.; Database management; Information technology;
Available copies: 1 / Total copies: 1
unAPI

Introduction to metadata / by Baca, Murtha.(CARDINAL)193193; Getty Research Institute.(CARDINAL)119558;
Includes bibliographical references (page 80).Setting the stage / Anne J. Gilliland -- Metadata and the Web / Tony Gill -- Crosswalks, metadata harvesting, federated searching, metasearching : using metadata to connect users and information / Mary S. Woodley -- Rights metadata made simple / Maureen Whalen -- Practical principles for metadata creation and maintenance -- Glossary."Metadata, literally "data about data," provides a means of indexing, accessing, preserving, and discovering digital resources. The volume of digital information available over electronic networks has created a pressing need for standards that assist in locating, retrieving, and managing this vast and complex universe of information." "This revised edition of Introduction to Metadata, first published in 1998 and updated in an online version in 2000, provides an overview of metadata: its types, roles, and characteristics; a discussion of metadata as it relates to resources on the Web; a description of methods, tools, standards, and protocols that can be used to publish and disseminate digital collections; and a handy glossary." "Newly added to this edition are an essay on the importance of standards-based rights metadata to the activities of cultural institutions; a section entitled "Practical Principles for Metadata Creation and Maintenance"; and the latest information on metadata harvesting and the role of Google and other commercial search engines in the rapidly evolving field of digital libraries."--Jacket.
Subjects: Metadata.; Database management.; World Wide Web.; Information organization.;
Available copies: 1 / Total copies: 1
On-line resources: Suggest title for digitization;
unAPI

SQL in easy steps / by McGrath, Mike,1956-author.(CARDINAL)422694;
SQL (Structured Query Language) is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux. SQL in easy steps, 4th edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract, and manipulate data.
Subjects: SQL (Computer program language); Database management.; Relational databases.;
Available copies: 3 / Total copies: 4
unAPI

Sams teach yourself SQL in 10 minutes / by Forta, Ben,author.(CARDINAL)212020;
Understanding SQL -- Retrieving data -- Sorting retrieved data -- Filtering data -- Advanced data filtering -- Using wildcard filtering -- Creating calculated fields -- Using data manipulation functions -- Summarizing data -- Grouping data -- Working with subqueries -- Joining tables -- Creating advanced joins -- Combining queries -- Inserting data -- Updating and deleting data -- Creating and manipulating tables -- Using views -- Working with stores procedures -- Managing transaction processing -- Using cursors -- Understanding advanced SQL features.Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know-starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply-in short, quick lessons that will each take only 10 minutes or less to complete.
Subjects: Instructional and educational works.; SQL (Computer program language); Database management.; Relational databases.;
Available copies: 2 / Total copies: 4
unAPI