Best Training institutes ,Computer education and Coaching classes in Vadapalani as of February 19, 2019

dotexe technologies institute located at vadapalani in chennai offers 45 Day(s) of Oracle DBA OCA training course in Chennai with 100% Placement Assistance.

We are specialized to provide RDBMS and especially for Oracle SQL and PlSQL. Our trainers are coming from various IT companies who have nearly 10+ years in IT industries. As of now we trained nearly 1

Install the Database on Linux. Back up and recover data. Administer users and manage data. Oracle Database 11g: Administration I (1Z0-052) Exploring the Oracle Database Architecture  Explain the Memory Structures  Describe the Process Structures  Overview of Storage Structures Preparing the Database Environment  Identify the tools for Administering an Oracle Database  Plan an Oracle Database installation  Install the Oracle software by using Oracle Universal Installer (OUI) Creating an Oracle Database  Create a database by using the Database Configuration Assistant (DBCA) Managing the Oracle Instance  Setting database initialization parameters  Describe the stages of database startup and shutdown  Using alert log and trace files  Using data dictionary and dynamic performance views Configuring the Oracle Network Environment  Configure and Manage the Oracle Network  Using the Oracle Shared Server architecture Managing Database Storage Structures  Overview of tablespace and datafiles  Create and manage tablespaces  Space management in tablespaces Administering User Security  Create and manage database user accounts  Grant and revoke privileges  Create and manage roles  Create and manage profiles Managing Data and Concurrency  Monitor and resolve locking conflicts Managing Undo Data  Overview of Undo  Transactions and undo data  Managing undo Implementing Oracle Database Security  Database Security and Principle of Least Privilege  Work with Standard Database Auditing Database Maintenance  Use and manage optimizer statistics  Use and manage Automatic Workload Repository (AWR)  Use advisory framework  Manage Alerts and Thresholds Performance Management  Use Automatic Memory Management  Use Memory Advisors  Troubleshoot invalid and unusable objects Intelligent Infrastructure Enhancements  Use the Enterprise Manager Support Workbench  Managing Patches Backup and Recovery Concepts  Identify the types of failure that can occur in an Oracle database  Describe ways to tune instance recovery  Identify the importance of checkpoints, redo log files, and archived log files  Overview of flash recovery area  Configure ARCHIVELOG mode Performing Database Backups  Create consistent database backups  Back up your database without shutting it down  Create incremental backups  Automate database backups  Manage backups, view backup reports and monitor the flash recovery area Performing Database Recovery  Overview of Data Recovery Advisor  Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file) Moving Data  Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)  Explain the general architecture of Oracle Data Pump  Use Data Pump Export and Import to move data between Oracle databases Oracle Database 11g: Administration II (1Z0-052) Database Architecture and ASM  Describe Automatic Storage Management (ASM)  Set up initialization parameter files for ASM and database instances  Start up and shut down ASM instances  Administer ASM disk groups Configuring for Recoverability  Configure multiple archive log file destinations to increase availability  Define, apply and use a retention policy  Configure the Flash Recovery Area  Use Flash Recovery Area Using the RMAN Recovery Catalog  Identify situations that require RMAN recovery catalog  Create and configure a recovery catalog  Synchronize the recovery catalog  Create and Use RMAN stored scripts  Back up the recovery catalog  Create and use a virtual private catalog Configuring Backup Specifications  Configure backup settings  Allocate channels to use in backing up  Configure backup optimization Using RMAN to Create Backups  Create image file backups  Create a whole database backup  Enable fast incremental backup  Create duplex backup and back up backup sets  Create an archival backup for long-term retention  Create a multisection, compressed and encrypted backup  Report on and maintain backups Performing User-Managed Backup and Recovery  Recover from a lost TEMP file  Recover from a lost redo log group  Recover from the loss of password file  Perform user-managed complete database recovery  Perform user-managed incomplete database recovery  Perform user-managed and server managed backups  Identify the need of backup mode  Back up and recover a control file Using RMAN to Perform Recovery  Perform complete recovery from a critical or noncritical data file loss using RMAN  Perform incomplete recovery using RMAN  Recover using incrementally updated backups  Switch to image copies for fast recovery  Restore a database onto a new host  Recover using a backup control file  Perform Disaster recovery Using RMAN to Duplicate a Database  Creating a duplicate database  Using a duplicate database Performing Tablespace Point-in-Time Recovery  Identify the situations that require TSPITR  Perform automated TSPITR Monitoring and Tuning RMAN  Monitoring RMAN sessions and jobs  Tuning RMAN  Configure RMAN for Asynchronous I/O Using Flashback Technology  Restore dropped tables from the recycle bin  Perform Flashback Query  Use Flashback Transaction Additional Flashback Operations  Perform Flashback Table operations  Configure, Monitor Flashback Database and Perform Flashback Database operations  Set up and use a Flashback Data Archive Diagnosing the Database  Set up Automatic Diagnostic Repository  Using Support Workbench  Perform Block Media Recovery Managing Memory  Implement Automatic Memory Management  Manually configure SGA parameters  Configure automatic PGA memory management Managing Database Performance  Use the SQL Tuning Advisor  Use the SQL Access Advisor to tune a workload  Understand Database Replay Space Management  Manage resumable space allocation  Describe the concepts of transportable tablespaces and databases  Reclaim wasted space from tables and indexes by using the segment shrink functionality Managing Resources  Understand the database resource manager  Create and use Database Resource Manager Components Automating Tasks with the Scheduler  Create a job, program, and schedule  Use a time-based or event-based schedule for executing Scheduler jobs  Create lightweight jobs  Use job chains to perform a series of related tasks Administering the Scheduler  Create Windows and Job Classes  Use advanced Scheduler concepts to prioritize jobs

dotexe technologies institute located at vadapalani in chennai offers 30 Day(s) of Php MySQL training course in Chennai with 100% Placement Assistance.

In our training Institute we have in house training as well as realtime working professional. Our trainer has been execute more than 25 batches and having experience of more than 6 years. Trainers a

Introduction to PHP PHP & MySQL Course Syllabus Introduction of Web & PHP  What is PHP?  The history of PHP  Why choose PHP?  Installation overview First Steps  Embedding PHP code on a page  Outputting dynamic text  The operational trail  Inserting code comments Exploring Data Types  Variables  Strings  String functions  Numbers part one: Integers  Numbers part two: Floating points  Arrays  Associative arrays  Array functions  Booleans  NULL and empty  Type juggling and casting  Constants Control Structures: Logical Expressions  If statements  Else and elseif statements  Logical operators  Switch statements Control Structures: Loops  While loops  For loops  Foreach loops  Continue  Break  Understanding array pointers User-Defined Functions  Defining functions  Function arguments  Returning values from a function  Multiple return values  Scope and global variables  Setting default argument values Debugging  Common problems  Warnings and errors  Debugging and troubleshooting Building Web Pages with PHP  Links and URLs  Using GET values  Encoding GET values  Encoding for HTML  Including and requiring files  Modifying headers  Page redirection  Output buffering Working with Forms and Form Data  Building forms  Detecting form submissions  Single-page form processing  Validating form values  Problems with validation logic  Displaying validation errors  Custom validation functions  Single-page form with validations Working with Cookies and Sessions  Working with cookies  Setting cookie values  Reading cookie values  Unsetting cookie values  Working with sessions MySQL Basics  MySQL introduction  Creating a database  Creating a database table  CRUD in MySQL  Populating a MySQL database  Relational database tables  Populating the relational table Using PHP to Access MySQL  Database APIs in PHP  Connecting to MySQL with PHP  Retrieving data from MySQL  Working with retrieved data  Creating records with PHP  Updating and deleting records with PHP  SQL injection  Escaping strings for MySQL  Introducing prepared statements Building a Content Management System (CMS)  Blueprinting the application  Building the CMS database  Establishing your work area  Creating and styling the first page  Making page assets reusable  Connecting the application to the database Using Site Navigation to Choose Content  Adding pages to the navigation subjects  Refactoring the navigation  Selecting pages from the navigation  Highlighting the current page  Moving the navigation to a function Application CRUD  Finding a subject in the database  Refactoring the page selection  Creating a new subject form  Processing form values and adding subjects  Passing data in the session  Validating form values  Creating an edit subject form  Using single-page submission  Deleting a subject  Cleaning up  Assignment: Pages CRUD  Assignment results: Pages CRUD Building the Public Area  The public appearance  Using a context for conditional code  Adding a default subject behavior  The public content area  Protecting page visibility Regulating Page Access  User authentication overview  Admin CRUD  Encrypting passwords  Salting passwords  Adding password encryption to CMS  New PHP password functions  Creating a login system  Checking for authorization  Creating a logout page Advanced PHP Techniques  Using variable variables  Applying more array functions  Building dates and times: Epoch/Unix  Formatting dates and times: Strings and SQL  Setting server and request variables  Establishing global and static variable scope  Making a reference assignment  Using references as function arguments  Using references as function return values Introduction to Object-Oriented Programming (OOP)  Introducing the concept and basics of OOP  Defining classes  Defining class methods  Instantiating a class  Referencing an instance  Defining class properties OOP in Practice  Understanding class inheritance  Setting access modifiers  Using setters and getters  Working with the static modifier  Reviewing the scope resolution operator  Referencing the Parent class  Using constructors and destructors  Cloning objects  Comparing objects Working with Files and Directories  File system basics  Understanding file permissions  Setting file permissions  PHP permissions  Accessing files  Writing to files  Deleting files  Moving the file pointer  Reading files  Examining file details  Working with directories  Viewing directory content Sending Emails  Configuring PHP for email  Sending email with mail()  Using headers  Reviewing SMTP  Using PHP Mailer

Arena Animation institute located at vadapalani in chennai offers 6 Months of Web Designing training course in Chennai with 100% Placement Assistance.

Adobe & Autodesk Authorized Trainers: Highly Experienced staff Member, Certified by Adobe and Autodesk. (3D staffs have worked for movies like Arundhathi & Jai Hanuman). Seminars by industry

Basics of Web Technologies Introduction to Web Technologies How the website works ? Domain Names How to Register a Domain Name Client and Server Software. Static and Dynamic Websites Careers in Web Technologies Web Standards and W3C.ORG Adobe Photoshop CS3 Introduction of Stock Photography Types of Images and Image Editing Tools Introduction to Adobe Photoshop Using Photoshop Tools Layers, Actions and Filters Creating Custom Effects Design Banners for Website Basic Website Layout Design Complex Webpage Layout Conversation of PSD to XHTML HTML / XHTML Markup Languages Structure of HTML Basic HTML Tags Advanced HTML Tags Difference between HTML & XHTML XHTML Basics Introduction to Doc Types Introduction to HTML 5.0 Adobe Dreamweaver Introduction to Adobe Dreamweaver Learning the Interface Tools in Dreaweaver. Defining a Dreamweaver site Adding Content and Multimedia. Creating user submission forms. Using Spry Elements Importing a website design Using DWT Template Web Design with CSS Introduction to Cascading Style Sheets Types of Style Sheets Types of CSS Selectors CSS properties Converting Table layout to CSS Custom CSS Layout Design Creating simple and dropdown menus Creating Appealing forms using CSS CSS Tips and Optimization Techniques Introduction to CSS 3.0 Java Script Client and Server side scripting Introduction to Java Script Programming Concepts Objects and Events Common Functions Using Dreamweaver Java Script Features Java Script Validations Implementing Menus Systems, Galleries etc. Adobe Flash Introduction to Animation Introduction to Adobe Flash Tools in Adobe Flash Shape Tween and Motion Tween Frame Animation Various Flash Effects Creating Flash Banners Creating Flash Intro s Creating Flash Website Basics of Action Scripting. Web Hosting Training Web Hosting Basics Types of Hosting Packages Changing Name Servers Linux and Windows Conrtrol Panel Using FTP Client Maintaining a Website Compatibility Testing Various Browser Versions Validating the XHTML & CSS Common Compatibility Issues

Arena Animation institute located at vadapalani in chennai offers 18 Months of Animation Multimedia training course in Chennai with 100% Placement Assistance.

# Separate Sound recording Studio (record or edit sound to the broadcast quality) # Highly Experienced staff Member, Certified by Adobe and Autodesk. # Seminars by industry experts on latest topics

SEMESTER-1 BASIC DRAWING ADOBE PHOTOSHOP ADOBE ILLUSTRATOR ADOBE INDESIGN COREL DRAW ONLINE EXAM+MARK SHEET+PROJECT SEMESTER-2 ANATOMY STUDY ADOBE PREMIERE PRO SOUND FORGE ADOBE FLASH with SCRIPTING DREAMWEAVER (ADDITIONAL) ONLINE EXAM+MARK SHEET+E-PROJECT SEMESTER-3 CLAYMODELLING 3DS MAX - AUTODESK CERTIFICATE AFTER EFFECTS ONLINE EXAM+MARK SHEET+PROJECT SEMESTER-4 AUTODESK MAYA - AUTODESK CERTIFICATE ZBRUSH CROWD SIMULATION PIXAR RENDERMAN 3D PROJECTION MAPPING 3D FOR AUGMENTED REALITY ONLINE EXAM+MARK SHEET+E-PROJECT

Times Technologies institute located at vadapalani in chennai offers 2 Months of Software Testing training course in Chennai with 100% Placement Assistance.

Our trainer have more than 5+ Years of experience in Software Testing Has worked on 4 real time Manual testing projects in MNC. Trained 150+ Students so far. Strong Theoretical & Practical Kn

Course Content: � Introduction to testing � Need of testing � Software development life �Different Models of SDLC V-Model Fish Model PET Model Agile Model � Types of testing �Testing document- Test strategy; Traceability matrix, test plan & test case documents � Common test process � Prepare and Execute test cases based on a project � Defect reporting � Maintenance of testing documents � Project Deliverables � Acceptance Testing- Staging and Production Environment � Understanding Manual Testing concepts with a sample Project

Impulse Technologies institute located at vadapalani in chennai offers 3 Months of Embedded Systems training course in Chennai with 100% Placement Assistance.

Our trainer have more than 5+ Years of experience in Embedded Systems Has worked on real time Embedded Systems based projects in MNC. Trained 100+ Students so far. Strong Theoretical & Practi

PIC 16F877A controller Module 1: Basic Electronics & Embedded System Concepts Module 2: 16Fxxx Architecture Explanation Module 3: CCS Compiler Module 4: Lab centre Proteus Module 5: Interfacing LED Simulation in Proteus with 16Fxx Module 6: Interfacing LCD Simulation in Proteus with 16Fxx Module 7: Relay interface Simulation in Proteus with 16Fxx Module 8: Keypad interface 16Fxx Module 9: ADC Simulation with 16Fxx ATMEL 89S52 Contoller Module 1: Basic Electronics & Embedded System Concepts Module 2: 8051 Architecture Explanation Module 3: Keil vision Module 4: Lab centre Proteus Module 5: Interfacing LED Simulation in Proteus with 89S52 Module 6: Interfacing LCD Simulation in Proteus with 89S52 Module 7: Relay interface Simulation in Proteus with 89S52 Module 8: Keypad interface 89S52 Module 9: ADC Simulation with 89S52 ARM 7 Controller Module 1: Basic Concepts Module 2: ARM 7 Architecture Explanation Module 3: Keil vision Module 4: Lab centre Proteus Module 5: Interfacing LED Simulation in Proteus with ARM 7 Module 6: Interfacing LCD Simulation in Proteus with ARM 7 Module 7: Relay interface Simulation in Proteus with ARM 7 Module 8: Keypad interface ARM 7 Module 9: ADC Simulation with ARM 7

dotexe technologies institute located at vadapalani in chennai offers 30 Day(s) of Informatica training course in Chennai with 100% Placement Assistance.

Working in Top MNC company. Having more than 7+ years of experience. Fully real time training and project Training. Free resume prepared by the trainer. You can contact for any quries at any time. Fle

Session-1 Introduction to Data Ware House Introduction to OLTP Difference between OLTP and DWH Dimension table Fact table Architecture of DWH Star schema Snowflake Schema Data mart Top down approach Bottom up approach ETL Session-2 Types of ETL s Code based GUI based Introduction to Informatica Domain service Node Informatica Power Center 9.1/9.5 Archtecture of Informatica Repository Repository service Integration service Informatica server component Informatica client component Session-3 Introduction to Admin tool Introduction to client tools Developer Workflow manager Workflow monitor Repository Manager Importing/creating source definition Importing/creating target definition creating Mapping Creating session creating workflow Executing the Workflow Monitoring the workflow Understanding session log Session-4 Working with Transformations ( Connected,unconnected,Active,Passive) Expression Filter Sorter Session-5 Aggregator Rank Seq generator Router Session-6 Union Update Strategy(Options in session level) Transaction control Working with flat files Normalizer Session-7 Source qualifier Joiner Look up Session-8 Stored Procedure SQL Transformation XML Source Qualifier Session-9 Variable port in Expression Working with variable port Multiple pipe lines in mapping Target load order Debugger File list Constraint based loading Session -10 SCD type -I SCD type _II SCD type �III Session -11 Caches in loop up Dynamic lookup Persistent cache Shared cache named shared and un named shared cache Parameters and parameter file Session-12 variables using variables Performance tuning Tasks CMD task email task Session -13 Reusable transformation Reusable Mapplet Reusable session Reusable Worklet Link task Parallel load Sequential load First load and incremental load Session-14 Timer task Control task event wait event raise decision task Assignment task Session -15 (use full in work environment) Code movement from Dev to production different methods for code movement Deployment groups Check in check out What is versioning Find checkouts dependencies Comparing previous versions Session-16 Partitions Pass through Round robin Hash key Hash user Key range DB Session-17 Restartability FAQ Resume preparation

dotexe technologies institute located at vadapalani in chennai offers 90 Day(s) of Web Designing training course in Chennai with 100% Placement Assistance.

Trainer Works in Top MNC. Having more than 8+ years of experience. Fully real time training and also provide free project training. Flexible time schedule. Regarding training you can contact at any ti

Section One: Getting Started 1. Course Introduction 2. Course software 3. What is a HTML and HTML 5? 4. Getting started with tags 5. How to save web pages 6. Viewing your web pages Section 2: Basic HTML Tags 1. Basic HTML template 2. Heading Tags 3. Paragraph and Break tags 4. Bold and Italics 5. HTML lists Reference: Basic HTML Tags Section 3: Getting started with CSS 1. Introduction to CSS 2. CSS rules 3. Where to put your styles 4. Using CSS selectors 5. Inline and Embedded styles 6. CSS and Fonts 7. Font colours 8. Font sizes 9. Styling Fonts Reference: CSS and Fonts Section 4: Dealing with Images 1. Types of Images 2. Inserting Images part 1 3. Inserting Images part 2 4. Image Attributes 5. Images and CSS 6. Text wrapping with CSS 7. CSS and image borders 8. Background Images 9. Adding captions to images Reference: CSS in this section Section 5: Linking to other pages 1. Hyperlinks 2. Linking to other pages 3. Other types of hyperlinks 4. CSS and hyperlinks 5. External stylesheets 6. HTML lists and nav bars Reference: CSS in this section Reference: HTML in this section Section 6: CSS Layouts 1. The Box Model 2. CSS Comments 3. CSS Positioning 4. CSS floats 5. A one column CSS layout 6. Styling the one column layout 7. Styling HTML 5 tags 8. A two column CSS layout Reference: CSS in this section Reference: HTML5 layout tags Section 7: HTML 4 and HTML 5 tables 1. HTML 4 Tables 2. Row and Col span 3. Table alignment, colour, images 4. HTML 5 Tables Reference: HTML and HTML5 tables Section 8: HTML forms 1. Form Tags 2. Textboxes, Submit, Reset 3. Formatting Textboxes with CSS 4. Labels, Textareas 5. Option buttons and Checkboxes 6. Passwords, hidden fields Reference: HTML and HTML5 Forms Section 9; HTML5 and Forms 1. HTML 5 Forms 2. Placeholders, Required 3. Email, URL, Search 4. Spinners and Sliders 5. Dates, Colour pickers 6. Data Lists 7. HTML Form Layouts 8. HTML 5 Video and Audio 9. The HTML 5 Canvas tag 10. Details, Aside, Mark Reference: HTML5 Audio and Video Section 10: Getting your site on the internet 1. Websites and Domain Names 2. What to look for when buying Webspace 3. Search engine optimisation 4. Pay per click advertising 5. Sitemaps Section 11: HTML and CSS Reference 1. Basic HTML Tags 2. CSS Font and Text Properties 3. CSS Borders, Margins, Padding 4. CSS used in the Lists section 5. CSS used in the Positioning section 6. HTML images and hyperlinks 7. HTML5 Layout tags 8. HTML and HTML5 Table tags 9. HTML and HTML5 Form tags 10. HTML5 Video and Audio tags 11. HTML Special Characters

dotexe technologies institute located at vadapalani in chennai offers 45 Day(s) of JAVA J2EE training course in Chennai with 100% Placement Assistance.

Having 6 Yrs Work Experience currently working in MNC Working as a Team Lead, Having Real Time Experience, Will Provide Sample Programs, Will Help to Prepare the Resumes. Certification Guidance also

About Java Training INTRODUCTION � Why Java � Paradigms � Diff b/w Java & Other (C,C++) � Java history � Java features � Java programming format � Java Tokens � Java Statements � Java Data Types � Typecasting � Arrays OOPS � Introduction � Class � Object � Static Keywords � Constructors � This Key Word � Inheritance � Super Key Word � Polymorphism (Over Loading & Over Riding) � Abstraction � Encapsulation � Abstract Classes � Interfaces STRING MANIPULATIONS � String � String Buffer � String Tokenizer PACKAGES � Introduction to all predefined packages � User Defined Packages � Access Specifiers EXCEPTION HANDLING � Introduction � Pre Defined Exceptions � Try-Catch-Finally � Throws, throw � User Defined Exception examples MULTITHREADING � Introduction � Thread Creations � Thread Life Cycle Life Cycle Methods � Synchronization � Wait() notify() notifyAll() methods I/O STREAMS � Introduction � Byte-oriented streams � Character � oriented streams � File � Random-access file � Serialization NETWORKING � Introduction � Socket, Server socket � Client �Server Communication WRAPPERCLASSES � Introduction � Byte, Short, Integer, Long, Float, Double, Character, Boolean classes. COLLECTION FRAME WORK � Introduction � Util Package interfaces, � List, � Set, � Map � List interface 7 its classes � Set interface & its classes � Map interface & its classes INNER CLASSES � Introduction � Member inner class � Static inner class � Local inner class � Anonymous inner class JDBC � Introduction � Jdbc Architecture � Types of Drivers � Statement � Result Set � Read Only Result Set � Updatable Result Set � Forward Only Result Set � Scrollable Result Set � Prepared Statement � Connection Modes � Save Point � Batch Updations � Callable Statement � BLOB & CLOB SERVLETS � Introduction � Web application Architecture � Http Protocol & Http Methods � Web Server & Web Container � Servlet Interface � Generic Servlet � Http Servlet � Servlet Life Cycle � Servlet Config � Servlet Context � Servlet Communication � Servlet-Browser communication � Send Error � Set Header � Send Redirect � Web-component Communication � Forward � Include � Servlet-Applet Communication � Session Tracking Mechanisms � Http Session � Cookies � URL-Rewriting � Hidden-Form Fields � Filters & Wrappers � Listeners � Web-Security JSP � Introduction � Jsp Life Cycle � Jsp Implicit Objects & Scopes � Jsp Directives � Page � Include � Taglib � Jsp Scripting Elements � Declaratives � Script lets � Expressions � Jsp Actions � Standard Actions � Use Bean tag � Set Property tag � Get Property tag � Include tag � Forward tag � Param tag � plug-in tag � Params tag � Fallback tag � Directives tag � Script let tag � Expression tag � Custom Actions � Classic Tags � Simple Tags � JSTL & Tag Library IDE � My Eclipse SERVERS � Tomcat � Weblogic DATABASE � MySql

Metaforum Technologies institute located at vadapalani in chennai offers 30 Day(s) of Oracle training course in Chennai with 100% Placement Assistance.

Trainer from CTS with 7 years of experience in Oracle. He is highly proficient in all databases especially oracle. He has worked as DBA for about 4 Years and is extremely good at SQL and PL/SQL. Has h

Basic history of database concept: DBMS, RDBMS, ORDBMS Advantage of ORACLE database and version information Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad SQL Language overview : DQL, DML, DDL, DCL, TCL What is the usage of ANSI standard. SELECT Command - Column Alias Rules, String data, Concatenations with various data Null Value handling with number and characters, Arithmetic Operator Concatenation Operator, Eliminating Duplicate Rows 2. Restricting and Sorting Data WHERE Clause - Character Strings and Dates, number General Comparison Conditions = > >= < <= <> Other Comparison BETWEEN , IN , LIKE , NULL Logical Conditions AND OR NOT ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns 3. Single-Row Functions Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE General Functions: NVL , NVL2 , NULLIF, COALESCE CASE Expression, DECODE Nested function with real-time usage 4. JOINS EQUI JOIN / SIMPLE JOIN / NORMAL JOIN ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER NATURAL JOIN, NATURAL OUTER JOINS INNER JOIN, JOIN ... USING clause, JOIN ... ON clause, CROSS JOIN, NON-EQUI JOIN, SELF JOIN ORACLE STANDARD OUTER JOINS. Multi table Joins, Complex Joins � How to simplified complex joins. 5. Multi-row Functions Group Functions Rules, SUM, MIN, MAX, COUNT, AVG Creating Groups of Data: GROUP BY Clause Filtering Group Results: The HAVING Clause 6. Sub-queries Single-Row Subqueries- Rules, Operators : = > >= < <= <> Null Values in a Subquery Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL 7. Reporting data using interface commands pagesize, linesize , column heading , column format , colsep tTitle , bTitle , break on column, spool , CSV file generation, Text file generation 8. Data Manipulation Language DML and Transaction Control Language TCL DML : INSERT, UPDATE, DELETE, MERGE TCL : COMMIT, ROLLBACK, SAVEPOINT 9. Data Definition Language - DDL DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE DEFAULT OPTION. Constrain table copy 10. Constraints NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK Column Level Constraint, Table Level Constraint � Naming constraints and usage Adding a Constraint, Dropping a Constraint, Disabling Constraints, Enabling Constraints Validating Constraints 11. Views Simple Views and Complex Views � Create, Drop, Source Code Rules for Performing DML Operations on a View WITH CHECK OPTION , WITH READ ONLY Inline Views Materialized View � Create, Refresh, Drop - Usage 12. Other Database Objects Sequence- NEXTVAL and CURRVAL Index - When to Create an Index, When Not to Create an Index. Synonyms 13. DCL COMMANDS Creating Users Granting / Revoking Privileges Creating and Granting Privileges to a Role 14. Dictionary Tables Tables, Views, Synonyms, Index, Sequence, Constrains, Source and other Dictionary 15. SET Operators UNION , UNION ALL , INTERSECT , MINUS

Metaforum Technologies institute located at vadapalani in chennai offers 25 Day(s) of SEO Training training course in Chennai with Basic Placement Support.

Trainer is working as a free lance trainer and one of the best SEO analyst and holds a SEO company in Chennai. He has worked on a lot of competitive keywords and you can know that when you meet our t

SEO Fundamental & Concepts Keyword Research Conceptual Analysis Local business listing Link Building tips & techniques Google Updates SEO Tools operations & Management Domain selection Keyword research URL Optimization Meta data optimization 301 redirection Robots.txt Anchor Text Optimization XML sitemap H1, H2, H3 tags Image optimization Content quality Keyword density Copyscape Webmaster tools Google analytics tool Posting information Archieves Do-follow and No-follow Indexing and Catching And more on-page techniques Directory Submissions Social Bookmarking Blog Commenting Forums Postings Press Release Article Submissions Local Business Listings Search Engine Submissions Social Networking Web 2.0 Submission Blog posting Link wheel Hub page creation Squidoo lens Classifieds Submissions All algorithm updates of google will be discussed and we can help you practice on our live sites.

Metaforum Technologies institute located at vadapalani in chennai offers 30 Day(s) of J2EE training course in Chennai with 100% Placement Assistance.

Trainer is from TCS. He has 5 years of experience in Java Technologies and has trained lot of students enrolled with us. You can know his expertise when you sit for a class.He will update all material

INTRODUCTION TO ENTERPRISE EDITION � Distributed Multitier Applications � J2EE Containers � Web Services Support � Packaging Applications � J2EE 1.4 APIs JAVA SERVLET TECHNOLOGY � What is Web Application? � What Is a Servlet? � Servlet Life Cycle � Sharing Information � Using Scope Objects � Controlling Concurrent Access � Getting Information from Requests � Constructing Responses � Filtering Requests and Responses � Programming Filters � Customized Requests and Responses � Specifying Filter Mappings � Invoking Other Web Resources � Including Other Resources in the Response � Transferring Control � Accessing the Web Context � Maintaining Client State � Session Management � Session Tracking � Tracking Service Requests � Notifying Methods to Shut Down � Creating Polite Long-Running Methods JSP TECHNOLOGY � JavaServer Pages Technology � The Life Cycle of a JSP Page � Translation and Compilation � Creating Static Content � Response and Page Encoding � Creating Dynamic Content � Using Objects within JSP Pages � Expression Language � Deactivating Expression Evaluation � Implicit Objects � Literals & Operators � Reserved Words � JavaBeans Components � Reusing Content in JSP Pages � Transferring Control � jsp:param Element � Including an Applet � Setting Properties for � Groups of JSP Pages MESSAGE DRIVEN BEAN � The Application Client � The Message-Driven Bean Class � The onMessage Method � The ejbCreate and ejb � Remove Methods � Advanced Enterprise Beans � EJB: Query Language � Terminology � Simplified Syntax � Simple Finder Queries � Navigate to Related Beans � Other Conditional Expressions � Select Queries � BNF Symbols � BNF Grammar of EJB QL � FROM Clause � Path Expressions � WHERE Clause � SELECT Clause � ORDER BY Clause ENTERPRISE BEANS � What Is an Enterprise Bean? � What Is a Session Bean? � What Is an Entity Bean? � What Is a Message-Driven Bean? � Client Access with Interfaces � The Contents of an Enterprise Bean � Naming Conventions for Enterprise Beans � The Life Cycles of Enterprise Beans BEAN MANAGED PERSISTENCE � Entity Bean Class � Home Interface � Remote Interface � Mapping Table Relationships for BMP � One-to-One Relationships � One-to-Many Relationships � Many-to-Many Relationships � Primary Keys for BMP SESSION BEAN � Session Bean Class � Home Interface � Remote Interface � Helper Classes � Creating the Application � Stateless Session Bean � Implementation Class � Container Managed Persistence � Method Invocations � Building and Running � Creating the Database Tables � Creating the Data Source � Capturing the Table Schema � Building the Enterprise Beans � Primary Keys for CMP � Finder and Selector Methods JAVA MESSAGE SERVICE API � Overview � What Is Messaging? � When Can You Use the JMS API? � Basic JMS API Concepts � JMS API Architecture � The JMS API Programming Model � Administered Objects � Connections � Sessions � Message Producers � Message Consumers � Writing Simple JMS Client Applications