Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

SQL Server Training Online For Beginners

Valiveti Sekhar

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
29 Videos (3h 19m)
    • Introduction

      2:24
    • Microsoft SQL Server Installation 2017

      10:02
    • Introduction To Database

      6:30
    • Create, Alter, Drop Database Using SQL Syntax

      4:17
    • Create, Alter, Drop Database Using GUI

      1:34
    • Introduction To Data Types

      2:58
    • Create, Alter, Drop Table Using SQL Syntax

      10:44
    • Create, Alter, Drop Table Using GUI

      4:42
    • Data Manipulation Language (DML)

      0:35
    • Insert Statement

      11:54
    • Update Statement

      4:16
    • Delete Statement

      5:45
    • Select Statement Part 1

      5:53
    • Select Statement Part 2

      10:26
    • Select Statement Part 3

      7:22
    • Select Statement Part 4

      13:25
    • Select Statement Part 5

      20:22
    • Advance Table Concepts Part 1

      8:51
    • Advance Table Concepts Part 2

      18:14
    • Advance Table Concepts Part 3

      10:49
    • Advance Table Concepts Part 4

      10:59
    • SQL Comments

      5:07
    • Introduction To Joins

      0:30
    • Inner Join

      5:05
    • Left Outer Join

      3:42
    • Right Outer Join

      5:15
    • Full Outer Join

      2:16
    • Cross Join

      1:49
    • Self Join

      3:30

About This Class

315b788d

Learn online Microsoft SQL Server and SQL concepts. Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS). SQL Server can be used for data storage as well as for data retrieval for web as well as desktop application. Online SQL Server Training is meant for students and developers to help them to learn various SQL database concepts step by step.

What are the requirements?

  • No Pre-Requisites - I will explain everything in the lectures.
  • No Prior Database OR SQL experience is required.

What you will learn in this course?

  • How to install SQL Server 2017.
  • How to create, alter and drop database.
  • How to create, alter and drop tables.
  • How to insert, update and delete records from tables.
  • How to query database using SELECT statement.
  • 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.
  • How to use UNION / UNION ALL operators
  • How to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
  • How to write complex queries using different types of Joins in SQL Server.
       Inner Join
       Left Outer Join
       Right Outer Join
       Full Outer Join
       Cross Join
       Self Join
  • You will also learn SQL comments and its use.

YouTube Videos

SQL Server Installation

How To Create Database In SQL Server

Additional Resources

SQL Server Articles

SQL Server Multiple Choice Questions

5

Students

--

Projects

0

Reviews (0)

Hello, I'm Valiveti.

See full profile