About this course
SQL is a powerful and popular database program that is widely used for data analysis and manipulation. This course is designed to provide the student with a solid understanding of database concepts and the basics of the SQL language. It includes review of database structures, application architecture, SQL constructs and client-server fundamentals. The course utilizes a series of exercises where the student writes and execute SQL statements using SQL syntax discussed in the lessons.

In this course, you will compose SQL queries to retrieve desired information from a database.

You will:

• Connect to the SQL Server database and execute a simple query.
• Include a search condition in a simple query.
• Use various functions to perform calculations on data.
• Organize the data obtained from a query before it is displayed on-screen.
• Retrieve data from multiple tables.
• Export the results of a query.

Audience profile
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Prerequisites
No prior database experience is necessary but can be helpful. A firm understanding of MS-Windows and Windows applications is mandatory. The course is best suited for people who have used spreadsheets and word processing applications for several years and wish to learn about databases and the SQL language.