SQL Server Power Search - Get More Relevant Results

Learn SQL

 

If you work with SQL Server it is essential that you learn SQL.

While the majority of administrative tasks can be performed using Management Studio, and some limited queries can also be performed, you are missing out on some of the real power of the product if you don't know SQL.

The problem with learning something as powerful and complex as SQL is that it is not obvious where to start. There are some very good books available, but where do you look on the internet? This section of SQL Server Pro is intended to teach the language, starting with the basics and gradually introducing more advanced concepts.

I have structured this section into a number of tutorials, starting with a summary of the basic SQL commands, moving onto ways of selecting data, and then covering some more advanced topics. I will add more tutorials soon, describing how to insert, update and delete rows.

 

Basic SQL Commands

This article covers the 4 essential and basic SQL commands, namely SELECT, INSERT, UPDATE and DELETE. Further articles are available that go into more depth on each command...

SQL SELECT Query

This article describes the SQL SELECT query in a little more detail and includes the JOIN and ORDER BY clauses...

SQL WHERE Clause

The SQL WHERE clause is used to restrict the number of rows returned by a query. This article describes some of the common ways it can be used...

SQL Subquery

The SQL subquery is a separate SELECT statement that is embedded in the main statement and may be executed once for each row of the result set...

SQL GROUP BY

The SQL GROUP BY clause is a powerful way of summarizing and aggregating data...

SQL JOIN

The SQL JOIN enables rows from 2 or more tables to be combined in a single query...

SQL UNION

The SQL UNION statement allows the results from multiple SELECT statements to be combined...

SQL ORDER BY

The SQL ORDER BY clause explained with examples and situations where it cannot be used...

SQL LIKE

SQL LIKE is a simple but powerful pattern matching operator. This article describes the syntax, with examples...