60001 SQL Scripting Essentials

Course: 6001

SQL (short for “Structured Query Language”) is the standard language for accessing, inputting and manipulating data in relational databases.

Download PDF
  • Duration: 2 days
  • Price: $1,490.00
Get This Course $1,490.00
December 12 - 13

9:00 AM – 4:00 PM CST

January 16 - 17

9:00 AM – 4:00 PM CST

February 13 - 14

9:00 AM – 4:00 PM CST

March 13 - 14

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

OVERVIEW:

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, etc.¬† You will learn the skill of writing correct and effective¬†SQL¬†statements that manipulate and retrieve data from your database

PREREQUISITES:

  • Experience with a desktop database such as Filemaker or MS Access

AGENDA TOPICS

Unit 1- Introduction to the Structured Query Language (SQL)?

  • Relational Databases
  • Basic SQL Keywords
  • Tips for Planning Queries
  • What People Do with Queries
  • SQL Platforms

Unit 2- Data Selection

  • Using SELECT Statements to Examine Database Tables
  • Using Results to Figure Out Other Tables to Examine
  • Narrowing Your SQL Statements Down to Fields You Need
  • Sorting Records
  • Using Field Aliasing
  • Saving a SQL Statement

Unit 3- Retrieving Data From Multiple Tables

  • Inner and Outer JOINS
  • Table Aliasing
  • Self JOINS

Unit 4- Use Criteria in SQL Statements

  • Avoiding Ambigious Situations
  • Using A Single Criterion to Limit Records
  • AND/OR Situations in Criteria
  • Criteria Keywords
  • Using Comparison Criteria
  • Using Wildcards

Unit 5- Generate Totals Using SQL

  • Aggregate Keywords
  • The GROUP BY Clause
  • Using Criteria in Aggregate-based Queries

Unit 6- Generate Calculated Fields Using SQL

  • Math Calculations
  • Using SQL Keywords to Enhance the Display of Data
  • DATE Calculations
  • TEXT Calculations

Unit 7- Using UNIONS, SUBQUERIES, and More JOINS

  • Using a WHERE Clause as an INNER JOIN
  • Using UNIONS
  • Using SUBQUERIES

Unit 8- Action Queries within SQL

  • Using the INSERT Keyword
  • Using the UPDATE Statements
  • Using the DELETE Keyword

Unit 9- VIEWS

  • Creating a VIEW to Simplify Data Retrieval
  • Altering a VIEW
  • Creating a VIEW to Restrict Accessbile Data
  • Inserting Data Through a VIEW
  • Delete VIEWS

Unit 10- Structure Databases using SQL

  • Understanding DATA Types
  • Creating Tables
  • Altering Tables
  • Deleting Tables

Unit 11- Working with Index

  • Creating a Single-Column Index
  • Creating a Multiple-Column Index
  • Dropping an Index

Unit 12- Working with Conditional Queries

  • Using an IF Statement
  • Using a CASE Statement

Unit 13- Developing Common Tables Expressions

  • Creating and Using Common Table Expressions (CTES)

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961