Brief Introduction
Learn SQL Server Basic concepts.Description
In this course you will learn SQL server basic concepts.
- Microsoft SQL Server 2017 Installation
- Introduction to databases and its structure
- Database
- How to create database
- How to modify database
- How to delete database
- Database delete issues
- Tables
- How to create table
- How to modify table
- How to delete table
- Data manipulation
- How to insert data in tables
- How to update data in tables
- How to delete data in tables
- Truncating data vs deleting
- Retrieving data
- Select statement
- Filtering data retrieval
- Filtering Data with the WHERE clause
- Filtering Data with the WHERE clause using various Operators
- UNION Operator and UNION ALL Operator
- EXISTS Operator
- Sorting Data with the ORDER BY Clause
- SELECT TOP Clause
- DISTINCT Statement
- GROUP BY Statement
- HAVING Clause
Requirements
- Requirements
- No Pre-Requisites - I will explain everything in the lectures.
- No Prior Database OR SQL experience is required.
Valiveti Sekhar
4.2 Raiting
Complete guide to ASP.NET Core MVC (.NET 5)
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Build real world application using ASP. NET Core MVC, Entity Framework Core and ASP. NET Core Identity. This is a Beginner to Advanced level course on ....
Advance SQL in VB.Net : Database Apps in Visual Basics & SQL
- 4.7
-
![]()
![]()
![]()
![]()
![]()
3 in 1: Barcode Scanner App in VB . net, Advance ADO. Net, ComboBox in Visual Basic & SQL, SQL CRUD in Visual Basic ....
Learn How to use Heidi SQL
- 3.6
-
![]()
![]()
![]()
![]()
![]()
Learn to Manage Databases MySQL, MS SQL using HeidiSQL This is your complete guide to learn about managing Databases , how easy it is to work like Professional Developers ....
Learn Business Data Analysis with SQL and Tableau
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Improve your Business Analytical Skills with with SQL and Data Visualization This course teaches you SQL from scratch till writing complex queries....
