Best SellerSQL DBALive Classes

KaaShiv's Training Program will provide you with in-depth knowledge in SQL DBA

5 of (8k+ satisfied learners)

Preview this Course

Most popular course on SQL DBA trusted by over 50,000 students! Built with years of experience by industry experts and gives you a complete package of video lectures, practice problems, quizzes. Start Today!

Available for 5 Days to

SignIn to Buy

Why should you take SQL DBA?

SQL DBA Internship excellent to learn

Get Job from Top Companies with this Internship

Average Salary
Rs.5,00,000 - 8,00,000 / Year

Course Content
5 Days
Topic Text Material Image content Video content Quiz
SQL Introduction -
MongoDB Introduction -
DataBase Design Principles -
MongoDB Features -
Phases of Database Design -
SQL RDBMS -
MongoDB Advantages -
SQL – RDBMS Database -
Table Design -
MongoDB Beginners -
Relationships -
SQL Data Types -
Clause in SQL -
MongoDB Environment Setup -
The Basis of Data Normalization -
The SQL server Database Architecture -
A Database Primer -
Database Basics -
Configuring SQL Server -
Configuration Parameters -
Advanced Configuration Parameters -
Asynchronous read - ahead configuration parameters -
Removing a Device -
10 Days
Topic Text Material Image content Video content Quiz
The transaction log file architecture -
SQL Server system data types -
Understanding DDL and DCL Statements in SQL Server -
Understanding the purpose of SQL Server system databases -
Modifying a database with T-SQL DDL statements -
Creating and managing tables -
Data Retrieval Using Transact-SQL Statements -
Using T-SQL functions in the query -
Understanding Different Types of Devices (What Is a Device?)- -
Creating a Database Device -
Creating a Backup (Dump) Device -
Viewing Device Information -
Expanding a Database Device -
Understanding the Default Device Pool -
Striping Data Across Disks -
Mirroring a Device -
Unmirroring and Remirroring Devices -
Device Mirroring Strategies -
Database Device Creation Considerations and Strategies -
SQL Clauses part-2 -
SQL Operators -
Operators in SQL – Alias, IN and Between -
SQL Expressions -
SQL Create Database -
Why MongoDB -
MongoDB Data Modeling -
How MongoDB Create Database -
How MongoDB Drop Database with DropDatabase() Method -
MongoDB Create Collection -
15 Days
Topic Text Material Image content Video content Quiz
Multiple table queries using UNION, EXCEPT, INTERSECT, and JOINs -
Subqueries -
Organizing and grouping data -
Updating data in SQL Server database tables -
Deleting data from SQL Server database tables -
Using the MERGE statement -
The TRUNCATE TABLE statement -
The SELECT INTO statement -
Understanding Advanced Database Programming Objects and Error Handling -
Creating and using variables -
Control-of-flow keywords -
Beyond the basics -
SQL DBA - Segments -
Database - Removable Media -
Distinct Keywords -
Easy Way To Understand -
SQL Join -
SQL Constraint -
SQL Wildcard Characters -
MongoDB Capped Collection -
MongoDB Projection -
Operations for MongoDB Document -
MongoDB Update Document -
MongoDB Delete Document -
20 Days
Topic Text Material Image content Video content Quiz
What Is a Database Backup (Dump)? -
What Is a Transaction Log Backup (Dump)? -
What Is a Table Backup (Dump)? -
Performing Database, Transaction Log, and Table Backups -
Understanding DUMP TRANSACTION Options -
NULL Values In SQL UNION Clause -
SQL Server Transaction -
SQL Index -
What is SQL Injection -
Alter Command In SQL -
MongoDB Limit Records -
MongoDB Data Types -
MongoDB Index -
MongoDB Text Search  -
MongoDB Mapreduce -
1 Month
Topic Text Material Image content Video content Quiz
WHILE, BREAK, and CONTINUE statements -
Creating, altering, and dropping views with Transact-SQL DDL statements -
Creating and using stored procedures -
Creating a stored procedure -
Modifying user-defined functions -
Creating and using triggers -
Recursive triggers -
Dropping a DML trigger -
Handling Transact-SQL errors -
Performance Basics -
Query execution and plan caching -
The SQL Server 2014 in-memory OLTP engine -
Indexes -
Composite indexes -
Performing Striped Backups -
Scheduling Backups -
Dumping a SQL Server 6.5 Database into a SQL Server 6.0 Format -
Understanding Database Options and the Transaction Log -
Using Database Dumps and Transaction Log Dumps to Recover a Database -
Understanding When to Dump a Database and Transaction Log -
SQL Like Clause -
Learn SQL Auto Increment -
Check Constraint in SQL -
SQL Null Functions -
Create SQL Sequence  -
Install Rockmongo in MongoDB -
MongoDB GridFS with Example -
MongoDB Aggregation -
MongoDB Replication -
MongoDB Regular Expression -
2 Months / 6 Weeks
Topic Text Material Image content Video content Quiz
SQL DBA - BCP -
Interactive BCP -
Sample BCP Scripts -
Modes of Operation -
BCP and Enforcement of Triggers, Rules, Defaults, Constraints, and Unique Indexes -
Common BCP Traps -
BCP Tips -
Alternatives to BCP -
SQL Subquery -
SQL Query Optimization Tools -
How to Find Duplicate Records in SQL  -
Primary and Foreign Key in SQL  -
SQL Create Table -
SQL Date Functions -
COUNT Function in SQL -
Generate MongoDB -
MongoDB Covered Query -
MongoDB Backup and Restore -
MongoDB Objectid -
MongoDB Relationships -
3 Months
Topic Text Material Image content Video content Quiz
Task Scheduler -
Alert Manager -
Database Maintenance Wizard -
Why SQL Server Uses a Query Optimizer -
Update Statistics -
Basic Query Optimization Suggestions -
Tools to Help Optimize a Query -
Overriding the Optimizer -
Other Tuning Tricks -
Reading the Showplan -
SUM Function in SQL -
Comments and Stored Procedure in SQL -
Cursor in SQL -
Dynamic SQL Tutorial -
Learn SQL Database Tuning -
SQL Comment -
View more

Overview

sql-dba-intership

SQL DBA Description

SQL DBA Certification

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

Internship Certificate

SQL DBA Projects

Testimonial Reviews

M
Mirnalini Babu

Attended 5 days internship for IOT and he made us to understand the basics of the course . Venkat S
A
A Anand

I will join the FULL STAKE DEVELOPMENT AND DOTNET Class is Awesome ? ?
S
Surya Maharajan

Good person to see for Kaashiv infotech and very good to usefull myself and ur self also.

Video Reviews

Madhusan

Madhusan shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.

Ram Prithiv Raju

Ram Prithiv Raju shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.

Vignesh

Vignesh shares her KaaShiv learning experience helped her gain an edge in job interviews and land a job.


SQL DBA Online Features

24 x 7 Expert Support

We have a lifetime 24x7 online support team to resolve all your technical queries, through a ticket based tracking system.

Certification

Successfully complete your final course project and Kaashiv will certify you as a SQL DBA Expert.

Forum

We have a community forum for all our learners that further facilitates learning through peer interaction and knowledge

SQL DBA FAQs