Catalog Search Results
Author
Description
Learn how databases work and how you can start designing one of your own.
Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles. Adam Wilbert covers the basics of relational...
Author
Description
Modeling phenomena with a relational database is an invaluable skill in today’s big-data world. This course covers the fundamentals of the relational model for creating databases.
In today’s big-data world, understanding how to model phenomena with a relational database is an invaluable skill. A variety of different users—from government agency employees to gamers—rely on relational databases for everyday operations. In this course, join...
Author
Description
Overview: Includes Coverage of Oracle and Microsoft SQL Implementations. In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security. This book's straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will...
Author
Formats
Description
Uncover the secrets of SQL and start building better relational databases today!
This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure
Author
Description
"Master the SQL statements that every application developer needs for retrieving and updating the data in a MySQL database; design databases like a pro and code the SQL statements that create databases, tables, indexes, and views; gain professional skills like using transactions, stored procedures, functions, triggers, and events; and get started as a DBA by leanring how to configure the server, manage security, create backups, and host a database...
Author
Description
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you'll tackle dynamic web programming with the latest versions of today's core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries. Web designers will learn how to use these technologies together and pick up valuable web programming...
Author
Description
If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite. In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both...
Author
Description
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...
Author
Description
Get a high-level view of the basics of NoSQL, from how it differs from relational databases to its pros and cons.
As the shiny new object in the data world, you might have heard a lot of people talk excitedly about NoSQL and all the things it can do. It’s great in terms of flexibility, speed, and is easy to work with. It’s super scalable, so it can accommodate increased numbers of users as websites and applications grow. But will it replace SQL?...
Author
Description
Get an introduction to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio.
This course with database expert Adam Wilbert introduces you to creating relational databases with SQL Server and the graphical interface, SQL Server Management Studio. Adam walks you through your first steps in the newest edition of Microsoft's database management system. He takes a detailed look at creating efficient tables...
Author
Formats
Description
"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...
Author
Description
Discover how to use Hibernate ORM, an object-relational mapping framework for the Java language, to map an object-oriented domain model to a relational database.
Working with both object-oriented software and relational databases can be time consuming. Due to a paradigm mismatch between how data is represented in objects (which are usually nonscalar values) versus relational databases (where scalar values are organized in tables) development costs...
Author
Description
Get a holistic overview of the essential elements of designing and implementing highly scalable and available relational databases.
Online activities, mobile devices, and Internet of Things (IoT) sensors are generating immense volumes of data. Much of that data requires relational database capabilities, such as consistent reads/writes and complex transaction processing. In this course, get a holistic overview of the essential elements of designing...
17) Learning JDBC
Author
Description
Learn how to manage data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server using Java Database Connectivity (JDBC) in Java programmed applications.
Whether developers want to build mobile device apps for Android or web-based or desktop-based applications with the core Java SDK from Oracle, they must contend with the fact that many dynamic applications need to integrate data from a relational database. In this course,...
Author
Description
Discover the top five skills to know in Microsoft SQL Server to manage data-driven insights more efficiently for your business.
Are you looking to enhance your skills in data analysis and become a valuable asset in today's data-driven business world? Learning SQL, the widely used language for managing relational databases, can be a game changer for you. In this course, you will learn the fundamental skills needed to navigate and analyze data effectively....
Author
Description
Learn about data schemas and dimensions, different data types, common data structures, and file formats, so that you can pass domain 1 of the CompTIA Data+ (DAO-001) exam.
Are you seeking your CompTIA Data+ certification? This course is part of a six-course series preparing you for the Data+ exam. In this course, Mike Chapple, a professor of information technology, analytics, and operations, presents information that you’ll need to know about data...
Author
Description
Explore how models and associations in Ruby on Rails provide an object-oriented interface to relational databases, automate common tasks, and speed up web application development.
Ruby on Rails can speed up and improve the development of full-featured web applications through powerful tools that provide an object-oriented interface to relational databases and automate common data tasks. In this course, extend your knowledge of Ruby on Rails as instructor...
In Interlibrary Loan
Didn't find what you need? Items not owned by Nashville can be requested from other Interlibrary Loan libraries to be delivered to your local library for pickup.
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request