SQL Fundamentals And Advanced Querying

Upon successful completion of this course, students will be able to:

• Connect to the SQL Server database and execute a simple query.
• Include a search condition in a simple query.
• Use various functions to perform calculations on data.
• Organize data obtained from a query before it is displayed on-screen.
• Retrieve data from tables.
• Format an output, save a result, and generate a report.
• Use subqueries to generate query output.
• Manipulate table data by inserting and updating records in a table and deleting records from a table.
• Manipulate the table structure.
• Create views, manipulate data through views, modify the view structure, and drop views.
• Create indices on table columns and drop inefficient indices.
• Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.