In this course you will be introduced to the advanced features of the SQL language, and how it can be used to query a database in order to answer business questions. In this course you will examine the following advanced features: querying with unions, advanced joins and sub queries, add, update and remove data, manipulate tables, views and various indexes, ensure data integrity with transactions, and create databases.
Objectives: After completing this course you will be able to use advanced techniques for querying a database, query with subqueries, add data to a database, change and delete data from a database, create, alter, and delete tables, and create, use, and delete views. You will also be able to create and delete indexes, manage how data is altered through the use of transactions, and create and drop databases. (duration: 210)
Advertisement
Advertisement
The Latest from CACM
Shape the Future of Computing
ACM encourages its members to take a direct hand in shaping the future of the association. There are more ways than ever to get involved.
Get InvolvedCommunications of the ACM (CACM) is now a fully Open Access publication.
By opening CACM to the world, we hope to increase engagement among the broader computer science community and encourage non-members to discover the rich resources ACM has to offer.
Learn More
Join the Discussion (0)
Become a Member or Sign In to Post a Comment
Comments are closed.