SQL Programming

Hours: 32 / Access Length: 7 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $375.00

Course Overview:

Structured Query Language (SQL) is the language use to work with databases and the information stored within them. In this course students will learn to query a database to SELECT the data with which they want to work. Students will use SQL to create, edit and delete data tables. Students will learn to create views, functions, and stored procedures. Students will need access to a database that uses SQL commands. There is a trial version of SQL Server available.

ATTENTION: This course has a strict start and end date.  When a student enrolls into this course, they will need to work with one of our Training Assessment Managers (TAMs) to choose a start date before they can be enrolled in their course.

Course Outline:

• install the SQL Server demo and explore the basics of relational databases.
• write SQL SELECT statements to retrieve data from a single data table.
• write SQL SELECT statements with JOINS to retrieve data from multiple tables.
• write queries to summarize data using aggregate functions.
• write queries that contain sub queries.
• write SQL queries to insert, update and delete data from data tabes.
• write queries to convert and edit data in the database.
• design a database
• will write SQL statements to create a database.
• create a final project showing what they have learned in this course.

All necessary materials are included.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.