|
CATEGORY
Microsoft Office |
|
DURATION
Full Day |
|
SKILL LEVEL
Intermediate |
|
PD HOURS
7 |
Description
- Achieve greater command of databases by becoming fluent in their language. Manipulate, summarize and move large amounts of data easily and quickly. Create, modify and delete database objects with greater control by using text instead of visual interfaces.
- Learn how to build powerful, dynamic SQL strings with parameters, joins, unions, subqueries and more. Use data definition SQL to modify tables, constraints, indexes and relationships. Implement Transact-SQL to program databases with stored procedures, triggers, custom functions, cursors and views.
What you'll learn
- Create complex algorithms on large sets of data to make data-driven reporting possible.
- Improve the performance of database tools and models to deliver dashboards and business insights in real-time.
- Elevate the database analysis capabilities of your team by reading and writing SQL.
Who will benefit
Business professionals who want to learn how SQL can allow them to interact directly with databases to ask questions and retrieve answers for data analysis.
Special Instructions / Notes:
Attendees must bring a laptop with Microsoft Office 2013 or newer installed.
|
Our courses emphasize high-quality instruction, interactive learning, and student-centered curricula.
All courses meet the same exacting standards for content excellence and expert instruction. |
|
