Complete Microsoft SQL Server from Scratch


7
Learners

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.


Course Faculty
Sekhar Metla
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passion... more>>
Basic Course Offerings
54 Lecture Topics
8+ Hours of Video Lectures
Course Specials
Interactive Discussion Forum
4+ Course Files
Course Completion Certificate
Basic Plan

  • 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
  • Videos may contain ads
INR 0
Enrol Now
EFY Times
Standard Plan

  • 180 days access to basic course offerings covering HD video lectures
  • Course specific discussion forum for anytime doubt resolution
  • Ad-free Videos
  • Course Completion Certificate
USD 13.31/USD 11.09
Enrol Now
Enterprise Plan

  • Ideal for multiple participants.
  • Single payment option for instant multi user on-boarding.
  • Attractive discounts on bulk purchases.
  • Option to include white labelled LMS with custom dashboard report.
  • Multi course selection available.
Course Overview

Learn how to write SQL (Structured Query Language) from scratch with the Microsoft SQL course. This course will easily step you through writing SQL using Microsoft's SQL Server Management Studio. SQL allows you to retrieve, sort, filter, group, aggregate, and calculate data stored in a SQL Server database. This course is designed for people wanting to learn how to internal data from a relational database, how to manipulate this data (Insert, update, and delete records).

Although we use SQL Server to interrogate data throughout this course, SQL is a common language easily adapted to other RDBMS (relational database management systems) such as MySQL, IBM DB2, PostgreSQL, Oracle, Ingres, Sybase and Microsoft Access.

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


Course Curriculum
1 Introduction Preview 03:55
2 Course Curriculum overview 04:24
3 Overview of Databases 08:57
4 MSSQL Installation 27:20
5 MSSQL Management Studio Installation 07:51
6 Connecting to MS-SQL (Windows Authentication) 04:41
7 Connecting to MS-SQL (SQL Server Authentication) 05:35
8 Overview of Challenges 02:39
9 SQL Statement Basic 12:54
10 SELECT Statement 16:29
11 SELECT DISTINCT 16:54
12 Column AS Statement 09:13
13 COUNT 09:42
14 SELECT WHERE Clause – One 04:59
15 SELECT WHERE Clause – Two 11:38
16 ORDER BY 09:34
17 TOP in MSSQL 05:39
18 BETWEEN 13:14
19 IN 08:13
20 LIKE 12:54
21 Overview of GROUP BY 08:13
22 Aggregation Function – SUM() 11:52
23 Aggregation Function – MIN()-MAX() 08:22
24 GROUP BY – One(theory) 10:55
25 GROUP BY – Two(practical) 13:55
26 HAVING 14:46
27 Overview Assessment Test 1 02:43
Assessment Test 1  
Solution for Assessment Test 1  
28 Overview of JOINS 06:40
29 Introduction to JOINS 07:08
30 AS Statement 03:45
31 INNER Join 12:21
32 Full Outer Join 07:24
33 Left Outer Join 05:59
34 Right Outer Join 07:52
35 Union 07:25
Assessment Test 2  
Solution for Assessment Test 2  
36 Basic of Database and Tables 09:42
37 Data Types 10:55
38 Select Data type on SSMS 05:06
39 Create Table on SSMS 07:46
40 How to set Primary Key 05:37
41 How to set Foreign Key 12:12
42 Create Table using SQL Script 07:13
43 Insert 06:29
44 Update 08:02
45 Delete 06:35
46 Alter Table 04:21
47 Drop Table 02:56
48 Check Constraint 14:08
49 NOT NULL Constraint 11:47
50 UNIQUE Constraint 11:16
51 Overview of Database and Tables 03:32
52 Creating a Database backup using SSMS 10:51
53 Restoring a Database from backup using SSMS 07:36
54 Basic of Advanced SQL Commands 04:21

Eligibility Criteria

There are no pre-requisites for this course, however, some fundamentals knowledge about DBMS will be beneficial.

Basic knowledge of computers

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



-----No Ratings & Reviews Yet-----

Frequently Asked Questions

There are no limitations in accessing the course. You can assess the course through the web (ApnaCourse.com) on any device

Most courses are self paced courses with a free access of 30 days. The 30 days access (basic plan) is only on the videos. To extend access by 180 days or to get course specials like question bank, course completion certificate, exam etc, you will have to enrol into the standard (paid) plan.

Yes. If your access to a course expires, you can extend that through an online payment and continue from where you left of.

We engage only experienced and certified faculties for each course. Each faculty has decades of relevant teaching / training experience that they bring to ApnaCourse. For details of our faculty partners, please visit the Faculty section in the website.

We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute who delivered the course.

For any course specific doubts, there is an Online forum on ApnaCourse called Social Circle for every Course. Access to the Social Circle is available only in the paid plan. Post your questions there and an expert would be able to respond to it. For general payment or enrolment related information, please email at support@apnacourse.com.

Pl visit our detailed FAQ section at https://www.apnacourse.com/about/faq. If you still have doubts, feel free to email at support@apnacourse.com.


×
×
Course Expert
Sekhar Metla
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 make a strong bridge the gap between the software companies requirements and the beginners.
×
All batches are currently full