Search results for [SQL (Computer program language).] at NC Cardinal

Results 11 to 20 of 36 | « 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

SQL in a nutshell : a desktop quick reference / by Kline, Kevin,1966-; Kline, Daniel.(CARDINAL)119629;

Subjects: SQL server.; SQL (Computer program language); Client/server computing.;

Available copies: 1 / Total copies: 2

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

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

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

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

MySQL crash course : a hands-on introduction to database development / by Silva, Rick,author.(CARDINAL)888209;

"Covers all things MySQL from the basics of creating a table to the complexities of managing an entire database. Teaches how to build efficient databases through examples, exercises, and three hands-on projects. Topics include creating simple databases and tables, updating and deleting data, working with multiple tables, and avoiding common mishaps"--1130L

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

Available copies: 1 / Total copies: 2

unAPI

NoSQL for dummies / by Fowler, Adam,author.;

Subjects: NoSQL.; Non-relational databases.; SQL (Computer program language);

Available copies: 1 / Total copies: 1

unAPI

Learn SQL in a month of lunches / by Iannucci, Jeff,author.;

SQL, Structured Query Language, is the standard way to query, create, and manage relational databases like SQL Server, PostgreSQL, and Oracle. It's also a superpower for data analysts who need to go beyond spreadsheets and BI dashboarding tools. SQL is easy to read and understand, and with this book (and a little practice) you'll be pulling data, tweaking tables, and cranking out amazing reports and presentations in no time at all! Learn SQL in a Month of Lunches introduces SQL to data analysts and other aspiring data pros with no prior experience using relational databases. In it, you'll complete 24 short lessons, each of which teaches an essential SQL skill for retrieving, filtering, and analyzing data. You'll practice each new technique with a friendly hands-on lab designed to take about 15 minutes, as you learn to write queries that deliver the exact data you need. Along the way, you'll build a valuable intuition for how databases operate in real business scenarios. What's inside: Get the data you need from any relational database ; Filter, sort, and group data ; Combine data from multiple tables ; Create, update, and delete data. For students, aspiring data analysts, software developers, and anyone else who wants to work with relational databases.

Subjects: Handbooks and manuals.; SQL server.; SQL (Computer program language).; Database management.; Database design.;

Available copies: 2 / Total copies: 2

unAPI

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

Results 11 to 20 of 36 | « previous | next »