Course curriculum

11 Hr, 24 Sections

What Will I Learn?

Basic Concepts

  • Microsoft SQL Server 2017 installation.

  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.

  • How to create, alter and drop database.

  • How to create, alter and drop table.

  • How to insert, update and delete records from tables.

  • SELECT statement to retrieve data from 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.

  • How to use UNION / UNION ALL operators

  • How to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

  • Built-in Functions and user defined functions.

Advance Concepts Part 1

  • Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.

  • How to create, alter and drop Stored Procedure and advantages of stored procedure.

  • How to create, alter and drop Trigger and its advantage.

  • How to create, alter and drop View and its advantage.

  • Temp tables and its advantage.

  • How to handel exceptions in SQL Server

  • Import & Export data in SQL server

Requirements

  • No Pre-Requisites - I will explain everything in the lectures.

  • No Prior Database OR SQL experience is required.

Description


Microsoft SQL Server Online Training

To be a great SQL server developer you have to gain knowledge in many concepts in SQL server. How to work with database, table, procedures, functions, triggers, joins etc.  

This online training course will let you understand the SQL Server concepts in an easy way. This course is for beginners who are interested to learn Microsoft SQL Server concepts from the scratch.

  • Microsoft SQL Server 2017 Installation
  • Introduction to databases and its structure
  • Cloud Database

          Amazon AWS

          - Microsoft Azure

  • 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

  • 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 & Export
  • Bulk Insert
  • Cursors


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, we will refund your money.

So come on inside and learn about what SQL Server has to offer. The course will always be up-to-date. I am also available for questions inside the course discussion board.


Who is the target audience?

  • 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


Course Features

  • 11 hours on-demand video

  • 7-Day Money-Back Guarantee

  • Full lifetime access

  • Quizzes

  • Self Practice Assignments

  • Support will continue even after course completion.

Reviews

  • Jason Walker

    “I came across Microsoft SQL Server 2017 Installation - Step By Step Process To Install SQL Server(which has more than 140,4000 views) on YouTube and loved it a lot. So decided to purchase Valiveti Sekhar's course on SQL server. It's a great course...”

    Read More

    “I came across Microsoft SQL Server 2017 Installation - Step By Step Process To Install SQL Server(which has more than 140,4000 views) on YouTube and loved it a lot. So decided to purchase Valiveti Sekhar's course on SQL server. It's a great course with quizzes and self Practice assignments. Definitely I would recommend it to others. https://www.youtube.com/watch?v=yasfZuou3zI”

    Read Less
  • Rohit Sharma

    “Excellent course, good pace,very well overview of the course.Nicely Designed Course.Definitely recommended.”

    “Excellent course, good pace,very well overview of the course.Nicely Designed Course.Definitely recommended.”

    Read Less
  • Raj S

    “Nice course. Completed 30% and it's very great learning.”

    “Nice course. Completed 30% and it's very great learning.”

    Read Less

About the Instructor



Valiveti Sekhar 

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.


FAQ

  • What if I don't like the course.

    I will be sad. I will refund your money. You can raise for refund with in 30 days.

  • How can I make the payment?

    To make the payment click on the Check Out with PayPal button. It will redirect to PayPal website. PayPal is one of the secure method to make any payments. You can make the payment using debit or credit card.

  • I don't have PayPal account.

    There is no need of PayPal account. We use PayPal payment gateway for secure transactions. Once you click on the Check Out with PayPal button; It will redirect to PayPal website.You can make the payment using your debit or credit card.

  • Do you store our debit or cerdit card information?

    No. We use PayPal for all payments and they don’t share your financial details with the merchant.

  • Reasons for Denied Refunds

    We will not process refund requests received after the refund window i.e 30 days. If the course is completed more than 50% we will not process refund. As We believe 50% is more than enough to know about the course quality.

  • How can i contact you?

    Email me at imvsekhar@gmail.com for any queries. You can also contact me on LinkedIn or Facebook.

  • If I have any questions regarding the course can i ask questions?

    You can. You will find the discussion icon once you start your course. By clicking on it you can start a new discussion. I will be happy to answer any questions.

  • Can I rate the course

    Yes. You can.