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!
4 activities • 11 videos • duration: 1h 15m
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.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
Very interactive teaching sessions through the instructor and the learner. They interacted nicely to bring out the way for a non-technical users to use SQL to get results. The example database is useful for our understanding too.
Yes. I would like to learn how to write queries and create reports from the database.
I really like the format of this course, it was very functional, not just a set of powerpoint slides but actual experience. I knew a good deal about SQL before going in, but I was still taught new things like subqueries and joins. It is a very progressive course for beginners or intermediate SQL query writers!
Great course. Step by step instruction and thorough.
