Oracle SQL Pl/sql Training at futurepointtech.com
 

 
Posted By : Individual    Posted On : 28-December-2017
 
Ad Details
SQL and PL/SQL Course Syllabus 1. DBMS Concepts • What is Database? • What is Database System? • E.F.CODD’s Rules • RDBMS • ORDBMS • Difference Between DBMS, RDBMS & ORDBMS 2. SQL • What is SQL? • DDL Commands • Create, Alter, Drop • Truncate, Rename • DML Command – Insert • SQL SELECT statements a. Order by Clause b. Distinct Clause c. Where Clause d. Operators e. Comparison Conditions • Constraints a. Primary Key Constraint b. Unique Constraint c. Not Null Constraint d. Foreign Key Constraint e. Check Constraint f. Cascade Constraints • Joins a. What is a Join? b. Cartesian Join c. Equi Join d. Non – Equi Join e. Self Join f. Outer Join g. Left Outer Join h. Right Outer Join i. Full Outer Join j. Pseudo Columns • Functions a. Numeric Functions b. Character Functions c. Date Functions d. Conversion Functions e. General Functions f. Aggregating Data Using Group Functions • Sub Queries a. Simple Sub Queries b. Multiple Row Sub Queries • Update a. Data Updating b. Updating data using Sub Queries • Delete a. Deleting Data b. Deleting data using Sub Queries c. Deleting data using join • Transaction Control Language (TCL) a. Commit b. Roll back c. Save point • Database Objects a. View b. Synonym c. Sequence d. Index e. Privileges • View a. Simple View b. Complex View c. In Line View • Synonym a. Private Synonym b. Public Synonym • Privileges a. Grant b. Revoke 3. PL/SQL • Block Structure of PL/SQL • Data Types, Variables & Constants • Flow Control Statements a. Simple IF b. IF-THEN-ELSE Statements c. IF-THEN-ELSIF Statements • Iterative Statements a. Simple Loop b. While Loop c. For Loop • Attribute Data Types a. %type b. %Rowtype • Cursor Management a. What is Cursor? b. Implicit Cursor c. Explicit Cursor d. Cursor with parameters e. Cursor with For Loop • Exceptions a. What is an Exception? b. Predefined Exception c. User defined Exception • Sub Programs a. Named PL/SQL Block b. Stored Procedures c. Types of Parameters d. Stored Function e. Difference between Function and Procedure • Package a. What is package? b. Importance of package • Triggers a. What is a Trigger? b. Row Level Trigger c. Table Level Trigger d. Instead of Trigger e. DML Triggers f. System Triggers Courses Offered in Our Training Institute: • Courses Offerings • Amazon Web Services • Android • AIX Administration • Business Analyst • Build and Release • CA Siteminder • CCNA, CCNP Security, CCIE , CheckPoint • Citrix XenApp • Cognos 10 BI & Tm1 • Crystal Reports • Data Stage • DB2 DBA • Dell Bhoomi • Dev Ops • Dot Net • Google Web Tool Kit • Golden Gate • Hadoop • Hyperion Essabase, Planning, HFR , HFM , DRM • IBM Websphere Commerce server Admin • IBM Lotus Notes (Development) • IBM Lotus Notes Domino Server Administration • IBM Message Broker • IBM MQ Series Administration • IBM Netezza DBA & Development • IBM Tivoli Access Manager • IBM Web Sphere Application Server Administration (WAS) • IBM Websphere Transformation extender (WTX 8.2) • IBM Integration BUS ( IIB ) • Informatica • I Phone • Swift Language training • Java/J2EE • JAVA UI • Java Apache Wicket • Linux Administration training • Mango DB • MicroSoft .NET Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc) • Microstrategy • MicroSoft Business Intelligence MSBI • MS Power BI • OBIEE 11 g , 12c • ODI ( Oracle Data Integrator) • Openstack • Oracle APPS – HRMS, SCM, Manufacturing , Technical , ASCP .Dmantra • Oracle APPS – Project Accounting • Oracle APPS - iProcurement , iSupplier, Sourcing • OAF • Oracle BI Apps • Oracle BI Publisher • Oracle DBA 11g • Oracle RAC , Data Guard , Performance Tuning, • Oracle Fusion SOA • Oracle SQL , PL SQL • People soft Functional and Technical • PHP • Perl Scripting • Qlikview • RSA Archer Security Operations Management (SecOps) Essentials • RUBY Cucumber • SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil, BODS • SAP Simple Finance • SAS • Sales Force CRM • Service NOW • SharePoint Server 2010 • Shell Scripting • SQL Server DBA • Springs and Hibernate • Storage Area Network ( SAN) • Tableau • Team Foundation Server • Tera Data • Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB • TIBCO BW, BE, TIBCO I Process , BPM • Tivoli Access Manager & Tivoli Storage Manager • Unix & Linux Administration • VMWare • WCF, WPF, LINQ, AJAX, SILVER LIGHT • Webservices , SOAP , REST ( JAVA) • Windows 2012 server Drop a mail info@futurepointtech.com we will get in touch with u http://www.futurepointtech.com/oracle-11g-sql-pl-sql-training.html

Locality : HYDERABAD

City : HYDERABAD

Price : 500048

Visitors : 15

Reply AD