Back to Home PageWelcome Guest! Register | Login | Home | Contact Us | Site Map | Advertise | FAQ | Search
Canadian Desi
    Classifieds





   Home   Latest   Accommodations   Autos   Services   Merchandise   Training   Properties   Put Your Ad   Search
Classifieds > Private Tuition and Training Providers. (Available) > Canada > Ontario > Hyderabad > SQL DBA real time online training ,interview support from USA >

SQL DBA real time online training ,interview support from USA

Listing ID: 107194   Posted on 26-Sep-19
Contact Details:
Contact: sri raja
Phone: 8106721223 



Address:
20 HI Tech city
Hyderabad Ontario 500031 

Driving Direction


 
Report Abuse

FOR FREE DEMO contact :
Email :
Phone/WhatsApp : +91-8106721223
USA Number : +1-650-993-1007
Gtalk :
WebSite: http://www.ibasetraining.com


SQL Introduction & Installation
 SQL Server Installation
 Services & Authentication
 Configurations Checker Tool
 Management Studio(SSMS) Tool
 Configuration Tools & SMO
 Protocols & Server Aliases
 SQL Server Database Design
 SQL Database Design
 Files & File Group Options
 Data File Recommendations
 Log File Recommendations
 Database Options & Sizing
 SQL Server Tables Design
 Table Design and Types
 T-SQL Data Types & Use
 INSERT & SELECT Options
 Tables & Filegroup Usage
 INSERT and UPDATE Queries
 Data Validations & Constraints
 Constraints and Keys
 Normalization and BCNF
 UNIQUE KEY and NOT NULL
 PRIMARY KEYS & Usage
 CHECK, DEFAULT, REFERENCES
 Composite Keys & Types
 SET Options & Sub Queries
JOINS and Sub Queries
 WHERE, IN and SWITH Options
 EXISTS, APPLY, BETWEEN
 ORDER BY, GROUPING, HAVING
 Sub Queries
 Nested Queries & Usage
 Views with Nested Joins
 Views as Virtual Objects
 Views as Physical Objects
 SCHEMABINDING, ENCRYPTION
 Issues with ALTER TABLE
 System Views & Joins
 Views with Joins and Views
 Indexes and Query Tuning
 Architecture of Table Indexes
 Clustered & NonClustered
 Execution Plans and Rules
 Indexes & Performance
 Unique Indexes and Uses
 Working with Indexed Views
 Stored Procedures & Benefits
 Stored Procedures & Use
 Variables and Parameters
 SCHEMABINDING, ENCRYPTION
 System Stored Procedures
 Dynamic SQL and Temp Tables

Functions(UDF) and Usage
 Functions Use & Types
 Scalar Valued Functions
 Table Valued Functions
 SCHEMABINDING, ENCRYPTION
 System Functions and Events
 Date, Time, String Functions
 Triggers and Cursors
 Why to use Triggers?
 DML Triggers & Performance
 INSERTED and DELETED tables
 Database and Server Triggers
 Cursor declaration Options
 STATIC and DYNAMIC cursors
 SCROLL & FORWARD_ONLY
 LOCAL and GLOBAL cursors
 Transaction Concepts
 Transaction Types & Use
 Blocking DML Operations
 Blocking DDL Operations
 COMMIT & ROLLBACK Options
 Transaction Locks & Deadlocks
 LOCKS Significance & Use
 Lock Types
 Isolation Levels & Usage
 Choosing Isolation Levels

Database Backups Strategies
 Backups Usage and Formats
 Database & Partial Backups
 FORMAT, INIT, CHECKSUM
 Backup with T-SQL & UI
 MSDB History Tables Audits
 Compressed Backups & Expiry
 Database Restores & Recovery
 Need for Restores and Types
 Backup Verifications
 Restore and Recovery Path
 DB, File Group, File Restores
 PARTIAL & Piecemeal Restores
 SQL Jobs
 Backup Schedules & Jobs
 Job Step Creation & Options
 Alert System
 Replication Configurations
 Replication for DR Process
 Snapshot and Transactional
 Merge Replication & Recovery
 Peer-Peer Initialization
 Replication PUSH & PULL

Log Shipping & DB Recovery
 Disaster Recovery Solutions
 Log Shipping Modes
 NORECOVERY and STANDBY
 LS Jobs, Schedules & Alerts
 LS Monitor Reports
 Database Mirroring
 COPY_ONLY & INIT Backups
 DB Mirroring Configuration
 Security and Data Encryption
 Levels of SQL Security
 Server Logins & DB Users
 Server Roles and Mappings
 Schema Level Security
 Database Roles and Security
 SQL Server Audits
 SQL Audits and SQL Tools
 Server Audits and Error Logs
 Realtime Implementations
 DBA Challenges in Realtime
 Partitions and Query Tuning
 Table Partitions and Tuning
 Partition Functions & Schemes
 Index Management
 Index Fragmentation & Issues
 Alerts and Troubleshooting
 LOG SPACE Issues & Solutions
 TEMPDB Issues & Solutions
 MEMORY Issues & Solutions

Windows Cluster Configuration
 Windows Licensing
 SQL Licensing
 SQL Cluster Configuration
 SQL Cluster Introduction
 Verifying Configurations
 Add Nodes to SQL Cluster
 Cluster Issues & Solutions
 Introduction

For course content please follow the link :http://ibasetraining.com/sql-dba-hands-on-online-training-job-support-from-india/

Printable Flier
Want to manage/update/remove your Listings?
Please enter your email or user-id
Nearby listings in this category
Mississauga 
SAP S/4HANA SALES Certification Training 
Projected start date Jan 10, 2021

2 Seats Remaining

Training Objectives

60 hours of in-class training conducted on weekends
Focused on getting SAP S/4 HANA SALES Certified Application Associate
Certified instructor with over 15 ye....
Date Posted: January 14 2021, 17:28


Mississauga 
Business Intelligence & Business Objects (BIBO) 
CONFIRMED START DATE OF BATCH Jan 16, 2021

Training Objectives

65 Hours of Instructor lead in-class training
Includes training on SAP BW on HANA, SAP Web Certification, SAP Design Studio (Lumira Designer 2.x), SAP Lumira (Lumira Discove....
Date Posted: January 14 2021, 17:27


Mississauga 
Starting SAP SuccessFactors training in IIBS!!! 
Projected start date of class Jan 17, 2021

SAP SuccessFactors is a complete, cloud-based HR system for all your needs

Training Objectives

50 hours of in-class training conducted on weekends
Focused on getting SAP SuccessFactors Certifi....
Date Posted: January 14 2021, 17:14


Mississauga 
Starting SAP HANA Analytics and Reporting with Data Modellin 
Business Intelligence & Business Objects (BIBO)


CONFIRMED START DATE OF BATCH Jan 16, 2021

Training Objectives

65 Hours of Instructor lead in-class training
Includes training on SAP BW on HANA, SAP Web Certification, SAP Design Stu....
Date Posted: January 14 2021, 17:13


Toronto 
NEW ONLINE BATCH FOR BUSINESS ANALYST STARTS JAN 16, 2021 
Business Analyst Training in Toronto
Are you a new fresh graduate from the business or it streams??
Do you know the software business analyst job market is expected to be robust for the next 5 - 10 years factoring in the retirements due in the next....
Date Posted: January 8 2021, 17:23


Toronto 
FREE DEMO CLASS-Business Analyst Training in Toronto-JAN 2,2 
SOFTWARE TESTING TRAINING AND PLACEMENT IN GTA
To start a career in Software Testing, you need to get an advanced testing training as per the industrial standards. It is a skilled profession, and the practical exposure you gain in this field is cons....
Date Posted: December 28 2020, 23:21


Toronto 
FREE DEMO CLASS-Business Analyst Training in Toronto-JAN 2,2 
SOFTWARE TESTING TRAINING AND PLACEMENT IN GTA
To start a career in Software Testing, you need to get an advanced testing training as per the industrial standards. It is a skilled profession, and the practical exposure you gain in this field is cons....
Date Posted: December 28 2020, 23:20


Mississauga 
Azure Data Factory and Data Analytics Training
Organizations of every size are moving to cloud computing to solve for a variety of business problems. Azure being one of the highest used cloud platform there are strong requirements of professionals with business intelligence skills on Azure Data F....
Date Posted: December 4 2020, 01:59


Toronto 
Business Analyst Training in Toronto
Business Analyst Training in Toronto
Are you a new fresh graduate from the business or it streams??
Do you know the software business analyst job market is expected to be robust for the next 5 - 10 years factoring in the retirements due in the next....
Date Posted: October 16 2020, 15:11


Mississauga 
LEARN THE LANGUAGE OF MEDICINE FROM AN AWARD-WINNING TEACHER

LEARN 'THE LANGUAGE OF MEDICINE' FOR FREE (BY APPOINTMENT ONLY)

AN AWARD-WINNING DOCTOR (IMG) TEACHER WILL TEACH

POTENTIAL DOCTORS/ MEDICAL STUDENTS/ NURSES/ HEALTHCARE WORKERS OR OTHERS WANTING TO LEARN THE SAME.

FREE FOR DESI ORIGIN ST....
Date Posted: October 12 2020, 18:49



Driving Direction

 
Contact sri raja
Your Name:*
Your Email:*
Your Phone:*
Your Message:
 
CAPTCHA Image
[ Different Image ]
Do not contact the advertiser for marketing purpose. Using someone's phone number and email address is considered fraud as per law and could result in punishment. We will block your access to the site, if we notice you misusing this tool.
* Indicates you must enter value in this field
Also Check Following Related Sections
  • Classifieds: Computer Related Services
  • Classifieds: Dance, Music, Arts and Culture Training
  • Yellow-Pages: Computer Training Schools
  • Yellow-Pages: Training Schools
  • Yellow-Pages: Trading
  • Discussion: Study
  • Articles: Education in Canada
  • Report Abuse



    Map locations are shown as per geocoding services and they depeneds on the accuracy of the address. If address is wrong it may show wrong map. If you put a listing which shows wrong map, please remove the listing and create a new one with correct address details.

    Please note: The information on this site is submitted by users. CanadianDesi never checks accuracy of the information. Please use this information at your risk. If you have any question or concern regarding this listing, or you know that the above information is not accurate, please Contact Us. Thanks. 
    List your Classified Ads. It is FREE!


     
    Web
    CanadianDesi
    Please Contribute!
    Write an Article
    Send Community News
    Create Photo and Video Albums
    Submit Good Pictures
    List Useful Websites
    Post Jobs
    Submit Events
    List for FREE!
    Businesses
    Classifieds
    Social Organizations
    Religious Places
    Employment Agencies
    Email Page
    Your Email
    Friend\'s Email

    Advertise Contact Us Privacy Policy and Terms of Usage FAQ
    Canadian Desi
    © 2001 Marg eSolutions


    Site designed, developed and maintained by Marg eSolutions Inc.