Introduction

Course Curriculum

How to get course requirements

Getting started on Windows, Linux or Docker

How to ask great questions

FAQs

What is Source Code

SQL Server Introduction

Microsoft SQL Server Installation

SQL Server Management Studio (SSMS) Installation

How to connect MS SQL (Windows Authentication)

How to connect MS SQL (SQL Server Authentication)

Download and Restore Sample Database

Introduction to SQL

Overview of Databases

Creating Database

SQL Data Types

Column Data Types on SSMS

Creating Table

Overview of Primary Key and Foreign Key

Primary Key

Foreign Key

Creating Temporary tables

DML Introduction

Insert statement

Update statement

Delete statement

DDL Introduction

CREATE table statement

DROP statement

ALTER statement

TRUNCATE statement

COMMENT in query

RENAME

Create Database user

GRANT permissions

REVOKE permissions

Introduction to Statements

SQL Statements basic

SELECT Statement

SELECT DISTINCT

SELECT with column headings

Column AS statement

SELECT WHERE Clause – theory

SELECT WHERE Clause – practical

Sum()

Min()-Max()

Order By statement

SELECT TOP clause in SQL

BETWEEN command

IN operator

Wildcard Characters and LIKE

Group By - Introduction

Group by – theory

Group by – practical

HAVING statement

Overview of SQL Joins

What are joins

Inner join

Left outer join

Right outer join

Full outer join

Union

Cross join

Query Exercise

Solution for Query Exercise

Check constraint

NOT NULL constraint

UNIQUE constraint

Creating Views

Reporting with multiple tables

Timestamp

Extract from timestamp

Mathematical scalar functions

String functions

Sub Query

SELECT with calculations

Create stored procedure

Stored procedure with parameter

Import Flat File

Import .csv or excel file

Export Data to Excel or any format

Creating Database backup

Restoring Database backup

Become an Expert at Microsoft SQL! By writing SQL queries for Data Analytics and Data Science base concepts

Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants makes a strong bridge the gap between the software companies requirements and the beginners. 

hari systems

Learn how to use SQL quickly and effectively with this course. 

This SQL course is without a doubt the most comprehensive database course available online. Even if you have zero SQL experience, this course will take you from beginner to mastery. 

Here's why:

You'll learn how to read and write complex queries to a database using one of the most in-demand skills - Microsoft SQL Server Bootcamp 2024. These skills are also applicable to any other major SQL database, such as MySQL, PostgreSQL, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in-demand tech skills! In this course, you'll learn quickly and receive challenges and tests along the way to improve your understanding!

We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a SQL developer.

Learn MySQL from scratch for Data Science and Analytics

Learn C++ Intermediate Pointers, Structures, and File Stream

Restful API Web Services with PHP and MySQL

 Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Certificate Details

Microsoft SQL Server Bootcamp 2024: Go from Zero to Hero

Course Goals

hari systems