College Original

Structured Query Language (SQL) Level 1 (Copy)

Name: Structured Query Language (SQL) Level 1 (Copy)
Price: 749 USD

$NaN

Need Financial Assistance?

Tombolo Institute at Bellevue College

Online - ScheduledType

Jul 13, 2021Enrollment Deadline

2.1 Continuing Education UnitsEducation Credits

Jul 20, 2021 - Aug 10, 2021Course Dates

30 AvailableTotal Seats

Course Details

Gain hands-on practice using a standard structured query language (SQL).

Create queries using a standard structured query language (SQL) that is applicable to almost any relational database. Gain hands-on practice creating queries to retrieve data in various forms, including filtered, calculated, grouped and aggregated, sorted and consolidated from multiple data sources. You’ll also practice writing queries to manipulate data in a table and create, alter and drop tables and views.

After This Course, You Will Be Able To

Use the WHERE clause in a SELECT statement to retrieve filtered data from a relational database
Apply aggregate, date and string functions to data retrieved from a relational database
Use the ORDER BY, GROUP BY and HAVING clauses to retrieve data from a relational database
Use a self-join operation to retrieve data from a single data source or a variety of operators, or subqueries to retrieve data from multiple data sources
Use the INSERT, UPDATE, DELETE and TRUNCATE commands to manipulate data in a table
Revise a relational database by creating, altering and dropping tables and views