|
Contacts:+91-7702999361 +91-7702999371
Online And Classroom Training
Introducing SQL Server
•Overview of the SQL Server suite of products
•Fundamentals of the relational database engine
•SQL Server Agent, BIDS and Management Studio
•Overview of SQL Server services
Building the Database
•Constructing a relational database
•Choosing optimal file size and growth parameters
•Working with database schemas
•Defining tables
•Specifying appropriate data types
•Indexing tables with Management studio
•Adding, modifying or removing columns
•Safeguarding data with constraints
•Enforcing uniqueness through primary key constraints
•Validating conditions with check constraints
•Protecting relationships with foreign keys
Leveraging Server Programmability
•Retrieving data with Transact-SQL
•Employing Query Designer to construct select statements
•Inserting new rows into tables
•Updating targeted data
•Deleting specific rows
•Creating stored procedures for productivity
•Writing user-defined functions to simplify queries
•Deploying triggers to capture change events
Administering SQL Server Databases
•Executing the Maintenance Plan Wizard
•Defragmenting data and checking database integrity
•Improving performance by rebuilding indexes
•Automating administrative tasks
•Scheduling repeating jobs
•Implementing a backup strategy
•Monitoring SQL Server resources
•Displaying current activity and expensive queries
•Running reports with Management Studio
•Securing the database infrastructure
•Authenticating SQL Server and Windows logins
•Assigning users to database and server roles
•Granting or revoking permissions
•Comparing authentication modes
•Defining logins
•Creating user-defined server roles
•Enforcing password policy
•Granting database access
•Contrasting users and logins
•Defining new roles
•Delegating privileges with predefined roles
•Repairing mismapped logins
Setting up SQL Server
•Selecting installation options
•Installing a named instance
•Leveraging essential tools
•SQL Server Management Studio
•Configuration Manager
•Transact-SQL
•sqlcmd
•Dedicated Administrator Connection
Constructing and Managing Databases
•Inspecting storage structures
•Relating servers, databases and files
•Creating databases and transaction logs
•Designing file groups
•Maximizing storage utilization
•Placing tables on file groups
•Upgrading and moving databases
•Choosing between upgrade and migration
•Detaching and attaching databases
•Controlling database space
•Permitting automatic database growth
•Adding database files to expand databases
Handling Server and Database Security Granting and Revoking Permissions
•Managing database-scoped privileges
•Permitting object creation
•Giving blanket permissions
•Defining object-level permissions
•Limiting object access
•Meeting complex permission requirements with roles
Backup and Recovery
•Backing up databases
•Selecting a recovery model
•Investigating the transaction log
•Running full, log and differential backups
•Restoring databases
•Performing a post-crash log backup
•Recovering user and system databases
Streamlining Tasks with Jobs, Alerts and Database Mail
•Configuring SQL Server Agent
•Setting agent properties
•Implementing database mail
•Defining jobs to handle routine tasks
•Creating alerts and operators
•Initiating multi-step jobs
•Associating alerts with jobs
Database Maintenance and Monitoring
•Handling fragmentation and database corruption
•Identifying and curing fragmentation
•Repairing database corruption
•Building database maintenance plans
•Scheduling plan execution
•Notifying operators of success or failure
•Resolving contention problems
•Identifying blocked processes
•Killing blockers
|
