Think Career in IT
Think Steps......

IT Training from the masters

Database Programmer Course

Overviews of Different Database:- Oracle, Ms Sql, My Sql, Postgress, Hadoop

Course Content :
SQL:
  • History of Sql
  • DDL, DML, DCL , TCL
  • Architecture Block Diagram Of oracle
  • Adding , Modify, Drop, Rename of Column
  • Different types of Data Type (Char, Varchar,Varchar2,Date,Number , Lob etc)
  • Difference Between Different Data type
  • Select Query
  • Sub Query
  • Cross Tab Query
  • Inline View Query
  • Set Operators:- Union , Intersect , Minus , Union All
  • Clauses :- In Clause, Exists
  • Cartesian Product
  • Arithmetic Sql Functions
  • Text Functions
  • Logical Functions
  • Other Functions
  • Any ,All, Order BY, Like etc
  • Alias Of table and Column of table
  • Order By, Between , Like , Group BY
  • Aggregate functions with group by and having
  • Complex Insert, Update , Delete , Select Statements
  • Views
  • Assignment of All Topics (300 Assignments )
  • Hierarchical Queries
  • Difference between Data warehouse and OLTP
  • Analytical Queries
  • Regular Expression Queries
  • Joins
  • Scalar Sub Query, Cross Table Queries
  • Practice Sessions
PL/SQL :
  • Introduction of Plsql
  • Relationship Between Sql And Plsql
  • Control statements of Plsql
  • Different Types of Object of Database
  • Procedure
  • Functions
  • Triggers
  • Materialized View
  • Synonym
  • Sequence
  • Job Scheduler
  • Array, Varray Table array , Record
  • Object
  • Advanced Plsql (Bulk Insert ,Bulk Collect etc)
  • Ult File
  • Json
  • Query Optimization
DBA :
  • Import Utility
  • Export Utility
  • SQL LOADER, Data Base Dump, etc
  • Spool Utility

Courses