PL/SQL Oracle Database Administration: Server UNIX & Queries

Description

In this course, you will learn :

• Database Terminologies
• Basic Concepts of SQL
• Learning Different RDBMS
• Various Syntaxes of SQL
• Data Types in SQL
• SQL Operators & Expressions in SQL
• SQL Wildcards & Constraints
• Data Manipulation in Oracle SQL
• Creating Your First Database
• Tables in Oracle SQL
• Create & Drop Table
• Queries in Oracle SQL
• Insert, Select, Update & Delete Query
• Clauses of SQL
• Where, And & Or, Order By, Group By, Like & Top, Having Clause

Syllabus :

1. Syntax of SQL

• Various Syntaxes of SQL
• Data Types in SQL
• SQL Operators
• Expressions in SQL
• SQL Wildcards & Constraints

 

2. Data Manipulation in Oracle SQL

• Creating your first Database
• Drop Database and Select Database

 

3. Tables in Oracle SQL

• Create Table
• Drop Table
• Rename Table & Change Table Data Type

 

4. Queries in Oracle SQL

• Insert Query
• Select Query
• Update Query
• Delete Query

 

5. Clauses of SQL

• WHERE Clause
• AND & OR Clause
• ORDER BY Clause
• GROUP BY Clause
• LIKE & TOP Clause
• HAVING Clause

Show more