Category: Database

OLTP in SQL SERVER

August 20, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified September 22, 2016

OLTP in SQL SERVER   Online Transaction and Processing helps and manages applications based on transactions involving high volume of data. The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. It involves Queries accessing individual record like Update your Email in Company database. For OLTP …

Interview Questions of MySQL

August 7, 2016 by Arti Khedkar

Filed under Database, MySQL

Last modified August 7, 2016

         Interview Questions of MySQL What is MySQL? In which language MySQL is written? What are the technical specification of MySQL? How many Triggers are possible in MySQL? What is heap table? What is BLOB and TEXT in MySQL? What is a trigger in MySQL? What is the difference between heap table and temporary table? What is the difference between FLOAT and DOUBLE? What are …

SQL Joins

August 3, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified October 25, 2016

SQL Joins The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key, it specifies that the database management …

Sql Interview Questions

August 2, 2016 by Giryavva Ghodake

Filed under SQL

Last modified August 2, 2016

Sql Interview Questions What is DBMS ? What is RDBMS ? What is SQL ? What are the different type of SQL’s statements ? What are the Advantages of SQL ? what is a field in a database ? What is a Record in a database ? What is a Table in a database ? What is a database transaction? What are properties of a …

Introduction to SQL

July 27, 2016 by Arti Khedkar

Filed under Database, SQL

Last modified July 27, 2016

  Introduction to SQL Sql is database language which is used by most of the companies for storing the data in it. SQL stands for Structured Query Language. SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language. The first incarnation of SQL appeared …

MySql Connection

July 17, 2016 by Arti Khedkar

Filed under Database, MySQL

Last modified July 17, 2016

MySql Connection Command   Every connections of mysql are based on storage space in a disk. So you have to set that maximum connection based on work load on disks have command. In mysql 100 connections are maximum connections. MySQL stands for My Structured Query Language. It is a open source database software. A NULL value is not equal to itself. If you compare a …

Introduction of Database

July 17, 2016 by Arti Khedkar

Filed under Database

Last modified October 21, 2016

 Introduction of Database             Connection of Database is more important in programs. Because of that the storing of all data is possible.   So for that purpose we can use database in programs. SQL is a standard language for accessing databases. Our SQL tutorial will teach you how to use SQL to access and manipulate data in:  SQL Server , Oracle, MS-Access ,MYSQL, Sybase, DB2, and …

Setup Mysql Database for Bugzilla

February 5, 2016 by S4

Filed under Database, MySQL

Last modified July 15, 2016

Setup Mysql Database for Bugzilla You need MySQL version 5.0.15 or higher. It’s possible to test which version of MySQL you have installed with: mysql -V 1.1 Installing 1.1.1 Windows Download the MySQL 32-bit or 64-bit MSI installer from the MySQL website (~28 MB). MySQL has a standard Windows installer. It’s ok to select a Typical MySQL install (the default). The rest of this documentation …

max_connections at AWS RDS MySQL Instance Sizes

February 4, 2016 by Linux Guru

Filed under AWS, Database, MySQL

Last modified July 15, 2016

max_connections at AWS RDS MySQL Instance Sizes This chart shows the max_connections limit, set by AWS, at various MySQL RDS instance sizes. t2.micro 66 t2.small 150 m3.medium 296 t2.medium 312 M3.large 609 t2.large 648 M4.large 648 M3.xlarge 1237 R3.large 1258 M4.xlarge 1320 M2.xlarge 1412 M3.2xlarge 2492 R3.xlarge 2540 AWS sets the MySQL max_connections system variable according to the size of the RDS instance.  max_connections is the …

Reset MySQL Root Password in Windows

December 31, 2015 by Linux Guru

Filed under Database, MySQL, Window

Last modified July 15, 2016

Reset MySQL Root Password in Windows 1] Log in to your system as the “Administrator” user created in Windows setup. 2] Stop the MySQL service by clicking “Start,” “Control Panel,” “Administrative Tools,” “Services.” Scroll down to “MySQL.” Click “Stop.” 3] Open Notepad from the Start menu and enter the text: “UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root.’“ 4] Save the file to an easily accessed location …