Course outline for MySQL and Relational Databases
Lab Setup
Operating System – Ubuntu 20.04/22.04 Desktop or Server Edition
Training Mode
Online training for MySQL and Relational Databases
We provide:
- Instructor led live training
- Self-paced learning with access to expert coaches
- 24x7 access to cloud labs with end to end working examples
All jnaapti sessions are 100% hands-on. All our instructors are engineers by heart. Activities are derived from real-life problems faced by our expert faculty. Self-paced hands-on sessions are delivered via Virtual Coach.
Classroom training for MySQL and Relational Databases
Classroom sessions are conducted in client locations in:
- Bengaluru
- Chennai
- Hyderabad
- Mumbai
- Delhi/Gurgaon/NCR
Note: Classroom training is for corporate clients only
Detailed Course Outline for MySQL and Relational Databases
Overview of SQL
- Datastore design considerations
- Relational stores
- Entities, Relationships and Database modeling
Installation
- Installing MySQL server and client
- Starting and stopping the server
- Connecting to a local or remote server
Database
- Creating databases
- Dropping databases
- Listing all the databases
Tables
- Fields
- Creating tables
- Listing tables
- Getting the definition of an existing table – DESCRIBE and SHOW CREATE TABLE
- Altering tables
- Working with relationships – primary and foreign keys
- 1..1
- 1..n
- m..n
CRUD
- Creating records
- Retrieving records
- SELECT
- FROM
- WHERE
- ORDER BY
- GROUP BY/HAVING
- LIMIT/OFFSET
- Joins
- Inner Join
- Left Join
- Right Join
- Full Join
- Aggregation functions
- COUNT
- MIN
- MAX
- SUM
- Updating records
- Replacing records
- Deleting records
Indexing
- Need for indexes
- How indexes improve performance
- Types of indexes – b-tree, hash, spatial, fulltext
- Evaluating the performance of queries
- Adding indexes
- Determining the performance of an index
Command Line Interface
- Running commands in batch mode
- mysqladmin
- Importing data
- Dumping data
Client Libraries – A Case Study
- Installing a client driver
- Using MySQL through the the client driver
NoSQL – An introduction
- When to use Relational/NoSQL?
- Categories of NoSQL stores
- Examples of NoSQL stores
- NoSQL patterns in MySQL