Price:
$1,295.00
Days:
1
Virtual
– • Use SQL Server query tools
– • Write SELECT statements to retrieve columns from one or more tables
– • Sort and filter selected data
– • Use built-in functions to return data values
– • Create groups of data and aggregate the results
– • Modify data with Transact-SQL using INSERT, UPDATE, DELETE, and MERGE
No specific prerequisites are required for this course. Basic computer literacy and familiarity with fundamental concepts in the subject area are recommended for the best learning experience.
• LAB Outline
• LAB Outline
• LAB Outline
• Get Started Querying with Transact-SQL
• Get Started Querying with Transact-SQL
• Get Started Querying with Transact-SQL
• Modify data with T-SQL
• Modify data with T-SQL
• Modify data with T-SQL
• Introduction to Transact-SQL
• Introduction to Transact-SQL
• Introduction to Transact-SQL
• Sort and filter results in T-SQL
• Sort and filter results in T-SQL
• Sort and filter results in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Combine multiple tables with JOINs in T-SQL
• Write Subqueries in T-SQL
• Write Subqueries in T-SQL
• Write Subqueries in T-SQL
• Use built-in functions and GROUP BY in Transact-SQL
• Use built-in functions and GROUP BY in Transact-SQL
• Use built-in functions and GROUP BY in Transact-SQL
Support Diversity, Equity, and Inclusion with Every Purchase.
Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.
Give your organization the skills edge it needs. Our corporate training experts will work with you to design, deliver, and support a customized IT program that drives real business results.