Home » Sql tutorial for Oracle ,MySQL

Sql tutorial for Oracle ,MySQL

SQL stands for structured Query Language. It is the standard language for RDBMS management and Data manipulation.All the Relational Database Management Systems (RDBMS) like Oracle,MySQL, Sybase, Postgres,Teradata and Microsoft SQL Server use SQL as their standard database language. Each of the RDBMS vendors has added to some specific features to it also,so  there could be some difference between the RDBMS system but they are almost similar.

sql tutorials

Here are the topics covered into Sql Tutorial

Start with

  1. How to Install Oracle Express Edition for SQL Practice
  2. Pre-Built Oracle database for learning and testing using Oracle Developer VM
  3. How to use Oracle SQL*Plus
  4. Things you need to know about Oracle SQL developer

Basics

  1. how to write sql queries
  2. SELECT statement
  3. Where Clause
  4. order by and select distinct
  5. GROUP BY
  6. Oracle Data types
  7. Oracle Joins
  8. Cross Join
  9. self Join
  10. Oracle Join Syntax
  11. Oracle Set Operators
  12. Sql Subqueries
  13. Oracle Date Functions

Strings & Comparison Functions

  1. Single row functions in sql
  2. Oracle NULLIF
  3. Oracle NVL
  4. Oracle NVL2
  5. Oracle Coalesce
  6. Oracle Decode
  7. Oracle Case Statement

Data Definition

  1. Primary Key
  2. Foreign Key
  3. Unique key
  4. check constraint
  5. Not NULL constraint
  6. Create table oracle
  7. Alter Table Oracle
  8. Query to check table size in Oracle
  9. DROP TABLE
  10. Oracle Truncate TABLE
  11. Create Global Temporary Table
  12. alter table add column oracle
  13. alter table rename column oracle
  14. oracle alter table modify column
  15. alter table drop column in oracle
  16. How to List All Tables in Oracle
  17. How to check all constraints in table

DML

  1. Delete
  2. Update
  3. Insert ,Insert into select, Insert all

Advanced

  1. Oracle Sequences
  2. Oracle views: Create, Drop,Modify, Updatable View
  3. materialized views
  4. How to delete duplicate rows from Oracle table
  5. External tables
  6. Oracle Indexes and types of indexes in oracle with example
  7. how to find indexes on a table in oracle
  8. Oracle Create User , System Privileges and Oracle Object Privileges
  9. Top 49 Oracle Interview questions : Basics , Oracle SQL
  10. Oracle Partitioned table
  11. Oracle Partition Index
  12. How to converts rows into column in a table
  13. How to change Data format in Oracle

Analytic Functions

  1. Oracle Analytic functions
  2. RANK, DENSE_RANK and ROW_NUMBER
  3. LEAD and LAG
  4. Top-N Queries and Pagination
  5. LISTAGG Function

PLSQL

  1. Oracle PLSQL Block Structure and Oracle PLSQL Variable
  2. PLSQL records
  3. PLSQL Tables (Associative array or index-by table)
  4. How to use google translate URL in Oracle plsql
  5. Oracle cursor
  6. Most commonly asked 25 oracle plsql interview questions

MySQL

  1. MySQL COALESCE and NULLIF Function
  2. Top 10 Most Common MySQL queries examples
  3. Auto Increment Column – Sequence as Default Value in Oracle and mysql
  4. Step-by-Step guide for Installing MySQL on Windows
  5. Most Common MySQL queries

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top