Search:

Results 1 to 10 of 36 |

SQL / by Fehily, Chris.(CARDINAL)540055;
Subjects: SQL (Computer program language);
Available copies: 2 / Total copies: 2
unAPI

SQL for beginners : the simplified guide to managing, analyzing data with SQL / by Park, J. D.(J. Daniel),author.;
Learning SQL programming for beginners -- Creating a database in SQL server -- The SQL structure -- Database administration -- Structure of the SELECT statement -- SQL data types -- Cursors: read only, forward only, fast forward, static scroll -- Preparation -- Working with filters -- SQL subqueries -- Database components -- Managing database objects.
Subjects: SQL (Computer program language);
Available copies: 1 / Total copies: 1
unAPI

Learning SQL / by Beaulieu, Alan.(CARDINAL)540712;
Includes bibliographical references (pages 267-277) and index.
Subjects: SQL (Computer program language);
Available copies: 2 / Total copies: 2
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: 0 / Total copies: 3
unAPI

SQL all-in-one for dummies / by Taylor, Allen G.(CARDINAL)759158;
Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations.SQL concepts -- Relational database development -- SQL queries -- Data security -- SQL and programming -- SQl and XML -- Database tuning overview.
Subjects: SQL (Computer program language); Relational databases.;
Available copies: 0 / Total copies: 1
unAPI

SQL demystified / by Oppel, Andrew J.(CARDINAL)545330;
Relational database concepts -- SQL concepts -- Defining database objects using SQL -- Retrieving data using query language (DQL) -- Combining data from multiple tables -- Advanced query writing -- Maintaining data using DML -- Applying security controls using DCL -- Preserving database integrity using transactions -- Integrating SQL into applications -- SQL performance and tuning considerations.
Subjects: Relational databases.; SQL (Computer program language);
Available copies: 2 / Total copies: 2
unAPI

SQL for data analysis : advanced techniques for transforming data into insights / by Tanimura, Cathy,author.;
1. Analysis with SQL -- 2. Preparing data for analysis -- 3. Time series analysis -- 4. Cohort analysis -- 5. Text analysis -- 6. Anomaly detection -- 7. Experiment analysis -- 8. Creating complex data sets for analysis -- 9. Conclusion.
Subjects: SQL (Computer program language); Mathematical statistics.;
Available copies: 1 / Total copies: 1
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

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

SQL : a beginner's guide / by Oppel, Andrew J.,author.;
Essential SQL Skills Made Easy Fully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features. Designed for Easy Learning: Key Skills & ConceptsLists of specific skills covered in the chapter Ask the ExpertQ&A sections filled with bonus information and helpful tips Try ThisHands-on exercises that show how to apply your skills NotesExtra information related to the topic being covered TipsHelpful reminders or alternate ways of doing things CautionsErrors and pitfalls to avoid Self-TestsChapter-ending quizzes to test your knowledge Annotated SyntaxExample code with commentary that describes the programming techniques being illustrated
Subjects: SQL (Computer program language); Relational databases.;
Available copies: 1 / Total copies: 1
unAPI

Results 1 to 10 of 36 |