About DBA

SQL,Microsoft SQL Server

A database administrator (DBA) is the information technician responsible for directing or performing all activities related to maintaining a successful database environment. A DBA makes sure an organization's database and its related applications operate functionally and efficiently.

If your organization uses a database management system (DBMS) for mission-critical workloads, it is important to employ one or more database administrators to ensure that applications have ongoing, uninterrupted access to data. Most modern organizations of every size use at least one DBMS, and therefore the need for database administrators is greater today than ever before.

The DBA is responsible for understanding and managing the overall database environment. By developing and implementing a strategic blueprint to follow when deploying databases within their organization, DBAs are instrumental to the ongoing efficacy of modern applications that rely on databases for data storage and access.

A DBA can, and does, assume many different roles and responsibilities within the IT department involving database systems and applications. When adopting a new DBMS, the DBA is responsible for designing, implementing, and maintaining the database system. Often, this includes installing the DBMS and setting up the IT infrastructure to allow applications to access databases.

Course Module

+ Module 1 : Introduction
  • Introductio
  • Basic of SQL
+ Module 2 : SQL Server
  • Install SQL Server
  • Connecting to SQL Server using SSMS
  • Creating altering and dropping a database
  • Creating and working with tables
+ Module 3 : constraint
  • Adding a default constraint
  • Cascading referential integrity constraint
  • Adding a check constraint
  • Identity Column in SQL Server
  • How to get the last generated identity column value in SQL Serve
  • Unique key constraint
+ Module 4 : Operation
  • Select statement in sql server
  • Group by in sql server
  • Joins in sql server
  • Advanced or intelligent joins in sql server
  • Self join in sql server
  • Different ways to replace NULL in sql server
  • Coalesce function in sql server
  • Union and union all in sql server
  • Stored procedures in sql server
  • Stored procedures with output parameters
+ Module 5 : functions
  • Stored procedure output parameters or return values
  • Advantages of stored procedures
  • Built in string functions in sql server
  • LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server
  • Replicate, Space, Patindex, Replace and Stuff string functions in sql server
  • DateTime functions in SQL Server
  • IsDate, Day, Month, Year and DateName DateTime functions in SQL Server
  • DatePart, DateAdd and DateDiff functions in SQL Server
  • Cast and Convert functions in SQL Server
  • Mathematical functions in sql server
  • Scalar user defined functions in sql server
  • Inline table valued functions in sql server
+ Module 6: trigger
  • Multi statement table valued functions in sql server
  • Important concepts related to functions in sql server
  • Temporary tables in SQL Server
  • Indexes in sql server
  • Clustered and nonclustered indexes in sql server
  • Unique and Non Unique Indexes in sql server
  • Advantages and disadvantages of indexes in sql server
  • Views in sql server
  • Updatable views in sql server
  • Indexed views in sql server
  • View limitations in sql server
  • DML triggers in sql server
  • After update trigger
  • Instead of insert trigger
  • Instead of update triggers in sql server
  • Instead of delete triggers in sql server
  • Transactions in sql server
+ Module 7: Cursors
  • Transactions in sql server and ACID Tests
  • Subqueries in sql
  • Correlated subquery in sql
  • Creating a large table with random data for performance testing
  • What to choose for performance SubQuery or Joins
  • Cursors in sql server
  • Replacing cursors using joins in sql server
  • List all tables in a sql server database using a query
  • Writing re runnable sql server scripts
  • Alter database table columns without dropping table
  • Optional parameters in sql server stored procedures
  • Merge in SQL Server
  • sql server concurrent transactions
  • sql server dirty read
  • sql server lost update problem
  • Non repeatable read example in sql server
+ Module 8: Isolation level
  • Phantom reads example in sql server
  • Snapshot isolation level in sql server
  • Read committed snapshot isolation level in sql serve
  • Difference between snapshot isolation and read committed snapshot
  • SQL Server deadlock
  • SQL Server deadlock victim selection
  • Logging deadlocks in sql server.
  • SQL Server deadlock analysis and prevention
  • Capturing deadlocks in sql profiler
  • SQL Server deadlock error handling
  • Handling deadlocks in ado net
  • Retry logic for deadlock exceptions
  • How to find blocking queries in sql server
  • SQL Server except operator
  • Difference between except and not in sql server
  • Intersect operator in sql server
  • Difference between union intersect and except in sql server
  • Cross apply and outer apply in sql server
+ Module 9: DDL
  • DDL Triggers in sql server
  • Server scoped ddl triggers
  • sql server trigger execution order
  • Audit table changes in sql server
  • Logon Triggers in SQL Server
  • Select into in sql server
  • Difference between where and having in sql server
  • Table valued parameters in SQL Server
  • Send datatable as parameter to stored procedure
  • Grouping Sets in SQL Server
  • Rollup in SQL Server
  • Cube in SQL Server
  • Difference between cube and rollup in SQL Server
  • Grouping function in SQL Server
  • GROUPING ID function in SQL Server
  • Debugging sql server stored procedures
  • Over clause in SQL Server
  • Row Number function in SQL Server
  • Rank and Dense Rank in SQL Server
+ Module 10: Rank dense rank and row number
  • Difference between rank dense rank and row number in SQL
  • Calculate running total in SQL Server
  • NTILE function in SQL Server
  • Lead and Lag functions in SQL Server
  • FIRST VALUE function in SQL Server
  • Window functions in SQL Server
  • Difference between rows and range
  • LAST VALUE function in SQL Server
  • UNPIVOT in SQL Server
  • Reverse PIVOT table in SQL Server
  • Choose function in SQL Server
  • IIF function in SQL Server
  • TRY PARSE function in SQL Server
  • TRY CONVERT function in SQL Server
  • EOMONTH function in SQL Server
  • DATEFROMPARTS function in SQL Server
  • Difference between DateTime and SmallDateTime in SQL Server
  • DateTime2FromParts function in SQL Server
  • Difference between DateTime and DateTime2 in SQL Server
+ Module 11: Offset fetch
  • Offset fetch next in SQL Server
  • Identifying object dependencies in SQL Server.
  • sys dm sql referencing entities in SQL Server
  • sp depends in SQL Server
  • Sequence object in SQL Server
  • Difference between sequence and identity in SQL Server
  • Guid in SQL Server
  • How to check GUID is null or empty in SQL Server
  • Dynamic SQL in SQL Server
  • Implement search web page using ASP NET and Stored Procedure
  • Implement search web page using ASP NET and Dynamic SQL
  • Prevent sql injection with dynamic sql
  • Sql server query plan cache
  • exec vs sp executesql in sql server
  • Dynamic sql table name variable
  • Quotename function in SQL Server
  • Dynamic SQL vs Stored Procedure
  • Dynamic sql output parameter
  • Temp tables in dynamic sql

DBA(Data Base Administrator Course Objective

We can Handle a multiple types of DataBase

  • SQL.
  • Microsoft SQL Server.
  • Oracle.
  • PostgreSQL.
  • ............more.

Live Class On

LMS

Learning Management System(LMS) on Web
Learning Management System(LMS) on Web

Recorded Class session


15

no of projects

45

Total Class

45

No. of Videos

12000

Total Students

Contact Us for More Information

Name
Email
Phone No.

To Know more about this course

Call Us Now

+91 9555378418