sales@dynamicsedge.com
202-410-6400

Note: For additional questions and clarification, you may reach Bill Ramirez at bill@dynamicsedge.com or on his following contact details: Office- (510) 804-3600 & Cell- (415) 200-6969

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:

AGENDA TOPICS

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

Unit 2- Data Selection

Unit 3- Retrieving Data From Multiple Tables

Unit 4- Use Criteria in SQL Statements

Unit 5- Generate Totals Using SQL

Unit 6- Generate Calculated Fields Using SQL

Unit 7- Using UNIONS, SUBQUERIES, and More JOINS

Unit 8- Action Queries within SQL

Unit 9- VIEWS

Unit 10- Structure Databases using SQL

Unit 11- Working with Index

Unit 12- Working with Conditional Queries

Unit 13- Developing Common Tables Expressions

 

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
https://www.dynamicsedge.com/
sales@dynamicsedge.com
Solutions
Company
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
202-410-6400
800-453-596 (Toll Free)
sales@dynamicsedge.com