Skip to main content
  • 4.7
  • 5.0

Official Learning Partner

Course Highlights

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads. Register Today

With Concept wise mock tests and Realtime Case Studies we ASSURE you 100% Hands-On Training with detailed explaination. Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

Practice Material, Certification, Resume & Interview Guidance are included in this MYSQL DBA Training.

  • Practical Training
  • Reak-Time Training
  • Daily Tasks
  • Weekly Assignments
  • Mock Interviews
  • Placement Assistance

Course Content

MySQL-Training
Course Contents

MySQL-Training Course Contents

CHAPTER 1 : INTRODUCTION TO DBMS

  • What is Data and Information?
  • Purpose of Data Management
  • File and File System For Data Storage
  • Disadvantages of File Data Management
  • Database : Purpose, Basic Terminology
  • Advantages of Database for Data Storage
  • Possible Operations on the Database
  • Database Models – Hierarchical Model
  • Network Model and Relational Model
  • Introduction to DBMS
  • Introduction to RDBMS
  • Database Design
  • Most Popular RDBMS Products
  • History, Real-time Database Examples (LIVE)

CHAPTER 2 : MYSQL INSTALLATION

  • MySql Installation Guidance
  • MySql 8 Installation
  • Installation Pre-Requisites and Precautions
  • MySql Workbench 8.0
  • My Sql Command prompt
  • Mysql Versions and Editions Comparisions
  • Connect Workbench Developer Tool
  • Creating a new User
  • Grant permission
  • Lock and Unlock User Account
  • How to Reset User Account Password
  • How to Establish the MySql Connection
  • Default System user in MySql
  • Default Sysdba user in MySql

CHAPTER 3 : INTRODUCTION TO RDBMS

  • Features of RDBMS
  • Advantages of RDBMS
  • E.F Codd Rules for RDBMS
  • Normalization Concepts & Process
  • Client Server Communication
  • Oracle Corporation Products
  • RDBMS from Other Vendors: Microsoft, IBM,etc
  • MySql Versions
  • Database Types: OLTP and OLAP Databases
  • Real-world Advantage of OLTP & OLAP
  • Why a database is called as Relational Database Model
  • Database Entites and Attributes
  • Applicative use of RDBMS Databases

CHAPTER 4 : SQL LANGUAGE COMMANDS – 1

  • Structured Query Language (SQL) Basics
  • What is SQL?
  • What Can SQL do?
  • Possible Operations with SQL
  • Data Definition Language (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)
  • Rules of SQL Queries and Statements
  • Real-world applicative uses of SQL
  • Creating Users and Tables

CHAPTER 5 : SQL LANGUAGE COMMANDS – 2

  • Table Data Inserts and Validations
  • Oracle Data Types
  • DDL Commands with Examples
  • CREATE, ALTER, TRUNCATE,DROP,RENAME
  • Learn the DESCRIBE command to display the table structure
  • DML Command DRL Commands Operators
  • INSERT, UPDATE, DELETE Statements
  • Difference between Truncate and Delete commands
  • SELECT Statements with Multiplier
  • SQL Comments
  • Single Line Comments & Multi Line Comments

CHAPTER 6.SQL SPECIAL OPERATORS

  • SET, AND, OR, NOT, IN
  • Special Operators – IN (NOT IN)
  • BETWEEN (NOT BETWEEN),
  • Arithmetic and Logical Operators
  • Understand Operator Precedence
  • UNION, UNION ALL, INTERSECT, MINUS
  • LIKE (NOT LIKE), IS NULL (IS NOT NULL)
  • Understanding DCL and TCL Commands
  • Transaction Concepts in Databases with SQL
  • Transaction Types and Uses
  • Commit and Rollback Operations
  • Nested Transactions with Savepoints
  • Database Read Consistency with SQL</

CHAPTER 7: GROUPING QUERY RESULTS

  • Identify Distinct Values in Tables
  • Group Function or Aggregate function
  • Group By Syntax
  • Group By Operations in Queries
  • Having Clause of DRL Statements
  • Aggregate Functions with Group By
  • Order By Clause and Group By
  • SQL Group By Statement
  • Query Execution Order with Group By
  • Arithmetic Functions,Character Function
  • Date & Time Functions,String Function
  • Conversion Functions,Analytical Function
  • Rank(), Dense_Rank(),Row_Number()
  • IFNULL() FUNCTION

CHAPTER 8 : CONSTRAINTS & KEYS

  • Importance of Data Integrity
  • Working with Integrity constraints
  • Types of Integrity Constraints
  • Domain Integrity Constraint and Usage
  • Entity Integrity Constraints and Usage
  • Referential Integrity Constraint and Usage
  • Check Constraints and Usage
  • NOT NULL Constraint, UNIQUE Constraint
  • PRIMARY KEY Constraint and Usage
  • FOREIGN KEY Constraints and Relations
  • Column Level & Table Level Constraints
  • Adding Constraints to Tables, User_Constraints
  • Enabling – Dropping Constraints, Self Referential Integrity
  • Disabling Constraints on Tables

CHAPTER 9 : QUERIES & JOINS

    • Need for Joins and Table Comparisons
    • SET Operations on Tables and Joins

How do Joins work in SQL?

What does (+) mean in SQL joins?

  • Join Types : Equi Join, Simple Join
  • Inner Join and Query Conditions
  • Cross Join (Cartesian Join), Conditions
  • Join syntax – Sql syntax and Ansi Syntax
  • Non-Equi Join and Self Join
  • Outer Joins – Types, Advantages and Usage
  • Cross Joins – Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Using Inner Self Joins with HAVING

 

CHAPTER 10 : VIEWS, SYNONYMS,SEQUENCES

  • VIEWS IN ORACLE, Understanding Views & Use
  • Relational Views and Standard Views
  • SIMPLE VIEWS and COMPLEX VIEWS in MYSQL
  • Column Definitions in VIEWS
  • Using VIEWS for DML Operations
  • Forced Views, CHECK Constraints in Views
  • Creation of READ ONLY VIEWS – Realtime Use
  • Sequences, with Synonyms
  • What is the Use of Synonym in Oracle?
  • Difference between View and Synonym in mysql
  • When should Table Synonyms be used?
  • Why views are used in MySQL?

CHAPTER 11 : SUB QUERIES, NESTED QUERIES – 1

  • Sub Queries in Real-world
  • Dynamic Conditions with Sub Queries
  • Sub Queries and Nested Sub Queries
  • How does oracle Execute Nested Sub Queries?
  • Inner Select and Outer Select Queries
  • Usage of Sub Queries with WHERE, HAVING
  • Impact of Having Clause in Sub Queries
  • Select Nth Highest salary
  • Select Duplicate Records
  • Delete Duplicate Records
  • Advantages of MySql Sub Query

CHAPTER 12 : SUB QUERIES, NESTED QUERIES – 2

  • Subquery in the Select Clause Examples
  • Subquery in the From Clause Examples
  • Display Odd Rows in a table
  • Display Even Rows in a table
  • Execution of Correlated Sub Queries in SQL
  • IN, ANY SOME, ALL Operators in Sub Queries
  • PAIR WISE and NON PAIR WISE in Sub Queries
  • Single Row Subquery & Multiple Row Subquery
  • Multiple Column Subquery
  • UnCorrelated Subquery
  • Difference between Correlated and Non-Correlated Subquery
  • How does Mysql Execute Correlated Subquery?
  • NULLs and Correlated Sub Queries in SQL

CHAPTER 13 : PERFORMANCE (QUERY) TUNING

  • Indexes – Definition and Architecture
  • B Tree Concept in Indexes
  • Clustered and Non clustered Indexes
  • Primary Key and Clustered Index
  • Unique Key and Non Clustered Indexes
  • Simple Index, Rebuild Index
  • Materialized Views – Indexed Views
  • Composite Index, Function Based Index
  • User_indexes System Table
  • Range Partitions and Hash Partition
  • List Partition and Composite Partition
  • Parallel Query Process with Partitions
  • Performance Tuning Advantages
  • What are the types of indexing in MySQL?

CHAPTER 14 : MYSQL – (CONTROL STRUCTURE) – Level I

  • Simple If, If..Else. Nested If..Else Statements
  • Ladder, Selection, Simple Case Statements
  • GOTO Label and EXIT Statements in MYSQL
  • Iterations in MYSQL, Simple LOOP, WHILE
  • FOR LOOP and NESTED LOOPS in MYSQL
  • MYSQL Select statements
  • SQL within MYSQL, Composite Data Types
  • Cursor Variables and Management in MYSQL
  • Implicit & Explicit Cursors and Attributes
  • Cursor with Parameters and Nested LOOPs
  • Cursors with Sub Queries, Reference Cursors
  • Implicit Cursors,Explicit Cursor
  • Parameterized Cursors,Ref Cursors
  • MySql Cursors Usage

CHAPTER 15: ADVANCED MYSQL – 1

  • Procedures in MYSQL: STORED PROCEDURE
  • PROCEDURES @ Parameters (IN, OUT, IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors and Sub Queries
  • ALTER and DROP of Stored Procedures
  • Functions in MYSQL: Real-time Usage
  • User Defined Functions, Nested Functions
  • Using Functions in SQL Statements
  • Working with Procedures and Functions
  • Comparing Stored Procedures and Functions
  • Using SPs with Table Value Functions
  • Using SPs for Dynamic SQL Statements
  • Loops and Table Variables in SQL Programs

CHAPTER 16 : ADVANCED MYSQL – 2

    • Pragma_Autonomous_Transaction() with SPs
    • Returning into clause, Bulk Collect
    • For All, Definer/Invoker Rights & Usage
    • About Flash Back Queries, Dynamic SQL
    • Flash Back Command, Purge Command
    • Regular Expressions in MYSQL
    • What is the Recycle Bin?
    • How to Delete RecycleBin Table?
    • How to Delete Recycle Bin?

How do I delete all data in MySQL?

Where are views stored in MySQL?

CHAPTER 17 : ADVANCED MYSQL – 3

  • Types of Triggers, Row Level Triggers
  • Statement Level Triggers, DML Triggers
  • DDL Triggers and Schema Level Triggers
  • Using OLD & NEW References, Trigger Auditing
  • Enabling / Disabling Triggers, Dropping Triggers
  • Triggers in MYSQL and Data Manipulations
  • Using Memory Tables in Triggers
  • DML and DDL Events with Triggers
  • Compound Triggers, New data types
  • Working with LARGE Tables in MYSQL
  • WHERE Keyword for Query Conditions

CHAPTER 18 : ADVANCED MYSQL – 4

  • MySql 8’s New Features
  • Indexing your data for High Performance
  • Advanced Data Techniques for Large Queries
  • Mysql Data Dictionary in MySQL
  • Advanced MySQL PerformanceTips and Techniques
  • What are the advanced MySQL topics?
  • What is considered advanced in SQL?
  • What is advanced query?
  • What are strong SQL skills?
  • How do I write an advanced SQL query?
  • What should I learn after MySQL?
  • Can we write procedure in MySQL?

"*" indicates required fields

Training Mode*
Courses*
Course Fee:INR 15000
Duration :4 Weeks

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Technical FAQs

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL ServerT-SQLSQL Server DBA and MSBI (SSISSSASSSRS) Courses. All our training services are completely practical and real-time.CREDITS of SQL School Training Center

  • We are Microsoft Partner. ID# 4338151
  • ISO Certified Training Center
  • Completely dedicated to Microsoft SQL Server
  • All trainings delivered by our Certified Trainers only
  • One of the few institutes consistently delivering the trainings for more than 8+ Years online as inhouse
  • Real-time projects in
    • Healthcare
    • Banking
    • Insurance
    • Retail Sales
    • Telecom
    • ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last EIGHT years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even aftrer the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register.html. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance
×