Radhika Technosoft head
SQL Server DBA
Radhika Technosoft head

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.

COURSE CONTENT:

  1. SQL Server Architecture
  2. SQL Server Version's and Editions
  3. SQL server Installation and Configuration
  4. System databases
  5. Pages and extents
  6. Sql server services
  7. Sql server protocols
  8. ACID properties
  9. Recovery models
  10. Security-Login and User,Principals,Securables,Managing Permissions
  11. Authentication Modes
  12. Server roles
  13. Database roles
  14. Isolation Levels and Concurrency
  15. Locking and Blocking-Types of locks and Types of reads
  16. Service accounts for SQL server
  17. GUI Templates-object explorer,solution explorer,template explorer,registered servers
  18. Command line tools-BCP,SQLCMD
  19. Creating and Configuring Database
  20. Altering Databases and Their Options-Using ALTER command,Controlling Access,Controling DB state.
  21. Linked servers
  22. DAC-Dedicated Adminstrator Connection
  23. CMS-Central Management Server
  24. Data Compression and Backup Compression
  25. Using ALTER Authorization Command
  26. Schemas-Creating and working with schemas
  27. Databasesnapshots
  28. DBCC-And their parameters
  29. Indexes-Types of Indexes,working and Maintaining indexes,resolving indexfragmentation,fill factor
  30. Update statistics
  31. SQL Server 2008 Top New Features
  32. DMV's-Types of Dynamic Management Views and working with them.
  33. PBM-Policy Based Management
  34. Resource governer
  35. Performance data collector
  36. SQL Server profiler
  37. Maintainence Plans
  38. Databasemail
  39. Types of Sql Server Backups and their important options.
  40. Types of Restores and its related options
  41. Orphan Users-Fixing orphan users
  42. Log shipping
  43. Database Mirroring
  44. Replication-Types Replication
  45. Basics of Windows Clustering
  46. Overview of real time Third party Monitoring tools-Ex:-Idera DM,Lite speed.
  47. Overview of real time Ticketing tool-Ex:-Altiris,Remedey.

our services Radhika Technosoft head RADHIKA Technosoft, a pioneer in software training has brought monumental changes in the methods and services offered. We're not an organization who puts across implausible claims. Since our inception, our services are exactly what we promised. On a given note, our service offerings are Online training, Corporate training, Certification, Web development and Job support.

our courses Radhika Technosoft head RADHIKA Technosoft is one of the trusted training institutes that offer online training for WEBSPHERE, SAP, ORACLE, PROFESSIONAL COURSES, works with a mission to make online software learning easier for all the students across the world.

Radhika Technosoft our courses websphere
Radhika Technosoft our courses sap
Radhika Technosoft our courses oracle
Radhika Technosoft our courses professional courses
Radhika Technosoft our courses java
Radhika Technosoft our courses microsoft
Radhika Technosoft our courses tibko
Radhika Technosoft our courses websphere
Radhika Technosoft our courses sap
Radhika Technosoft our courses oracle
Radhika Technosoft get in touch

Radhika Technosoft get in touch message get in touch
Feel free to get in touch with us.

contact us

Radhika Technosoft
No.1, 4th floor ideal home township,
Raja Rajeshwari Nagar,
Bangalore - 560098

social network
  • Facebook
    Radhika Technosoft Social icon
  • Linkedin
    Radhika Technosoft Social icon
  • Twitter
    Radhika Technosoft Social icon
  • Google Plus
    Radhika Technosoft Social icon

Copyrights @ All rights reserved | Privacy Policy | Sitemap Login

Scroll Up