What are the typical daily tasks of SQL Server DBA?
Check SQL Server Instance Up-time
Check Last Full, Differential and Log Backup Times
Check Failed SQL Agent Jobs in the Last 24 Hours
Check Current Log for Failed Logins
Check for Blocked Processes
Check Top N Queries Based on Average CPU Time
Check Drive Volumes Space
Check Index Fragmentation
At SQL School Training Institute we provide SQL DBA Online Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities: Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management including Azure SQL DBA Activities like Azure Sync, Azure Server Failover, Azure Virtual Machines, and Azure DB Migrations.
Free Demo: Feb 25th, 6:15 AM IST
Detailed Course Curriculum of SQL DBA with Azure DBA @
Register today for SQL DBA with Azure DBA : https://sqlschool.com/Register.html
Tables : In Relational database model, a table is a collection of data elements organised in terms of rows and columns. A table is also considered as a convenient representation of relations. Table is the most simplest form of data storage. Below is an example of an Employee table.
Tuple or Record or Row : A single entry in a table is called a Tuple or Record or Row. A tuple in a table represents a set of related data. For example, the above Employee table has 4 tuples/records/rows.
Following is an example of single record or tuple.
Fields : A field is part of a record and contains a single piece of data for the subject of the record. In the employee table, each record contains four fields. ID, Name, Age, Salary are fields in the table.
Responsibilities: (In Brief)
Data analysis, cleansing & processing data using Advanced Excel and PL SQL
Identify, analyse, and interpret trends or patterns in complex data sets
Combine and collate information from multiple sources and present your findings to the broader group.
Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
Experience of Advance Excel, SQL, is a must.
Knowledge and experience on Google Analytics is a plus.
Strong problem solving ability, should be able to identify key areas of improvements by understanding business process and analyzing data.
Should have eagerness to learn new techniques and methodologies related to Analytics to come up with innovative solutions.
Develop dashboards to track the performance of various campaigns
Dashboard monitoring for day to day business and operational functionalities which enables identifying the risk areas for further mitigation
Update models / reports as and when required
Candidate must complete course on SQL and should have working experience on SQL (preferred)
Pls email your updated resume to firstname.lastname@example.org / 9885737360
You will receive a call if your profile is shortlisted.
Pls mention in subject of email referred by SQL School