Search:

Results 31 to 40 of 219 | « previous |

Access / by Ulrich-Fuller, Laurie,1961-author.(CARDINAL)351956; Cook, Ken,1959-author.(CARDINAL)351955;
Introduction -- Part 1 : basic training. Access basic training -- Navigating the Access workspace -- Database basics -- Part 2 : getting it all on the table. Sounds like a plan -- Table tune ups -- Remodeling your data -- Types, masks, and triggers -- Part 3 : data management mania. A form for all reasons -- Importing and exporting data -- Automatically editing data -- Access and the web -- Part 4 : the power of questions. Finding, filtering, and sorting your data, fast -- I was just asking ... for answers -- I want these and those or them -- Number crunching with the total row -- Express yourself with formulas -- Take charge with action queries -- Part 5 : simple and snazzy reporting. Fast and furious automatic reporting -- Professionally designed reports made easy -- Groups and page breaks, headers and footers -- Mailings to the masses -- Part 6 : the parts of tens. Ten common problems -- Ten uncommon tips -- Getting help."Become a database boss--and have fun doing it--with this accessible and easy-to-follow guide to Microsoft Access...Databases hold the key to organizing and accessing all your data in one convenient place. And you don't have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you'll learn to use the latest version of Microsoft's Access software to power your database needs. Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases. Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access's more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries--this book covers Access now matter how you access it. The book also shows you how to: handle the most common problems that Access users encounter; import, export, and automatically edit data to populate your next database; and write powerful and accurate queries to find exactly what you're looking for, exactly when you need it. Microsoft Access For Dummies is the perfect resource for anyone expected to understand, use, or administer Access databases at the workplace, classroom, or any other data-driven destination." --
Subjects: Handbooks and manuals.; Microsoft Access.; Database management.;
Available copies: 7 / Total copies: 8
unAPI

Oracle big data handbook / by Plunkett, Tom,1967-author.(CARDINAL)606445; MacDonald, Brian,author.; Nelson, Bruce,author.(CARDINAL)477180; Sun, Helen,author.(CARDINAL)500890; Hornick, Mark F.,author.(CARDINAL)482435; Laker, Keith,author.; Mohiuddin, Khader,author.; Harding, Debra L.,author.; Segleau, David,author.; Mishra, Gokula,author.; Stackowiak, Robert,author.(CARDINAL)420815;
Introduction to big data -- The value of big data -- The Apache Hadoop platform -- Why an appliance? -- BDA configurations, deployment architectures, and monitoring -- Integrating the data warehouse and analytics infrastructure to big data -- BDA connectors -- Oracle NoSQL database -- In-database analytics: delivering faster time to value -- Analyzing data with R -- Endeca information discovery -- Big data governance -- Developing architecture and roadmap for big data."Cowritten by members of Oracle's big data team, [this book] provides complete coverage of Oracle's comprehensive, integrated set of products for acquiring, organizing, analyzing, and leveraging unstructured data. The book discusses the strategies and technologies essential for a successful big data implementation, including Apache Hadoop, Oracle Big Data Appliance, Oracle Big Data Connectors, Oracle NoSQL Database, Oracle Endeca, Oracle Advanced Analytics, and Oracle's open source R offerings"--Page 4 of cover.
Subjects: Oracle (Computer file); Big data.; Database management.;
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

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

Data systems in early intervention / by Hebbeler, Kathleen M.,1950-; Carolina Institute for Child and Family Policy.; University of North Carolina at Chapel Hill.Carolina Policy Studies Program.;
Includes bibliographical references (leaf 35).
Subjects: Children with disabilities; Database management.;
Available copies: 1 / Total copies: 2
On-line resources: Suggest title for digitization;
unAPI

Access 2019 bible / by Alexander, Michael,1972-author.(CARDINAL)475485; Kusleika, Dick,author.(CARDINAL)609555;
Access building blocks. An introduction to database development ; Getting started with Access -- Understanding Access tables. Creating Access tables ; Understanding table relationships ; Working with Access tables ; Importing and exporting data ; Linking to external data -- Working with Access queries. Selecting data with queries ; Using operators and expressions in Access ; Going beyond select queries -- Analyzing data in Microsoft Access. Transforming data in Access ; Working with calculations and dates ; Performing conditional analyses ; The fundamentals of using SQL ; Subqueries and domain aggregate functions ; Running descriptive statistics in Access -- Working with Access forms and reports. Creating basic Access forms ; Working with data on Access forms ; Working with form controls ; Presenting data with Access reports ; Advanced Access report techniques -- Microsoft Access programming fundamentals. Using Access macros ; Using Access data macros ; Getting started with Access VBA ; Mastering VBA data types and procedures ; Understanding the Access event model ; Debugging your Access applications -- Advanced Access programming techniques. Accessing data with VBA ; Advanced data Access with VBA ; Customizing the ribbon ; Preparing your Access application for distribution ; Integrating Access with SharePoint.Learn the essentials of using Microsoft Access to store data, analyze information, build reports, create applications and much more! With "Microsoft Access 2019 bible", you'll gain a solid understanding of how Access works from the ground up. Starting with basic database concepts, you'll work your way through detailed instruction on building effective tables, creating powerful analytical queries, creating robust applications with Access forms, and building attractive Access reports. With additional topics covering SharePoint integration and Visual Basic programming, "Microsoft Access 2019 bible" is an invaluable resource for users of all skill levels.
Subjects: Handbooks and manuals.; Microsoft Access.; Microsoft Access; Database management.;
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

Access 2000 for Windows for dummies / by Kaufeld, John.(CARDINAL)274618;
Subjects: Microsoft Access.; Microsoft Windows (Computer file); Database management.;
Available copies: 1 / Total copies: 2
unAPI

Beginning Access 97 VBA programming / by Smith, Robert,1944-(CARDINAL)462811; Sussman, David,1966-(CARDINAL)334303;
Subjects: Microsoft Access.; Microsoft Windows (Computer file); Database management.;
Available copies: 1 / Total copies: 1
unAPI

Microsoft 365 Access / by Ulrich-Fuller, Laurie,1961-author.(CARDINAL)351956; Cook, Ken,1959-author.(CARDINAL)351955;
"In the newly revised edition of Microsoft Access For Dummies, professional database developer and Access extraordinaire Laurie Ulrich-Fuller walks you through the ins-and-outs of one of the world's most popular database platforms. This is the perfect beginner's guide to Microsoft Access, showing you how to create databases, extract data, create reports, and more. The author demonstrates a ton of tips, tricks, and best practices you can use immediately to create, maintain, and improve your databases"--
Subjects: Database management.; Microsoft Access.; Microsoft Windows (Computer file);
Available copies: 6 / Total copies: 6
unAPI

Results 31 to 40 of 219 | « previous |