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