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. deepank joshiAugust 27, 2020 at 4:02 PM

    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

DSA in C# | Data Structure and Algorithm using C#

  DSA in C# |  Data Structure and Algorithm using C#: Lecture 1: Introduction to Data Structures and Algorithms (1 Hour) 1.1 What are Data Structures? Data Structures are ways to store and organize data so it can be used efficiently. Think of data structures as containers that hold data in a specific format. Types of Data Structures: Primitive Data Structures : These are basic structures built into the language. Example: int , float , char , bool in C#. Example : csharp int age = 25;  // 'age' stores an integer value. bool isStudent = true;  // 'isStudent' stores a boolean value. Non-Primitive Data Structures : These are more complex and are built using primitive types. They are divided into: Linear : Arrays, Lists, Queues, Stacks (data is arranged in a sequence). Non-Linear : Trees, Graphs (data is connected in more complex ways). Example : // Array is a simple linear data structure int[] number...
Post a Comment
Read more

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...
Post a Comment
Read more

Conditional Statement in Python

It is used to solve condition-based problems using if and else block-level statement. it provides a separate block for  if statement, else statement, and elif statement . elif statement is similar to elseif statement of C, C++ and Java languages. Type of Conditional Statement:- 1) Simple if:- We can write a single if statement also in python, it will execute when the condition is true. for example, One real-world problem is here?? we want to display the salary of employees when the salary will be above 10000 otherwise not displayed. Syntax:- if(condition):    statements The solution to the above problem sal = int(input("Enter salary")) if sal>10000:     print("Salary is "+str(sal)) Q)  WAP to increase the salary of employees from 500 if entered salary will be less than 10000 otherwise the same salaries will be displayed. Solution:- x = int(input("enter salary")) if x<10000:     x=x+500 print(x)   Q) WAP to display th...
217 comments
Read more