Microsoft SQL Server For Beginners

Microsoft SQL Server For Beginners, available at $19.99, has an average rating of 4.3, with 32 lectures, 4 quizzes, based on 21 reviews, and has 72 subscribers.

You will learn about 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. This course is ideal for individuals who are This course is for beginners who likes to gain basic SQL Server concepts. It is particularly useful for This course is for beginners who likes to gain basic SQL Server concepts.

Enroll now: Microsoft SQL Server For Beginners

Summary

Title: Microsoft SQL Server For Beginners

Price: $19.99

Average Rating: 4.3

Number of Lectures: 32

Number of Quizzes: 4

Number of Published Lectures: 32

Number of Published Quizzes: 4

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 36

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

This course is for beginners who likes to gain basic SQL Server concepts.

Target Audiences

This course is for beginners who likes to gain basic SQL Server concepts.

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Introduction To Microsoft SQL Server

Lecture 1: Introduction

Lecture 2: Introduction To Database

Lecture 3: Microsoft SQL Server 2017 Installation

Lecture 4: Overview Of SQL Server Management Studio

Lecture 5: Summary

Chapter 3: Introduction To Database

Lecture 1: Introduction

Lecture 2: Create, Alter, Drop Database Using SQL Syntax

Lecture 3: Drop Database Issues

Lecture 4: Create, Alter, Drop Database Using GUI

Lecture 5: Summary

Lecture 6: Self Practice

Chapter 4: Introduction To Tables

Lecture 1: Introduction

Lecture 2: Tables

Lecture 3: Create, Alter, Drop Table Using SQL Syntax

Lecture 4: Create, Alter, Drop Table Using GUI

Lecture 5: Summary

Lecture 6: Self Practice

Chapter 5: Data Manipulation Language (DML)

Lecture 1: Introduction

Lecture 2: Insert Command

Lecture 3: Update Command

Lecture 4: Delete Command

Lecture 5: Select Command Part 1

Lecture 6: Select Command Part 2

Lecture 7: Select Command Part 3

Lecture 8: Select Command Part 4

Lecture 9: Select Command Part 5

Lecture 10: Self Practice

Chapter 6: Advance Table Concepts

Lecture 1: Advance Table Concepts Part 1

Lecture 2: Advance Table Concepts Part 2

Lecture 3: Advance Table Concepts Part 3

Lecture 4: Self Practice

Instructors

Valiveti Sekhar
IT Professional

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 8 votes

5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!