Introduction to SQL
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…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
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.