Search:

Results 1 to 10 of 20 |

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

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

SQL / by Russell, Jesse.;
Subjects: SQL server.; Client/server computing.; Database management.;
Available copies: 1 / Total copies: 1
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

Microsoft SQL Server 2016 : a beginner's guide / by Petković, Dušan,author.(CARDINAL)656979;
Relational database systems: an introduction -- Planning the installation and installing SQL server -- SQL server management studio -- SQL components -- Data definitions language -- Queries -- Modification of a table's contents -- Stored procedures and user defined functions -- System catalog -- Indices -- Views -- Security system of the database engine -- Concurrency control -- Triggers -- System environment of the database engine -- Backup, recovery, and system availability -- Automating system administration tasks -- Data replication -- Query optimizer -- Performance tuning -- In-memory OLTP -- Business intelligence: an introduction -- SQL server analysis services -- Business intelligence and transact-SQL -- SQL server reporting services -- Optimizing techniques for data warehousing -- Columnstore indices -- XML and JSON integration in the database engine -- Spatial and temporal data -- SQL server full-text search.Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features. Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.
Subjects: Handbooks and manuals.; SQL server.; Database management.; Client/server computing.;
Available copies: 2 / Total copies: 3
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

Database processing : fundamentals, design, & implementation / by Kroenke, David M.,1946-(CARDINAL)166328;
Includes bibliographical references (pages 587-588) and index.System requirements: PC with Pentium or Alpha processor (166 MHz or higher); Windows 95, Windows 98 or Windows NT; 32 MB RAM; 80 MB hard disk space for minimum installation, 185 MB for typical installation.
Subjects: Database management.;
Available copies: 1 / Total copies: 1
On-line resources: Suggest title for digitization;
unAPI

Databases demystified / by Oppel, Andrew J.(CARDINAL)545330;
Presents a guide that gives readers necessary information to build and manage their own database, including how to form database queries, connect databases to applications, and store data for analysis.Young AdultYoung Adult
Subjects: Databases.;
Available copies: 1 / 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

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

Results 1 to 10 of 20 |