Day: September 14, 2020

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

Hits: 6   (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: 5   (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: 14 (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: 9 (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: 6 (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: 10 (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 …