Skip to main content

Database Tutorials, SQL Tutorials, MYSQL Tutorials

 What is Database?

A database is a systematic collection of data. it will use on electronic storage and manipulation of data. using this we can implement data management and data storage of application.

The database is used to store information using a structured and unstructured pattern, in the structured pattern it stores data using a table pattern and unstructured pattern it stores data using file pattern.


The database provides separate partition into the disk to store application data permanently, for example, if the application contains registration form then all registration-based data will be stored under the database.


The database uses various database software to perform database operations.

TOP 5 Database software:-




1)  Oracle:-  It is the best database software which provides large data storage, if we want to create a large database server then we can use Oracle database Server.

Oracle is the most secure and enterprise software tool in the IT Industry. all ERP based, SAP-based, Secure domain(Banking, Insurance, Gateway) prefer oracle database software,

Now Oracle 19c  is the latest edition of Oracle that is called Oracle Cloud.

Related Software Tools:-  Oracle SQL Developer, SQL Plus


2)  MS-SQL Server:-  It is called Microsoft SQL Server that was created by Microsoft company especially for .NET Software development, but we can use MS-SQL into another application software such as Java, PHP, Python, etc.

It is also the most secure and reliable database software into IT Industry, many ERP product has used MS-SQL as database software.

SQL Server 2019 is the latest version of SQL Server.

Related Software Tools:-  SQL Server Management Studio


3)  MYSQL Server:-  It is the most useful light-weight database software, it is completely open-source software that is mostly used by middle level and small level applications.

all open source-based technology prefer MYSQL database server for database operations.

PHP, Python, Ruby, and Java languages prefer MYSQL Server.

The latest edition of Mysql is 8.1 

Related Software Tools:-  MY SQL YOG,  MYSQL CONSOLE, PHPMYADMIN


4)  PostgreSQL:-  It is the best light-weight, open-source database software, this database performance is best for medium-scale application.

Postgre SQL software is compatible with all open source technology such as PHP, Python, Ruby, Java, etc.

Postgre SQL 9.6 is the latest version of PostgreSQL software.

Related Software Tools:-  pgAdmin, DBeaver


5)  SQLite:-  It is also light-weight, open-source software that can be used for a medium-scale application, and small scale application.

SQLite is created to manage mobile application database information but now it can be used in all technologies.

By default Android and iOS use SQLite database software tools to store offline data. but now SQLite is compatible with Django, Rails, PHP, and all other technologies.

the latest version of SQLite:-  3.33 is the latest version

Related Software Tools:-  SQLiteStudio, Db Browser 


What is SQL:-

First I clear about to you that SQL is not a database, many students confused that SQL is database but SQL is the only language that is common for all database software.

Means if you want to use MYSQL, SQL Server, ORACLE, PostgreSQL, SQLite then SQL is common.


Initially, SQL was known as SEQUEL means Structured Query English Language after some time its name was changed as SQL (Structured Query Language).


SQL languages are based on command, methods, operator, and clause, means if you want to learn SQL then you should know command(insert,update,delete,select,etc),operator(IN,Between,Like,etc),methods(max,min,avg,etc) and clause(where,groupby,orderby,having,etc)


How many ways Write SQL Language?

We can write SQL using two different ways:-


1)  Normal SQL or Statement Pattern:-  we will write SQL Query using different statements. using this we can write only Single Statement.


2)  PL/SQL:-  We can write more than one SQL Statement to create procedure, function, triggers, and cursor object.








Comments

  1. nice tutorial for database, i have face same topic on multiple interview related database.

    ReplyDelete

Post a Comment

POST Answer of Questions and ASK to Doubt

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...