• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 678-701-4914

About Course:

mysql

MySQL is an open-source database management system that is being used to manage database systems, retrieving data from database tables, etc. ... SQL is a type of programming language which is used for manipulating data in the database.


Duration : 25 hours

Fee: 438


Job Trends

Training Calender

Date Time Type Attend
4th May 2024 8:00 AM   IST Demo
7th May 2024 8:00 AM   IST Regular
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

MySQL Download  

MySQL Training Outline

Relational Database Basics

  • Brief History of SQL
  • Relational Databases
    • Tables
    • Rows
    • Columns
    • Relationships
    • Datatypes
    • Primary Keys
    • Foreign Keys
    • Relational Database Management System
  • Popular Databases
    • Commercial Databases
    • Popular Open Source Databases
    • Valid Object References
  • SQL Statements
    • Database Manipulation Language (DML)
    • Database Definition Language (DDL)
    • Database Control Language (DCL)

Simple SELECTs

  • Introduction to the Northwind Database
  • Some Basics
    • Comments
    • Whitespace and Semi-colons
    • Case Sensitivity
  • SELECTing All Columns in All Rows
  • Exploring the Tables
  • SELECTing Specific Columns
  • SELECTing Specific Columns
  • Sorting Records
    • Sorting By a Single Column
    • Sorting By Multiple Columns
    • Sorting By Column Position
    • Ascending and Descending Sorts
  • Sorting Results
  • The WHERE Clause and Operator Symbols
    • Checking for Equality
    • Checking for Inequality
    • Checking for Greater or Less Than
    • Checking for NULL
    • WHERE and ORDER BY
  • Using the WHERE clause to check for equality or inequality
  • Using the WHERE clause to check for greater or less than
  • Checking for NULL
  • Using WHERE and ORDER BY Together
  • The WHERE Clause and Operator Words
    • The BETWEEN Operator
    • The IN Operator
    • The LIKE Operator
    • The NOT Operator
  • More SELECTs with WHERE
  • Checking Multiple Conditions
    • AND
    • OR
    • Order of Evaluation
  • Writing SELECTs with Multiple Conditions

Advanced SELECTs

  • Calculated Fields
    • Concatenation
    • Mathematical Calculations
    • Aliases
  • Calculating Fields
  • Aggregate Functions and Grouping
    • Aggregate Functions
    • Grouping Data
    • Selecting Distinct Records
  • Working with Aggregate Functions
  • Built-in Data Manipulation Functions
    • Common Math Functions
    • Common String Functions
    • Common Date Functions
  • Data Manipulation Functions

Subqueries, Joins and Unions

  • Subqueries
  • Subqueries
  • Joins
    • Table Aliases
    • Multi-table Joins
  • Using Joins
  • Outer Joins
  • Unions
    • UNION ALL
    • UNION Rules
  • Working with Unions

Conditional Processing with CASE

  • Using CASE
  • Working with CASE

Inserting, Updating and Deleting Records

  • INSERT
  • Inserting Records
  • UPDATE
  • DELETE
  • Updating and Deleting Records

Creating and Modifying Tables

  • Data Types
  • Creating Tables
    • NULL Values
    • Primary Keys
    • Foreign Keys
  • Creating Tables
  • Adding and Dropping Columns
  • Renaming Tables
    • SQL Server
    • Oracle and MySQL
  • Dropping Tables

Views

  • Creating Views InnoDB
  • Dropping Views
  • Benefits of Views
  • Creating a View

Stored Procedures

  • Creating Stored Procedures
  • Dropping Stored Procedures
  • Creating a Stored Procedure
  • Benefits of Stored Procedures

 

Who should Learn MySQL?

Prerequisite to learn MySQL

Delivery Methodology used to deliver the MySQL

Class delivery

MySQL FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?