MySQL Certification Course

Both experienced and novice professionals looking to learn to code can get started with SQL, Oracle, MySQL databases and more. Oracle MySQL Certification Training is perfect for professionals to learn how to access, add, and manage database content.

Both experienced and novice professionals looking to learn to code can get started with SQL, Oracle, MySQL databases and more. Oracle MySQL Certification Training is perfect for professionals to learn how to access, add, and manage database content.

DBMS SQL

Duration – 2days.
➢ Getting Started with Database
– Introduction to Database
– Characteristics of DBMS
– Data models
– Relational DBMS
➢ Basics of SQL
– The SQL Language
– Standard SQL Statement Groups
– Logging to MySQL
➢ Data Query Language
– The SELECT statement
– The WHERE clause
– Comparison, Mathematical, and Logical operators
– The DISTINCT clause
– The ORDER BY clause
– limit, offset (top n analysis)
➢ Aggregate (Group) functions
– The Group function
– GROUP BY & HAVING clause
– Examples of GROUP BY and HAVING clauses
➢ SQL (Single-row) functions
– SQL functions
– Number functions
– Character functions
– Date functions
➢ Joins and Sub-queries
– Joins
– Types of Joins
• inner join—equijoin, nonequi join, self join • Outer join -→left right and full outer join
– Sub-query
➢ Introduction to Data Modeling, E-R model and Normalization
– Data Modeling
– E-R model
– Normalization (1 NF , 2 NF , 3 NF,BCNF)
– Advantages and Disadvantages of Normalization
➢ Lesson 8: Database Objects
– Basic Data Types
– Data Integrity
– CREATE TABLE
– ALTER TABLE
– Index
– View
➢ Set Operators
– Set Operation
– The UNION Operator
➢ Data Manipulation Language
– Adding Data
– Removing Data
– Modifying Data
➢ Transaction Control Language
– Introduction to Transactions
– Statement Execution and Transaction Control
➢ Data Control Language
– Object Privileges
– Grant and Revoke Statements
PLSQL
➢ PL/SQL Basics
– Introduction to PL/SQL
– PL/SQL Block Structure
– Handling Variables in PL/SQL
– Declaring a PL/SQL table
– SQL in PL/SQL
➢ Introduction to Cursors
– Introduction to Cursors
– Processing Cursors
➢ Exception Handling
– Error Handling (Exception Handling)
➢ Procedures, Functions, and Packages
– Subprograms in PL/SQL
– Anonymous Blocks versus Stored Subprograms
– Procedures
– Functions
➢ Database Triggers
– Concept of Database Triggers
– Types of Triggers ---Before and After
– Disabling and Dropping Triggers
– Restriction on Triggers
– Using :Old and :New values,