Diksha IT Training Centre

Performance Tuning in Oracle. Hello Everyone, Before Reading this blog please go through my previous blog for better understanding of this topic. Today I will discuss about performance tuning by using SQL for Data Analysis. Performance Tuning play important role in any application where data is heavy and on daily basis data is extracting from user. As everyone needs data / information on time and if get stuck somewhere it means we need to tune the query to improve the performance of the application. So in this blog, we will learn to identify when SQL queries needs to be improved, and how to improve them.   Let’s understand Performance tuning in Simple way. Performance tuning is the process of optimizing Database performance by streamlining the execution of SQL statements. In other words, performance tuning simplifies the process of accessing and altering information contained by the database with the intention of improving query response times and application operations. ...

Why Oracle Database is important in IT organization and job Demand in IT company.   Oracle database is a very popular secured database that is widely used across all multinational companies. Knowledge of SQL and PL/SQL is must because the demand for SQL and PL/SQL-expertise is high and it's give you advantage to get the job easily. Database is always wanted technology in IT. In fact its growing tremendously as data is keep on increasing in all sectors like cashless, e-commerce, SMAC etc. Oracle is no doubt a Dominant leader in DB industry. So PL/SQL is all time a good technology to learn in IT career. Oracle database server also prevents unauthorized access and provides efficient solutions for failure recovery. Oracle Database is the first database designed for enterprise grid computing and the most flexible and cost effective way to manage information and applications. Nowadays you will see in evry Domain Oracle database is used as Back-end to manage information and applic...

          Index and Types of Index in Oracle and it’s Advantages.   Hello Everyone, Today I will discuss about Index and types of index in Oracle and its advantages. I suggest you to please follow my previous blogs related to SQL topics for better understanding. Let’s start why index is used in SQL database and the types of index and benefits of using index for query performance. Index is an object which is associated with tables or table cluster that can used to speed data access and reducing disk I/O. By creating an index, you can retrieve related set of rows from table instead of all Rows. In database technologies (Oracle, SQL Server, Sybase, DB2, MySQL, etc.), the objects we create to access the data for fast retrieval is known as Index: The usage of Index is very common especially in the performance tuning of database. Index is one of the most important objects that are used for performance tuning of databases. When any data is queried from a t...

                             Normalization in Oracle database.     Hello Everyone , Today I am going to discuss about Normalization . Before starting this topic   I suggest you to please go through my previous blogs for your reference. Let’s discuss about Normalization. Normalization rules divide larger tables into smaller tables and links them using relationships. Normalization in Database is very important as it is the process of taking data from a problem and reducing it to a set of relations while ensuring data integrity and eliminating data redundancy.   In Simple word Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion . Below are the Key Points in Normalization. Data Integrity : All of the data in the database are consistent , and satisfy all integrity constraints. Data Redun...

  Order By and Distinct Clause in Oracle.   Today I will discuss about SQL Order by and Distinct Clause which is vastly used in SQL query to perform Operation in query. I suggest you to please see my previous blog for your reference First start with Order By clause with Syntax and example. Order by Clause: ORDER BY clause is used to sort the records in the result set for a SELECT statement. Order by clause is used to sort the result-set in ascending or descending order. The Order By clause sorts the records in ascending order by default. To sort the records in descending order, use the DESC command in SQL. The Syntax of Order by Clause in SQL is as below: SELECT expression FROM table_name [WHERE conditions] ORDER BY expression [ ASC | DESC ];   In Above syntax : Expression: We need to specify the columns that will be retrieved or also we can use function for calculation to retrieve the column. Table_name : Table is object which stored in the...

    Logical Operator and other Operators uses in Oracle SQL.   Hello Everyone, Today I will discuss about Logical Operator used in Oracle SQL. This Topic is important as you can use Logical Operator in several SQL queries to get the result set as per your requirement.   I suggest you to please go through my previous blogs which you will able to see in archive folder so that you can use Logical Operator in SQL Queries. Let’s start with Logical Operators used in SQL. SQL operators are reserved keywords which basically used in the WHERE clause of a   SQL Statement to perform arithmetic, logical and comparison operations. Since, there are different types of operators in SQL, let us understand different type of operator and its uses in SQL. Below are the Logical Operators used in SQL . AND OR NOT BETWEEN LIKE IN EXIST ALL ANY     Uses of above operator in SQL 1.       AND Operator: AND operator di...