Training dbms

Our Mysql syllabus covers from basic to advanced level according to industries needs. We are notable for our practical approach towards course training which will help candidates to gain real-time exposure. We have experts with experience of 8 years working in real time MNC’S. We conduct classes in both weekdays, weekends, fast track class, online and class room classes. BENEFITS OF PERIDOT • Free demo n courses for two days given by experts • 100% placement assistance • Good interview preparation • Customized syllabus • Limited batch size • Training on both classroom and online • Course completion certificate • Flexible timings MYSQL MYSQL is database used for web applications. It is central components which uses LAMP (LINUX, Apache, My SQL, PHP/ Perl) web application open source software stack. MYSQL is based on web applications so there is demand for SQL professional in present IT industry with hike salary package.We have team of experts working in real time IT industry with experience of 7-8 years and they are certified in MYSQL. Our course content is prepared by experts from basic level to advance according to present industry requirements. We conduct both online and classroom training. Our lab is equipped with latest technologies and has good infrastructure. SYLLABUS OF MYSQL • MYSQL Introduction • Database definition • DBMS basics • RDBMS • Database creation and deletion • User Database creation and deletion • Table • Operations of table like creation, deletion and insertion • Data type • Constraint • SQL Queries • SQL Queries Nested

7Eleventech arthashatra is one of the leading Oracle training institutes in the urban city of chennai.It provides best Oracle training in chennai with latest systematic course material designed by the leading Oracle experts in the industry, which consists of five modules.The trainers in the institute have hands-on corporate experience in Oracle DBMS.Our Institute gives its students flexi-time schedules classes.After the training, students have the option to get assured 100% placement from MNC's.

We, at ICE Technology Lab, offer 4 weeks winter training courses for B.Tech.,BCA,MCA etc. with more emphasis on practical training. We provide best infrastructure and renowned faculties having thorough knowledge of industry. We also arrange industry visit for our trainees. Our courses include C/C++, Java, DotNet, PHP, Android, Web designing, CCNA, CCNP, Matlab, Robotics, Embedded systems, Linux, VLSI, Information security, Cloud computing, Digital marketing, DBMS etc. Visit us at:- ICE Technology Lab 2nd floor, Laxmi pustakalay campus Navin kothi, Opp. Khudabaksh library Ashok Rajapth, Patna-800004

RELATIONAL DATA MODEL : 1.Data and Databases 2.Database Management Systems (DBMS) 3.Information Model & Data Model 4.Relational Data Model & Relational Databases 5.Normalization DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL 1.Product Overview 2.Editions & Features 3.Licensing 4.Fundamentals 5.Architecture 6.Users 7.Instances 8.DB2 Client 9.Storage 10.Table spaces 11.Buffer pools 12.Security 13.SQL and XQuery 14.IBM Data Studio 15.DSAC INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS) 1.Installation 2.Configuration 3.Database creation 4.Instance creation 5.Table space Creation 6.Working with Buffer pool WORKING WITH DATABASES AND DATABASE OBJECT IN DB2 1.Servers, Instances, and Databases 2.Managing Instances 3.Creating a DB2 Database 4.Cataloging 5.Database (Data) Objects INTRODUCTION TO SQL 1.SQL 2.Data Definition Language 3.Data Manipulation Language 4.JOINs 5.Data Control Language 6.Transaction Control Statements DATA CONCURRENCY 1.Database Transactions 2.Concurrency 3.Concurrency Issues 4.Concurrency Control 5.Isolation Levels 6.Locking 7.Specifying Isolation Levels DB2 SECURITY 1.Authentication 2.Trusted Context 3.Authorization 4.Authorities 5.Privileges 6.Label-Based Access Control (LBAC) 7.ROLES DB2 BACKUP AND RECOVERY 1.Backup 2.Recovery DB2 PURE XML 1.Overview of XML 2.PureXML in DB2 3.XML Data Movement in DB2 4.XQuery and SQL/XML 5.XML Indexes in DB2 6.Application Development DB2 PROGRAMMING FUNDAMENTALS 1.Application Development Environment 2.Embedded SQL 3.Static SQL 4.Dynamic SQL 5.Routines 6.Types 7.Benefits 8.Usage 9.Tools for Developing Routines 10.Triggers Our Courses WebSphere SAP Oracle Java Microsoft Tibco PROFESSIONAL COURSES Address Rakesh Kumar +91 9700330693 +1 234 200 0813 info@pradhikatechnology.com pradhikatechnology@gmail.com

We at ICETL Patna provides 6 months, 4 months & 2 months diploma program and 6 weeks certification program in Our courses include C/C++, Java, DotNet, PHP, Android, Web designing, CCNA, CCNP, Matlab, Robotics, Embedded systems, Linux, VLSI, Information security, Cloud computing, Digital marketing, DBMS etc. C/C++/Java/.NET/PHP/ANDROID/INFORMATION SECURITY/EMBEDDED SYSTEM/VLSI/MATLAB/CCNA/CCNP/MPLS/AUTO CAD/CATIA/PRO-E/STAAD PRO/PLC SCADA etc.. with full project assistance for BTECH, BCA MCA and other technical courses at affordable rates. For Details Contact:- 2nd floor,Laxmi centre,Navin Kothi,Opp.Khuda bhaksh library,ashok rajpathPatna-800004 Contact Us At:- 8102927001/02 Landline No:- 0612-3196111 email: icetlpatna@outlook.com website: www.icetl.com

Our courses include C/C++, Java, DotNet, PHP, Android, Web designing, CCNA, CCNP, Matlab, Robotics, Embedded systems, Linux, VLSI, Information security, Cloud computing, Digital marketing, DBMS etc.