What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard - BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

Using SQL in Your Web Site

To build a web site that shows data from a database, you will need:

An RDBMS database program (i.e. MS Access, SQL Server, MySQL)

To use a server-side scripting language, like PHP or ASP

To use SQL to get the data you want

To use HTML / CSS to style the page Read more about Database

Database defined

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database.

Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.

About the job

TCS is hiring for Postgres DBA

Role: PostgreSQL 11, 14 Database administrator

Required Technical Skill Set: MS-SQL 2019, MS-SQL 2016, MS-SQL 2014, MS-SQL 2012, Oracle 19C, 12C Tools (SSMS, SPLUNK, ServiceNow)

Desired Experience Range: 7- 10yrs

Location of Requirement: Chennai

Desired Competencies:

Must-Have:

• 4-5 years’ experience in Oracle 19C, 12C Database or MS-SQL 2011, 2019 database

Good-to-Have:

• HA/DR Setup including logical, physical standby 

Apply here

About the job   

Want to build a stronger, more sustainable future and cultivate your career? Join Cargill's global team of 155,000 employees who are committed to safe, responsible and sustainable ways to nourish the world. This position is in Cargill’s food ingredients and bio-industrial business, where we anticipate trends around taste, nutrition and safety to innovate and provide solutions to manufacturers, retailers and foodservice companies.

Job Purpose and Impact

The Data Analyst - Price hub is responsible for delivering robust data support along with analytic inputs in business requirements and data management activities to support different business units within Cargill. In this role, you will contribute to the continuous process improvement on price data management, standardization and harmonization and you will be actively involved in developing and implementing action plans on business performance optimization.

Key Accountabilities
 

• Deploy a basic understanding of the trading questions that data can help to solve.
• Mapping upstream data source fields to Price Hub attributes; along with formulating transformation rules for new/derived columns in mapping
• Work with data engineers to give them the requirement for them to create the data output flow.
• Test the output data within Price Hub to validate if it is as per the said rules and check for anomalies and relay them back to data engineers for corrections.
• Create documentation for the newly mapped data source for consumers for easy understanding and create adhoc SQL queries for consumers based on their requirements.
• Handle basic issues and problems under direct supervision, while escalating more complex issues to appropriate staff.
• Other duties as assigned
   

Qualifications

Minimum Qualifications
 

• Bachelor's degree in a related field or equivalent experience
• Minimum of two years of experience in a related field
• Experience in MS office suite (Outlook, Excel, Word, Power Point) and entry level SQL
   

Preferred Qualifications
 

• Experience in managing and planning pricing metadata such as data mining and analysis of price types such as exchange futures prices, options, cash, bids and offer price etc.
• Ability to make case across and help people learn the basic of data connection to web-based portal to power excel via Oracle Database Connectivity (ODBC)   APPLY HERE  

About the job

Paisabazaar is Hiring Data Analyst.

Experience - 0 to 3 years

Location - Gurgaon

Roles and Responsibilities:

? Analyze raw data: data cleaning, structuring and transforming for downstream

processing.

? Develop and implement proprietary machine learning algorithms and techniques

? Work with datasets of varying degrees of size and complexity, including both structured

and unstructured data.

? Work with the business to understand the key problem areas and develop analytics

driven solutions

? Create dashboards/automated reports that present actionable insights for stakeholders

? Collaboration with the engineering team to bring analytical prototypes to production

Desired Skills:

? Python ( Pandas & NumPy )

? Machine Learning

? Predictive Modeling Skills

? Statistical Algorithms

Skills to be evaluated:

? Structured Thinking

? Analytical and Problem Solving

? Programming language technical test (R/Python),

? Advanced level knowledge of ML techniques

Interested candidates can fill the form - https://forms.gle/fRS3D2YMNoRYMmwZ6