SQL Server Programming Fundamentals (3) :: BlackWasp Software Development

<< Previous | 1 | 2 | 3 | 4 | 5 | 6 | Next >> |

SQL Server Views
The twenty-first part of the SQL Server Programming Fundamentals tutorial examines the use of views. A view is a predefined SELECT statement that can be used as a virtual table, hiding complexities such as joins and filters from the consumers of the view.

SQL Server Indexed Views
The twenty-second part of the SQL Server Programming Fundamentals tutorial describes indexed views. An indexed view is simply a view that has a unique clustered index and, optionally, one or more non-clustered indexes defined to improve query performance.

SQL Server Stored Procedures
The twenty-third part of the SQL Server Programming Fundamentals tutorial describes stored procedures. A stored procedure allows you to create a script, or batch, containing multiple commands to be executed, potentially being controlled by parameters.

SQL Server Check Constraints
The twenty-fourth part of the SQL Server Programming Fundamentals tutorial describes check constraints. These constraints add business rules to database tables to prevent invalid information being stored and damaging the domain integrity of the database.

SQL Server Union Operations
The twenty-fifth part of the SQL Server Programming Fundamentals tutorial takes a step back from creating database schemas and procedures and returns to queries. In this article we consider the use of the UNION keyword in Transact-SQL.

SQL Server Except and Intersect
The twenty-sixth part of the SQL Server Programming Fundamentals tutorial reviews two set operations that are available in SQL Server 2005 queries. Both EXCEPT and INTERSECT use a combination of two sets of results to determine the rows returned.

SQL Server Basic Aggregation Functions
The twenty-seventh part of the SQL Server Programming Fundamentals tutorial describes the use of the aggregation functions that can be used when executing queries. These functions allow you to perform calculations based upon multiple result rows.

SQL Server Grouping
The twenty-eighth part of the SQL Server Programming Fundamentals tutorial adds to the description of the use of aggregate functions within queries. In this article the GROUP BY and HAVING clauses are used to summarise groups of similar result rows.

SQL Server Summaries with ROLLUP and CUBE
The twenty-ninth part of the SQL Server Programming Fundamentals tutorial describes the ROLLUP and CUBE clauses, which can be used when grouping data. These clauses create additional summary rows containing aggregated values from multiple groups of rows.

SQL Server Subqueries
The thirtieth part of the SQL Server Programming Fundamentals tutorial examines subqueries. These can be nested queries allowing complex selections that are not possible using joins. They can also be used to update rows using the contents of other tables.

<< Previous | 1 | 2 | 3 | 4 | 5 | 6 | Next >> |