What you need to know to get started
Learn to write simple queries to get the information you need to do your job
Do you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? It’s time to take matters into your own hands.
In this course, you’ll learn how to write a basic SQL query from start to finish. This course will quickly teach you what you need to know to get started. By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter query results, and use simple calculations. We’ll cover commonly used functions, so you can format dates and text as well as calculate sums and averages.
These lessons will help you learn the fundamentals of the SQL language while also introducing you to some of the more advanced topics. If you’re ready to stop waiting on someone else to pull data for you, this course is for you.
Note: This course uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.
Topics covered include:
Enjoy seventy-five minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Powering Productivity, One Brain at a Time!
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.
Peggy Ward has almost two decades of experience facilitating classroom and virtual training for personal and professional development and software applications. As a Microsoft Certified Trainer (MCT), Peggy has educated thousands of professionals in Office Applications such as Excel, Access, Word, PowerPoint, Outlook, and Office 365. She also conducts training in programming languages including VBA and SQL. Peggy has a passion for personal and professional growth and her interest in helping others, as well as her drive for excellence, knowledge, and growth, have made her an outstanding teacher, mentor, and coach.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
