4.11 out of 5
4.11
47 reviews on Udemy

SQL Complete Course|SQL Server Database Beginners to Interm

Learn Easily the SQL Server Database From Scratch ,SQL Select Query,Operators,...|Search Data by Real SQL Project Sample
Instructor:
Musavi Abdullah
11,538 students enrolled
English [Auto-generated]
Install SQL Server 2014 in Win 7, Win 10
Create SQL Server Data base
Create SQL Table and work with it
Numeric data types: int,bigint,float,bit,smallint, ...
English text data types: char,varchar,text,varchar(max) ,...
Unicode text data types: nchar,nvarchar,ntext,nvarchar(max) ,...
Date data types: Date,Datetime,Time,Datetime2, ...
Identity column and Auto increment column
Project 1: Create Phone Book Data base
Select Query In SQL
Where clause in SQL Select query
Between Operator for Searching Data
IN Operator for Searching in SQL
SQL Like Operator for Searching
Logical Operators of SQL
NULL Values in SQL
Alias Names in SQL
SQL Aggregate Functions

Hi There!

With my 20 years programming skills i’m with you to share my knowledge with you.

So

If you try you will learn SQL Server!

If you are beginners or student looking for a tutorial that learn the SQL Server in simplest way!

If you wanna make more money with learning the SQL!

 

I started from beginning and show you how to install SQL Server 2014.

Then started to create first data base in SQL Server and …

Then I talked about form table and how to create,delete,rename and …

Then i’ll talk about Numeric data types.

Then i’ll talk about English and Unicode text data types.

Then i’ll talk about Date and Time data types.

Then i’ll talk about GUID data type.

Then i’ll talk about Identity auto increment column.

Then i’ll talk about Attach,Detach and making DB offline.

Then i’ll create Phone Book database project from scratch!

Then i’ll talk about Select query for showing data.

Then i’ll talk about Searching data with Where Clause.

Then i’ll talk about Searching data with Between , IN , NOT , LIKE operators.

Then i’ll talk about Searching data with ( = , < , <= , >, >= , <> ) operators.

Then i’ll talk about Wildcards in Like Operator such as %.

Then i’ll talk about Logical Operators of SQL.

Then i’ll talk about NULL Values in SQL.

Then i’ll talk about Alias Names in SQL.

Then i’ll talk about SQL Aggregate Functions.

 

Don’t hesitate to start learning SQL Server!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi SQL world and let’s go !!!

Would you like know more about it? Click here!Close

Introduction

1
Introduction
2
About me
3
Download projects and files of this course

Start SQL Server

1
Download SQL Server 2014 express & requirements
2
Install SQL 2014 express in Windows 7
3
Install SQL 2014 express in Windows 10
4
What is SQL Server & its structure?
5
Common parts of SQL Server
6
What is SQL Server Management Studio (SSMS) ?
7
Customize SQL Server Environment

SQL Server Database

1
What is SQL Server database?
2
Create SQL Database
3
Different parts of the SQL database
4
Rename and delete SQL Database
5
Default location of the SQL Database files
6
Different type of SQL datbase files

SQL Server Table

1
SQL table intro
2
What is SQL table?
3
Add table to the SQL Database
4
Add data to the SQL table
5
Load data in to the SQL table
6
Change the design of table & save it
7
Rename and delete the SQL table
8
What is the prefix "dbo" in SQL table name?

SQL Numeric Data types

1
What is SQL Numeric data type?
2
Int data type in SQL
3
Bit data type in SQL
4
Tinyint data type in SQL
5
Smallint data type in SQL
6
Bigint data type in SQL
7
Float data type in SQL
8
Decimal data type in SQL

SQL English Text Data types

1
Section Introduction
2
Char data type in SQL
3
Varchar data type in SQL
4
Varchar(max) data type in SQL
5
Text data type in SQL

SQL Unicode Text Data types

1
Section Intro
2
nchar data type in SQL
3
nvarchar data type in SQL
4
nvarchar data type in SQL
5
ntext data type in SQL

SQL Other Data Types

1
What is GUID in SQL?
2
Using GUID in SQL Server

SQL Database Working Tips

1
How to detach SQL database?
2
How to attach SQL database?
3
Attach SQL database without LDF file
4
Make SQL database offline and online

Identity and Auto Increment Column in SQL Server

1
Create sample database to set identity column
2
Add identity and auto increment column and test it
3
Identity column count in each table

SQL Date Time Data types

1
Date Time Data type intro
2
SQL Date data type
3
SQ Smalldatetime data type
4
SQ Datetime data type
5
SQ Datetime2 data type
6
SQ Datetimeoffset data type
7
SQ Time data type

Phone Book Database Project in SQL Server

1
Create phone book project database in SQL Server
2
Add personal columns to phone book table
3
Add contacts columns to phone book table
4
Add address columns to phone book table
5
Add identity and auto increment column
6
Add sample data and test our SQL table

Select Query In SQL

1
What is Select Query in SQL?
2
Writing our first Select query
3
Use Select query with (*) to show all columns
4
Sort the records with Select query
5
Show specific number of top rows with Select Query
6
Show specific number of bottom rows with Select Query
7
Reorder the columns in Select Query

Where Clause for Searching Data in SQL

1
Overview of Where clause for searching data
2
Using Where clause to find English characters
3
Using Where clause to find Unicode characters
4
Using Where clause to find Numbers
5
Different operators with Where clause
6
Use Not equal operator() with Were clause

Between Operator for Searching Data

1
Introduction to Between operator
2
Between operator for Numeric column searching
3
Between operator for Text column searching
4
Between operator for Date column searching
5
Using NOT operator with Between operator

IN Operator for Searching in SQL

1
SQL IN operator intro and it's usage
2
In operator for searching multiple Text values
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
47 Ratings

Detailed Rating

Stars 5
24
Stars 4
12
Stars 3
9
Stars 2
0
Stars 1
2
042580815897f848a0830f732a72dbd8
30-Day Money-Back Guarantee

Includes

9 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion