HOT

Microsoft SQL Server 2017 Database Training For Beginners

Development

Rating4.6
Enroll Now

Microsoft SQL Server 2017 Database Training For Beginners, available at $64.99, has an average rating of 4.6, with 107 lectures, 6 quizzes, based on 390 reviews, and has 1535 subscribers.

You will learn about Start from scratch by installing Microsoft SQL Server 2017 and create a practice environment for yourself. You will be familiarized with some of the core concepts of RDBMS / SQL Server. You will learn the ins and outs of SQL Server Management studio. You will learn how to create and connect SQL server colud database using Amazon AWS and Microsoft Azure. You will learn how to create, alter and drop database. You will learn how to create, alter and drop tables. You will learn how to insert, update and delete records from tables. You will start constructing your SELECT statement to retrieve data from SQL Server. You will know 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. You will also see how to use UNION / UNION ALL operators You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions. You will learn Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join. You will also know about some of the string functions, date functions, and system functions. You will learn how to create your own function. You will learn how to create, alter and drop Stored Procedure and advantages of stored procedure. You will learn how to create, alter and drop Trigger and its advantage. You will learn how to create, alter and drop View and its advantage. You will learn about temp tables and its advantage. You will learn how to handel exceptions in SQL Server. You will learn how to import data from excel file, flat file, another SQL server database and MySQL. You will learn how to export data to excel file, flat file and another SQL server database You will learn about Bulk Insert. You will learn about Cursors. This course is ideal for individuals who are I have designed the course for beginners that want to learn Microsoft SQL Server from scratch. or Anybody who wants to better understand how databases work or Anybody who wants to enhance their career in Microsoft SQL Server database It is particularly useful for I have designed the course for beginners that want to learn Microsoft SQL Server from scratch. or Anybody who wants to better understand how databases work or Anybody who wants to enhance their career in Microsoft SQL Server database.

Enroll now: Microsoft SQL Server 2017 Database Training For Beginners

Summary

Title: Microsoft SQL Server 2017 Database Training For Beginners

Price: $64.99

Average Rating: 4.6

Number of Lectures: 107

Number of Quizzes: 6

Number of Published Lectures: 102

Number of Published Quizzes: 5

Number of Curriculum Items: 113

Number of Published Curriculum Objects: 107

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

  • Start from scratch by installing Microsoft SQL Server 2017 and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • You will learn the ins and outs of SQL Server Management studio.
  • You will learn how to create and connect SQL server colud database using Amazon AWS and Microsoft Azure.
  • You will learn how to create, alter and drop database.
  • You will learn how to create, alter and drop tables.
  • You will learn how to insert, update and delete records from tables.
  • You will start constructing your SELECT statement to retrieve data from SQL Server.
  • You will know 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.
  • You will also see how to use UNION / UNION ALL operators
  • You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.
  • You will learn Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.
  • You will also know about some of the string functions, date functions, and system functions.
  • You will learn how to create your own function.
  • You will learn how to create, alter and drop Stored Procedure and advantages of stored procedure.
  • You will learn how to create, alter and drop Trigger and its advantage.
  • You will learn how to create, alter and drop View and its advantage.
  • You will learn about temp tables and its advantage.
  • You will learn how to handel exceptions in SQL Server.
  • You will learn how to import data from excel file, flat file, another SQL server database and MySQL.
  • You will learn how to export data to excel file, flat file and another SQL server database
  • You will learn about Bulk Insert.
  • You will learn about Cursors.

Who Should Attend

  • I have designed the course for beginners that want to learn Microsoft SQL Server from scratch.
  • Anybody who wants to better understand how databases work
  • Anybody who wants to enhance their career in Microsoft SQL Server database

Target Audiences

  • I have designed the course for beginners that want to learn Microsoft SQL Server from scratch.
  • Anybody who wants to better understand how databases work
  • Anybody who wants to enhance their career in Microsoft SQL Server database

Microsoft SQL Server developers are earning higher salary in IT industry, but, it’s not about writing queries it’s about understanding and applying the right query at right time. This course will let you understand the SQL Server concepts in an easy way. This SQL course is for beginners who are interested to learn Microsoft SQL Server Database 2017.

 

This Online SQL Server Training course takes some of the basics and then goes in depth. There are regular quizzes and self practice assignments to help you remember the information. 

 

  • Microsoft SQL Server 2017 Installation   

  • Introduction to SQL Server database and its structure

  • Database   

        –How to create database   

            -How to modify database   

           -How to delete database   

          -Database delete issues

  • Cloud Database

    – Amazon AWS

    – Microsoft Azure   

  • 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   

  • Advance Table Concepts

       – Primary Key   

       – Foreign Key   

      – Unique Key   

       – Null values   

       – Default Values   

      – CHECK constraint   

  • Joins   

      Learn 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   

  • Stored Procedure

         – How to create, alter and drop stored procedure   

         – SQL Injection   

         – Advantages of stored procedure   

  • Built-in Functions     

         – String Functions   

         – Numeric Functions   

         – Date Functions   

         – Conversion Functions   

         – Advanced Functions   

  • User defined Functions   

  • Temp Tables   

  • Triggers   

  • Views

  • Exception Handling

  • Import

         – Import data from excel file   

         – Import data from flat file   

         – Import data from another SQL server database   

        – Filter data while importing   

        – Import data from MySQL

  • Export

        – Export data to excel file   

         – Export data to flat File   

         – Export data to another SQL server database   

         – Filter data while exporting

  • Bulk Insert

  • Cursors

  • Table Variable

  • Derived tables and Except operator

  • Common table expressions (CTE)

You will make your money back from the price of this course. If you didn’t like the course you really have nothing to lose. Udemy guarantees it with their no-risk 30 day money back guarantee.   

So come on inside and learn about what Microsoft SQL Server has to offer.

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: Cloud DataBase

Lecture 1: Introduction

Lecture 2: Amazon AWS

Lecture 3: Microsoft Azure

Chapter 4: Introduction To Database

Lecture 1: Introduction

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

Lecture 3: Drop Database Issue

Lecture 4: Create, Alter, Drop Database Using GUI

Lecture 5: Summary

Lecture 6: Self Practice

Chapter 5: 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 6: 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 7: 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

Chapter 8: SQL Comments

Lecture 1: SQL Comments

Chapter 9: Joins

Lecture 1: Introduction To Joins

Lecture 2: Inner Join

Lecture 3: Left Outer Join

Lecture 4: Right Outer Join

Lecture 5: Full Outer Join

Lecture 6: Cross Join

Lecture 7: Self Join

Lecture 8: Self Practice

Chapter 10: Stored Procedure

Lecture 1: Stored Procedure Part 1

Lecture 2: Stored Procedure Part 2

Lecture 3: Self Practice

Chapter 11: SQL Injection And Advantages of Stored Procedure

Lecture 1: SQL Injection And Advantages of Stored Procedure Part 1

Chapter 12: Functions

Lecture 1: Functions

Lecture 2: Built-in Functions Part 1

Lecture 3: Built-in Functions Part 2

Lecture 4: User Defined Function

Chapter 13: Temp Tables

Lecture 1: Temp Tables

Chapter 14: Triggers

Lecture 1: Trigger

Lecture 2: Self Practice

Chapter 15: Views

Lecture 1: Views

Chapter 16: Examples

Lecture 1: Examples

Lecture 2: Answers 1-15

Lecture 3: Answers 16-30

Lecture 4: Answers 31- 35

Chapter 17: Quiz

Chapter 18: Extra : Additional Examples

Lecture 1: How to Find Your SQL Server Instances or Server Name

Lecture 2: Convert or transform rows into columns in SQLL Server

Lecture 3: How to get all objects in SQL Server

Chapter 19: Stored Procedure Extended

Lecture 1: Introduction

Lecture 2: Input Parameter

Lecture 3: Output Parameter

Lecture 4: Return Value

Lecture 5: Output Clause In Insert, Update and Delete

Lecture 6: Dynamic Output Parameter

Lecture 7: Parameter as optional and default value

Lecture 8: Retrieving identity column value

Lecture 9: Summary

Chapter 20: Exception Handling

Lecture 1: Introduction

Lecture 2: Exception Handling Part 1

Lecture 3: Exception Handling Part 2

Instructors

Rating Distribution

  • 1 stars: 13 votes
  • 2 stars: 21 votes
  • 3 stars: 64 votes
  • 4 stars: 134 votes
  • 5 stars: 158 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

YouTube: How to Start a Successful YouTube Channel

2024 InstaFamous Influencer + AI Instagram Marketing Growth

Genuine Copywriting: Effective Copywriting That Gets Results