Mar 19, 2024  
2021-2022 Course Catalog 
    
2021-2022 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

NET 711 - SQL Database

Credits: 3
Lecture Hours: 3
Lab Hours: 0
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
This course covers the current curriculum for implementing a database in Microsoft SQL Server. For more information, contact the chairperson of the ITNA program.
Prerequisite: NET 333, NET 664, NET 343 
Competencies
  1. Use SQL Server books online
    1. Describe Microsoft SQL Server 7.0 and its supporting operating systems.
    2. Describe SQL Server architecture
    3. Describe SQL Server components
    4. Identify SQL Server design options, as well as implementation and administration activities
  2. Demonstrate ways to use Transact-SQL
    1. Describe the basic elements of Transact-SQL
    2. List data definition statements
    3. List data manipulation statements
    4. List data control statements
    5. Describe the ways to execute Transact-SQL statements
  3. Create databases
    1. Evaluate database considerations
    2. Create and configure a database.
    3. Manage a database and transaction log
    4. Create and drop user-defined data types
    5. Create and drop user tables
    6. Generate a script
  4. Implement Data Integrity
    1. Describe the three types of data integrity
    2. Determine which features to use to enforce data integrity
    3. Define and use DEFAULT and CHECK constraints
    4. Define PRIMARY KEY, UNIQUE, and FOREIGN KEY constraint
    5. Describe and use defaults and rules
  5. Plan and create indexes
    1. Determine when indexes are useful and decide the types of indexes to create
    2. Create clustered and nonclustered indexes with unique or composite characteristics
    3. Use the CREATE INDEX options to expedite index creation and improve index performance
    4. Apply the appropriate fillfactor value to accommodate the future growth of tables
    5. Use various tools and verification features to maintain indexes and enhance their optimal performance
  6. Perform advanced queries
    1. Combine data from two or more tables using joins
    2. Combine multiple result sets into one result set using the UNION operator and the SELECT INTO statement
    3. Use subqueries to break down and perform complex queries
    4. Use joins and subqueries as selection or data modification criteria within a statement
    5. Set up a distributed environment that accesses data stored in a remote SQL Server 
  7. Summarize data.
    1. Generate a single summary value using aggregate functions.
    2. Organize summary data for a column using aggregate functions with the GROUP BY, HAVING, COMPUTE, and COMPUTE by clauses
    3. Generate summary data for a table using aggregate functions with the GROUP BY clause and the ROLLUP or CUBE operators
    4. Use the TOP n keyword to retrieve a list of the specified top values in a table
  8. Manage transactions and locks
    1. Describe transaction processing
    2. Execute, cancel, or roll back a transaction
    3. Identify resource items that can be locked
    4. Identify the types of locks
    5. Set locking options and display locking information
    6. Initiate a distributed transaction
    7. Compare distributed transactions and replication
  9. Implement views
    1. Explain the purpose and benefits of using views
    2. Create a view using the CREATE VIEW statement
    3. Drop a view from a database
    4. Locate view definition information
    5. Alter a view
    6. Update a source table using a view
  10. Implement stored procedures
    1. Describe how a stored procedure is processed
    2. Create, execute, modify, and drop a stored procedure
    3. Execute a stored procedure on a remote server
    4. Use parameters with stored procedures
    5. Recompile a stored procedure
    6. Create custom error messages
  11. Implement triggers
    1. Define a trigger
    2. Explain the advantages of using a trigger
    3. Describe some considerations when using a trigger
    4. Create a trigger
    5. Drop a trigger
    6. Alter a trigger



Add to Portfolio (opens a new window)