Microsoft SQL Server For Beginners
4.2 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
39 students enrolled

Microsoft SQL Server For Beginners

Learn SQL Server Basic concepts.
4.2 (13 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
39 students enrolled
Created by Valiveti Sekhar
Last updated 6/2018
English
English
Current price: $23.99 Original price: $34.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
Course content
Expand all 32 lectures 03:31:56
+ Introduction To Database
6 lectures 18:07
Introduction
00:23
Create, Alter, Drop Database Using SQL Syntax
04:59
Drop Database Issues
07:50
Create, Alter, Drop Database Using GUI
02:07
Summary
02:01
Self Practice
00:47
Quiz
4 questions
+ Introduction To Tables
6 lectures 29:43
Introduction
00:29
Tables
04:41
Create, Alter, Drop Table Using SQL Syntax
16:00
Create, Alter, Drop Table Using GUI
04:42
Summary
02:02
Self Practice
01:49
Quiz
7 questions
+ Data Manipulation Language (DML)
10 lectures 01:21:56
Introduction
00:35
Insert Command
11:54
Update Command
04:16
Delete Command
05:45
Select Command Part 1
05:53
Select Command Part 2
10:26
Select Command Part 3
07:22
Select Command Part 4
13:25
Select Command Part 5
20:22
Self Practice
01:58
Quiz
12 questions
+ Advance Table Concepts
4 lectures 50:37
Advance Table Concepts Part 1
08:51
Advance Table Concepts Part 2
18:14
Advance Table Concepts Part 3
21:46
Self Practice
01:46
Quiz
4 questions
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.