In today's world, the individual user may be given access to a large database, and they somehow have to make sense of this huge amount of data. This used to be the responsibility of an IT team, but these days the IT teams do not have the resources to write the reports needed by each person. Many databases use the SQL language to retrieve the proper data from the large database. This course shows you how to start writing your own SQL queries.
- Select statements
- Giving the output field a different name
- Using Where statements to get the exact records you are looking for
- Using Order By statements to sort the data
- Creating Subtotals with the Group By statement
- Introduction to joining tables together
About the Instructor
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, education, retail, etc.
He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.