Microsoft SQL for Beginners

What you'll learn:

• Complete literal SELECT statements.
• Complete basic SELECT statements querying against a single table
• Filter data using the WHERE clause
• Sort data using the ORDER BY clause
• Learn about database design and normalization
• Using joins, return columns from multiple tables in the same query
• Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
• Complete SQL statements that use aggregate functions
• Group data together using the GROUP BY clause
• Filter groups of data using the HAVING clause

Requirements:

• I assume you have absolutely NO SQL or database background before taking this course.
• You will need to have a Windows-based computer to run Microsoft SQL Server.

Description:

Who this course is for:

• Anyone who works with data, tables, or databases!
• Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
• If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
• Someone who wants to learn skills that give them the potential to earn near SIX figures!
• Spring & Hibernate for Beginners (includes Spring Boot)
• Machine Learning A-Z™: Hands-On Python & R In Data Science
• React - The Complete Guide (incl Hooks, React Router, Redux)
• Microsoft Excel - Excel from Beginner to Advanced

Course Details:

• 3.5 hours on-demand video
• 3 downloadable resources
• Full lifetime access
• Access on mobile and TV
• Certificate of completion

Microsoft SQL for Beginners udemy free download

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.