Month: September 2020

SQL tutorials for Business Analyst – SQL | AND and OR Conjunctive Operators

Hits: 23 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | AND and OR Conjunctive Operators.   The SQL AND & OR operators are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called as the conjunctive operators. These …

SQL tutorials for Business Analyst – SQL | WHERE Clause

Hits: 36 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | WHERE Clause.   The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given condition is satisfied, …

SQL tutorials for Business Analyst – SQL | SELECT Query

Hits: 15 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SELECT Query.   The SQL SELECT statement is used to fetch the data from a database table which returns this data in the form of a result table. These result tables are called …

SQL tutorials for Business Analyst – SQL | INSERT Query

Hits: 23 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | INSERT Query.   The SQL INSERT INTO Statement is used to add new rows of data to a table in the database. Syntax There are two basic syntaxes of the INSERT INTO statement …

SQL tutorials for Business Analyst – SQL | DROP or DELETE Table

Hits: 18 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | DROP or DELETE Table.   The SQL DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. NOTE − You should …

SQL tutorials for Business Analyst – SQL | CREATE Table

Hits: 23 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | CREATE Table.   Creating a basic table involves naming the table and defining its columns and each column’s data type. The SQL CREATE TABLE statement is used to create a new table. Syntax …

Excel formula for Beginners – How to Sort by one column in Excel

Hits: 28   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by one column in Excel.   Excel formula for Beginners – How to Sort by one column in Excel Generic formula =SORT(data,index,order) Explanation To sort by one column, you can use …

Excel formula for Beginners – How to Sort by custom list in Excel

Hits: 40   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by custom list in Excel.   Excel formula for Beginners – How to Sort by custom list in Excel Generic formula =SORTBY(rng,MATCH(rng,custom,0)) Explanation To sort a list in a custom order, you …

Excel formula for Beginners – How to get Sequence of years in Excel

Hits: 14   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to get Sequence of years in Excel.   Excel formula for Beginners – How to get Sequence of years in Excel Generic formula =DATE(SEQUENCE(12,1,YEAR(A1)),MONTH(B5),DAY(A1)) Explanation To generate a series of dates by year, …

Excel formula for Beginners – How to get Sequence of times in Excel

Hits: 26   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to get Sequence of months in Excel.   Excel formula for Beginners – How to get Sequence of times in Excel Generic formula =TIME(SEQUENCE(n,1,HOUR(start),1),0,0) Explanation To generate a sequence of times, you can …

SQL tutorials for Business Analyst – SQL | SELECT Database, USE Statement

Hits: 18 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | SELECT Database, USE Statement.   When you have multiple databases in your SQL Schema, then before starting your operation, you would need to select a database where all the operations would …

SQL tutorials for Business Analyst – SQL | DROP or DELETE Database

Hits: 10 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | DROP or DELETE Database.   The SQL DROP DATABASE statement is used to drop an existing database in SQL schema. Syntax The basic syntax of DROP DATABASE statement is as follows − DROP …

SQL tutorials for Business Analyst – SQL | CREATE Database

Hits: 7 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | CREATE Database.   The SQL CREATE DATABASE statement is used to create a new SQL database. Syntax The basic syntax of this CREATE DATABASE statement is as follows − CREATE DATABASE DatabaseName; Always …

SQL tutorials for Business Analyst – SQL | Expressions

Hits: 11 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Expressions.   An expression is a combination of one or more values, operators and SQL functions that evaluate to a value. These SQL EXPRESSIONs are like formulae and they are written …

SQL tutorials for Business Analyst – SQL | Operators

Hits: 12 (SQL tutorials for Business Analyst & Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: SQL | Operators.   What is an Operator in SQL? An operator is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform operation(s), such as comparisons …