Project Description

Class Length: 3 Days

Retail Price: $750

Multiple Seat Discounts Available

Live online available!

You can learn from work, home, or here at Computer Tutors. On days that this class is scheduled, you have the option to join us using Microsoft Teams.

Enroll Now

Details

Students will acquire the skills to answer real-life questions by planning, executing, and filtering SQL commands. They will also be able to carry out basic tasks involving managing the data and structure of a database.

Day 1 Day 2 Day 3
Database Design & Terms Mathematical Operators Types of Information in SQL
Selecting Data in Tables Scalar Functions: Rounding & Concatenating Adding & Removing Tables
Refining Results with Conditionals Aggregate Functions: Counting, Averaging, Min & Max Adding & Removing Data
Flexible Conditionals Using Wildcards Filtering Results of Functions Modifying Tables & Data
Sorting Results Subqueries & JOINs Keeping Temporary Tables in Views

This is an essential course for students working in any type of Structured Query Language (SQL). This course covers the basics of database design and how SQL can be used to manage the database. The course will also cover the basic syntax of queries, how to refine query results, as well as the basics of how to manage the structure of a database.

There are no prerequisites for this class.