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 
Get Certified in SAP SuccessFactors!!! 
Projected start date of class Jul 12, 2020

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 towards getting SAP SuccessFactors Cer....
Date Posted: July 1 2020, 04:12


Mississauga 
QA Training !!!  
Software Testing Professional Training
Confirmed Start date of Batch Jul 12, 2020
2 Seats Remaining
Training Objectives
Intensive 65 hours of software testing training
Targeted towards ISTQB Certified (International Software Testing Quali....
Date Posted: July 1 2020, 03:52


Mississauga 
Get certified in SAP S/4 HANA Finance!!! 
Projected start date of a batch Jul 12, 2020. REGISTRATIONS OPEN NOW.
Companies need to integrate and upgrade to S/4 HANA resulting in huge demand for SAP finance professionals who can execute the successful and smooth transition from SAP R/3 to ....
Date Posted: July 1 2020, 03:47


Mississauga 
SAP S/4 HANA Sourcing and Procurement Certification Training 
Confirmed start date Jul 11, 2020


2 Seats Remaining

Training Objectives

60 hours of in-class training conducted on weekends
Focused towards getting SAP S/4 HANA Sourcing and Procurement Certified Application Associate
Certified i....
Date Posted: July 1 2020, 03:44


Mississauga 
CAPM/PMP Exam Prep Course (54 hours) - Virtual Interactive 
SIXTH DIMENSION LEARNING INC. is a PREMIER training institute (PMI approved Registered Education Provider #3601) offering multiple courses within the domain of Project Management. All our courses are PMI approved and qualify for PDUs.

Come and a....
Date Posted: June 19 2020, 18:33


Toronto 
IELTS prep course 
Hey everyone! PROMO GOING ON.

10 students will be getting the course for 50% off with Ak's Academy. Please refer me to anyone that you might think will need help.

Thanks in advance.

Book your spot NOW by emailing

I lo....
Date Posted: June 2 2020, 20:55


Toronto 
techSME Inc. offering Training and Job Placement Program
Who We are techSME Inc:
techSME is a North America's based IT Solutions Company. We provide top quality talent, we are dedicated to work closely with our clients and become an integral part of their growth, development and success. We operate pan ....
Date Posted: April 28 2020, 17:53


Available world 
PMP Certification 100% Guaranteed Pass Without Exam Test Tra
If you are looking to pass PMP - Project Management Professional certification exam over the internet, you have come to the right place. Certxpert.com offers fast and easy way to pass PMI PMP Certification with 100% guarantee.

Now you can pass PM....
Date Posted: April 3 2020, 12:10


Brampton 
ONLINE SAP HANA & SAP BW ON HANA TRAINING
Excellent experience in teaching in SAP HANA 2.0 & SAP BW 7.3/7.4/7.5 ( business wareshouse) ON HANA . It is online interactive teaching via webex meetings and In-person also ( avoid at present because of COVID19). You will be able to ....
Date Posted: March 26 2020, 22:49


Scarborough 
Tutoring available for Grades Kg-8 in Scarborough M1J2R4
Hi. I am Hema Jagesha. I am having 8+ years of Tutoring experience and very well versed in the Canadian curriculum. I teach Math & English and help students' with their homework. I offer personalized coaching to cater to student's needs. I offer 8 cl....
Date Posted: March 23 2020, 02:07



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.