SQL CREATE TABLE Statement

I am a software Developer. I hold Bachelor degree in Tech. My main skills are Angular, C#, ASP.Net, MVC, Javascript, JQuery, SQL Server.
Ajay Nagar
Latest posts by Ajay Nagar (see all)

Introduction In this article you will learn how to create table using SQL. syntax SQL CREATE TABLE Example Output EmployeeID LastName FirstName Address City

Continue Reading

Learn About SQL Data Types

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

SQL Data Types Data types are used to represent the kind of data that can be stored in the database table. Data types mainly classified into three categories. String Data types Numeric Datatypes Date and Time Data type String Data Types in MySQL CHAR(Size) From 0 to 255 characters. The default value is 1. VARCHAR(Size) […]

Continue Reading

ALTER TABLE Clause In SQL

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

THE SQL ALTER TABLE CLAUSE The SQL ALTER TABLE Clause is used to add, update, or drop/delete columns in a table. The SQL ALTER TABLE Clause is also used to rename a table. Add a column in the table Syntax To add a column in a table, the ALTER TABLE syntax in SQL is, ALTER TABLE table_name […]

Continue Reading
SQL

UPDATE Clause In SQL

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

The SQL UPDATE CLAUSE The SQL UPDATE Clause is used to update existing records in the tables. Syntax UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition; Example UPDATE solo SET Name = “SQLSERVER” WHERE id=109; Output Conclusion In this article, you will understand how to modify or update the existing records in a table.

Continue Reading
SQL

ORDER BY Clause In SQL

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

The SQL ORDER BY Clause The ORDER BY Clause is used to sort the result-set in ascending or descending order. Syntax The syntax for the ORDER BY clause in SQL is      SELECT column1, column2, …      FROM table_name      ORDER BY column1, column2, … ASC|DESC; Example SELECT * FROM solo ORDER BY Name; The ORDER BY Clause […]

Continue Reading
SQL

How Do You Use The SQL*Loader Utility

Aastha sharma is Data Analyst and XML Developer, having 4 years of experience EBook Publication.
Aastha Sharma
Latest posts by Aastha Sharma (see all)

EXAMPLE 1 Follow the Below Steps, Step 1 Below is the sample data. Put this data in a Microsoft Excel sheet and save it as a comma-separated file named emp_detail.csv. Tom 1023424 Andrew 1014224 Richard 1033422 Step 2 Below is the sample control file (emp.ctl) that will load an external data file containing delimited data […]

Continue Reading
SQL

How To Create Tables And Insert Data Into Database

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

How to Create Table The CREATE TABLE statement is used to create a new table in a database. CREATE TABLE table_name(     column 1 datatype ,    column 2 datatype ,     ………………………….. ); Where Column 1, Column 2 is the Name Of Column. Example CREATE TABLE Student(           […]

Continue Reading
SQL

SQL WHERE Clause

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

How do I use the SQL WHERE clause? The SQL WHERE clause filters for rows that meet certain criteria. WHERE Clause is used with SELECT, UPDATE, and DELETE. Syntax The SELECT statement with a WHERE clause, SELECT column1, column2, … FROM table_name WHERE condition; Example SELECT id, Phone, Name, Age, City FROM s1 WHERE id=101;

Continue Reading
SQL

Learn About SQL SELECT Statement

JYOTI MISHRA recently I have completed my post graduation in MCA from DAVV A+ University and I am a Software Tester and I have also worked in Python, SQL.
Jyoti Mishra
Latest posts by Jyoti Mishra (see all)

Please read my previous article here, How To Create Tables And Insert Data Into Database How do I get data from a database?  The SELECT statement is used to retrieves data from a database.  The data is returned in a table-like structure called a result-set.  Syntax  The general syntax is, SELECT column1, column2,…… FROM table_name; […]

Continue Reading
SQL

Learn About SQL Join – Inner Join

Rashmi Tyagi working on Microsoft Technologies for more than 3+ years. Skilled in C#.NET, Angular7, NodeJs, ASP.NET, ADO.NET, SQL Server, Web Services, WebApi.
Rashmi Tyagi

When we combine data or rows from two or more tables we called them to join. A SQL Join statement executed between tables common field. Different types of Joins are, INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN Inner Join The INNER JOIN selects all rows from all the tables as long as the condition […]

Continue Reading