Introduction to SQL
- Type product
Introduction to SQL
Opleiderscore:
Beschrijving
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…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
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
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.