Mysql Training Institute In Delhi

Mysql Training Institute in Pitampura Delhi

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

Outline

  1. Introduction
    • What is SQL?
    • Installation Environment
  1. SQL Quick Start
    • Quick-start introduction
    • Save Quick-start introduction
    • Using the basic SELECT statement
    • Save Using the basic SELECT statement
    • Selecting rows
    • Save Selecting rows
    • Selecting columns
    • Save Selecting columns
    • Counting rows
    • Save Counting rows
    • Inserting data
    • Save Inserting data
    • Updating data
    • Save Updating data
    • Deleting data
    • Save Deleting data
  1. Fundamentals
    • Databases and tables
    • Save Databases and tables
    • SQL syntax overview
    • Save SQL syntax overview
    • Formatting SQL
    • Save Formatting SQL
    • Creating tables
    • Save Creating tables
    • Deleting a table with DROP TABLE
    • Save Deleting a table with DROP TABLE
    • Inserting rows into a table
    • Save Inserting rows into a table
    • Deleting rows from a table
    • Save Deleting rows from a table
    • Understanding NULL
    • Save Understanding NULL
    • Controlling column behaviors with constraints
    • Save Controlling column behaviors with constraints
    • Changing a schema with ALTER
    • Save Changing a schema with ALTER
    • Creating an ID column
    • Save Creating an ID column
    • Filtering data with WHERE, LIKE, and IN
    • Save Filtering data with WHERE, LIKE, and IN
    • Removing duplicates with SELECT DISTINCT
    • Save Removing duplicates with SELECT DISTINCT
    • Sorting with ORDER BY
    • Save Sorting with ORDER BY
    • Conditional expressions with CASE
    • Save Conditional expressions with CASE
  1. Relationships
    • Understanding joins
    • Save Understanding joins
    • Accessing related tables with JOIN
    • Save Accessing related tables with JOIN
    • Using multiple related tables
    • Save Using multiple related tables
  1. Strings
    • About SQL strings
    • Save About SQL strings
    • Finding the length of a string
    • Save Finding the length of a string
    • Selecting part of a string
    • Save Selecting part of a string
    • Removing spaces with TRIM
    • Save Removing spaces with TRIM
    • Making strings uppercase and lowercase
    • Save Making strings uppercase and lowercase
  1. Numbers
    • About numeric types
    • Save About numeric types
    • Finding the type of a value
    • Save Finding the type of a value
    • Integer division and remainders
    • Save Integer division and remainders
    • Rounding numbers
    • Save Rounding numbers
  1. Dates
    • Dates and times
    • Save Dates and times
    • Date- and time-related functions
    • Save Date- and time-related functions
  1. Aggregates
    • How aggregates work
    • Save How aggregates work
    • Using aggregate functions
    • Save Using aggregate functions
    • Aggregating DISTINCT values
    • Save Aggregating DISTINCT values
  1. Transactions
    • Why use transactions?
    • Save Why use transactions?
    • Using transactions
    • Save Using transactions
  1. Triggers
    • Updating a table with a trigger
    • Save Updating a table with a trigger
    • Preventing automatic updates with a trigger
    • Save Preventing automatic updates with a trigger
    • Automating timestamps with a trigger
    • Save Automating timestamps with a trigger
  1. Subselects and Views
    • Creating a simple subselect
    • Save Creating a simple subselect
    • Searching within a result set
    • Save Searching within a result set
    • Creating a view
    • Save Creating a view
    • Creating a joined view
    • Save Creating a joined view
  1. A Simple CRUD Application
    • Touring the CRUD application
    • Save Touring the CRUD application
    • The SELECT functions
    • Save The SELECT functions
    • The INSERT, UPDATE, and DELETE functions
    • Save The INSERT, UPDATE, and DELETE functions
TOP