Webfire Themes Weebly Templates
    Mapple Jaipur
    info@mapple.ac.in
        mapple.edusoft@gmail.com
    Call us :  8233-25-2525
                          8233-54-5555
    • Home
    • Profile
      • Meet the Team
      • Partner with us
      • Webmail
      • Career >
        • Code of Conduct
    • Services
    • Training
      • Online Registration
      • IT Training >
        • Oracle Training >
          • Oracle 11g Database (DBA) >
            • 11g: Introduction to SQL
            • 11g: Administration Workshop 1
            • 11g: Administration Workshop 2
          • Oracle 10g Database (DBA) >
            • 10g: Introduction to SQL
            • 10g: Administration Workshop 1
            • 10g: Administration Workshop 2
          • Oracle 9i Database (DBA) >
            • 9i: Introduction to SQL
            • 9i: Administration Fundamentals 1
            • 9i: Administration Fundamentals 2
            • 9i: Performance Tuning
        • Big Data >
          • Introduction to Big Data
          • Big Data Essentials
        • Java Training >
          • Java Fundamentals SE6 (OCJA)
          • Java Fundamentals SE7 (OCJA)
          • Java Fundamentals SE8 (OCJA)
          • Java SE6 (OCJP)
          • Java SE7 (OCJP)
          • Java SE8 (OCJP)
          • Java SE 7 New Features
          • Java SE 8 New Features
          • Java EE6 Developing App (OCWCD)
          • Java EE6 Servlets & JSP (OCWCD)
          • Java EE6 EJB TECHNOLOGY (OCBCD)
        • PHP With MySQL >
          • PHP Training & MySQL
          • MySQL for Developers
        • Ethical Hacking
        • SEO Training
      • SSC Training >
        • SSC SYLLABUS TIER-I >
          • QUANTITATIVE APTITUDE
          • GENERAL MENTAL ABILITY
          • ENGLISH
          • COMPUTER AWARENESS
          • GENERAL KNOWLEDGE
    • Certification
    • Online Test
      • Admin
    • Alliances
    • Placement
    • Contact Us
      • Bank Details

    MySQL for Developers

    What you will learn:
    This course gives in-depth knowledge of the skills, tools, and issues involved in writing applications with the MySQL database server. It forms the core of the MySQL Developer learning path, and covers the programming topics in MySQL, from queries, data types, and functions through to transactions, triggers, and stored procedures. The course
    examines the tools used by MySQL development professionals, and uses real-world examples in explaining how to generate complex queries, and consume them in your application. Students perform lab work with common programming languages, connecting to MySQL databases and executing queries and stored routines. In addition, it will prepare students for the Oracle Certified Professional, MySQL 5 Developer certification.

    Why PHP Training from Mapple Edusoft :
    • Official Course-ware from Oracle University.
    • Authorized Structured PHP Training in Jaipur.
    • Highly Qualified PHP Industry Experts as Trainer.
    • Hands on experience on PHP Software.
    • Course Completion Certificate From Oracle University.
    • Discount Vouchers for International Exams.
    • 10 Full-length Online Mock Tests (Real-life PHP® Exam) per Module.
    Prerequisites:
    • Experience with having created tables and queries within relational Databases, and comfort with basic SQL statements and another MySQL for Beginners NEW

    Course Topics:
      • Introduction
        • MySQL Product
        • MySQL Services and Support
        • MySQL Resources
        • Example Databases
        MySQL Client/Server Concepts
        • MySQL General Architecture
        • Diskspace use
        • Memory use
        MySQL Clients
        • Invoking Client Programs
        • Using Option Files
        • The MySQL Client
        • MySQL Workbench
        • MySQL Connectors
        • Third Party APIs
        Querying for Table Data
        • The SELECT Statement
        • Aggregating Query Results
        • Using UNION
        • Import and Export Data
        Handling Errors and Warnings
        • SQL Modes
        • Handling Missing or Invalid Data Values
        • Interpreting Error Messages
        • Conditions and Signals
        • Error Handling when using Connectors
        Data Types
        • Data Type Overview
        • Numeric Data Types
        • Character String Data Types
        • Binary String Data Types
        • Temporal Data Types
        • Spatial Data Types
        • NULLs
        SQL Expressions
        • SQL Comparisons
        • Functions in SQL Expressions
        • Comments in SQL Statements
        Obtaining Metadata
        • Metadata Access Methods
        • The INFORMATION_SCHEMA Database/Schema
        • Using SHOW and DESCRIBE
        • The mysqlshow Command
        Database
        • Database Properties
        • Good Design Practices
        • Identifiers
        • Creating Databases
        • Altering Databases
        • Dropping Databases
        Tables
        • Creating Tables
        • Table Properties
        • Column Options
        • Creating Tables Based on Existing Tables
        • Altering Tables
        • Dropping Tables
        • Foreign Keys
        Manipulating Table Data
        • The INSERT Statement
        • The DELETE Statement
        • The UPDATE Statement
        • The Replace Statement
        • INSERT with ON DUPLICATE KEY UPDATE
        • The TRUNCATE TABLE Statement
        Transactions
        • What is a Transaction
        • Transaction Commands
        • Isolations Levels
        • Locking
        Joins
        • What is a Join?
        • Joining Tables in SQL
        • Basic Join Syntax
        • Inner Joins
        • Outer Joins
        • Other Types of Joins
        • Joins in UPDATE and DELETE statements
        Subqueries
        • Types of Subqueries
        • Table Subquery Operators
        • Correlated and Non-Correlated Subqueries
        • Converting Subqueries to Joins
        Views
        • What are Views?
        • Creating Views
        • Updating Views
        • Managing Views
        • Obtaining View Metadata
        Prepared Statements
        • Why use Prepared Statements
        • Using Prepared Statements for the mysql client
        • Executing a Prepared Statement
        • Deallocating a Prepared Statement
        • Programming with Prepared Statements
        Stored Routines
        • What is a Stored Routine?
        • Creating Stored Routines
        • Compound Statements
        • Assign Variables
        • Parameter Declaration
        • Execute Stored Routines
        • Stored Routine Characteristics
        • Examine Stored Routines
        Triggers
        • What are Triggers
        • When to Use Triggers
        • How to Delete Triggers
        • Restrictions on Triggers
        Optimization and Monitoring
        • Overview of Optimization Principles
        • Using Indexes for Optimization
        • Using EXPLAIN to Analyze Queries
        • Using Performance Schema to Analyze Performance
        • Query rewriting techniques
        • Optimizing Queries by Limiting Output
        • Using Summary Tables
        • Optimizing Updates
      Certificate From Oracle University :
      PHP Training in Jaipur
      PHP Training in Jaipur
      Authorized Java Training in Jaipur @ Mapple Edusoft

      OUR SERVICES : 

      IT Training & Skill Development
      International Certification
      Earn & Learn
      Software & Website Development
      Business Support Services
      Infrastructure leasing
      Franchise

      Company :

      About Us
      Contact Us
      Terms and Conditions
      Privacy Policy
      Disclaimer of Warranty

      Alliances :

      Oracle - Java - WDP
      EC - Council
      MeritTrac Services Pvt. Ltd
      Aspiring Minds
      Hughes Communication India Ltd.

      Contact US

      • Mapple Edusoft Private Limited
        78, 3rd Avenue, Goms Defence Colony,
        Vaishali Nagar, Jaipur - 302021
        Rajasthan
      • +91-8233-54-5555
        +91-8233-25-5555
      • info@mappleedusoft.com
      • www.mappleedusoft.com

      Back to top