Ms access sql

MS Access SQL VBA Training to Design & Create Database and Tables, Query, Table and Create Forms & how you can build re-usable structures which will benefit you time to time. In this training student learn how to use SQL to retrieve, store or update data in Microsoft Access. One of the most prominent software used by organizations to create analysis and reporting programs from massive databases including SQL Server and accounting, Sybase, etc, is VBA or Visual Basic for Applications.

1. Live projects 2. Project based training in VB 6.0, SQL, MS Access & vba, Basic and Advance Excel, SAS, Html, C# + sql. Training is only based on projects. 6 projects are included in this training. Preference would be for those candidates who are pursing Graduation level courses or doing BPO Jobs.

VGREDDY TECHNOLOGIES is a leading computer training Institute for IT services, training, Development, Consultancy services based in Hyderabad, Andhra Pradesh, India. Iam VGREDDY, Teacher, Trainer, Project Manager of VGREDDY TECHNOLOGIES , Hyderabad having 26 + years of experience in teaching, training, development on client/server, internet,ERP Technologies and Engineering Subjects. we are offering home tutions online trainings and class room training for C, C++, EXCEL ADVANCED EXCEL , EXCEL WITH VBA, MS OFFICE, MS PROJECT, MS VISIO, MS ACCESS, ADVANCED MS ACCESS, ORACLE 10g,11g(SQL,PLSQL) D2K FORMS 6i/10g, REPORTS 6i/10g, vb6.0, html, css, vbscript, javascript from vgreddy 9885464910

WEEK ENDS TRAINING ONLINE TRAINING ON MS ACCESS, EXCEL WITH VBA PLSQL D2K , oracle MS OFFICE VB6 ADVANCED EXCEL C CPP INFORMATION TECHNOLOGY SUBJECTS FROM VGREDDY 9885464910

We take this opportunity to introduce ourselves as ‘GITS Academy’ a Leading name in Corporate IT Training and online training. We provide training for analytical software like Advance Excel VBA, Access, SQL server, Ms Access, MSBI SPSS and SAS. Our Advance Excel Training Includes: 1. Advanced Data analysis and Data Management using Excel . A) Advanced Data Analysis: - Pivot tables & Reports, Goal seek, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation, macros writing in Excel/VBA. Duration: 20hrs…. 2. VBA/macros programming in Excel. Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excel’s Events, Interacting with Other Applications, Controlling Program Flow and Making Decisions IF, If Else, Else if, Select...While Error-Handling Techniques, Bug Extermination Techniques Etc. Duration: 20hrs… 3. Advanced VBA/macros programming in Excel. Primer in Excel VBA, Workbooks and Worksheets, Using Ranges, Using Names, Data Lists, PivotTables, Charts, and Event Procedures, Adding Controls, Text Files and File Dialog, User Forms, RibbonX, Interacting with Other Office Applications, Data Access with ADO, Managing External Data, Programming the VBE,…. Duration: 30hrs… 4. MS Access. OOPS, Advanced programming Concepts, Active X Controls, Conversions, Automations, ActiveX Data Objects, Set Forms Reports, Properties, Criteria Statements, Error Codes, Functions Etc. Duration: 20hrs… 5. SQL Server Training: Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to generate databases that can be accessed from workstations, the Internet, or other media such as a personal digital assistant (PDA). Database and Relational Database Management systems, Data Types, Creating, altering and manipulating tables, Data Manipulation language: using select, insert, update and delete commands, Using filter clauses, operators and SQL functions, Column & table alias joins, Queries and indexes triggers, stored procedures, Etc. Duration: 24hrs

Iam VGREDDY, Teacher, Trainer, Project Manager of VGREDDY TECHNOLOGIES , Hyderabad having 19 + years of experience in teaching, training, development on client/server, internet,ERP Technologies and Engineering Subjects. we are offering home tutions online trainings and class room training for C, C++, EXCEL ADVANCED EXCEL , EXCEL WITH VBA, MS OFFICE, MS PROJECT, MS VISIO, MS ACCESS, ADVANCED MS ACCESS, ORACLE 10g,11g(SQL,PLSQL) D2K FORMS 6i/10g, REPORTS 6i/10g, vb6.0, html, css, vbscript, javascript from vgreddy 9885464910

MS Business Intelligence Training at VARNAAZ Academy About Microsoft Business Intelligence [MS BI]: Microsoft BI solutions leverage your existing technology investments in.NET, SQL Server and Office to develop rich integrated reporting and analytic experiences that empower users to gain access to accurate, up-to-date information for better, more relevant decision making. This unit provides an introduction to Business Intelligence and to Microsoft BI from a developer perspective. Why MS BI: 1.Improved Technology Management 2.Improved Information for Decision Making 3.Improved Customer & Partner Management 4.Perfect career for SQL aspirants 5.Complete package Please feel free to contact for further clarifications required Dinesh Kumar Agrahari Sales Executive Call @ ,

MS Business Intelligence Training at VARNAAZ Academy About Microsoft Business Intelligence [MS BI]: Microsoft BI solutions leverage your existing technology investments in.NET, SQL Server and Office to develop rich integrated reporting and analytic experiences that empower users to gain access to accurate, up-to-date information for better, more relevant decision making. This unit provides an introduction to Business Intelligence and to Microsoft BI from a developer perspective. Why MS BI: 1.Improved Technology Management 2.Improved Information for Decision Making 3.Improved Customer & Partner Management 4.Perfect career for SQL aspirants 5.Complete package Please feel free to contact for further clarifications required Dinesh Kumar Sales Executive Call @ ,

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact VENKI, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com ,,,,

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. ................................................................................................... You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training. You Can Attend FREE DEMO Classes| We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.... You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.|||||||||||||||| You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training../,. You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

SQL SERVER DBA ONLINE TRAINING Training Icon is a Global Interactive Learning company started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. Training Icon has a pool of Expert Trainers worldwide on all the technologies to train the students. Training Icon is offering Training services to Major IT giants and to individual students worldwide. About Our faculty: we have excellent SQL SERVER DBA instructors who have real time experience plus expert orientation in Online Training.,./.// You Can Attend FREE DEMO Classes We offer you: 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions We have a new batch starting on SQL SERVER DBA Online Training. We also provide online training on SAP HANA, SAP BASIS, SAP ABAP, SAP FICO , SAP BI, SAP BO,SAP OIL & GAS, SAP All Modules, ORACLE APPS ALL MODULES,ORACLE DBA,WORKDAY,HADOOP,JAVA,MS DYNAMICS AXAPTA,ALL ETL TOOLS, WEBLOGIC Experience the Quality of our Online Training. For Free Demo Please Contact Srinivas, INDIA: +91-9666900051, US: +1 408-791-8864, Email id: info@trainingicon.com http://www.trainingicon.com

AssignmentTutorHelp.com brought you help with Database Management System (DBMS) course: DBMS Provides efficient, reliable, convenient and safe multi-user storage of and access to massive amounts of persistent data. If you are looking for MS SQL Server Homework Help you have come to the right place. We offer the best Homework Help for SQL Server. In many ways most of the databases are the same i.e., in terms of all of them being based on SQL queries to retrieve the required information.

Type Computer Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented SQL Server Training Courses in bangalore. Our SQL Server training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time SQL Server projects knowledge which will provide you an edge over other training institutes. Our SQL Server training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in SQL Server Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our SQL Server Training course content and syllabus based on students requirements to achieve everyone's career goal. Our SQL Server Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for SQL Server Training in our centres located across bangalore. We also provide Online Training Classes for SQL Server Training Course. Contact us today to schedule a free demo and complete course details on SQL Server Training Course. What is SQL Server Training ? SQL Server Training Objectives Installing Microsoft SQL ServerUpgrading to SQL Server Management StudioMonitoring the Database ServerDatabase and Index MaintenanceUsing the Database Tuning AdvisorSQL Server Disaster RecoveryDatabase AvailabilityReplicating InformationHTTP Synchronization for Merge ReplicationOLE DB Command objectMonitoring and Performance Training Prerequesites Any Programming Language Knowledge.Good understanding of relational databasesSome experience with client databases, such as Access. Course Details SQL Server Overview Availability and Scalability Features Security Features Data Management Features Administration and Maintenance Features Development Features To enable SQLiMail Testing mail delivery Installing SQL Server SQL Server Editions Installing Microsoft SQL Server System Requirements Preparing for a SQL Installation Installation Checklist Setup Features Using the System Consistency Checker Component Install Unattended Installation Installation Sequence Installation Maintenance Upgrading to SQL Server Management Studio Management Studio Windows Registered Servers Object Explorer Review Database Objects Modify Database Properties Create Database Scripts The Maintenance Plans Node Solution Explorer Query Editor Template Explorer Dynamic Help Upgrading to SQL Server Computer Manager SQL Server Services node SQL Server Network Configuration node SQL Server Native Client Configuration node The SQLCMD Management Utility SQLCMD Syntax SQLCMD Variables Dedicated Administrative Connection SQL Server Management Studio SQLCMD Mode Securing SQL Server Implementing Securable New Security Features Principals Securable Permissions Permission Types Managing Logins Managing Schemas Managing Users Schema Definition Using Schemas Managing Execution Context Managing Permissions Manage Server Permissions Manage Server-Scope Securable Permissions Manage Database Permissions Manage Database-Scope Securable Permissions Native Data Encryption Code and Module Signing Database Availability SQL Data Availability Database Mirroring The Witness Server and Automatic Failover Configuring Database Mirroring Transaction Safety Level Operating Modes High Availability Operating Mode High Protection Operating Mode High Performance Operating Mode Monitoring Mirroring Database States for Database Mirroring Prepare the Servers Configure Mirroring Verify Principal and Mirror Access Execute the Mirror Failover Verify Mirror and Witness Status Terminating the Mirror Session SQL Server Integration Services Creating the Database Objects Creating a Package Using Business Intelligence Studio Integration Services Project Template OLE DB Command object Column Mappings Adding a Data Viewer Monitoring the Database Server Managing Metadata Views Metadata Storage System Views Information Schema Catalog Views Sys All Dynamic Management Views System Stored Procedures Database and Index Maintenance Index Management New Index Features Creating Indexes Online Index Maintenance Parallel (multiple CPU) Index Operations Lock Options Included Columns in Indexes Partitioned Tables and Indexes XML Index Support Altering an Index Rebuilding an Index Reorganizing an Index Disabling an Index Dropping an Index Index Fragmentation Using the Database Tuning Advisor SQL Server Disaster Recovery Disaster Recovery SQL Disaster Recovery Feature Enhanced Features Database Snapshots Creating a Snapshot Common Snapshot Applications Undeleting table rows Undoing a table update Recovering a dropped object Backup and Restore Media Integrity Changes Recovering the MASTER Database Create a mirrored backup Restore from the backup mirror Create a snapshot Restore the snapshot data Automate the creation of daily snapshots Replicating Information Replication Enhancements Stand-alone Replication Monitor Support for Oracle Publishing HTTP Synchronization for Merge Replication Subscriber Initialization Replicating DDL Statements Modified User Interface Replication Management Objects To Configure Publishing and Distribution Configuring Peer-to-Peer Replication Create a Publication Create a Subscription with RMO Monitoring and Performance SQL Server Profiler Optimal Data Storage Diagnostic Tools Query Analyzer Database Engine Tuning Advisor Index Optimization Federated Database Servers Partitioned Indexes Lock Optimization SQL Server Training Course Details Duration:30 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

What we offer: KITS Online Trainings understand the need for a quality training curriculum along with real-time implementation exposure as it forms the very essence of your future career in SQL Server DBA. Our well-structured online training course in SQL Server DBA extensively covers all the core aspects of SQL Server DBA with an emphasis on live scenarios. Users get the complete flexibility in choosing their batch timings from weekend or weekday slots. Access to expert trainers and instructor led training sessions ensure that you can easily clear your doubts and get the exact guidance that is expected from a classroom training session. Course Overview BASIC SQL SERVER AND T-SQL BASIC ADMINISTRATION ADVANCED ADMINISTRATION The Advantage you get with KITS Online SQL Server DBA Course: Flexibility in choosing training sessions as per your existing schedule Advantage of completing the course at your own place and convenience Training resources are prepared by Industry Experts in SQL Server DBA with rich real-time experience Interactive training sessions with 24/7 access to support and training resources Focus on building interview skills with extensive interview questions and resume writing tips Real-time implementation projects, course exercises, assignments and complete access to expert faculty Please contact for more details KITS Online Technologies Ph: +91

SQL-PL SQL SQL •The Oracle database environment Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g •Basic SELECT Statement Writing the statement in sqlplus, Running the SELECT statement •Ordering the output Single Column, Descending order, Multiple column sort •Conditional retrieval of data Working with complex conditions, AND OR NOT,,,, LIKE BETWEEN •Pseudo columns and functions Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table •Working with character functions UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), •Working with date functions TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() •Using non-character function ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins, Writing Outer Joins •Using the SET operators Union, Intersect, Minus •Aggregating data using group functions GROUP BY, HAVING •Creating Subqueries Single Row subqueries, Multiple row Subqueries •Enhancing groups function ROLLUP, CUBE •Transaction Control Language Rollback, Commit, Savepoint •Processing hierarchies Creating the Tree structure, LEVEL, CONNECT BY •Data Manipulation Language INSERT, UPDATE, DELETE •Data Definition Language CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE •Using Declarative Constraints Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null •Other Database Objects Views, Sequences, Synonyms, Indexes USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS •Database Security Object Privileges, Granting access to objects PL -SQL •Blocks Structure, Writing Anoyomous Blocks •Variables Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments •Control structures IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END, LOOP statement, WHILE condition, FOR condition •Cursors Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN •Error Handling Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions •Procedures Creating and Calling Procedures •Functions Creating and Calling Functions •Packages Package Header, Package Body •Design Tips and Techniques Format of standard packages in an application, Spec and Body, NOCOPY hint ------------- thoery •Triggers Database triggers, CALLing procedures from triggers •Dynamic SQL EXECUTE IMMEDIATE, DBMS_SQL package •Oracle Supplied packages DBMS_OUTPUT, UTL_FILE •Collection datatypes Associative Arrays, Nested tables, VARRAYs For More Details contact us: Elegant It Services contact no: