Sekhar Metla

Complete Microsoft SQL Server from Scratch: Bootcamp

Build Your Data Science BI Career With Real World Data Science Exercises - by Microsoft Certified Professional

168 enrolled

$9.99 $199.99

Limited time offer.

watching now

44 Students

Description

Learn SQL, The first step to MSSQL you need to learn to succeed in SQL database application development, it is easy to learn and understand our online MSSQL Training course is designed for you with the complete steps to require to learn real-world dynamic Database concepts. Mr. Sudha Sekhar(MCP) will explain to you even complex topics to simplify and teach you even beginners can understand easily with real-world data science exercises.

Create a Good and Strong base foundation in MSSQL, With the Complete Microsoft SQL Server Course.

Microsoft SQL Introduction

Microsoft SQL Setting up Local Server Environment

SQL DataTypes

SQL Queries

SQL Statements

SQL Built-in Functions

SQL Programming

SQL reading data rows

SQL updating data rows

How to use SSMS for Microsoft SQL Server

SQL Commands, Clauses, and Operators

Database import and export using GUI tool

A Strong Skillset at Your Hands-on Query

Learn to develop an MSSQL database using SQL language. This course assumes no prior SQL programming knowledge( basics will help you), just a desire to learn to develop your own DATABASE structure for your application as well.

In this course, we cover from scratch to create your own database like all software application supports with basic instructions, you also learn query functionalities interacting with the database.

Content and Summary Who wants to start with beginning in MS-SQL database Development, through this course of 55+ lectures and 8+ hours of content, you’ll learn all of the MSSQL Skills and establish a strong understanding of the concept behind MSSQL Database instance implementation. Every Section closes with a challenge, putting your new learned skills into practical use immediately and Most of the Lectures are having Assignments to test your knowledge.

Starting with an introduction, how to use Microsoft SQL Server SSMS, controls, basics, and settings, etc.

Learning with these MSSQL skills, you will be eager to learn other database SQL development very quickly that lead you to become a successful database SQL professional.

If you really want to learn MSSQL, This Complete MSSQL full-stack Course is for you to develop your skills more than others and you will become strong on MSSQL Database SQL professional.

Show More Show Less

What Will You Learn?

learn to use MS SQL professional way, learn new SQL!

create basic SQL queries

know how to simplify reports like spreadsheets! with huge data sets

learn how to protect your data by doing backup and restore methods!

create left, right, inner and full outer joins

Requirements

A basic knowledge of computers

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

NFT Certificate

61 Lessons

Beginner

English

+100 XP

Share Course on Social media

Curriculum

Course consist of total 8h 49min of content, in total.

Section 1: Course Introduction

17:14

Course Curriculum overview

Overview of Databases

Section 2: SQL Environment Setup

45:26

MSSQL Installation

MSSQL Management Studio Installatione

Connecting to MS-SQL (Windows Authentication)ture

04:41

Connecting to MS-SQL (SQL Server Authentication)

05:35

Section 3: SQL Statement Basics

1:07:49

Overview of Challenges

02:38

SQL Statement Basic

12:54

SELECT Statement

16:29

SELECT DISTINCT

16:54

Column AS Statement

09:12

COUNT

09:42

Section 4: Filtering Data Rows

16:36

SELECT WHERE Clause – One

04:58

SELECT WHERE Clause – Two

11:38

Section 5: SQL Query Operators

49:32

ORDER BY

09:34

TOP in MSSQL

05:39

BETWEEN

13:13

In Operator

08:12

SQL LIKE Operator

12:54

Section 6: GROUP BY Statements

1:08:01

Overview of GROUP BY

08:12

Aggregation Function – SUM()

11:52

Aggregation Function – MIN()-MAX()

08:21

GROUP BY – One(theory)

10:55

GROUP BY – Two(practical)

13:55

HAVING

14:46

Section 7: Assessment Test 1

02:43

Overview Assessment Test 1

02:43

Assessment Test

Solution for an Assessment Test

Section 8: JOINS

58:30

Overview of JOINS

06:39

Introduction to JOINS

07:08

AS Statement

03:44

INNER Join

12:21

Full Outer Join

07:24

Left Outer Join

05:59

Right Outer Join

07:51

Union

07:24

Section 9: Advanced SQL Commands

57:19

Basic of Advanced SQL Commands

04:20

Timestamp

11:40

Extract from Timestamp

06:22

Mathematical Scalar Functions

11:08

String Functions

16:40

SubQuery

07:09

Section 10: Creating Database and Tables

33:26

Basic of Database and Tables

09:41

Data Types

10:54

Select Data type on SSMS

05:06

Create Table on SSMS

07:45

Section 11: Primary Key and Foreign Key

25:00

How to set Primary Key

05:37

How to set Foreign Key

12:11

Create Table using SQL Script

07:12

Section 12: SQL CRUD Operations

1:05:29

Insert

06:29

Update

08:02

Delete

06:35

Alter Table

04:20

Drop Table

02:55

Check Constraint

14:07

NOT NULL Constraint

11:46

UNIQUE Constraint

11:15

Section 13: Backup and Restore Functions

21:58

Overview of Database and Tables

03:32

Creating a Database backup using SSMS

10:51

Restoring a Database from backup using SSMS

07:35

About the Instructor

Sekhar Metla

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

See All Instructor Courses

BitDegree platform reviews

EXCLUSIVE OFFER: GET 25% OFF

Save Big With DataCamp Promo Code

Days

Hours

Minutes

Seconds

GET 25% OFF