Search:

Results 11 to 20 of 146 | « previous |

SQL for dummies / by Taylor, Allen G.(CARDINAL)759158;
Subjects: Computer programming.; Database searching.; Relational databases.; SQL (Computer program language);
Available copies: 0 / Total copies: 1
unAPI

MySQL database usage & administration / by Vaswani, Vikram.(CARDINAL)541066;
Includes bibliographical references and index.An introduction to MySQL -- Understanding basic commands -- Making design decisions -- Using joins, subqueries, and views -- Using transactions -- Using stored procedures and functions -- Using triggers and scheduled events -- Working with data in different formats -- Optimizing performance -- Performing basic server administration -- Managing users and controlling access -- Performing maintenance, backup, and recovery -- Replicating data -- Installing MySQL and the sample database.
Subjects: MySQL (Electronic resource); Relational databases.; Client/server computing.;
Available copies: 1 / Total copies: 1
unAPI

Microsoft SQL server 2019 : a beginner's guide / by Petković, Dušan,author.;
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get Up to Speed on Microsoftª SQL Serverª 2019. Quickly and Easily Start working with Microsoft SQL Server 2019 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition starts by explaining fundamental relational database system concepts. From there, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use powerful analysis and reporting tools. New topics such as SQL and JSON support, graph databases, and support for machine learning with R and Python are also covered in this step-by-step tutorial. *Install, configure, and customize Microsoft SQL Server 2019 *Create and modify database objects with Transact-SQL statements *Write stored procedures and user-defined functions *Handle backup and recovery, and automate administrative tasks *Tune your database system for optimal availability and reliability *Secure your system using authentication, encryption, and authorization *Work with SQL Server Analysis Services, Reporting Services, and other BI tools *Gain knowledge of relational storage, presentation, and retrieval of data stored in the JSON format *Manage graphs using SQL Server Graph Databases *Learn about machine learning support for R and Python.
Subjects: SQL server.; Client/server computing.; Relational databases.;
Available copies: 0 / Total copies: 1
unAPI

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

SQL essentials / by Blum, Richard,1962-author.(CARDINAL)422552; Taylor, Allen G.,author.(CARDINAL)759158;
Introduction -- Getting to know SQL -- Creating a database with SQL -- Drilling down to the SQL nitty-gritty -- Values, variables, functions, and expressions -- SELECT statements and modifying clauses -- Querying multiple tables with subqueries -- Querying multiple tables with relational operators -- Cursors -- Assigning access privileges -- Ten retrieval tips -- Index."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: Handbooks and manuals.; Guides et manuels.; SQL (Computer program language); Relational databases.;
Available copies: 3 / Total copies: 3
unAPI

Sams teach yourself Oracle PL/SQL in 10 minutes / by Forta, Ben,author.(CARDINAL)212020;
Subjects: Oracle (Computer file); PL/SQL (Computer program language); Relational databases.;
Available copies: 3 / Total copies: 4
unAPI

Oracle PL/SQL language pocket reference / by Feuerstein, Steven,author.(CARDINAL)684800; Pribyl, Bill,author.(CARDINAL)533560; Dawes, Chip,author.(CARDINAL)420407;
The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c . Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of: fundamental language elements, such as block structure, datatypes, and declarations; statements for program control, cursor management, and exception handling; records, procedures, functions, triggers, and packages; execution of PL/SQL functions in SQL; compilation options, object-oriented features, collections, and Java integration. A perfect companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming .
Subjects: Oracle (Computer file); PL/SQL (Computer program language); Relational databases.;
Available copies: 1 / Total copies: 3
unAPI

Sams Teach Yourself NoSQL with MongoDB in 24 hours / by Dayley, Brad.(CARDINAL)653307;
"Now, in just 24 lessons of one hour or less, you can learn how to leverage MongoDB's immense power. Each short, easy lesson builds on all that's come before, teaching NoSQL concepts and MongoDB techniques from the ground up."--
Subjects: MongoDB.; Databases; Information storage and retrieval systems.; Non-relational databases.;
Available copies: 1 / Total copies: 1
unAPI

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

Begin to code with C♯ / by Miles, Rob,1957-author.(CARDINAL)875800;
Includes index.
Subjects: Microsoft .NET Framework.; C# (Computer program language); Relational databases.; Application software; Internet programming.;
Available copies: 1 / Total copies: 3
unAPI

Results 11 to 20 of 146 | « previous |