SQL Scripting Class

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)
• and much more!