dbm294 | undergraduate

Querying A SQL Server

Explore by:

or call us at

About:

About:

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. This course addresses the objectives contained in the Microsoft Certified Solutions Associate (MCSA) for querying a Microsoft® SQL Server®.

This undergraduate-level course is 5 weeks This course is available to take individually or To enroll, speak with an Enrollment Representative.

Course details:

Credits: 3
Continuing education units: XX
Professional development units: XX
Duration: 5 weeks

topic title goes here

    Managing Transactions and Error Handling

    • Apply query optimization techniques
    • Manage transactions
    • Implement error handling

    Querying SQL Server

    • Retrieving data using SQL
    • Compare filtering and sorting data
    • Aggregate functions
    • Establish relationships.
    • Demonstrate how to import data into a table

    Managing SQL Data

    • Calculate totals
    • Handle NULL Data
    • Use DCL Statements
    • Modify Data
    • Generate calculated fields

    Database Solutions

    • Create database objects
    • Diagram DDL statements
    • Implement data types
    • Diagram DML statements

    Modifying Data

    • Join a dataset
    • Utilize subqueries
    • Group data
    • Utilize subqueries
    Tuition for individual courses varies. For more information, please call or chat live with an Enrollment Representative.

    Please ask about these special rates:

    Teacher Rate: For some courses, special tuition rates are available for current, certified P-12 teachers and administrators. Please speak with an Enrollment Representative today for more details.

    Military Rate: For some courses, special tuition rates are available for active duty military members and their spouses. Please speak with an Enrollment Representative today for more details.

    The University of Phoenix reserves the right to modify courses.

    While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Representative.

    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.