-
SQL – Where Clause
SQL – Where Clause Table Of Contents: What Is SQL Where Clause? Syntax Of Where Clause. Examples Of Where Clause. Where Clause Operations. (1) What Is SQL Where Clause ? Where clause is used to select the specific records for you. It will only display the records you want to see. (2) Syntax Of Where Clause ? SELECT column1, column2, … FROM table_name WHERE condition; (3) Examples Of Where Clause ? Demo Data: Example-1: SELECT * FROM Customers WHERE Country=’Mexico’; Example-2: SELECT * FROM Customers WHERE CustomerID=1; (4) Where Clause Operations? Example-3: SELECT * FROM Products WHERE Price = 18;
-
SQL – Select Distinct Statement
SQL – Select Distinct Statement Table Of Contents: What Is Select Distinct Statement? Syntax Of Select Distinct. Examples Of Select Distinct. (1) What Is Select Distinct Statement ? The SELECT DISTINCT the statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; sometimes you only want to list the different (distinct) values. (2) Syntax Of Select Distinct. SELECT DISTINCT column1, column2, … FROM table_name; (3) Examples Of Select Distinct. Demo Data Example-1: Select Only Different Country Names SELECT DISTINCT Country FROM Customers; Example-2: Select a Different City and Country Combination. SELECT DISTINCT
-
SQL – Select Statement
SQL Select Statement Table Of Contents: What Is SQL SELECT? SELECT Syntax. SELECT Examples. (1) What Is SQL Select We use the “SELECT” statement to retrieve data from the database. The data returned is stored in a result table, called the result set. (2) SELECT Syntax SELECT column1, column2, … FROM table_name; (3) SELECT Examples Demo Dataset: Example-1: SELECT CustomerName, City FROM Customers; Example-2: SELECT CustomerName, City FROM Customers; Example-3: SELECT PostalCode FROM Customers;
-
SQL – Syntax Rules
SQL Syntax Rules Rules To Follow: SQL keywords are NOT case sensitive: select is the same as SELECT SQL statement cannot be followed by another statement on the same line. Place a semicolon (;) at the end of the last clause. Example-1: SQL Select Statement SELECT column1, column2….columnN FROM table_name; Example-2: SQL CREATE TABLE Statement CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ….. columnN datatype, PRIMARY KEY( one or more columns ) );
-
SQL – Introduction
SQL -Introduction (1) What Is SQL? SQL Stands for Structured Query Language. SQL is a query language which helps us to send queries to the database and get our results back. Language allows us to talk to another person and get connected with each other. Similarly, SQL language helps us to connect with the SQL database and get our results. (2) What SQL Can Do? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records into a database SQL can update records in a database SQL can delete records from a database
-
SQL – Syllabus
SQL Syllabus Part-1 Introduction To SQL SQL Syntax Rules SQL Select Statement SQL Select Distinct Statement SQL Where Statement SQL And, Or, Not Keywords Part-2 SQL Order By Statement SQL Insert Into Statement SQL NULL Values SQL Update Statement SQL Delete Statement SQL Select Top Statement Part-3 SQL Min and Max Functions SQL Count(), Avg(), Sum() Functions SQL Like Keyword SQL Wild Card Characters SQL In Keyword SQL Between Operator SQL Aliases Part-4 SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join Part-5 SQL Union SQL Group By SQL Having SQL Exists
-
GIT – How To Push Code To A Repository?
How To Push Code To A Repository? Table Of Contents: What Is GIT Push? Examples Of GIT Push? (1) What Is GIT Push ? The git push the command is used to upload local repository content to a remote repository. Push will upload your changes from the local repo to the remote repository. (2) Examples Of GIT Push ? Syntax: git push <Remote URL> Example-1: Using URL git push https://github.com/Subrat/Project.git Example-2: Using origin git push origin Example-3: Pushing Specific Branch git push origin branch1
-
GIT – How To Pull Code From Repository ?
How To Pull Code From A Repository? Table Of Contents: What Is GIT Pull? Examples Of GIT Pull. (1) What Is GIT Pull ? The “git pull” the command is used to fetch and download content from a remote repository and immediately update the local repository to match that content. “git pull” is the combination of two commands “git fetch” and “git merge”. git fetch which downloads content from the specified remote repository. git merge is executed to merge the remote content refs and heads into a new local merge commit. (2) Examples Of GIT Pull ? Syntax: git pull <Remote URL> Example-1:
-
GIT – How To Fetch Code From Remote ?
How To Fetch Code From Remote? Table Of Contents: What Is Git Fetch? Examples Of Git Fetch? Difference Between Fetching and Pulling? (1) What Is GIT Fetch? You can use git fetch to know the changes done in the remote repo/branch since your last pull. This is useful to allow for checking before doing an actual pull, which could change files in your current branch and working copy (and potentially lose your changes, etc). (2) Examples Of GIT Fetch? Example-1: Fetching Remote Repository git fetch <repository Url> git fetch https://github.com/Subrat/Project.git It will download all the changes and keep them in a separate
-
GIT – What Is GIT Remote ?
What Is GIT Remote? Table Of Contents: What Is GIT Remote? How To Check Your Remote Repository Details ? (1) What Is GIT Remote ? ‘Remote’ is the keyword used for to check the remote repository configuration. A remote repository is stored on code hosting services like an internal server, GitHub, Subversion, Bitbucket and more. (2) How To Check Your Remote Repository Details ? Syntax: git remote Output: origin The default name for the remote repository is the ‘origin’. Syntax: git remote -v Output: origin https://github.com/Subrat/Project.git(fetch) origin https://github.com/Subrat/Project.git(push) The above output is providing available remote connections. If a repository contains
