Microsoft SQL Server For Beginners udemy course free download
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:
In this course you will learn SQL server basic concepts.
- Microsoft SQL Server 2017 Installation
- Introduction to databases and its structure
- Database
- How to create database
- How to modify database
- How to delete database
- Database delete issues
- Tables
- How to create table
- How to modify table
- How to delete table
- Data manipulation
- How to insert data in tables
- How to update data in tables
- How to delete data in tables
- Truncating data vs deleting
- Retrieving data
- Select statement
- Filtering data retrieval
- Filtering Data with the WHERE clause
- Filtering Data with the WHERE clause using various Operators
- UNION Operator and UNION ALL Operator
- EXISTS Operator
- Sorting Data with the ORDER BY Clause
- SELECT TOP Clause
- DISTINCT Statement
- GROUP BY Statement
- HAVING Clause
Who this course is for:
- This course is for beginners who likes to gain basic SQL Server concepts.
Course Details:
- 3.5 hours on-demand video
- 5 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion