Useful tips for everyday
What is a Binlog? The binary log is a set of log files that contain information about data modifications made to a MySQL server instance.…
What are the relational algebra in SQL? RELATIONAL ALGEBRA is a widely used procedural query language. It collects instances of relations as input and gives…
How to test for null in case statement? In this form each boolean_expression is evaluated sequentially and the first to return true is executed. Here…
How do I start my database in exclusive mode? Issue one of the following commands: * STARTUP OPEN dbname PFILE=filename This command starts the instance,…
How do you grant access to tables in redshift? The following is the syntax for using GRANT for datashare privileges on Amazon Redshift. ALTER and…
What does ER mean in Entity Relationship Model? Introduction to Entity-Relationship Model Entity-Relationship Model is the diagrammatical representation of database structure which is called an…
How do I query a MySQL database? Some of the commonly used MySQL queries, operators, and functions are as follows : SHOW DATABASES. This displays…
Which is an iSQL plus command? You can use iSQL*Plus to write SQL*Plus, SQL and PL/SQL commands to: Enter, edit, run and save SQL commands…
How can I make SQL Server load data faster? Below are 23 rules to make your SQL faster and more efficient Batch data deletion and…
How do I give someone access to my MySQL database? To GRANT ALL privileges to a user , allowing that user full control over a…