Skip to main content

Posts

Showing posts matching the search for database

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...

JDBC Introduction,CRUD in JSP,Servlet,Insert,Update,Delete,Select record using JDBC,JDBC CRUD

It is intermediate technology of Java that is used to perform database operations using drivers and providers, JDBC contains a set of classes and methods to perform database operations for the different database servers. JDBC means Java Database connectivity, It is used to create dynamic applications of Java because JDBC has database-related classes and methods to perform database operations. It will work as a bridge between the java application and the database server. It works using four different types:- 1)  type1:-      JDBC-ODBC Driver:-   It is used for desktop applications because ODBC provides local connection using DSN (Data source name) 2) type2:- JDBC-Network Specific Driver -  It is used to connect the database from a different network, It uses C and C++ Programming approach to connect the server machine. 3) type3:-    JDBC-Vendor Specific Driver, It uses a third-party library to communicate application data to the database server, ...

ASP.NET CORE Database Application

 ASP.NET  CORE Database Application STEP 1. Create Database Tables First, we're going to create two database tables, tblMembers and tblSkills. These tables store employee details and skills. You can create a new database in SQL Server or add these tables to an existing database. The following scripts will create these database tables. If you want to use your existing database, you may skip this step.  CREATE   TABLE  [dbo].[tblEmployees](       [EmployeeID] [ int ] IDENTITY(1,1)  NOT   NULL ,       [EmployeeName] [ varchar ](50)  NULL ,       [PhoneNumber] [ varchar ](50)  NULL ,       [SkillID] [ int ]  null ,       [YearsExperience] [ int ]  null ,   PRIMARY   KEY  CLUSTERED    (      ...