10 Best Sql Server Training

Updated on: March 2021

Best Sql Server Training in 2021


Sql Guide (Quick Study: SQL)

Sql Guide (Quick Study: SQL)
BESTSELLER NO. 1 in 2021
  • Array

Querying Microsoft SQL Server 2012 Exam 70-461 Training Kit

Querying Microsoft SQL Server 2012 Exam 70-461 Training Kit
BESTSELLER NO. 2 in 2021

MCSA SQL Server 2016 Database Development Exam Ref 2-pack: Exam Refs 70-761 and 70-762

MCSA SQL Server 2016 Database Development Exam Ref 2-pack: Exam Refs 70-761 and 70-762
BESTSELLER NO. 3 in 2021

SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach

SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach
BESTSELLER NO. 4 in 2021

SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out
BESTSELLER NO. 5 in 2021

Murach's SQL Server 2012 for Developers (Training & Reference)

Murach's SQL Server 2012 for Developers (Training & Reference)
BESTSELLER NO. 6 in 2021
  • Array

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
BESTSELLER NO. 7 in 2021
  • Array

Murach's SQL Server 2016 for Developers

Murach's SQL Server 2016 for Developers
BESTSELLER NO. 8 in 2021

McSe Training Guide: SQL Server 6.5 Design and Implementation

McSe Training Guide: SQL Server 6.5 Design and Implementation
BESTSELLER NO. 9 in 2021

Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)

Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
BESTSELLER NO. 10 in 2021
  • Array

Connecting to MySql Server from Commandline

Learn how to connect to MySql server from commandline.

C:/ gt; mysql -u user_name -p -h host_name

If the user_name is root and host_name is 192.168.1.3(location of mysql server) then the command would be written as

C:/ gt;mysql -u root -p -h 192.168.1.3

Next, you will be asked for a password

Enter password:****

Type the password and press enter.

One may also specify database name during connection

C:/ gt;mysql -u user_name -p -h 192.168.1.3 db_name

Different formats

1. C:/ gt;mysql -uroot -proot -h192.168.1.3 student_db

2. C:/ gt;mysql --user=root --password=root --host=192.168.1.3 student_db

student_db is a database name.

Above formats are all valid ways of connecting. However, note that you cannot say -p root, that would throw an error.

Try C:/ gt;mysql -u root -p root -h 192.168.1.3

What do you get? You would be prompted for a password then an error would be thrown.

If you don't want to type the password on the commandline, you could always ask the commandline to prompt you for a password.

C:/ gt;mysql -u root -p -h 192.168.1.3

Or

C:/ gt;mysql -u root --password -h 192.168.1.3

Next you will be asked to enter a password.

The clients used for connecting to a server can be commandline, gui etc. Each may have different program specific parameters to setup a connection. But some parameters are common in all.

Some of the common parameters are :

The first two parameters are used for user identification.