College Original

Structured Query Language (SQL) Level 2

Name: Structured Query Language (SQL) Level 2
Price: 629 USD

$NaN

Need Financial Assistance?

Tombolo Institute at Bellevue College

Online - ScheduledType

Apr 27, 2021Enrollment Deadline

2.1 Continuing Education UnitsEducation Credits

May 4, 2021 - May 20, 2021Course Dates

20 AvailableTotal Seats

Course Details

Create queries using transact structured query language (T-SQL) commands. In this intermediate SQL course, you’ll create queries using transact structured query language (T-SQL) commands that are used with SQL Server databases. Gain hands-on practice creating queries to merge data between tables, track data changes on tables, rank data and compare tables. Students will also join data from subqueries and table-valued functions, perform recursive queries with hierarchical data, use common table expressions in place of complex joins, query Excel data, and transfer XML data between a SQL Server table and an outside file.

After This Course, You Will Be Able To

Create queries using transact structured query language (T-SQL) commands that are used with SQL Server databases
Understand how to create queries in order to merge data between tables, track data changes on tables, rank data and compare tables
Join data from subqueries and table-valued functions, perform recursive queries with hierarchical data, use common table expressions in place of complex joins, query Excel data and transfer XML data between a SQL Server table and an outside file