SQL

Intro to Software

Structured Query Language (SQL) is the fundamental language for relational database management system. 99% of companies use relational database to store their business information. It is very important for Business Analysts and database administrators to use SQL skills to retrieve insights from data and support decision making.  

Course Description

Whatever a database is being used for—websites, bookkeeping, sales and inventory, or even the lowly to-do list—it's still all about the data. Completely updated for 2014, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Beginning with a quick start introduction for those who want to start working with data immediately, the instructor will teach all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views. Instructor Scott Simpson offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple CRUD (Create, Read, Update, and Delete) application using SQL.Topics include:

  • Understanding SQL terminology and syntax
  • Creating new tables and records
  • Inserting and updating data
  • Writing basic SQL queries
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Finding the numeric type of a value
  • Using aggregate functions and transactions
  • Updating a table with triggers
  • Creating views


SQL is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. The Instructor will also show how to perform simple math operations and transform data into different formats. Topics include:

  • What is SQL?
  • Asking for data with SELECT
  • Limiting database responses
  • Organizing responses
  • Asking for data from two or more tables
  • Understanding join types and data types
  • Transforming data
  • Performing math
  • Adding and modifying data in a table


There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases.

The course begins with a brief overview of SQL. Then it moves on to the five major topics a data scientist should understand when working with relational databases: basic statistics in SQL, data preparation in SQL, advanced filtering and data aggregation, window functions, and preparing data for use with analytics tools. Topics include:

  • Data manipulation
  • ANSI standards
  • SQL and variations
  • Statistical functions in SQL
  • String, numeric, and regular expression functions in SQL
  • Advanced filtering techniques
  • Advanced aggregation techniques
  • Windowing functions for working with ordered data sets


Class Format

Available both live online & face to face in a classroom (minimum # of student is 3)    

Class Duration

Essential Level 32 hours

Advanced topic 32 hours

Career Opportunities

Database Administrator

Data Scientist

Business Analyst

Business Intelligence Analyst

Data Warehouse Analyst

c#

Intro to Software

This general-purpose language was originally designed by Microsoft to be used for developing apps on the Microsoft platform, and C# developers love the language for being pleasant to use and well-designed. If you want to build apps for the Microsoft platform, you should naturally learn C#. C# is often the recommended language to use when making games through the Unity Game engine. 

Course Description

 C# is an object-oriented language designed by Microsoft and used by systems engineers, desktop programmers, and mobile app developers all over the world. In these tutorials, David Gassner takes you through C#'s history, its core syntax, and the fundamentals of writing strong C# code. After explaining C#'s relationship to .NET and Windows, David shows how to install Visual Studio, a great IDE for developing in C#, and then dives into the language itself. Along the way, he covers topics such as:

  • Declaring and initializing variables with a variety of data types
  • Exploring operators, expressions, constants, and enumerations
  • Controlling flow with conditional code and loops
  • Handling exceptions
  • Managing data collections
  • Creating custom classes
  • Organizing classes by namespace
  • Understanding inheritance

Whether you're choosing C# as your first step into programming or adding it your existing skillset, these training videos will help you understand the language and use it to build your own great software 



Want an easy way to query and update data? To query different data stores with a single tool? LINQ is the answer. Language-Integrated Query (LINQ) extends Visual Studio with powerful query capabilities based on C# and Visual Basic. LINQ makes big data doable.

In LINQ with C# Essential Training, engineer Olivia Chiu introduces techniques for querying, updating, and transforming data with LINQ. She covers standard queries—such as finding overlaps in two datasets and creating hierarchies—as well as complex chained queries. She also shows how to group and join LINQ queries with lambda expressions, and use LINQ to query SQL databases and XML documents. Last but not least, Olivia provides tips for optimizing the performance of your queries. Topics include:

  • Creating and executing a LINQ query
  • Returning results
  • Changing the data source type
  • Performing standard queries
  • Working with lambda expressions
  • Chaining and complex queries
  • Querying SQL and XML
  • Performing tree queries
  • Using sequences, elements, and scalars
  • Allocating memory


Class Format

Available both live online & face to face in a classroom (minimum # of student is 3)    

Class Duration

Normally, 55 hours for essential training if no background at all.

16 hours for each advanced topic.

Career Opportunities

Software developer

Testing engineer

Software engineer

.net Application developer