SQL Tutorials for Business Analyst

In-Depth Guide to Star Schema in Data Warehouse Modeling: Concepts, Design Principles, and Advantages

In-Depth Guide to Star Schema in Data Warehouse Modelling: Concepts, Design Principles, and Advantages

Beginners Guide to R – R Vector

R Vector A vector is a collection of elements, all the same type (similar to an array in other programming languages but more versatile). When using R, you will frequently encounter the four basic vector types viz. logical, character, integer and double (often called numeric). Create a vector In R, there are several ways to …

SQL with Examples : SQL DELETE Statement

SQL DELETE Statement The DELETE statement is used to delete data from a table. It can be used in two ways: To delete specific rows from a table To delete all rows from a table Now let’s take a look at each of these in detail. Syntax DELETE FROM table_name WHERE condition; Sample Table To …

SQL with Examples : SQL UPDATE Statement

SQL UPDATE Statement The UPDATE statement allows you to update existing rows with new values. With it, you can change the value of one or more columns in each row that meets the search condition of the WHERE clause. Syntax The UPDATE statement is made up of three parts: The table you want to update …

SQL with Examples : SQL INSERT SELECT Statement

SQL INSERT SELECT Statement INSERT statement is commonly used to insert a row into a table using specified values. There is a second form of INSERT that inserts the result of a SELECT statement in a table, known as INSERT SELECT. As its name suggests, it is made up of an INSERT statement and a SELECT …

SQL with Examples : SQL INSERT INTO Statement

SQL INSERT INTO Statement The INSERT INTO statement allows you to insert one or more new rows into a table. Using the INSERT INTO statement, it is possible to insert a complete row, a partial row, multiple rows or rows generated as the result of a query. Let’s now take a look at each of …

SQL with Examples : SQL Aggregate Functions

SQL Aggregate Functions It is often necessary to summarize data for analysis and reporting purposes. Be it determining the number of rows in a table, obtaining the sum of column’s values, or finding the column’s highest, lowest, or average value. Aggregate functions are used for this type of retrieval. Although each DBMS has its own …

SQL with Examples : SQL LIKE Operator

SQL LIKE Operator Until now you have been using operators such as conditional operators (for testing equality), BETWEEN operator (for checking against a range of values) or IN operator (for checking against a set of values) in which one thing is common; They all search for an exact match. Filtering data that way is all well and good. But sometimes a …

SQL with Examples : SQL IN Operator

SQL IN Operator The IN operator allows you to test whether a value falls within a set of values. A set can be a list of literal values, or the result of a subquery. Syntax The IN operator must be followed by a comma-delimited list of valid values enclosed within parentheses. SELECT column_name(s) FROM table_name …