Microsoft SQL for Beginners
- Offered byUDEMY
Microsoft SQL for Beginners at UDEMY Overview
Duration | 4 hours |
Total fee | ₹490 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Microsoft SQL for Beginners at UDEMY Highlights
- Full lifetime access
- Earn a Certificate of completion from Udemy
- Learn from 3 downloadable resource
- Comes with 30 days money back guarantee and full lifetime access
Microsoft SQL for Beginners at UDEMY Course details
- For Anyone who works with data, tables, or databases
- For Those who work in organizations where the company typically uses Microsoft databases
- For Someone who wants to learn skills that give them the potential to earn near SIX figures
- Complete literal SELECT statements
- Filter data using the WHERE clause
- Learn about database design and normalization
- Group data together using the GROUP BY clause
- Sort data using the ORDER BY clause
- Complete SQL statements that use aggregate functions
- SQL (Structured Query Language) is the language we use to interact with databases that store data
- This allows us to retrieve data with ease and simplicity
- As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language
- This course will teach how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world
Microsoft SQL for Beginners at UDEMY Curriculum
Introductions to Select Statements
How to Download and Install SQL Server Express
How to Attach the Adventure Works Database
Introduction to T-SQL and Database Concepts
Literal SELECT Statements
Filtering Data with the Where Clause
Using the WHERE Clause - Part 1
Using the WHERE Clause - Part 2
Using the WHERE Clause - Part 3
Using the WHERE Clause - Part 4
Using the WHERE Clause - Part 5
Using the WHERE Clause - Part 6
Using the WHERE Clause - Part 7
Sorting with the ORDER BY Clause
Sorting with the ORDER BY Clause - Part 1
Sorting with the ORDER BY Clause - Part 2
Querying Multiple tables with Joins
Using the INNER JOIN - Part 1
Using the LEFT OUTER JOIN - Part 1
Using the LEFT OUTER JOIN - Part 2
Using the LEFT OUTER JOIN - Part 3
Using the INNER JOIN - Part 2
Aggregate Functions
Aggregate Functions - Part 1
Aggregate Functions - Part 2
Grouping with the GROUP BY Clause
Grouping with the GROUP BY Clause - Part 1
Grouping with the GROUP BY Clause - Part 2
Filtering Groups with the HAVING Clause
Filtering Groups with the HAVING Clause - Part 1
Filtering Groups with the HAVING Clause - Part 2