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 using SQL Server Database in Visual Basic. Net Application!

If you are beginners or student looking for a tutorial to create a Phone Book database in SQL Server and create a application for that in Visual Basic in simplest way!

I started from beginning and show you how to start working with SQL Server and create phone book database.

- How to create phone book database in SQL

- Talking about SQL ADO.Net and it's concept and parts and ...

- Creating Phone Book project in Visual Basic.

- Connect your VB.Net application to SQL Database.

- Create a VB.Net App for phone book and show data in Data Grid View.

- How Search data by writing new query to table-adapter

- How to search Unicode text in SQL Database with VB. Net code

- Search Numeric text in SQL Database with VB. Net code

- How to use simple SQL LIKE operator in VB. Net code

- How to use SQL LIKE operator with Wildcard to advance search in VB. Net code

Don't hesitate to start learning Advance SQL Server in VB.Net!

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

Say Hi Excel and SQL & VB.Net world and let's go !!!

• VB. Net programmers who want to Learn Search SQL Data in VB. Net
• VB. Net programmers who want to Learn Quickly Advance SQL Server in VB. Net code!
• VB. Net programmers who want to make more money by Using SQL Server in Visual Basic !

Course content

• Introduction
  • Introduction
  • About Me!
  • How to increase sound volume of tutorials?
• Quick Review of SQL Server
  • Who should watch this section!
  • 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
  • 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 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?
  • How to detach SQL database?
  • How to attach SQL database?
  • Attach SQL database without LDF file
  • Make SQL database offline and online
  • Create sample database to set identity column
  • Add identity and auto increment column and test it
  • Identity column count in each table
• 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
• Phone Book Project in VB.Net
  • Create VB.Net Phone Book Project for SQL Server
  • Introduction to SQL ADO.Net in VB.Net
  • Add Dataset & TableAdapter to Phone Book app
  • Connection String in depth
  • Bind datatable to Datagrid View on form
  • Load data in to form from the SQL database
• 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
• Searching SQL Data in Vb.Net Form
  • Introduction to Searching SQL Data in Vb.Net
  • Write query to search fix last name in VB.Net
  • Write query to search last name from textbox
  • Write query to search numeric columns
  • Search Unicode text in SQL table by VB.Net
  • Use Not equal operator() for searching in VB.Net and SQL
  • Use other operators for search in SQL numeric columns in VB.Net
• SQL Like Operator for Searching
  • Section Introduction
  • 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
• Searching Data by SQL LIKE operator in VB.Net
  • LIKE operator in table adapter for searching fix Last Name
  • WildCard '%' with SQL Like to search words with common ending
  • WildCard '%' for searching words with common starting
  • Searching words anywhere with WildCard '%'+ SQL Like
  • Use LIKE operator for searching Unicode Values
• Bonus Section: Get My Other Courses with Discount
  • Bonus Lecture: Get Amazing Discount for My Other Courses