universal-informatics
  • Home
  • ABOUT US
  • SERVICES
    • Software Training
      • Industrial Training
        • MCA Project Training
          • Training For BE (EC)
          • Track -1 For EC(System & Network Administration)
          • Track -2 For EC(EMBEDDED)
          • Track -3 For EC( VLSI Using VHDL)
          • Track -4 For EC( Embedded Using Arduino & PCB)
          • Track -5 For EC(RF Survey)
        • Industrial Training for BE with Live Project
          • Training For BE (CS/IT)
          • TRACK 1 (Core Java, Advance Java & Live Project)
          • TRACK 2 (Advance Java & Live Project)
          • TRACK 3 (Advance Java, J2EE & Live Project)
          • TRACK 4 (J2EE & Live Project)
          • TRACK 5 (Android & Live Project)
          • TRACK 6 (Core Java, Android & Live Project)
          • TRACK 7 (PHP & Live Project)
          • TRACK 8 (CodeIgniter, Wordpress & Live Project)
          • TRACK 9 (ASP.Net & Live Project)
          • TRACK 10 (MVC.Net & Live Project)
          • TRACK 11 (Web Designing & Live Project)
          • TRACK 12 (IOS Programming & Live Project)
          • TRACK 13 (Big-Data, Hadoop & Live Project)
          • TRACK 14 (Kotlin & Live Project)
          • TRACK 15 (Python & Live Project)
          • TRACK 16 (MEAN Stack & Live Project)
          • TRACK 17 (Web Designing Expert & Live Project)
          • TRACK 18 (Cloud Computing)
      • Placement Training
        • Job Oriented Training
          • Placement Training On PHP
          • Placement Training On Android
          • Placement Training On MEAN
          • Placement Training On IOS (IPhone)
          • Placement Training On Java/J2EE
          • Placement Training On .Net
      • Short Term Training
        • Basic
          • C, C++ And Data Structures
        • Java
          • Core PHP With Wordpress
          • Advance PHP (CodeIgniter, Wordpress)
          • Core Java (Java 8) Programming
          • Advance Java Programming
          • J2EE (Java 2 Enterprise Edition)
          • OCJP 1.7
          • Web Application (ASP.Net) Using C# 4.5 (Visual Studio 2013)
          • Web Application Using C# 4.5 (Visual Studio 2013) Direct
          • Advanced .Net 4.5 (Visual Studio 2013)
          • Open Cart
          • Cake PHP
        • .NET
        • Database
          • Oracle 11g SQL & PL/SQL Programming
          • MySQL 5 (SQL & PL/SQL Programming)
          • OCA
          • OCP
        • Mobile App.
          • Android Application Development
          • IPhone & IPad Application Development
        • PHP
        • Other
          • ORACLE Certification (Developer Track)
          • Oracle Java Certification
          • CCNA
          • CCNP
          • Linux
          • Ethical Hacking And Network Security
    • Telecom Services
    • H/W & Networking
      • Advanced Linux Administration
      • Basic VLSI Front End Design Using VHDL
      • CCNA (Cisco Certified Network Associate) (640-802)
      • Ethical Hacking and Network Security
    • Software Development
  • PLACEMENTS
  • CLIENTS
    • Institutional Clients
    • Placement Clients
    • Corporate Clients
  • CAREER
    • Jobs
    • Life At Universal
  • GALLERY
  • CONTACT US

SQL & PL/SQL Programming on SQL Server

SQL & PL/SQL Programming on SQL Server

Transact SQL (T-SQL)

  • DDL Statements
  • Constraints
  • Working on Tables (DML). 
  • Select ,Insert
  • Update, Delete
  • Single row functions
  • Group function with Rollup & Cube
  • Distinct
  • Order by Clause
  • Cross, Inner, Outer, Equi, Non-Equi, Self Joins
  • Single Row & Multiple Row Subquery
  • Advanced Sub-Query
  • Co-Related with DML
  • TCL Statements
  • Commit Transaction
  • Rollback Transaction
  • Database objects
  • Views (Normal, Read Only)
  • Indexes

Procedural Query Language (PL/SQL)

  • Anonymous Block 
  • Structure of block, Coding style
  • Conditional Statements, IF ELSE
  • Cursors and Exception Handling
  • Cursors, Exception Handling
  • Sub Programs
  • Stored Procedure
  • User Defined Functions
  • Triggers

Database Administration

  • Creating Manually Database in SQL Server
  • User & Privileges
  • User Creation, Object Navigator
  • User Roles
  • Attach/Detach Files

UPCOMING BATCHES

For Batch Detail Please Contact Phone no 0731-2535381

© 2019 By Universal Informatics  |   All Rights Reserved