MySQL Training and Certification Course In Pune

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

• UNION/UNION ALL
• INTERSECT
• MINUS
• Set Operator Guidelines
• Controlling the Order of Rows
• Assignments

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

• About Cursors
• Explicit Cursor Operations
• Controlling Explicit Cursors
• Declaring the Cursor
• Opening the Cursor
• Fetching Data from the Cursor
• Fetching Data from the Cursor using Loop
• Closing the Cursor
• MySQL CURSOR Restriction
• Cursors with Subqueries
• Assignments

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum

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

Download Curriculum