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
SQL School Training Institute is one of the world’s leading training providers. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals.
We provide Online Training, Classroom Training and Video Training in disciplines such as SQL Server, SQL DBA, MSBI, Azure SQL, Power BI, Oracle PL-SQL, Oracle DBA, GoldenGate, RAC DBA, Python and Data Science among others, where technologies and best practices are changing rapidly and demand for qualified candidates significantly exceeds supply.