Microsoft SQL Server for Beginners and Intermediate



Advertisements   
   

 

What you’ll 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.

Requirements

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

  • No Prior Database OR SQL experience is required.

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
Read more course:  CBT Nuggets - Cisco Application Centric Infrastructure ACI

         – 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

Who this course is for:

  • This course is for beginners who likes to gain basic SQL Server concepts.

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.

Microsoft SQL Server for Beginners and Intermediate, Free Tutorials Download

Download Microsoft SQL Server for Beginners and Intermediate Free Tutorials Direct Links

Go to Download Tutorials Page Go to HomePage Tutorials

Password : freetuts.download


Advertisements

Related Courses

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.