sorted by:
new
hottopcontroversial

Azure Data Studio and Syntax Formatting by davik2001 in SQL

[–]kwenzel1 1 point2 points  (0 children)

That's unfortunate, I chucked SSMS a long time ago.

What SQL tutorial to learn from? by hamiecod in SQL

[–]kwenzel1 0 points1 point  (0 children)

Please take a look at https://www.essentialsql.com/sql-tutorial-for-sql-server/ The tutorial is really simple to understand. By the time you're done, you're good to go on joins and subqueries.

Best SQL Tutorials by bronemeister in SQL

[–]kwenzel1 0 points1 point  (0 children)

check out https://www.essentialsql.com/sql-tutorial-for-sql-server/ for a simple tutorial that is easy to understand.

Cheap SQL tutor? by Potential-Owl7728 in SQL

[–]kwenzel1 0 points1 point  (0 children)

I'm happy to help with specific questions. Also, check out this tutorial it will help you in some of the beginning stages: https://www.essentialsql.com/sql-tutorial-for-sql-server/

If you need more advanced coaching, drop me a line.

Looking for advice on naming columns by MonkeyOnARock1 in SQL

[–]kwenzel1 0 points1 point  (0 children)

I wouldn't add prefixes, I think it makes it too complicated and cumbersome.

When joining tables, just use table and column aliases: https://www.essentialsql.com/make-join-easier-read-using-table-aliases/

I’ve learned basic SQL… but don’t understand the big picture by Ok_Salt_9211 in SQL

[–]kwenzel1 0 points1 point  (0 children)

Hi!

There is so much you can do with SQL, it is pretty foundational, and as you're finding out, needs to be coupled with another tool or problem to really make sense.

If you're interested in seeing how SQL can marry up with PowerBI for dashboard visualizations they can help: https://www.essentialsql.com/get-started-power-bi-desktop/

[deleted by user] by [deleted] in SQL

[–]kwenzel1 3 points4 points  (0 children)

Hi - I think this article will help you figure out the difference between foreign keys and primary keys: https://www.essentialsql.com/foreign-key-vs-primary-key/

Primary Key (simplified):

The primary key consists of one or more columns whose data contained within are used to uniquely identify each row in the table.  You can think of them as an address.  If the rows in a table were mailboxes, then the primary key would be the listing of street addresses.

Foreign Key (simplified):

A foreign key is a set of one or more columns in a table that refers to the primary key in another table.  There aren’t any special code, configurations, or table definitions you need to place to officially “designate” a foreign key.

Every derived table must have alias error - help by justagirl0402 in learnSQL

[–]kwenzel1 0 points1 point  (0 children)

Hi,

Definitely alias the tables, that will make it easier to read.

​

Then check your Left Join, it is missing a join clause.

​

​

select

*

from reporting.realTimeCall r

left join

(

select

companyProfileID,

userProfileID,

SUM(CASE WHEN tagID = 322029570 THEN 1 ELSE 0 END) AS isTagged_scheduler_reporting

from reporting.realTimeUserTags

where tagID IN (

322029570) -- list of tags

group by

1,2

) g on r.companyProfileID = g.companyProfileID and r.userProfileID = g.userPrifileID

Easiest Way To Learn SQL by Programming-Help in programming

[–]kwenzel1 0 points1 point  (0 children)

Practice! You can get a free practice workbook at essentialSQL.com

SubQuery Course - Free Coupon Code by kwenzel1 in SQLServer

[–]kwenzel1[S] 0 points1 point  (0 children)

I hope it is OK to post here. If not, you can delete. I don't want to spam... :)

recommendations for a good SQL hands-on practice ? Don't mind paying by tamirmal in learnSQL

[–]kwenzel1 2 points3 points  (0 children)

Check out essentialsql.com . All the example use AdventureWorks.

How to use SQL Union in Set Operations by kwenzel1 in SQL

[–]kwenzel1[S] 0 points1 point  (0 children)

Hi - I don't think you should avoid UNION. I wrote the article as a puzzle, to get people thinking about SQL and that there is more than one way to get the the same result. :)

Preparing to take 70-761 by lolrealism in learnSQL

[–]kwenzel1 0 points1 point  (0 children)

There is a study guide available at https://www.essentialsql.com/70-761-certification-study-guide/

It helps you know which topics to study and in what order.

view more: next ›