Call :+91 8055223360
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
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 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 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 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
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 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 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 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 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 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
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 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 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 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 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 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 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
Course completion certificate and Global Certifications are part of our all Master Program
Course completion certificate and Global Certifications are part of our all Master Program
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%
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/
Radical Technologies is a recognized leader in training of Administrative and Soft ware Development courses since 1995 to empower IT individuals with competitive advantage of exploiting untapped jobs in IT sector