Search results for [Relational databases.] at NC Cardinal

Results 31 to 40 of 146 | « previous | next »

SQL / by Taylor, Allen G.,author.(CARDINAL)759158;

Getting started with SQL. Relational database fundamentals ; SQL fundamentals ; The components of SQL -- Using SQL to build databases. Building and maintaining a simple database structure ; Building a multi-table relational database -- Storing and retrieving data. Manipulating database data ; Handling temporal data ; Specifying valuse ; Using advanced SQL value expressions ; Zeroing in on the data you want ; Using relational operators ; Delving deep with nested queries ; Recursive queries -- Controlling operations. Providing database security ; Protecting data ; Using SQL within applications -- Taking SQL to the real world. Accessing data with ODBC and JDBC ; Operating on SML data with SQL ; SQL and JSON -- Advanced topics. Stepping through a dataset with cursors ; Adding procedural capabilities with persistent stored modules ; Handling errors ; Triggers -- The part of tens. Ten common mistakes ; Ten retrieval tips -- Appendix: ISO/IEC SQL: 2016 reserved words.Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages--and this book shows you how to harness the core element of relational databases with ease. --

Subjects: SQL (Computer program language); Database management.;

Available copies: 1 / Total copies: 1

unAPI

The Internet of things : do-it-yourself projects with Arduino, Raspberry Pi, and Beaglebone Black / by Norris, Donald(Electrical engineer),author.(CARDINAL)610703;

1. Introduction to the Internet of Things : Raspberry Pi platform ; Raspberry Pi GPIO ; Establishing a Raspberry Pi development station ; Setting up the Raspberry Pi software ; The LAMP project ; MySQL database installation -- 2. Home temperature monitoring system : Temperature sensor network ; Serial peripheral interface ; Connecting and testing the MCP3008 with the Raspberry Pi ; Temperature database ; Flask -- 3. Introduction to Object Orientation Programming (OOP) with Java : Java Software Development Kit (SDK) ; The sensor abstract class ; Child classes ; Real-world controls ; Threads ; Java database connector ; Using the Java connector in a program -- 4. Home weather station : Java and GPIO ; GPIO pin expansion ; Interrupts ; Pi4J library ; LED blink program ; Weather station sensors ; Weather station software ; Java software ; Thermostatic application ; Setting the thermostat remotely ; Remote access to the HWS database -- 5. Webcam and Raspberry Pi camera projects : Conventional webcam ; Motion software package ; Motion features ; Motion setup ; Webcam viewing ; Raspberry Pi camera ; Raspberry Pi camera software ; Using Python with the Raspberry Pi camera ; Remote Raspberry Pi camera viewing ; Raspberry Pi camera with motion software --6. Internet-enabled, Arduino powered garage door opener : Arduino hardware ; Arduino Uno software ; Testing the ethernet connection ; Simplified garage door opener ; Visual Studio 2012 IDE ; VS2012 LED Blink program ; Enhanced garage door project ; Testing the enhanced garage door opener -- 7. Arduino irrigation control system : Irrigation system design ; Irrigation control program ; Irrigation system physical installation ; Operating the new irrigation system ; Moisture sensing subsystem ; Actual system operation ; Enhancements -- 8. Arduino lighting controller : System design ; Controller node ; Ethernet shield ; Controller node case and mounting arrangement ; XBee receiver node ; PowerSwitch Tail II ; System software ; Operational test ; Enhancements -- 9. BeagleBone Black message controller : Beagle Boards ; BeagleBone Black ; Downloading, installing, and booting a new Linux distribution ; GPIO pins ; Setting up the LCD display ; LCD operational test ; Message controller software ; Download and install the Flask package ; Main application ; Test results -- 10. BeagleBone Black with Cloud service : Temperature sensor ; Adafruit_BBIO library ; Initial test program ; Xively Cloud service ; BBB to Xively Python program ; Xively website with an active datastream ; Adding additional data channels ; Configuring Angstrom to auto start the application ; System case -- 11. Machine-to-machine (M2M) communications : Paho and Eclipse.org ; Raspberry Pi subscriber client ; MQTT two-phase thermostat.The Internet of Things gets you started working with the most popular processing platforms and wireless communication technologies to connect devices and systems to the Internet using sensors. You'll learn the basics of object-oriented programming and relational databases so you can complete your projects with ease. Each project features a list of required tools and components, how-to explanations with photos and illustrations, and complete programming code. Take advantage of the power and versatility of the IoT with help from this practical, easy-to-follow guide.

Subjects: Programmable controllers; Arduino (Programmable controller); Raspberry Pi (Computer); BeagleBone Black (Computer);

Available copies: 2 / Total copies: 3

unAPI

Murach's SQL server 2012 for developers / by Syverson, Bryan.(CARDINAL)688493; Murach, Joel,1968-(CARDINAL)206512;

An introduction to relational databases and SQL -- How to use the Management Studio -- How to retrieve data from a single table -- How to retrieve data from two or more tables -- How to code summary queries -- How to code subqueries -- How to insert, update, and delete data -- How to work with data types -- How to use functions -- How to design a database -- How to create and maintain databases, tables, and sequences with SQL statements -- How to use the Management Studio for database design -- How to work with views -- How to code scripts -- How to code stored procedures, functions, and triggers -- How to work with cursors -- How to manage transactions and locking -- How to manage database security -- How to work with XML -- How to work with BLOBs -- An introduction to CLR integration -- How to code CLR stored procedures, functions, and triggers -- How to code aggregate functions and user-defined types.

Subjects: SQL server.; Client/server computing.;

Available copies: 1 / Total copies: 1

unAPI

Practical SQL : a beginner's guide to storytelling with data / by DeBarros, Anthony,author.(CARDINAL)803562;

"Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently"--

Subjects: SQL (Computer program language); Database design.;

Available copies: 1 / Total copies: 3

unAPI

Sams teach yourself SQL in 24 hours / by Stephens, Ryan K.,author.(CARDINAL)212592;

Understanding the relational database and SQL -- Exploring the components of the SQL language -- Getting to know your data -- Setting up your database -- Understanding the basics of relational (SQL) database design -- Defining entities and relationships -- Normalizing your database -- Defining data structures -- Creating and managing database objects -- Manipulating data -- Managing database transactions -- Introduction to database queries -- Using operators to categorize data -- Joining tables in queries -- Restructuring the appearance of data -- Understanding dates and times -- Summarizing data results from a query -- Using subqueries to define unknown data -- Combining multiple queries into one -- Creating and using views and synonyms -- Managing database users and security -- Using indexes to improve performance -- Improving database performance -- Working with the system catalog -- Bonus workshop for the road -- Appendixes. Common SQL commands ; Popular vendor RDBMS implementations -- Answers to quizzes and exercises.Featuring step-by-step instructions that walk you through the most common SQL tasks, this authoritative resource helps you use SQL to build effective data bases, efficiently review data and manage everything from performance to security.

Subjects: Instructional and educational works.; SQL (Computer program language); Database design.; Database management.;

Available copies: 2 / Total copies: 3

unAPI

PHP and MySQL web development : a beginner's guide / by Matthews, Martin S.,author. ;

Machine generated contents note: Part I: Getting Ready -- Ch 1: Setting Up Your Programming Workstation -- Ch 2: Building Web Pages with HTML -- Ch 3: Using CSS and Templates -- Ch 4: Adding Dynamic Elements with JavaScript -- Part II: Exercising the Server with PHP -- Ch 5: Introduction to PHP -- Ch 6: Fundamentals of PHP -- Ch 7: Reading and Writing Files -- Ch 8: User Authentication and Error Handling -- Part III: Creating and Using a Relational Database with MySQL -- Ch 9: Introduction to Databases, SQL, and MySQL -- Ch 10: Fundamentals of MySQL -- Ch 11: Adding, Modifying, and Deleting Tables and Records -- Part IV: Powering Databases with PHP and MySQL -- Ch 12: Connecting to and Accessing a MySQL Database with PHP -- Ch 13: Registering Users and Responding to Their Needs -- Ch 14: Providing For and Handling Online Purchases."This step-by-step tutorial shows you how to use PHP and MySQL to power websites with dynamic content. PHP and MySQL Web Development: A Beginner's Guide takes you from building static pages to ones with PHP and MySQL dynamic elements. Hands-on projects get you started using new skills right away!This solutions-oriented book is organized around real-world web scenarios that demonstrate the use of PHP and MySQL. These scenarios can be directly used to build web pages with dynamic content. Security topics such as validation, authentication, and encryption are addressed throughout. Each chapter teaches practical techniques that can be immediately applied Covers the basics of what drives many of today's most popular sites Ready-to-use code examples from the book available for download "--

Subjects: PHP (Computer program language); MySQL (Electronic resource); Web site development.;

Available copies: 1 / Total copies: 1

unAPI

Crime fighting : the impact of science and technology / by Harris, Nathaniel,1937-(CARDINAL)126414;

Includes bibliographical references (page 63) and index.Looks at how advances in science and technology have affected crime fighting, providing information as well as pro and cons about a variety of related topics, such as fingerprints, ballistics, surveillance, and DNA databases.8.85-85-81170LAccelerated Reader ARAccelerated Reader AR

Subjects: Criminal investigation; Criminal investigation.;

Available copies: 1 / Total copies: 1

unAPI

SQL for MySQL : a beginner's tutorial / by Darmawikarta, Djoni,author.(CARDINAL)620065;

"This introduction to SQL for MySQL begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. The guide then discusses how to construct basic queries, choose an appropriate output, and how to create and use groups. Readers will also learn how to use joins to query data from multiple tables, how to create predefined views that can be stored in a database, and how to utilize the metadata of a database. Appendices round out the book, covering the various indexing techniques available in MySQL and discussing how to install MySQL Community Edition and list the MySQL built-in data types."--

Subjects: MySQL (Electronic resource); SQL (Computer program language); Database management.;

Available copies: 1 / Total copies: 1

unAPI

Mapping & documenting cemeteries / by Goffinet, Pamela.;

Introduction -- Getting started -- Tools -- Gravestone mapping basics -- Beyond the basics -- Working with a lot map -- How to draft the map -- Gathering gravestone inscriptions -- Creating an inscription database -- Organizing other related data -- Finishing touches -- Further activities -- AppendixThis is a practical how-to book that guides the reader through the process of mapping and documenting a cemetery with easily available tools and basic skills.

Subjects: Cemeteries; Geomorphological mapping.; Digital mapping.; Cartography.;

Available copies: 2 / Total copies: 3

unAPI

Egle's notes and queries of Pennsylvania, 1700s-1800s. by Egle, William Henry,1830-1901(DLC)n 50030242; Brøderbund.(DLC)no 93034341 ;

Contains images of the pages of William Henry Egle's Notes and Queries. Notes and queries was originally published between 1879 and 1895 as a series of newspaper columns in the Harrisburg Daily Telegraph, and then continued separately and published in four annual volumes between 1896 and 1900. Produced in collaboration with the Genealogical Publishing Company, the Family Archive lists more than 109,000 individuals referenced in a vast array of original resources.System requirements: CD-ROM drive; version 3.02 or higher of Family Tree Maker for Windows, or, version 3.02 or higher of the Family Archive viewer.

Subjects: Biographies.;

© c1998., Brøderbund Software,

Available copies: 1 / Total copies: 1

unAPI

Results 31 to 40 of 146 | « previous | next »