Microsoft SQL Server 2017 Database Training For Beginners (Udemy.com)

Learn Microsoft SQL server step by step.An absolute beginners online course to learn SQL Server Database from scratch.

( 126 Reviews )

Created by: Valiveti Sekhar

Produced in 2021

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 cla

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 80 / 100

Course Description

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. Thank you for signing up for this course on Udemy. The course will always be up-to-date. I am also available for questions inside the course discussion board. Who this course is for:

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

Time: 11h

Instructor Details

Valiveti Sekhar

4.0 Rating
126 Reviews

12 years IT industry experience in various domains CRM, Supply Chain Management, E Commerce applications. Worked on requirement gathering,analysis, design, development and implementation of IT systems. Worked on web technologies Html, CSS, JavaScript, jQuery, Bootstrap, ASP.Net, MVC, Web API and Web Services. Worked on databases Microsoft SQL Server, MySQL and Oracle.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.0

126 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Amitava Saha on 11/15/2020

Good going

By Marcos Chotsourian on 9/9/2020

Bien, pero los videos se traban

By Avinash Inamdar on 8/14/2020

Very good

By santosh somusundar on 7/17/2020

Explains everything very clearly in a very professional speed.

By Raheel kazmi on 7/2/2020

great way of explanation in details.

By Michael Clark on 6/18/2020

This course is starting out well. This is exactly what I need.

By Chetankumar Patel on 5/11/2020

Really good course for the beginners. Good details

By Cam McMains on 5/5/2020

Good content so far and the instructor seems knowledgeable. I have had to skip around in the videos quite a bit because I don't find it helpful when someone reads from a slide. The order of content and theming of the videos also leans toward haphazard. I can continue the course and I think I'll learn what I need to, but the instructor could use to learn better digital pedagogy methods.

By Yared Belachew on 4/10/2020

Good, I would like it

By Banani Kumari on 3/24/2020

It was helpful till some extent. I would suggest some more explanation about the table variables, the derived tables and CTE concepts. Some new code and technical stuff have been used which were not explained in detail. Hope you will revisit the course as per the feedback.

By Abrham Negash Regassa on 3/11/2020