What you will learn

Understanding about basic SQL Course

Hardly will take 1 month to understand SQL

EG – How to store data in tables, select, create and many more

You can get the opportunity as Oracle DBA, Hadoop and many more technology

Description

I created this course to help freshers start day career as Oracle DBA. SQL and Unix is really important to start career as Oracle DBA.

In this course I have explain about the basic concept of SQL. this course will help you to get the knowledge about structured query language.

whenever you go for an interview as a fresher Oracle DBA there is a chances that interviewer can expect that you have a knowledge about SQL.

What is SQL?

  • SQL stands for Structured Query Language

  • SQL lets you access and manipulate databases

  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?


Get Instant Notification of New Courses on our Telegram channel.


  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can set permissions on tables, procedures, and views

RDBMS

RDBMS stands for Relational Database Management System.

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

English
language

Content

Introduction

Introduction

Oracle Tables

What is Table
How to Create Oracle Table
SYSTEM Tables and User Created Tables
Alter Table in SQL
Create Table as select (CTAS)

Oracle Queries

Insert Data in Table
Select Data from Tables
Update Statement Introduction
Update Statement Example
Fetch Clause SQL
drop table
Delete Table

Oracle Data Types

Data Types

Order Clauses

Order By In SQL
Distinct in SQL

Oracle Operator

AND Operator
OR Operator in SQL
Between in SQL
IN Operator in SQL

Aggregate Function

Aggregate Function – Count
aggregate Function – Average
Aggregate Function – SUM

SQL Transactions

Commit in SQL
Rollback in SQL

Bonus Lecture

Generate Mock Data