Introduction to SQL

Product type
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • Describe the basic concepts surrounding a relational database
  • Access an Adaptive Server database using ASE client software
  • Write a simple query that returns data from a database
  • Write a qualified query that returns a specific subset of information
  • Use aggregates to perform mathematical analyses of data
  • Query data from more than one table using joins
  • Query data from more than one table using subqueries

Audience

  • Database Designers, Application Developers, Database Administrators, End Users

Prerequisites

Essential
  • * None

Content

  • Relational database concepts, client/server architecture, simple queries (queries that retrieve all data from a given table), queries (queries that retri…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Goals

  • Describe the basic concepts surrounding a relational database
  • Access an Adaptive Server database using ASE client software
  • Write a simple query that returns data from a database
  • Write a qualified query that returns a specific subset of information
  • Use aggregates to perform mathematical analyses of data
  • Query data from more than one table using joins
  • Query data from more than one table using subqueries

Audience

  • Database Designers, Application Developers, Database Administrators, End Users

Prerequisites

Essential
  • * None

Content

  • Relational database concepts, client/server architecture, simple queries (queries that retrieve all data from a given table), queries (queries that retrieve only data that matches a given condition), aggregates (simple functions that summarize data), joins (queries that retrieve data from multiple tables), and subqueries (queries nested inside other queries).

Notes

  • An excellent refresher for entry-level programmers and database administrators. Gain practical, hands-on experience writing database queries that retrieve, organize, and summarize data managed by an Adaptive Server. Learn to construct simple and complex queries using both ANSI-89 standard SQL and Transact-SQL extensions.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.