Have a question?
Message sent Close
  1. Home
  2. »
  3. Microsoft SQL from A to Z

Microsoft SQL from A to Z

15 Student

Course Duration:

45 Hours

Course level:

Beginner to Advanced

What you'll learn

  • Complete literal SELECT statements.
  • Filter data using the WHERE clause
  • Learn about database design and normalization
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
  • Group data together using the GROUP BY clause
  • Use built-in SQL Server functions
  • Work with Table Expressions: Derived Tables and CTEs
  • Use Subqueries
  • Complete basic SELECT statements querying against a single table
  • Sort data using the ORDER BY clause
  • Using joins, return columns from multiple tables in the same query
  • Complete SQL statements that use aggregate functions
  • Filter groups of data using the HAVING clause
  • Understand SQL Server Data Types and Type Casting
  • Use CASE Statements

Benefits Obtained :

Webinar Link
Training Evaluation Test
Completion Certification