Description

Practical Database Administration and Engineering Step by Step

• Creating Databases
• Creating Tables
• Creating Views
• Creating Stored Procedures
• Using subqueries
• Managing users and privileges
• Performing backups and restore
• Perform table joins
• Perform aggregate functions
• Attaching Sample Database
• Querying data from all columns in a table
• Querying data from specific columns in a table
• Sorting data using ORDER BY clause
• Removing duplicate records
• Identifying NULL values
• Filtering data
• Inserting data unto database
• Updating existing records inside database
• Deleting records from database