We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases. This course is designed to help users understand the most common language for database wrangling. The content covers major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views.

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
Reviews
Be the first to write a review about this course.
Write a Review

St.Hua Private School is established in 1997 by a group of experienced graduates from recognized universities such as National University of Singapore (NUS) and Nanyang Technological University (NTU).

Additionally, most of our courses are subsidized by SkillsFuture credit, an initiative offered by the Singapore Government to upgrade Singapore Citizens’ skills by providing each citizen with $500 in funding to partake any eligible course they wish.

Ultimately, we aim to ensure that students are better equipped with the necessary skill sets to meet the requirements of society, to prepare them for the workforce and to enhance and elevate current workers’ skills so that they can better fit their current job and propel them to further heights in Singapore society.

Furthermore, St.Hua Private School is recognized and accepted by CPE (Council of Private Education) to practice as a private school from 9th January 2017 to 8th January 2021.

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.