|By Marketwired .||
|August 14, 2013 08:00 AM EDT||
SAN FRANCISCO, CA -- (Marketwired) -- 08/14/13 -- Embarcadero Technologies announced today it is hosting an online event titled "Common Table Expressions on SQL Server," featuring SQL Server expert Rick Morelan. Two separate sessions will be held on Aug. 20, 2013.
Have you ever wanted to create a recursive query, but didn't see how to do it? What about finding and cleaning duplicates? Now you no longer have to cringe when asked to turn a self-join table into a tree path outline or level hierarchy.
Each of these goals is now just one query if you use a common table expression (CTE). Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries.
Attendees will learn:
- What is a CTE and how it compares to other subqueries
- How a CTE can simplify complex subqueries
- How to create outlines, tree paths, and hierarchies from a single query using CTEs
Tuesday, Aug. 20, 2013
7:00 a.m. PT / 10:00 a.m. ET
11:00 a.m. PT / 2:00 p.m. ET
To register for the "Common Table Expressions on SQL Server," webinar, visit: http://bit.ly/CommonTableExpressions.
About the Presenter
Rick Morelan has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI, which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008.) As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.
About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance, and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. www.embarcadero.com