It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
Where does Java come into the picture? You can learn SQL on its own if you have a database and an application that lets you interact with it. If you're able+willing to have a service or daemon running try PostgreSQL, which includes an excellent command line interface psql. If you aren't, look into SQLite. There are a wide variety of graphical query and database management tools, most of which connect to more than one flavor of SQL DBMS.
I can't tell you much as far as tutorials go, except that @helenanders26
has a series here.
Microsoft offers a tutorial and download of SQL Server Management Studio (SSMS) aimed at database administrators and developers who are familiar with database concepts and Transact-SQL Tutorials for SQL Server Management Studio
I am interviewing for a job where I will be writing java in connection with a SQL db. I just want to be sharper on those skills approaching the interview and possible job.
I am good with Java, but a bit overwhelmed in approaching the db.
It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
I'd concentrate on learning basic database concepts and honing your SQL then. When you need to use Java to talk to one you'll be able to, but it's better to keep things simple when you're trying to pick it up.
I think that's where my understanding was breaking down. In previous projects with DBs, I used Python and SQLAlchemy. The whole ORM concept makes DBs easy, but it makes it tough to get the fundamentals. So in my mind, SQL wasn't a language of it's own.
It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
Oh my seems like there is a problem with way people learn programming today: they jumped on framework without learning fundamentals and SQL is fundamental. Whatever programming languages you learn, if you don't know SQL, you risk to be discarded in many interviews right away.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Where does Java come into the picture? You can learn SQL on its own if you have a database and an application that lets you interact with it. If you're able+willing to have a service or daemon running try PostgreSQL, which includes an excellent command line interface
psql. If you aren't, look into SQLite. There are a wide variety of graphical query and database management tools, most of which connect to more than one flavor of SQL DBMS.I can't tell you much as far as tutorials go, except that @helenanders26 has a series here.
I'm not super familiar with Java but as far as SQL goes:
For practice in the browser, these two are great:
PostgreSQL Exercises
SQL Zoo
Microsoft offers a tutorial and download of SQL Server Management Studio (SSMS) aimed at database administrators and developers who are familiar with database concepts and Transact-SQL
Tutorials for SQL Server Management Studio
I am interviewing for a job where I will be writing java in connection with a SQL db. I just want to be sharper on those skills approaching the interview and possible job.
I am good with Java, but a bit overwhelmed in approaching the db.
I'd concentrate on learning basic database concepts and honing your SQL then. When you need to use Java to talk to one you'll be able to, but it's better to keep things simple when you're trying to pick it up.
I think that's where my understanding was breaking down. In previous projects with DBs, I used Python and SQLAlchemy. The whole ORM concept makes DBs easy, but it makes it tough to get the fundamentals. So in my mind, SQL wasn't a language of it's own.
Thanks for your help, I'm starting to get it!
When it's time to bring Java in, look at MyBatis. Object-relational mapping always winds up being more trouble than the initial convenience is worth.
Oh my seems like there is a problem with way people learn programming today: they jumped on framework without learning fundamentals and SQL is fundamental. Whatever programming languages you learn, if you don't know SQL, you risk to be discarded in many interviews right away.