This SQL for Report Writers and Analysts training teaches attendees the basics of Transact SQL, including writing simple and complex queries, working with data types, building functions, and more. Students also learn how to combine data from multiple tables and result sets using JOIN operations and subqueries. Students then take their skills to the next level with advanced query concepts, including ranking functions and common table expressions (CTE’s). Finally, they learn how to change data in the database using Data Manipulation Language (DML).
Note: This class is appropriate for SQL Server 2012 through 2017.
We also offer a 3-day class to cover the basics if your group does not wish to include advanced topics.
Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.
All students will be able to:
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
All SQL training students receive comprehensive courseware.
Attendees will need SQL Server Developer Edition or Express Edition (versions 2012 through 2017), including the database engine and Management Studio, as well as sample databases that Accelebrate will provide.
Accelebrate’s training classes are available for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us.Contact Us
New York City
Salt Lake City