Skip to Main Content Skip to bottom Skip to Chat, Email, Text

DBM/294

Querying a SQL Server

credits

Total credits

weeks

Course length

Take this course on its own, or as part of a degree or certificate program.

Please Note: Attendance and participation are mandatory in all University courses, and specific requirements may differ by course. If attendance requirements are not met, a student may be removed from the course. Please review the Course Attendance Policy in the Catalog for more information.

University of Phoenix reserves the right to modify courses. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative.

Course level: Undergraduate

This course provides an overview of querying a SQL Server®. Emphasis is placed on creating database objects, working and modifying data, and optimizing the database environment.

Please Note: Attendance and participation are mandatory in all University courses, and specific requirements may differ by course. If attendance requirements are not met, a student may be removed from the course. Please review the Course Attendance Policy in the Catalog for more information.

University of Phoenix reserves the right to modify courses. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative.

What you'll learn

Course skills and outcomes

  • Describe how to connect to Microsoft® SQL Server® using authentication.
  • Explain the different functions in SQL Server® Management Studio (SSMS) and run the program.
  • Construct tables using SSMS and be able to view and execute resulting T-SQL.

  • Explain T-SQL syntax.
  • Execute queries using the SELECT statement.
  • Determine how to specify columns to display, including aliases.
  • Apply the WHERE clause to filter query results.
  • Demonstrate the use of the ORDER BY clause to sort results.

  • Describe database keys used in database design.
  • Identify how to insert data into a table using an INSERT statement.
  • Demonstrate updating data in a table using the UPDATE statement.
  • Execute the DELETE statement to delete rows in a table.

  • Explain how to logically relate tables through the use of foreign keys.
  • Use INNER JOIN to retrieve data from multiple tables.
  • Use OUTER JOIN to retrieve data from multiple tables.
  • Describe how to create and utilize views.

  • Demonstrate grouping results in a query using the GROUP BY clause.
  • Demonstrate filtering grouped results using the HAVING clause.
  • Describe how to create and use subqueries.
  • Demonstrate how to utilize aggregate functions.

Why UOPX

Why take courses at University of Phoenix

Accreditation that matters

We’ve been accredited by the Higher Learning Commission (hlcommission.org) for more than 40 years.

Real-world instructors

Learn from instructors who bring an average of 25 years of working experience to the classroom.

Affordable and potentially reimbursable

Our tuition and fees are competitive and fixed. Also, check to see if your employer will cover you for this course.

Next Steps

Smiling enrollment representative

Start a conversation about your future with an enrollment representative today.

Transfer Credits

Credit Transfer

Need to transfer credits to another college or university?

Before you enroll in a course, check with your school of choice to make sure they will accept our transfer credits and to understand any requirements or limitations. Then you can complete your course, and request your official transcript be sent to your school. That’s it!

Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice. If you have a question contact us at (866) 354-1800.

The University of Phoenix reserves the right to modify courses. Although our continuing teacher education courses are accepted by some state agencies in the United States toward teacher certifications and endorsements, this may not be the case in all states or foreign jurisdictions. If you plan to use courses for certification or endorsement, please check with your own state agency and your school district for applicability. Continuing teacher education courses are not eligible to apply to degree programs at University of Phoenix. These courses are not eligible for federal financial aid. Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative. If you have a question contact us at (866) 354-1800.