MY SQL DEVELOPER TRAINING IN BANGALORE

2376 Reviews
4.8/5
2180 Learners

Overview

Duration of Training : 175 hrs

Batch type : weekdays /weekends/ Customized Batches

Mode of Training: Offline / Online / Corporate Training

Projects Given : 2 Projects minimum

Trainer Profile : Experienced Faculty from IT Industry

Projects | Assignment |  Scenarios and Used Case Studies

Watch
INTRO VIDEO

Why Radical Technologies

  • Highly practical oriented training
  • 25000+ Man-hours of Real-time projects & scenarios
  • 10 to 20+ year Experienced corporate trainers With Real Time Experience.
  • Building up professionals by highly experienced professionals
  • 100 % quality assurance in training .
  • 10000+ Placement Records and 180+ MNC’s and Consultancies Tie up

Check Batch Schedulings

Module-1 Retrieving Data Using the MySQL SELECT Statement

Module-1 Basic SELECT Statement
Module-1 Selecting All Columns
Module-1 Selecting Specific Columns
Module-1 Arithmetic Expressions
Module-1 Defining a Null Value
Module-1 Duplicate Rows
Module-1 Displaying Table Structure
Module-1 Assignments

Module-2 Restricting and Sorting Data

Module-2 Limiting Rows Using a Selection
Module-2 Using the WHERE Clause
Module-2 Character Strings and Dates
Module-2 Comparison Conditions
Module-2 Logical Conditions
Module-2 Rules of Precedence
Module-2 Using the ORDER BY Clause
Module-2 Using the LIMIT Clause
Module-2 Assignments

Module-3 Using Single-Row Functions to Customize Output

Module-3 MySQL Functions
Module-3 Two Types of MySQL Functions
Module-3 Single-Row Functions
Module-3 Character Functions
Module-3 Case-Manipulation Functions
Module-3 Character-Manipulation Functions
Module-3 Number Functions
Module-3 Working with Dates
Module-3 Arithmetic with Dates
Module-3 Date Functions
Module-3 Conversion Functions
Module-3 Nesting Functions
Module-3 General Functions
Module-3 Conditional Expressions
Module-3 Assignments

Module-4 Reporting Aggregated Data Using the Group Functions

Module-4 Types of Group Functions
Module-4 Group Functions and Null Values
Module-4 Creating Groups of Data
Module-4 Using the GROUP BY Clause
Module-4 Restricting Group Results
Module-4 Using the HAVING Clause
Module-4 Assignments

Advanced MySQL Topics

Module-5 Displaying Data from Multiple Tables

Module-5 Obtaining Data from Multiple Tables
Module-5 Types of Joins
Module-5 Joining Tables Using SQL:1999 Syntax
Module-5 Creating Natural Joins
Module-5 Creating Joins with the USING Clause
Module-5 Using Table Aliases
Module-5 Creating Joins with the ON Clause
Module-5 Self-Joins Using the ON Clause
Module-5 Applying Additional Conditions to a Join
Module-5 Creating Three-Way Joins with the ON Clause
Module-5 Non-Equijoins
Module-5 Outer Joins
Module-5 INNER Versus OUTER Joins
Module-5 LEFT | RIGHT OUTER JOIN
Module-5 Cartesian Products
Module-5 Cross Join
Module-5 Assignments

Module-6 Using Subqueries to Solve Queries

Module-6 Using a Subquery to Solve a Problem
Module-6 Guidelines for Using Subquery
Module-6 Types of Subqueries
Module-6 Single-Row Subqueries
Module-6 Using Group Functions in a Subquery
Module-6 The HAVING Clause with Subqueries
Module-6 Multiple-Row Subqueries
Module-6 Using the ANY Operator in Multiple-Row Subqueries
Module-6 Using the ALL Operator in Multiple-Row Subqueries
Module-6 TOP-N Analysis using Subquery
Module-6 Assignments

Module-7 Using the Set Operators

Module-7 UNION/UNION ALL
Module-7 INTERSECT
Module-7 MINUS
Module-7 Set Operator Guidelines
Module-7 Controlling the Order of Rows
Module-7 Assignments

Module-8 Manipulating Data

Module-8 Data Manipulation Language
Module-8 Adding a New Row to a Table
Module-8 INSERT Statement Syntax
Module-8 Inserting Rows with Null Values
Module-8 Copying Rows from Another Table
Module-8 Changing Data in a Table
Module-8 UPDATE Statement Syntax
Module-8 Updating Two Columns with a Subquery
Module-8 Updating Rows Based on Another Table
Module-8 Removing a Row from a Table
Module-8 DELETE Statement
Module-8 Deleting Rows from a Table
Module-8 TRUNCATE Statement
Module-8 Database Transactions
Module-8 Advantages of COMMIT and ROLLBACK Statements
Module-8 Controlling Transactions
Module-8 Rolling Back Changes to a Marker
Module-8 State of the Data After COMMIT
Module-8 Committing Data
Module-8 State of the Data After ROLLBACK
Module-8 Statement-Level Rollback
Module-8 Read Consistency
Module-8 Implementation of Read Consistency
Module-8 Assignments

Module-9 Using DDL Statements to Create and Manage Tables

Module-9 Database Objects
Module-9 CREATE TABLE Statement
Module-9 DEFAULT Option
Module-9 Data Types
Module-9 Including Constraints
Module-9 NOT NULL Constraint
Module-9 UNIQUE Constraint
Module-9 PRIMARY KEY Constraint
Module-9 FOREIGN KEY Constraint
Module-9 CHECK Constraint
Module-9 Violating Constraints
Module-9 Creating a Table by Using a Subquery
Module-9 ALTER TABLE Statement
Module-9 Dropping a Table
Module-9 Assignments

Module-10 Creating Other Schema Objects

Module-10 What Is a View?
Module-10 Advantages of Views
Module-10 Simple Views and Complex Views
Module-10 Creating a View
Module-10 Retrieving Data from a View
Module-10 Modifying a View
Module-10 Creating a Complex View
Module-10 Rules for Performing DML Operations on a View
Module-10 Using the WITH CHECK OPTION Clause
Module-10 Removing a View
Module-10 Sequences (AUTO_INCREMENT)
Module-10 Using a Sequence
Module-10 Indexes
Module-10 Creating an Index
Module-10 Type of Index
Module-10 Removing an Index
Module-10 Assignments

Advanced MySQL-Programming Topics
Module-11 Declaring MySQL Variables

Module-11 Use of Variables
Module-11 Identifiers
Module-11 Handling Variables in MySQL
Module-11 Declaring and Initializing MySQL Variables
Module-11 Delimiters in String Literals
Module-11 Use of Select Statement in Block
Module-11 Assignments

Module-12 Writing Control Structures – Procedure

Module-12 Controlling Flow of Execution
Module-12 IF Statements
Module-12 Simple IF Statement
Module-12 IF THEN ELSE Statement
Module-12 IF ELSEIF ELSE Clause
Module-12 NULL Values in IF Statements
Module-12 CASE Statement
Module-12 CASE Statement: Example
Module-12 Searched CASE Expressions
Module-12 MySQL CASE vs. IF
Module-12 Iterative Control: LOOP Statements
Module-12 Basic Loops
Module-12 WHILE Loops
Module-12 REPEAT Loops
Module-12 Assignments

Module-13 Using Cursors – Procedure

Module-13 About Cursors
Module-13 Explicit Cursor Operations
Module-13 Controlling Explicit Cursors
Module-13 Declaring the Cursor
Module-13 Opening the Cursor
Module-13 Fetching Data from the Cursor
Module-13 Fetching Data from the Cursor using Loop
Module-13 Closing the Cursor
Module-13 Mysql CURSOR Restriction
Module-13 Cursors with Subqueries
Module-13 Assignments

Module-14 Handling Exceptions

Module-14 Declaring a handler
Module-14 MySQL error handling examples
Module-14 MySQL handler example in stored procedures
Module-14 MySQL handler precedence
Module-14 Using a named error condition
Module-14 MySQL handler precedence
Module-14 MySQL SIGNAL statement
Module-14 MySQL RESIGNAL statement
Module-14 Assignments

Module-15 Creating Stored Functions

Module-15 Describe the uses of functions
Module-15 Create stored functions
Module-15 Invoke a function
Module-15 Remove a function
Module-15 Differentiate between a procedure and a function
Module-15 Assignments

Module-16 Creating Stored Procedures

Module-16 Describe and create a procedure
Module-16 Create procedures with parameters
Module-16 Differentiate between formal and actual parameters
Module-16 Use different parameter-passing modes
Module-16 Invoke a procedure
Module-16 Handle exceptions in procedures
Module-16 Remove a procedure
Module-16 Assignments

Module-17 Creating Triggers

Module-17 Describe the different types of triggers
Module-17 Describe database triggers and their uses
Module-17 Create database triggers
Module-17 Describe database trigger-firing rules
Module-17 Remove database triggers
Module-17 Assignments

Training Options

Live Online Training

  • Highly practical oriented training
  • Installation of Software On your System
  • 24/7 Email and Phone Support
  • 100% Placement Assistance until you get placed
  • Global Certification Preparation
  • Trainer Student Interactive Portal
  • Assignments and Projects Guided by Mentors
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

  • Weekend / Weekdays / Morning / Evening Batches
  • 80:20 Practical and Theory Ratio
  • Real-life Case Studies
  • Easy Coverup if you missed any sessions
  • PSI | Kryterion | Redhat Test Centers
  • Life Time Video Classroom Access ( coming soon )
  • Resume Preparations and Mock Interviews
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Exam & Certification

Course Reviews

Why we are the best Radical Technologies

Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.

Creative

0%

Innovative

0%

Student Friendly

0%

Practical Oriented

0%

Valued Certification

0%

Training FAQs

Similar Courses

MYSQL DEVELOPER TRAINING IN BANGALORE

Learning MYSQL was a pleasant experience here. Sir has indepth knowledge of all the concepts which he is explaining. He has a passion for teaching and follows a perfect methodology of explaining the concepts. I definitely recommend students to join RADICALS Academy.

Course Provider: Organization

Course Provider Name: Radicals Technologies

Course Provider URL: https://radicals.in/

Editor's Rating:
5