10 Best Sql Server Training
Updated on: May 2023
Best Sql Server Training in 2023
Sql Guide (Quick Study: SQL)
Querying Microsoft SQL Server 2012 Exam 70-461 Training Kit
MCSA SQL Server 2016 Database Development Exam Ref 2-pack: Exam Refs 70-761 and 70-762
SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing†approach
SQL Server 2019 Administration Inside Out
Murach's SQL Server 2012 for Developers (Training & Reference)
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Murach's SQL Server 2016 for Developers
McSe Training Guide: SQL Server 6.5 Design and Implementation
Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
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.