Discussion SQL is a database computer language designed for the retrieval and management of data in a relational database. This tutorial will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works. Why to Learn SQL? SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. Allows users to describe the data.
|Published (Last):||6 January 2009|
|PDF File Size:||14.2 Mb|
|ePub File Size:||18.1 Mb|
|Price:||Free* [*Free Regsitration Required]|
If you are a software developer, database administrator, data analyst, or data scientist who wants to use SQL to analyze data, this tutorial is a great start. Each topic is covered clearly and concisely with many practical examples so that you can both truly understand the concept and know how to apply it to solve the data problems more effectively. Today, SQL is one of the most common programming languages for interacting with data. Comparison operators — learn how to use the comparison operators including greater than, greater than or equal, less than, less than or equal, equal, and not equal to form the condition in the WHERE clause.
Logical operators — introduce the logical operators and how to use them to test for the truth of a condition. Section Subquery Subquery — show you how to nest a query inside another query to form a more flexible query for querying data.
Correlated Subquery — introduce you to the correlated subquery which is a subquery that uses values from the outer query. ALL — illustrate how to query data by comparing values in a column of the table with a set of columns. ANY — query data if a value in a column of a table matches one of value in a set.
Order By — guides you on how to sort the result set returned from a query. Section 3. Fetch — limits the number of rows returned by a query. Is Null — checks if a value is null or not. Section 4. Self-join — joins a table to itself by comparing a table to itself.