- 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.
|