Hi There!

Description

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 !!!

• Any one who wants to start SQL Server but can't find appropriate source!

Course content

• Introduction
  • Introduction
  • About me
  • Download projects and files of this course
  • How to increase sound volume of tutorials?
• Start SQL Server
  • Download SQL Server 2014 express & requirements
  • Install SQL 2014 express in Windows 7
  • Install SQL 2014 express in Windows 10
  • What is SQL Server & its structure?
  • Common parts of SQL Server
  • What is SQL Server Management Studio (SSMS) ?
  • Customize SQL Server Environment
• SQL Server Database
  • What is SQL Server database?
  • Create SQL Database
  • Different parts of the SQL database
  • Rename and delete SQL Database
  • Default location of the SQL Database files
  • Different type of SQL datbase files
  • Using SQL Server configuration manager
• SQL Server Table
  • SQL table intro
  • What is SQL table?
  • Add table to the SQL Database
  • Add data to the SQL table
  • Load data in to the SQL table
  • Change the design of table & save it
  • Rename and delete the SQL table
  • What is the prefix "dbo" in SQL table name?
• SQL Numeric Data types
  • What is SQL Numeric data type?
  • Int data type in SQL
  • Bit data type in SQL
  • Tinyint data type in SQL
  • Smallint data type in SQL
  • Bigint data type in SQL
  • Float data type in SQL
  • Decimal data type in SQL
• SQL English Text Data types
  • Section Introduction
  • Char data type in SQL
  • Varchar data type in SQL
  • Varchar(max) data type in SQL
  • Text data type in SQL
• SQL Unicode Text Data types
  • Section Intro
  • nchar data type in SQL
  • nvarchar data type in SQL
  • nvarchar data type in SQL
  • ntext data type in SQL
• SQL Other Data Types
  • What is GUID in SQL?
  • Using GUID in SQL Server
• SQL Database Working Tips
  • How to detach SQL database?
  • How to attach SQL database?
  • Attach SQL database without LDF file
  • Make SQL database offline and online
• Identity and Auto Increment Column in SQL Server
  • Create sample database to set identity column
  • Add identity and auto increment column and test it
  • Identity column count in each table
• SQL Date Time Data types
  • Date Time Data type intro
  • SQL Date data type
  • SQ Smalldatetime data type
  • SQ Datetime data type
  • SQ Datetime2 data type
  • SQ Datetimeoffset data type
  • SQ Time data type
• Phone Book Database Project in SQL Server
  • Create phone book project database in SQL Server
  • Add personal columns to phone book table
  • Add contacts columns to phone book table
  • Add address columns to phone book table
  • Add identity and auto increment column
  • Add sample data and test our SQL table
• Select Query In SQL
  • What is Select Query in SQL?
  • Writing our first Select query
  • Use Select query with (*) to show all columns
  • Sort the records with Select query
  • Show specific number of top rows with Select Query
  • Show specific number of bottom rows with Select Query
  • Reorder the columns in Select Query
• Where Clause for Searching Data in SQL
  • Overview of Where clause for searching data
  • Using Where clause to find English characters
  • Using Where clause to find Unicode characters
  • Using Where clause to find Numbers
  • Different operators with Where clause
  • Use Not equal operator() with Were clause
• Between Operator for Searching Data
  • Introduction to Between operator
  • Between operator for Numeric column searching
  • Between operator for Text column searching
  • Between operator for Date column searching
  • Using NOT operator with Between operator
• IN Operator for Searching in SQL
  • SQL IN operator intro and it's usage
  • In operator for searching multiple Text values
  • In operator for searching multiple Numeric values
  • In operator for searching multiple Date values
  • In operator for searching multiple Unicode Text values
• SQL Like Operator for Searching
  • Introduction to LIKE Operator in SQL
  • LIKE operator simple usage for searching data
  • LIKE operator with Wildcard '%' at the end
  • LIKE operator with Wildcard '%' at the beginning
  • Using Like to Search everywhere with Wildcard '%'
  • Searching Unicode column with Wildcard '%'
  • Using other Wildcards with LIKE operator
  • Using NOT operator with LIKE operator
• Logical Operators of SQL
  • Introduction to SQL logical operators
  • Using 'AND' logical operator
  • Using 'AND' logical operator with Unicode column
  • Using 'OR' logical operator
  • Using 'OR' logical operator with Unicode column
  • Using 'AND' with 'OR' operator together
• NULL Values in SQL
  • What is NULL value in SQL?
  • Check to see a column is NULL?
  • Check to see a column is NOT NULL?
• Alias Names in SQL
  • Create a simple Alias column
  • Create Alias column with multiple columns
  • STR function to Add Numeric column to text column
  • Tips for creating Alias columns
• SQL Aggregate Functions
  • What is SQL Aggregate function?
  • Add debt and income columns to SQL table
  • Using COUNT function in SQL
  • Using SUM function in SQL
  • Using AVG function in SQL
  • Using MIN function in SQL
  • Using MAX function in SQL
  • Using multiple Aggregate function together in SQL
• Bonus Section: Get My Other Courses with Discount
  • Bonus Lecture: Get Amazing Discount for My Other Courses

SQL.Server.Database.for.Beginners.Learn.SQL.From.Scratch.part1.rar

SQL.Server.Database.for.Beginners.Learn.SQL.From.Scratch.part2.rar