Microsoft SQL - Absolute Beginner's Course
5.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled

Microsoft SQL - Absolute Beginner's Course

Absolute beginners course
5.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled
Created by Rajkumar B
Last updated 3/2020
English
English [Auto]
Current price: $14.99 Original price: $24.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Database Basics and Structured Query Language
Requirements
  • Microsoft SQL Express 2017 and SQL Server Management Studio 2017 must be installed and SQL Server management studio must be configured to connect to SQL Express instance.
Description

This course is for absolute beginners and they will learn how to create the database, how to create a table, what are constraints and how they can be applied to database columns, What are the different types of constraints, What is DDL,DML,DCL and TCL?

We will then learn the data types, how to group and order the data set results, Sub-Queries and Joining the tables based on condition.

RDBMS, SQL, DataTypes, Joins, Sub Queries, DDL,DML,DCL,TCL these are some of the important concepts which you will learn.

Who this course is for:
  • Who have basic knowledge of databse and want to explore the Query language used with the database
Course content
Expand all 10 lectures 02:30:26
+ Introduction to SQL and SQL Command Categories
2 lectures 16:36

In this SQL tutorial, we go through the basics of SQL. We will be using MS SQL Server for this SQL Introduction tutorial. In this session we look at what is Data, then what is database? and then we will look at RDBMS (Relational database management system). We will then look at SQL Basics where we will see what we can do using SQL and finally we see which projects needs SQL knowledge.

Preview 05:40

There are 4 categories. SQL Language is split into DDL (Data Definition Language) DML (Data Manipulation Language) DCL (Data Control Language) TCL (Transaction Control Language) We will go through brief intro on each of these.

Preview 10:56
+ SQL Constraints - Primary, Foreign, Check, Null, Not Null Constraints
2 lectures 50:50

In this video we will go through the following constraints which can be applied to a column.

We will take a look at the following constraints

Null

Not Null

Unique Constraint

Check Constraint &

Primary Key

SQL Constraints -1 : Unique, Check, Primary, null, not null
34:57

In this session we will go through the last constraint on a particular column, i.e. Foreign Key Constraint.

This is part 2 of the SQL Constraint which is continuation of Part 1 where we went through Null, Not-Null, Primary Key, Unique Key, Check Constraint etc.

SQL Constraints - 2 : Foreign Key constraint
15:53
+ SQL Datatypes
1 lecture 05:46

In this video we will go through different data types available in SQL. There are various data types available. We will go through Numeric data type, Date-Time data type, String data type and other data types such as image, blob , binary data type.

Numeric, String, Datetime etc.
05:46
+ SQL Operators
1 lecture 25:49

In this video we will go through various operators available in SQL with examples and the operators which we will be discussing in this session are

Logical

Comparison

Comparison Keyword

Logical, Comparison operator and keyword
25:49
+ SQL Grouping and Ordering data set
1 lecture 19:09

In this tutorial we will take a look at grouping the result sets using the clause Group By and ordering the result set by using Order By clause.

Group By and Order By
19:09
+ SQL Built-In Functions
1 lecture 03:06

In this video we will go through some of the built in functions available along with examples.

Built-In Functions
03:06
+ SQL Sub-Queries
1 lecture 08:57

In this video we will take a look at Sub Query. There are two ways of writing sub-queries a) Inner Query b) Co-Related Query

Inner and Co-related Query
08:57
+ SQL Joins
1 lecture 20:13

In this video we will go through various Joins available such as

Inner Join

Outer Join

Left Join

Right Join

Cross Join or Cartesian Join

These joins are explained with an example.

Inner, Outer, Left, Right and Cross Join
20:13