Learn to write simple queries to get the information you need to do your jobDo you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? Its time to take matters into your own hands. In this course, youll 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, youll be able to retrieve data from multiple tables, sort and filter query results, and use simple calculations. Well 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 youre 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: Retrieving data from one or multiple tablesUsing aliases to simplify your queriesFiltering data with the WHERE clauseUsing Outer JoinsWorking with functions: DATEPART, DATENAME, DATEDIFF, TRIM, SUM, AVGUsing the GROUP BY and HAVING clauses to retrieve and filter summarized dataWriting subqueries including nested subqueriesEnjoy seventy-five minutes of high-quality HD content in the Uniquely EngagingTM Bigger Brains Teacher-Learner style!
