Your cart is empty.
Keep shoppingMicrosoft SQL Server For Beginners
77 students
Microsoft SQL Server For Beginners
Learn SQL Server Basic concepts.
Created byValiveti Sekhar
Last updated 6/2018
English
What you'll learn
- How to install SQL server 2017
- How to create,alter,drop database
- How to create,alter,drop table
- How to insert, update and delete records from tables.
- How to select data from tables using basic SELECT statement in SQL Server.
- How to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.
- UNION and UNION ALL operators
- GROUP BY clause, HAVING clause and Aggregate functions.
Explore related topics
Course content
6 sections • 32 lectures • 3h 31m total length
Requirements
- No Pre-Requisites - I will explain everything in the lectures.
- No Prior Database OR SQL experience is required.
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.