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 |
|
|
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
|
|
|
|