Database Querying with SQL

終了済み 投稿 Sep 8, 2014 着払い
終了済み

I need someone who is good with below. i have basic knowledge of sql but want to upgrade it as well while working with the successful bidder.

Retrieving Data with SQL:

Introducing Queries: The SELECT Statement

The Clauses of the SELECT Statement

About Optional Clauses and Mandatory Clauses

Using FROM to Specify the Source Table(s)

Retrieving Entire Tables

Retrieving Specific Columns

The Importance of Clause Order

How to Build Successful Queries

Types of Output: About the Result Set

Using Column Aliases to Rename Columns

Performing Calculations

Using Numeric and String Operators to Create Derived Output

Ways of Limiting the Output

Using ORDER BY to Sort the Output

Ways of Working: Some Tips

Using WHERE to Filter Results

Working with Comparison Operators (=, >= etc)

Numeric and String Based Filtering

Filtering Based on Calculations

Eliminating Duplicate Results with DISTINCT

The Execution Order and its Traps

Column Aliases: Where You Can and Cannot Use Them

Extending Filters with AND and OR

Solving AND/OR Difficulties with Brackets

Excluding Results with NOT: Some Tips

Range Filtering using BETWEEN and IN

NULL and its Implications Explained

Catering for NULL

Matching Patterns with LIKE

Learning to Join

Qualifying Column Names

Joins Explained

The Different Types of Joins

Mastering the Inner Join: WHERE Syntax

Mastering the Inner Join: INNER JOIN Syntax

Table Aliases: Why We Need Them

Joining Two Tables

Joining Multiple tables

How to Simplify Joins: An Approach

Getting Confident with SQL Joins

The Importance of the Database Diagram

What if there is No Database Diagram?

Primary Keys and Foreign Keys Explained

Locating Primary Keys and Foreign Keys

Do we Need Primary Keys and Foreign Keys?

Approaching Joins the Right Way

Avoiding Common Join Errors

Using Standard SQL Functions

How to Use Standard SQL Functions to Modify Results

How to Find the Right Function

Mathematical, String and Conversion Functions

Functions for Modifying and Calculating Dates

Formatting Numbers to Two Decimal Places

Replacing NULL with a Specific Value

Using Standard Functions in WHERE

Using CASE to Specify Output Conditions

Working with Dates

Understanding How Dates are Stored

Introducing Date Functions

Converting Text Dates To Date Format

Establishing Today's Date

Extracting Parts of a Date (Day, Month, Year)

Displaying Dates in Specific Date Formats

Filtering with Dates

Grouping and Summarizing Results

The difference Between Tabular and Scalar Results

Using Aggregate Functions (MAX(), SUM(), AVG(), COUNT() etc)

The Way Aggregate Functions Work

Where to Use and Where Not to Use Aggregate Functions

Using GROUP BY to Group Results

Get GROUP BY Right Every Time!

The Need for HAVING: Filtering the Result Table

SQL

プロジェクトID: #6426741

プロジェクトについて

43個の提案 リモートプロジェクト アクティブ Oct 15, 2014

43 人のフリーランサーが、平均$7/時間で、この仕事に入札しています。

sumon355

Hello, I am very much interested to do this work as i am experienced a lot in writing complex SQL queries. I read your requirements & understand. I think i am the right person for this job. Looking forward to have a p もっと

$11 USD / 時間
(217件のレビュー)
7.5
codetod

Hi SQL expert here, with 12+ years of programming experience. The clauses and functions you have mentioned here are always used in my SQL programming tasks. I am eperienced in writing and optimizing SQL queries, sto もっと

$11 USD / 時間
(75件のレビュー)
6.4
mpalgeo

HI I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I’am working at the MIS department of a large bank as a DBA and SQL Developer. The DataBase which a hav もっと

$12 USD / 時間
(40件のレビュー)
5.8
acronymsolutions

Hi, I have gone through your requirements ,I am a DBA at CMMI-5 Level company since August 2008.I am working on MySql,MSSQL Server, SQL,Oracle database, I can do your job confidently. I am very much Interested to do yo もっと

$10 USD / 時間
(24件のレビュー)
5.2
BhargavaB

Hi this is bhargava expert in sql and pl/sql. i am ready to explain you complete sql with advanced functions . i will cover all the topics mentioned by you .also i will explain you how to improve the performance of the もっと

$6 USD / 時間
(16件のレビュー)
3.7
avinashjain09

Hello, I have knowledge about all the given points given in your requirement and I can explain you all the points with simple examples. I have expertise in database and my many projects are of database only. I am also もっと

$8 USD / 時間
(レビュー1件)
3.0
bilal978

Hello, I have been working with all kinds of databases for over four years. I am also conducting DBMS labs at a university here in Pakistan. My students are satisfied with my methodology. It will be a fun experience もっと

$16 USD / 時間
(3件のレビュー)
2.4
developerroger

I could do that for free I you want,,, I need a good reputation for the first job. So I could do for free and if you like the job make a good recommendation...

$5 USD / 時間
(3件のレビュー)
1.3
blairhacche

I am an experience SQL specialist. I have worked for many years writing and optimizing SQL queries and stored procedures for large companies. I don't have a great reputation in this site yet as I had one job where the もっと

$7 USD / 時間
(レビュー1件)
1.0
j0sephin3

Hello sir, please feel free to contact me on private message so we could discuss. Looking forward for Your reply. Thank You.

$13 USD / 時間
(0件のレビュー)
0.0
rameshdhanakkodi

We are South India Based company having 14 years of experience in software and web development. we are also engaged with research activities in cloud and data mining. we are sure that we can give you a good and effec もっと

$11 USD / 時間
(0件のレビュー)
0.0
karlosudp

La propuesta todavía no ha sido proveída

$5 USD / 時間
(0件のレビュー)
0.0
pratham21289

I have 3+ years technical experience on Oracle SQL. I also have experience writing PL/SQL stored procedures. In our project, I have been querying o DB for information required a organization level to generate reports. もっと

$4 USD / 時間
(0件のレビュー)
0.0
annamalaic

I have very good experience in Oracle Technologies for more than 7 years. I can take up this task. I can complete it on time.

$11 USD / 時間
(0件のレビュー)
0.0
Gopinadh2004

A proposal has not yet been provided

$8 USD / 時間
(0件のレビュー)
0.0
sonudineshvarma

I'v been working in SQL Server From past 4 Years and as an SQL Developer in MSBI from past 3 Years. And as I also love teaching.

$5 USD / 時間
(0件のレビュー)
0.0
mukeshsharma1988

A proposal has not yet been provided

$6 USD / 時間
(0件のレビュー)
0.0
alkasrivastava

I have worked in many projects which requires developing sql and pl/sql code. I have written complex sql and pl/sql code. I have mentor the team mates, to write this code. I have also reviewed their code, to deliver a もっと

$7 USD / 時間
(0件のレビュー)
0.0
ambrish2

A proposal has not yet been provided

$11 USD / 時間
(0件のレビュー)
0.0
punyamani

A proposal has not yet been provided

$5 USD / 時間
(0件のレビュー)
0.0