Course Outline
This course provides students with the knowledge and skills needed to maintain a SQL Server database. The course focuses on learning how to use SQL Server product features and tools related to maintaining course focuses on learning how to use SQL Server product features and tools related to maintaining a database.
Upcoming Meetings
There are no upcoming meetings for this course. Contact us to schedule this course, which will be customized specifically for your organization.
info@hackerupro.comModules
Using Sub queries
- Writing Self Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicat e with Subqueries
Writing and using queries
- What is a view?
- How we create and edit a view?
- Writing simple views
- Writing complex views
Store Procedures
- What is a procedure?
- Write a procedure in SQL
- Understanding the basic SQL store pr ocedure commands
- Sending and using parameters to a procedure
Working with external files
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
Indexes
- About Indexes
- CREATE & DROP INDEX Statements
- Indexes & Performance
Indexes
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and T ransaction Logs
- Using Backup Options
- Ensuring Backup Reliability
Security
- Introduction to SQL Server Security
- Managing Server Level Security
- Managing Database Level Principals
- Managing Database Permissions
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of SQL
- Working knowledge of relational databases
- Experience with database design