My Tech Knowledge

Hello, and welcome to the blog. In this blog we are going to talk about "Queries" in database. As we discussed in my previous blog (  https://learntocodewithmustafapinjari.blogspot.com/2020/07/basics-of-sql.html ) that SQL is used for performing different operations on database. But how SQL do it? It is actually actually done by "Queries". Don't worry here "Query" doesn't meant doubt. In this blog we will talk about : What is a Query? Types of Query. Creating our database with the help of query. Let's start with 1) What is Query? Query is nothing but a statement or instruction to communicate with manipulate database or to manipulate database. By using queries you can create a database, insert values in table, update those values, delete rows and many more operations can be performed. 2) Types of Query. There are 5 types of query: DDL : Data Definition Language. DML : Data Manipulation Language. DCL : Data Control Language. TCL : Transaction Con...

Hello, and welcome to the blog. In this blog we are going to talk about different data types available in the SQL and we are going to create our first table in which we are going to store data. In our previous blog(  https://learntocodewithmustafapinjari.blogspot.com/2020/07/understanding-queries-and-creating.html  ) we learn how to create database and we created a database named as "EmployeeManagementSystem". Now its time to create some tables in our database so that we can store our data. So in this blog we are going talk about: Understanding data types Different data types in SQL Creating a database table Adding Column to existing table Lets' start with : 1) Understanding Data Type: It is very important to understand "Data types" before creating a database table as your table is going to represent a data for a specific Entity. "Entity is thing with distinct and independent existence" like a Person, Car, Shop, Institute, Animal etc. Every entity do h...

Hello, and welcome to the blog. This blog is about some of the very basic concepts of SQL. The concepts which we are going to talk about are as follows: What is SQL? What is Database? Is Excel sheet a database or not? What is DBMS? What is RDBMS? Different DBMS software available in the market. Let's start with 1) What is SQL? Whenever you post anything on Facebook, Instagram or any other social media platform, your data is stored in a database and then retrieved from it then shown to the users. The Language because of which this can be done is known as SQL. SQL stands for Structured Query Language. SQL is also pronounced as "Sequal" so don't get confused. SQL is used to perform different operation on a database. With the help of SQL you can perform n number of operations on database right from Creating a database, designing database, inserting data, updating data, retrieving data  and many more. SQL is not case sensitive language i.e if you write a SQL query in upper...