HOT
blank

Microsoft SQL Server For Beginners

Development

Rating4.3
Enroll Now

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

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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024