Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero

in Microsoft SQL Server Boot camp 2023

Best Seller

(0 Ratings)

5 Students enrolled

Created by Melta Sudha Sekhar

English Advanced

Last Updated

28 Dec 2022

What you'll learn

Use SQL to query a database

Advanced SQL statements

Be comfortable putting SQL and Microsoft SQL on their resume

Replicate real-world situations and query reports

Complete basic SELECT statements querying against a single table

Sort data using the ORDER BY clause

Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN

Import Flat, .CSV, Excel to SQL Database

Write SELECT on Query Calculations to get Discount and Non Discount Sales

Get a job as a junior Database developer

Use SQL to perform data analysis

Learn to perform GROUP BY statements

Complete literal SELECT statements.

Filter data using the WHERE clause

Using joins, return columns from multiple tables in the same query

Complete SQL statements that use aggregate functions

Perform Secure Backup and Restore Full SQL Database task

Get certificate of completion

Course content

87 Lessons • 6:01 Hr

Getting Started

6 Lessons • 0:15 Hr

Introduction

0:03 Hr

Course Curriculum

0:06 Hr

How to get course requirements

0:01 Hr

Getting started on Windows, Linux or Docker

0:00 Hr

How to ask great questions

0:01 Hr

FAQ’s

0:01 Hr

SQL Server setting up

6 Lessons • 0:43 Hr

Section Introduction

0:01 Hr

Microsoft SQL Server Installation

0:18 Hr

SQL Server Management Studio (SSMS) Installation

0:08 Hr

How to connect MS SQL (Windows Authentication)

0:03 Hr

How to connect MS SQL (SQL Server Authentication)

0:03 Hr

Download and Restore Sample Database

0:07 Hr

SQL Database basic

10 Lessons • 0:54 Hr

Section Introduction

0:01 Hr

Overview of Databases

0:10 Hr

Creating Database

0:04 Hr

SQL Data Types

0:03 Hr

Column Data Types on SSMS

0:03 Hr

Creating Table

0:09 Hr

Overview of Primary Key and Foreign Key

0:04 Hr

Primary Key

0:04 Hr

Foreign Key

0:06 Hr

Creating Temporary tables

0:06 Hr

SQL DML (Data Manipulation Language)

4 Lessons • 0:17 Hr

Section Introduction

0:00 Hr

Insert statement

0:08 Hr

Update statement

0:05 Hr

Delete statement

0:03 Hr

SQL DDL (Data Definition Language)

7 Lessons • 0:18 Hr

Section Introduction

0:00 Hr

CREATE table statement

0:02 Hr

DROP statement

0:02 Hr

ALTER statement

0:05 Hr

TRUNCATE statement

0:04 Hr

COMMENT in query

0:00 Hr

RENAME

0:01 Hr

SQL DCL (Data Control Language)

3 Lessons • 0:14 Hr

Create Database user

0:03 Hr

GRANT permissions

0:06 Hr

REVOKE permissions

0:04 Hr

SQL Statement Basic

6 Lessons • 0:19 Hr

Section Introduction

0:01 Hr

SQL Statement basic

0:03 Hr

SELECT Statement

0:07 Hr

SELECT DISTINCT

0:02 Hr

SELECT with column headings

0:02 Hr

Column AS statement

0:02 Hr

Filtering Data rows

2 Lessons • 0:10 Hr

SELECT WHERE Clause – theory

0:03 Hr

SELECT WHERE Clause – practical

0:07 Hr

Aggregate functions

2 Lessons • 0:13 Hr

Sum()

0:08 Hr

Min()-Max()

0:05 Hr

SQL Query statements

5 Lessons • 0:26 Hr

Order By statement

0:05 Hr

SELECT TOP clause in SQL

0:04 Hr

BETWEEN command

0:08 Hr

IN operator

0:04 Hr

Wildcard Characters and LIKE

0:04 Hr

SQL Group by statement

4 Lessons • 0:13 Hr

Section Introduction

0:01 Hr

Group by – theory

0:03 Hr

Group by – practical

0:05 Hr

HAVING statement

0:03 Hr

JOINS

10 Lessons • 0:26 Hr

Overview of Joins

0:01 Hr

What are Joins

0:02 Hr

Inner join

0:07 Hr

Left outer join

0:02 Hr

Right outer join

0:02 Hr

Full outer join

0:01 Hr

Union

0:02 Hr

Cross join

0:03 Hr

Query Exercise

0:01 Hr

Solution for Query Exercise

0:01 Hr

SQL Constraints

4 Lessons • 0:21 Hr

Section Introduction

0:00 Hr

Check constraint

0:06 Hr

NOT NULL constraint

0:08 Hr

UNIQUE constraint

0:05 Hr

Views

2 Lessons • 0:07 Hr

Creating Views

0:03 Hr

Reporting with multiple tables

0:03 Hr

Advanced SQL commands

7 Lessons • 0:26 Hr

Section Introduction

0:00 Hr

Timestamp

0:04 Hr

Extract from timestamp

0:03 Hr

Mathematical scalar functions

0:03 Hr

String functions

0:04 Hr

Sub Query

0:03 Hr

SELECT with calculations

0:06 Hr

SQL Stored procedures

2 Lessons • 0:09 Hr

Create stored procedure

0:04 Hr

Stored procedure with parameter

0:04 Hr

Import & Export data

4 Lessons • 0:14 Hr

Section Introduction

0:01 Hr

Import Flat File

0:05 Hr

Import csv or excel file

0:02 Hr

Export Data to Excel or any format

0:06 Hr

Backup and Restore Database

3 Lessons • 0:08 Hr

Section Introduction

0:00 Hr

Creating Database backup

0:03 Hr

Restoring Database backup

0:03 Hr

13 more sections

Requirements

No prior technical experience is required! All you need a computer!

No software is required in advance of the course (all software used in the course is free)

No pre-knowledge is required - you will learn from basic

About this course

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 2023. 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!

The course is taught by the lead instructor having 20+ years of professional experience.

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.

We’re in the News!

About the instructor

Melta Sudha Sekhar

EFA User

Melta Sudha Sekhar

EFA User

0 Reviews
2 Courses

Sekhar Metla is a software engineer with 20 years of professional experience. He is the author of several online-selling Udemy courses with more than 30,000+ students in more countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.

87 Video Lessons

Get instant & lifetime access

This course contains pre-recorded videos that can be watched anytime

30 day money back

Don’t like it, no problems

If for any reason you are not happy with your purchase, simply email us within 30 days of purchase and we will refund you within 24 hours.

Celebrating

200000+

Happy Learners!

Student reviews

Course Rating

Content quality (0)

Instructor skills (0)

Purchase worth (0)

Support quality (0)

Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero

in Microsoft SQL Server Boot camp 2023

Best Seller

(0 Ratings)

5 Students enrolled

Created by Melta Sudha Sekhar

English Advanced

Last Updated

28 Dec 2022

₹399.00

₹2,999.00

Get Discount 86.70% off

7 Hours left for this price

₹399.00

₹2,999.00

30 Days money back guarantee

Gift this course

Send this course as a gift to your friends

This Course includes:

6:01 Hours On demand videos

87 Lessons

Full time access

Access on mobile, Tablet and tv

Course specifications

Capacity:

0 Students

Duration:

6:01 Hours

Files:

Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero

What you'll learn

Get certificate of completion

Course content

Requirements

About this course

We’re in the News!

About the instructor

Melta Sudha Sekhar

Melta Sudha Sekhar

87 Video Lessons

Get instant & lifetime access

30 day money back

Don’t like it, no problems

Celebrating

200000+

Happy Learners!

Student reviews

Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero

Gift this course

Course specifications

Report course

Share

Buy with points