Tips for getting started with SQL?

Question

I never needed programming with databases. Since their use is so common, it seems to me that this is good for me. SQL seems like a place to run, maybe SQLite and maybe Python binding . What would you recommend for someone new in this? Libraries, tools, and design ideas are welcome.

Answer 1

Structure Query Language (SQL) is the language used to communicate with database management systems (DBMS). Although it’s good to study, it’s best to do it taking into account the project you would like to do. It's funny that you say that you never had a need, because I'm the opposite, almost every program that I ever wrote used some kind of database. The vast majority (mainly websites) revolve around using a database.

• Learn about relationships and database architecture. This means how to structure your tables, create foreign keys and relationships.

  , . , , , . . . ( ..) Movie, , Movie Studio. " " ( ). , . , " ".

• SQL. SQLCourse - , . SQL , RDBMS (, , ..). , (, Oracle, MySQL), , .

• . MySQL - , . SQLite Postgresql , /open -source.

Answer 2

, -, , , . , (, 3- ), , .

, , , , . " " , CASE. . , , . SQL. , Joe Celko SQL Puzzles and Answers - , .

SQL. . , , 3- . , , , , - .

, , . , : " " " , ". . .

Answer 3

Wikipedia, http://www.w3schools.com/sql/default.asp http://www.sql-tutorial.net/ YouTube SQL.

Answer 4

, SQLite - , , . . SQLite SQL , , . , , SQLite - .

Answer 5

SQLite , , , SQL, MySQL, Postgres . SQLite API , , API- . Perl, DBI - SQL.

/Allan

Answer 6

" SQL" - " " -.

http://sqlzoo.net/

Answer 7

SQL - , SQL, , .

Celko .

.

.

Answer 8

- .

Answer 9

Jeo Clecko SQL .

Answer 10

: sql-ex.ru , .

Answer 11

Ideone -.

Answer 12

.NET, LINQ . LINQ "engine" ( , , XML ..) . , SQL, LINQ, .

Answer 13

- -, . webapp SQL .

Answer 14

Head First . , , . . (LINK)

Answer 15

MySQL, . Community Edition, GUI Tools .

Answer 16

, SQL. SQL- Apress ( ).

Answer 17

90% , SQL, . 1997 .

, .

Answer 18

, , SQLite, , Google " SQL ", -, , SQLite.

Google pdf "Cough Cough", http://www.sqlfiddle.com/

This is an online platform that is free! There is no need to register, just go to your page, create your database depending on which language you need (which is the best bit I choose T-SQL as I study it), and then you can query it as much as you want . I am studying a pdf file that has open source SQL files that you can download, and SQLFiddle has perfectly studied the specific SQL provider.