SQL Scripting

SQL (short for "Structured Query Language") is the standard language for accessing, inputting and manipulating data in relational databases. With an easy-to-follow English-based syntax, SQL scripting gives you the power to access data in a wide variety of databases, including MS Access, MySQL, Postgres, Oracle, and MS SQL Server. AcademyX's SQL class covers everything you need to know, including:

• Selecting Data

• Getting Data from Multiple Tables

• Using Criteria in SQL Statements

• Generating Totals Using SQL

• Generating Calculated Fields Using SQL

• Using UNIONS, SUBQUERIES, and more JOINS

• Modifying Databases with Action Queries

• Working with VIEWS

• Using SQL to Structure Databases

• Creating and Working with Indexes

• Conditional Queries with IF and CASE Statements

• Creating and Using Common Table Expressions (CTES)