Happy Holidays! from eMexo Technologies..
Call us (+91 9513216462) to get 30% discount now!
All Courses
Programming Courses
Python Certification Training Course
Trending
Python Django Certification Training Course
Node.js Certification Training Course
Java Certification Training Course
Best Seller
Spring Framework Certification Training Course
Spring Boot Certification Training Course
Trending
Hibernate Certification Training Course
Full Stack Web Developer Certification Training Course
Trending
Microsoft .NET Framework Certification Training Course
PHP MYSQL with MVC Certification Training Course
Advanced Java Certification Training
Get your free demo class
Call Us
Cloud Computing
AWS Solution Architect Certification Training Course
Trending
AWS Development Certification Training Course
New
Microsoft Azure Certification Training Course (AZ-305)
Microsoft Azure DevOps Certification Training Course (AZ-400)
Microservices Certification Training Course
Salesforce Developer Certification Training Course
Salesforce Administrator Certification Training Course
Linux Certification Training Course
Get your free demo class
Call Us
DevOps
DevOps Master Program Certification Training Course
DevOps Certification Training Course
Trending
Kubernetes Certification Training Course
Docker Certification Training Course
GIT Certification Training Course
AWS DevOps Engineer Certification Training Course
New
Get your free demo class
Get now
Data science
Python Certification Training Course
Trending
DataScience with Python Certification Training Course
Best Seller
Machine Learning Certification Training Course using Python
Get your free demo class
Call Us
Big Data
Big Data Hadoop Certification Training Course
Trending
Apache Spark and Scala Certification Training Course
Apache Kafka Certification Training Course
Best Seller
Get Your Free Demo Class
Call Us
Software Testing
Selenium Certification Training Course
Trending
Selenium with Python Certification Training Course
New
Selenium with C# Certification Training Course
Manual Testing Certification Training Course
Get your free demo class
Call Us
Robotic Process Automation
RPA using UiPath Certification Training Course
Trending
RPA using Automation Anywhere Certification Training Course
RPA using Blue Prism Certification Training Course
Get your free demo class
Call Us
Frontend Development
Angular Certification Training Course
Trending
React JS Certification Training Course
Best Seller
Web Development Certification Training Course
MERN Stack Certification Training Course
Get your free demo class
Call Us
Databases
SQL Certification Training Course
Oracle Certification Training Course
MongoDB Certification Training Course
Trending
Get your free demo class
Call Us
Mobile Development
Android Certification Training Course
Trending
Get your free demo class
Call Us
Home
About
Gallery
FAQs
Contact
Pages
About
Instructor
Instructor Profile
Become an instructor
Pricing
FAQs
Contact
Pages
Instructor
Become an instructor
Event
new
Blogs
Courses
All Courses
Get your free demo class
Enroll Now
Blog
X
Contact Us
SQL Certification Training Course
Getting Started with MySQL & Installing MySQL
MySQL Overview
Basics of Relational Databases
Entities and Relationships
SQL Language and MySQL
SQL data definition language and data manipulation language
MySQL Client/Server Model
MySQL Connectors
Installation of the MySQL server
Starting and stopping MySQL server
Using the MySQL client
MySQL Workbench
Hands-On
Designing Your Database & Understand Data Types
Database Modeling
Keys and Normalization
Database Design
Viewing and Evaluating a Database
Data Types and Database Design
Numeric, Temporal and String Data Types
Character Set and Collation Support
Data Type Considerations
Meaning of NULL
Hands-On
Creating Databases & Tables
Creating a Database
Creating a Table
Showing How a Table Was Created
Table Options
Column Options
Indexes, Keys, and Constraints
Deleting database and tables
Creating New Table Using an Existing Table
Creating a Temporary Table
Copying an Existing Table Structure
Adding, removing and modifying table columns and indexes
Hands-On
Querying & Modifying Table Data
The SELECT Statement
Creating Views
Querying Data from an Application
Exporting and Importing a Delimited File
Troubleshooting: Authorization Levels
Manipulating Data and inserting records
Replacing and updating existing records
Deleting records
Exporting and importing a script
Multistatement Transactions
Modifying Data from an Application
Hands-On
Joining Tables & Functions
Querying Multiple Tables
Joining Tables with SELECT
Inner Joins
Outer Joins
Table Name Aliases
Functions in MySQL Expressions
Using Functions
String Functions
Date and time functions
Numeric Functions
Aggregate Functions
Spaces in Function Names
Hands-On
MySQL Architecture & Administration Basics
Architectural Overview
Understand how MySQL Transmits Data and Processes Requests
Understand how MySQL Stores Data and Uses Memory
Tablespaces, Redo and Undo Logs
Plug-in Interface
Hands-On
Configuring & Monitoring MySQL Server
Server Configuration Options
Option Files and System Variables
Launching Multiple Servers on the Same Host
Monitoring Tools & Techniques
MySQL Enterprise Audit
MySQL Enterprise Monitor
Monitoring User Activity
Hands-On
User Management
Creating and Modifying User Accounts
Configuring Passwords
Authentication Plug-Ins
Granting Permissions & Grant Tables
Hands-On
Security
Understanding Security Risks
Network Security & Secure Connections
Password & Operating System Security
Hands-On
Backup Tools & Technique
Understanding Backups & Backup Techniques
Creating a Backup Strategy
MySQL Backup Tools
Raw Backup Methods
Hands-On
This content is protected, please
login
and enroll in the course to view this content!
Modal title
Main Content