Welcome!

Eclipse Authors: Pat Romanski, Elizabeth White, Liz McMillan, David H Deans, JP Morgenthal

News Feed Item

Research and Markets: Introduction to SQL Training - An Essential Resource

Research and Markets (http://www.researchandmarkets.com/research/ngw86z/introduction_to) has announced the addition of the "Introduction to SQL Training" training to their offering.

This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

This class is hands-on and interactive, with exercises, presentations and readings to ensure students stay engaged and learn the material presented.

Approximately 16 hours of training.

This course is valid for One Year after purchase.

Key Topics Covered:

Relational Database Basics

- Brief History of SQL

- Relational Databases

-- Tables

-- Rows

-- Columns

-- Relationships

-- Datatypes

-- Primary Keys

-- Foreign Keys

-- Relational Database Management System

- Popular Databases

-- Commercial Databases

-- Popular Open Source Databases

-- Valid Object References

- SQL Statements

-- Database Manipulation Language (DML)

-- Database Definition Language (DDL)

-- Database Control Language (DCL)

Simple SELECTs

- Introduction to the Northwind Database

- Some Basics

-- Comments

-- Whitespace and Semi-colons

-- Case Sensitivity

- SELECTing All Columns in All Rows

- Exploring the Tables

- SELECTing Specific Columns

- Sorting Records

-- Sorting By a Single Column

-- Sorting By Multiple Columns

-- Sorting By Column Position

-- Ascending and Descending Sorts

- The WHERE Clause and Operator Symbols

-- Checking for Equality

-- Checking for Inequality

-- Checking for Greater or Less Than

-- Checking for NULL

-- WHERE and ORDER BY

- Using the WHERE clause to check for equality or inequality

- Using the WHERE clause to check for greater or less than

- Checking for NULL

- Using WHERE and ORDER BY Together

- The WHERE Clause and Operator Words

-- The BETWEEN Operator

-- The IN Operator

-- The LIKE Operator

-- The NOT Operator

- More SELECTs with WHERE

- Checking Multiple Conditions

-- AND

-- OR

-- Order of Evaluation

- Writing SELECTs with Multiple Conditions

Advanced SELECTs

- Calculated Fields

-- Concatenation

-- Mathematical Calculations

-- Aliases

- Calculating Fields

- Aggregate Functions and Grouping

-- Aggregate Functions

-- Grouping Data

-- Selecting Distinct Records

- Working with Aggregate Functions

- Built-in Data Manipulation Functions

-- Common Math Functions

-- Common String Functions

-- Common Date Functions

- Data Manipulation Functions

Subqueries, Joins and Unions

- Subqueries

- Joins

-- Table Aliases

-- Multi-table Joins

- Using Joins

- Outer Joins

- Unions

-- UNION ALL

-- UNION Rules

- Working with Unions

For more information visit http://www.researchandmarkets.com/research/ngw86z/introduction_to

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

IoT & Smart Cities Stories
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
"Avere Systems deals with data performance optimization in the cloud or on-premise. Even to this day many organizations struggle with what we call the problem of data gravity - 'Where should I put the data?' - because the data dictates ultimately where the jobs are going to run," explained Scott Jeschonek, Director Cloud Solutions at Avere Systems, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
If a machine can invent, does this mean the end of the patent system as we know it? The patent system, both in the US and Europe, allows companies to protect their inventions and helps foster innovation. However, Artificial Intelligence (AI) could be set to disrupt the patent system as we know it. This talk will examine how AI may change the patent landscape in the years to come. Furthermore, ways in which companies can best protect their AI related inventions will be examined from both a US and...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
DXWorldEXPO LLC, the producer of the world's most influential technology conferences and trade shows has announced the 22nd International CloudEXPO | DXWorldEXPO "Early Bird Registration" is now open. Register for Full Conference "Gold Pass" ▸ Here (Expo Hall ▸ Here)
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
@DevOpsSummit at Cloud Expo, taking place November 12-13 in New York City, NY, is co-located with 22nd international CloudEXPO | first international DXWorldEXPO and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time t...
Contextual Analytics of various threat data provides a deeper understanding of a given threat and enables identification of unknown threat vectors. In his session at @ThingsExpo, David Dufour, Head of Security Architecture, IoT, Webroot, Inc., discussed how through the use of Big Data analytics and deep data correlation across different threat types, it is possible to gain a better understanding of where, how and to what level of danger a malicious actor poses to an organization, and to determin...
The hierarchical architecture that distributes "compute" within the network specially at the edge can enable new services by harnessing emerging technologies. But Edge-Compute comes at increased cost that needs to be managed and potentially augmented by creative architecture solutions as there will always a catching-up with the capacity demands. Processing power in smartphones has enhanced YoY and there is increasingly spare compute capacity that can be potentially pooled. Uber has successfully ...