Connecting to SQL with Query Express

Once you get into IT and begin to mature, you’ll have dozens of paths to select.  One of the many things you may be asked to do is to query data.   While you can have direct access to the server, you may be asked to perform queries from your workstation.  One of the many ways you can connect is with small programs that connect by ODBC to your SQL server.

Query Express is freeware that you can download.  No installation is required.

Running Queries with Query Express

1 connection

2 Select table

3 Query One

4 Counting

5 specific

6 Like

7 Counting specfic

Want a great place to learn SQL?

Sample database to practice on-


About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Technology and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s