Project Description

Class Length: 3 Days

Retail Price: $750

Multiple Seat Discounts Available

This class is only available in-person

Due to the equipment used in this class, this class can only be attended in person at this time.

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.