SQL Server -Advanced

24 Hours

TDXBI-107

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.

When completing this course, students will be able: 1. Plan and implement a backup strategy 2. Import and export data. Monitor SQL Server 3. Manage SQL Server security 4. Better understanding of queries and store procedures

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.com
Download Full Syllabus

Modules

  • Writing Self Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicat e with Subqueries
  • What is a view?
  • How we create and edit a view?
  • Writing simple views
  • Writing complex views
  • What is a procedure?
  • Write a procedure in SQL
  • Understanding the basic SQL store pr ocedure commands
  • Sending and using parameters to a procedure
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • About Indexes
  • CREATE & DROP INDEX Statements
  • Indexes & Performance
  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and T ransaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Introduction to SQL Server Security
  • Managing Server Level Security
  • Managing Database Level Principals
  • Managing Database Permissions

Prerequisites

  • 01 Basic knowledge of the Microsoft Windows operating system and its core functionality
  • 02 Working knowledge of SQL
  • 03 Working knowledge of relational databases
  • 04 Experience with database design

Target Audience

  • The primary audience for this course is individuals who wish to develop applications that deliver content from SQL Server databases.

Contact us

    Skip to content