Home > Articles > Data > SQL

SQL

83 Items

Sort by Date | Title

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.
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.
SQL Queries for Mere Mortals: Thinking in Sets
By Michael J. Hernandez
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
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
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
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.
Enhanced Connectivity from SQL to SharePoint to Office
Jul 12, 2010
Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!
SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
Nov 3, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
Oracle SQL: The Basics
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
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
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
Dec 2, 2008
Learn why you should let the ADO.NET Entity Framework be your data access layer.
SQL Fundamentals: Storing Information in Tables
Oct 8, 2008
This chapter examines SQL tables in detail.

Page 1 2 3 4 5 Next >