Home > Articles > Data

Data

535 Items

Sort by Date | Title

Big Data Adoption and Planning Considerations
Feb 8, 2016
Big Data adoption can enable the sort of innovation that fundamentally alters the structure of a business, either in its products, services or organization. However, innovation management requires care: too many controlling forces can stifle the initiative and dampen the results, and too little oversight can turn a best intentioned project into a science experiment that never delivers promised results. It is against this backdrop that this chapter from Big Data Fundamentals: Concepts, Drivers & Techniques addresses Big Data adoption and planning considerations.
Getting Started with Data Science: Hypothetically Speaking
Feb 2, 2016
This chapter from Getting Started with Data Science: Making Sense of Data with Analytics introduces the basic concepts of random numbers and probability distributions. It provides a formal introduction of Normal and t-distributions, which are commonly used for statistical models. Finally, it explores hypothesis testing for the comparison of means and correlations.
SQL Queries: Summarizing Data Results from a Query in SQL
Jan 28, 2016
Aggregate functions can be useful and are quite simple to use. In this chapter from SQL in 24 Hours, Sams Teach Yourself, 6th Edition, you learn how to count values in columns, count rows of data in a table, get the maximum and minimum values for a column, figure the sum of the values in a column, and figure the average value for values in a column.
Video: Oracle SQL: Use Analytical Functions
Nov 26, 2015
In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka discusses analytical functions.
Creating a SQL Server Database
Nov 25, 2015
This lesson from T-SQL in One Hour a Day, Sams Teach Yourself covers how to create a SQL Server database, how to set database options, how to work with the Transaction Log, and how to attach to an existing database.
Video: Oracle SQL: Understanding Multiple Table Joins
Nov 24, 2015
In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka discusses table joins.
Video: Oracle SQL: Exploring Date Functions
Nov 20, 2015
In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka shows you how to work with date functions and date format functions.
Video: Learning SQL: Use the SELECT Statement
Nov 19, 2015
In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta shows you how to use the SQL statement that you will use the most: The SELECT statement.
Video: Learning SQL: Review Database Basics
Nov 17, 2015
In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta covers database basics, including what a database is, the purpose of tables, columns and rows, relational databases, and keys.
Video: Learning SQL: Retrieve Individual Columns
Nov 13, 2015
In this excerpt from Learning SQL LiveLessons (Video Training), Ben Forta looks at a simple SELECT statement that will retrieve a single column from a table.
Using the SELECT Statement to Retrieve Data in SQL
Oct 14, 2015
In this lesson from Oracle PL/SQL in 10 Minutes, Sams Teach Yourself, you’ll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
Choosing Design Patterns for Your Document Databases
Sep 23, 2015
Dan Sullivan (author of NoSQL for Mere Mortals) and James Sullivan discuss the options for modeling various design patterns in a document database system.
NoSQL Key-Value Database Simplicity vs. Document Database Flexibility
Sep 16, 2015
Dan Sullivan (author of NoSQL for Mere Mortals) and James Sullivan explore the features and advantages of two widely used types of NoSQL databases.
6 Reasons to Migrate Your Oracle Databases Twice as Fast to Release 12.1.0.2
Sep 15, 2015
Oracle Database 11.2.0.4 is the terminal release for Oracle 11g R2, and extended support for that release ends as of December 2015. Yet many Oracle shops haven't accelerated their pace to transition to Oracle Database 12c R1. Oracle ACE Director Jim Czuprynski, author of Oracle Database 12c New Features, Part 1 LiveLessons, explains why Oracle DBAs should redouble their upgrade efforts to take advantage of six key feature sets available in Oracle Database 12.1.0.2.
Relational Versus NoSQL Databases: Which Is Right for Your Database Application?
Sep 9, 2015
Dan Sullivan (author of NoSQL for Mere Mortals) and James Sullivan summarize the main factors to consider when deciding whether to go with a relational database or a NoSQL database for your application.
An Interview with Bert Scalzo and Dan Hotka on Toad for Oracle
Aug 27, 2015
Data expert Phyllis Helton talks to Bert Scalzo and Dan Hotka, co-authors of Toad for Oracle Unleashed, about some of their favorite features in Toad, their thoughts on GUI tools, and advice for people new to developing using Oracle and Toad.
Working with the PowerShell Desired State Configuration, Part 1: Theory and Initial Setup
Aug 24, 2015
Timothy Warner, author of Sams Teach Yourself Windows PowerShell 5 in 24 Hours, shares the advantages of the PowerShell Desired State Configuration (DSC) for keeping your network configuration from being changed inadvertently (or intentionally).
Understanding the Big Data World
Aug 20, 2015
The data volume, velocity, variety, and need to perform analytics on data from multiple different sources are disrupting business. The authors of Virtualizing Hadoop discuss how big data solutions such as Hadoop, in-memory, distributed search, and NoSQL are solutions for addressing the data disruption.
Toad for Oracle Unleashed: Working with SQL
Aug 3, 2015
This chapter from Toad for Oracle Unleashed covers various aspects of the SQL Editor window, such as various modes to compile and execute code, using Toad history for past SQL, enhancing the interface to best fit your needs, using little-known items within the SQL Editor, code templates, and building SQL without typing.
Querying Neo4j with Cypher
Jul 29, 2015
Steven Haines concludes his three-part series on Neo4j with an overview of Cypher, Neo4j's custom query language. Learn by example how to build basic single-element queries, and then move on to structuring multiple-level queries that are surprisingly readable.

Page 1 2 3 4 5 Next >