SQL 101: A Foundation for Success
In business today there is more data that has to be reviewed and analyzed then ever before. Each individual piece of data is meaningful unto itself, but the collection of data can show trends or reveal metrics that may change the way your business operates. The problem is that the end-user is often responsible to manager their own data as IT teams aren't equipped to handle every data request that comes in. SQL, or structured query language, has become an essential tool for the end-user in order to be able to summarize and analyze data. SQL is used in many applications including Access, SQL Server, Oracle, SAP, SAAS and many others. SQL has become a critical skill for many in order to empower them to run their own queries and extract information from raw data.
Your Benefits of Attending:
- Learn how to give output fields a different name.
- Gain insight into Select statements.
- Learn about Where statements to extract the exact records you are looking for.
- Understand how to use Order By statements to sort the data.
- Learn how to create subtotals with Group By statement.
- Understand how to join tables together and why you would do that.
Join Tom Fragale as he provides you with the SQL foundation that will allow you to be successful using SQL statements.
Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, e... View Full Profile