Home > Articles > Data > SQL

SQL

RSS Feed Subscribe to this topic  RSS details

83 Items

Sort by Date | Title

SQL Queries: Summarizing Data Results from a Query in SQL
By Ron Plew, Ryan Stephens, Arie D. Jones
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
By Dan Hotka
Nov 26, 2015
In this excerpt from Oracle SQL LiveLessons (Video Training), Downloadable Version, Dan Hotka discusses analytical functions.
Video: Oracle SQL: Understanding Multiple Table Joins
By Dan Hotka
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
By Dan Hotka
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
By Ben Forta
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
By Ben Forta
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
By Ben Forta
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
By Ben Forta
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.
SQL Queries for Mere Mortals: Thinking in Sets
By Michael J. Hernandez, John Viescas
Jul 1, 2014
This chapter introduces the concept of an SQL set. It discusses each of the major set operations implemented in SQL in detail (intersection, difference, and union), and shows how to use set diagrams to visualize the problem you’re trying to solve. Finally, it introduces the basic SQL syntax and keywords (INTERSECT, EXCEPT, and UNION) for all three operations.
Retrieving Data Using the SQL SELECT Statement
By Ben Forta
Dec 10, 2012
In this lesson, learn how to use the SELECT statement to retrieve one or more columns of data from a table.
SQL Standards and Guidelines for DB2 Developers
By Tony Andrews
Oct 15, 2012
This chapter shows how to create a set of SQL standards and guidelines for developers to follow when running applications that involve DB2.
Managing SQL Database Objects
By Arie D. Jones, Ron D. Plew, Ryan Stephens
Jun 16, 2011
In this chapter you will learn about database objects: what they are, how they act, how they are stored, and how they relate to one another.
SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
By Arie D. Jones
Nov 3, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
By Arie D. Jones
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
Oracle SQL: The Basics
By Alice Rischert
Aug 25, 2009
In this chapter you will learn the basics of the SQL language and use SQL Developer and SQL*Plus.
Object Relational Mapping and Java Persistence: Data Modeling and Legacy Schemas
By Stephen B. Morris
Jun 23, 2009
Stephen Morris tackles object relational mapping (ORM) techniques. This includes entity and value type component mapping and database design workflow.
SQL Expressions, Conditions, and Operators
By Arie D. Jones, Ron Plew, Ryan Stephens
Jun 18, 2009
This lesson introduces SELECT and FROM and expands the basic query with some new terms, a new clause, and a group of handy items called operators.
Using Entity SQL As Your Data Access Layer
By Paul Kimmel
Dec 2, 2008
Learn why you should let the ADO.NET Entity Framework be your data access layer.
SQL Fundamentals: Storing Information in Tables
By John J. Patrick
Oct 8, 2008
This chapter examines SQL tables in detail.
Querying SQL with LINQ
By Paul Kimmel
Jul 28, 2008
With LINQ and LINQ to SQL, never again should you have to write a data access layer.

Page 1 2 3 4 5 Next >