SQL ESSENTIAL TRAINING

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

⇓