About

SQL

Introduction to MYSQL

Sorting Data

Filtering Data with Predicates

Filtering Data with Top and Bottom

Working with Unknown values

Basic Queries in MYSQL

How to retrieve data from MYSQL

Understanding the Order of Operations inSelect Statements

Fetching Duplicates with Distinct

Using Coumns & Tables Aliases

Writing Simple Case Expressions

Writing Order by/ Group by

Sorting and Filtering Data

Sorting Data

Filtering Data with Predicates

Filtering Data with Top and Bottom

Working with Unknown values

Grouping and Aggregating Data

Using Aggregate Functions

Using the Group By Clause

Filtering Groups with Having

Adding Tables

Creating Tables

Altering Tables

Adding new Columns

Altering existing columns

Data type Decrease/Increase

Columns by insert

MYSQL Constraints

No Null Constraint

Default Constraints

Unique key Constraints

Primary key constraints

Foreign key constraints

MYSQL Joins

Understanding Joins

Querying with Inner Joins

Querying with Outer Joins

Querying with Left & Right Joins

Querying with Cross Joins & Self Joins

MYSQL String Functions

Left, Right Functions

UCase, LCase Functions

Length, Format, Concat etc.

MYSQL Triggers

Types of triggers

How to use triggers

What are cursonrs

Eliminate cursors and temp tables

Implementing MYSQL

Tracking real time scenarios

Project basis training