Search results for [Database design] at NC Cardinal

Results 21 to 30 of 171 | « previous | next »

The language of SQL / by Rockoff, Larry.(CARDINAL)599866;

Relational Databases and SQL -- Basic Data Retrieval -- Calculated Fields and Aliases -- Using Functions -- Sorting Data -- Selection Criteria -- Boolean Logic -- Inner Joins -- Outer Joins -- Self Joins and Views -- Subqueries -- Set Logic -- Stored Procedures and Parameters -- Modifying Data -- Maintaining Tables -- Conditional Logic -- Summarizing Data -- Subtotals and Crosstabs -- Principles of Database Design -- Strategies for Displaying DataMany SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors. For SQL beginners, it&#x;s more important for a book to focus on general concepts and to offer clear explanations and examples of what various SQL statements can accomplish. This is that book. A number of features make The Language of SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to grow your understanding as you encounter new terms and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle. Special "Database Differences" sidebars clearly show you any differences in syntax among these three databases, and instructions are included on how to obtain and install free versions of the databases. This is the only book you need to gain a quick working knowledge of SQL and relational databases. Learn How to use SQL to retrieve data from relational databases, apply functions and calculations to data, group and summarize data in a variety of useful ways, use complex logic to retrieve only the data you need, update data and create new tables, design relational databases so that data retrieval is easy and intuitive, use spreadsheets to transform your data into meaningful displays, retrieve data from multiple tables via joins, subqueries, views, and set logic, create, modify, and execute stored procedures, install Microsoft SQL Server, MySQL, or Oracle. -- Provided by publisher.

Subjects: SQL (Computer program language); Relational databases.;

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

Careers in Internet technology / by Steffens, Bradley,1955-author.(CARDINAL)774727;

Includes bibliographical references and index.User experience designer -- Web developer -- Search engine optimization manager -- Database administrator -- Cybersecurity analyst -- Social media specialist -- Mobile app developer -- Penetration tester.

Subjects: Internet;

Available copies: 1 / Total copies: 1

unAPI

Archival database specifications for the SHRP asphalt research program / by Anderson, D. A.(David A.),1936-(CARDINAL)312078; Strategic Highway Research Program (U.S.)(CARDINAL)298325;

Includes bibliographical references (page 37).... contract no.

Subjects: Pavements, Asphalt; Pavements, Asphalt; Pavements, Asphalt;

Available copies: 1 / Total copies: 1

unAPI

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

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

PHP & MySQL, novice to ninja / by Butler, Tom,author.; Yank, Kevin,author.;

[Webliography].PHP & MySQL: Novice to Ninja, 6th Edition is a hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional application using PHP & MySQL. Comprehensively updated to cover PHP 7 and modern best practice, this practical and fun book covers everything from installing PHP and MySQL through to creating a complete online content management system. You'll learn how to: *Install PHP & MySQL on Windows, Mac OS X, or Linux *Gain a thorough understanding of PHP syntax *Use object oriented programming techniques *Master database design principles and SQL *Develop robust websites that can handle high levels of traffic *Build a working content management system (CMS) *And much more!

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

Available copies: 1 / Total copies: 1

unAPI

Learning MySQL : get a handle on your data / by Grippa, Vinicius M.,Author(DLC)no2021118195; Kuzmichev, Sergey,Author(DLC)no2021118204;

Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS. Authors Vinicius Grippa and Sergey Kuzmichev from Percona show developers and DBAs methods for minimizing costs and maximizing availability and performance. You'll learn how to perform basic and advanced querying, monitoring and troubleshooting, database management and security, backup and recovery, and tuning for improved efficiency. This edition includes new chapters on high availability, load balancing, and using MySQL in the cloud. *Get started with MySQL and learn how to use it in production *Deploy MySQL databases on bare metal, on virtual machines, and in the cloud *Design database infrastructures *Code highly efficient queries *Monitor and troubleshoot MySQL databases *Execute efficient backup and restore operations *Optimize database costs in the cloud *Understand database concepts, especially those pertaining to MySQL.

Subjects: MySQL (Electronic resource); SQL (Computer program language); Web databases.;

Available copies: 0 / Total copies: 1

unAPI

Careers in information technology / by Shally-Jensen, Michael,editor.(CARDINAL)682936;

Includes bibliographical references (page 312) and index.Publisher's Note -- Editor's Introduction -- Chief Information Officer/Chief Technology Officer -- Computer & Information Systems Manager -- Computer-Control Machine Tool Operator -- Computer Engineer -- Computer Network Architect -- Computer Programmer -- Computer Service Technician -- Computer Support Specialist -- Computer Systems Analyst -- Database Administrator -- Database Entry Keyer/Data Coder -- Desktop Publisher -- Electronic Commerce Specialist -- Game Designer -- Information Security Analyst -- Information Technology Project Manager -- Network & Computer Systems Administrator -- Robotics Technician -- Software and/or Mobile/Apps Developer -- Telecommunications Equipment Installer/Repairer --UX Designer -- Web Administrator -- Web Developer -- Appendix A: Holland Code -- Appendix B: Bibliography -- Index.The U.S. Bureau of Labor Statistics reports that employment in all computer occupations is expected to increase by 22% by 2020. Careers in Information Technology examines 25 potential career paths in Information Technology.

Subjects: Information technology; Computer science;

Available copies: 1 / Total copies: 1

unAPI

Murach's PHP and MySQL : training & reference / by Murach, Joel,1968-author.(CARDINAL)206512; Harris, Ray(Software engineer),author.(CARDINAL)814983;

Introduction to web development with PHP -- How to code a PHP application -- Introduction to relational databases and MySQL -- How to use PHP with a MySQL database -- How to use the MVC pattern to organize your code -- How to test and debug a PHP application -- How to work with form data -- How to code control statements -- How to work strings and numbers -- How to work with dates -- How to create and use arrays -- How to work with cookies and sessions -- How to create and use functions -- How to create and use objects -- How to use regular expressions, handle exceptions, and validate data -- How to design a database -- How to use SQL to create a MySQL database -- How to use SQL to work with a MySQL database -- Professional PHP for working with MySQL -- A database-driven website -- How to create secure websites -- How to send email -- How to work with files, uploads, and images -- An eCommerce website -- Appendix A: How to set up Windows for this book -- Appendix B: How to set up Mac OS X for this book -- Appendix C: How to set up Linux for this book.

Subjects: MySQL (Electronic resource); Relational databases.; PHP (Computer program language);

Available copies: 1 / Total copies: 1

unAPI

Results 21 to 30 of 171 | « previous | next »