Discover how to query data from SQL Server tables. In this course, Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language. Learn the fundamental structure of a query and see how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a dataset that's formatted to meet a wide variety of needs and perspectives. Upon wrapping up this course, you'll be equipped with the commands and keywords you need to know to effectively analyze your data.
Topics include:
- Writing SELECT queries
- Removing duplicates with DISTINCT
- Matching text with LIKE and wildcards
- Retrieving records from multiple tables
- Grouping records
- Using functions in T-SQL
- Writing SQL scripts
- Using subqueries
- Creating and using variables in a query
Ce cours n´est disponible qu´en anglais. Si ce n´est pas un problème pour vous, soumettez votre demande.
This course is in French only. If this is not a problem for you, by all means go ahead and apply.