Database Querying with SQL
$2-8 USD / 時間
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
プロジェクトID: #6426741
プロジェクトについて
43 人のフリーランサーが、平均$7/時間で、この仕事に入札しています。
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 もっと
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 もっと
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...
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 もっと
Hello sir, please feel free to contact me on private message so we could discuss. Looking forward for Your reply. Thank You.
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 もっと
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. もっと
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.
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.
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 もっと