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.
Basic Plan
- 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
- Videos may contain ads
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
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.
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
| 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 |
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!
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.
