Uncategorized

What are the typical daily tasks of SQL Server DBA?

What are the typical daily tasks of SQL Server DBA?

  1. Check SQL Server Instance Up-time
  2. Check Last Full, Differential and Log Backup Times
  3. Check Failed SQL Agent Jobs in the Last 24 Hours
  4. Check Current Log for Failed Logins
  5. Check for Blocked Processes
  6. Check Top N Queries Based on Average CPU Time
  7. Check Drive Volumes Space
  8. Check Index Fragmentation
  9. Patch Management

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 @
https://sqlschool.com/SQLDBA-Online-Training.html

Register today for SQL DBA with Azure DBA : https://sqlschool.com/Register.html

Reach us:
contact@sqlschool.com
India: +91 (0)9666440801

USA: +1(510) 400-4845

 

 

 

 

 

 

 

 

 

 

#SQL #SQLDBA #Admin #Database #SQLServer #Microsoft #FreeDemo #RegisterToday

What is a subquery in SQL?

SubQuery is a query within another query. The outer query is called as main query and inner query is called as SubQuery.

The SubQuery generally executes first, and its output is used to complete the query condition for the main or outer query. Subquery must be enclosed in parentheses.

Subqueries are on the right side of the comparison operator. You can place the Subquery in a number of SQL clausesWHERE clauseHAVING clauseFROM clause.

Subqueries can be used with SELECTUPDATEINSERTDELETE statements along with expression operator. It could be equality operator or comparison operator such as =, >, =, <= and Like operator.

ORDER BY command cannot be used in a SubQueryGROUPBY command can be used to perform same function as ORDER BY command.

A Sample Syntax Example for SubQuery:

SELECT column_name

FROM table_name

WHERE column_name expression operator

( SELECT COLUMN_NAME from TABLE_NAME WHERE … );

SQL Server Online Training

What do you mean by Table and Field in SQL?

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.

Opening for Data Analyst Position – PL SQL Experience Mandatory

Company Name: Promocio

Work Location: Begumpet

Designation: Data Analyst

Mandatory Skills Needed: PL SQL & Advanced Excel

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

Experience: 1+yrs

Candidate must complete course on SQL and should have working experience on SQL (preferred)

Pls email your updated resume to pavan@promocio.co / 9885737360

You will receive a call if your profile is shortlisted.

Pls mention in subject of email referred by SQL School

VS Shell installation has failed with exit code 1638.

The following error has occurred:
VS Shell installation has failed with exit code 1638.

Error while installing SQL Server 2017.

Solution : Install Microsoft Visual C++ 2017 Redistributable  available at: https://go.microsoft.com/fwlink/?LinkId=746572

For any further errors please mail to contact@sqlschool.com

SQL School Training Team

+91 9666440801 (INDIA),  + 1 510.400.4845 (USA)

www.sqlschool.com