SQL
(Structured Query Language)
Essential Training


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.


Topics Cover In This Course

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


That Is All

Subscribe Our YouTube Channel And Stay Tuned

Click Below To Subscribe

⇓


Brought To You Free By VJ SECURITY

Click Below To Download The Course

⇓