New pages
Jump to navigation
Jump to search
- 23:06, 24 May 2024 Person Company City (hist | edit) [1,150 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Querying Multiple Tables =Overview= <syntaxhighlight lang='sql'> </syntaxhighlight>")
- 22:49, 24 May 2024 SQL ARRAY (hist | edit) [1,222 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL Data Types =Overview=")
- 22:27, 23 May 2024 SQL Set Operations (hist | edit) [167 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =TODO= <font color=darkkhaki>PROCESS: https://learning.oreilly.com/library/view/learning-sql-3rd/9781492057604/ch06.html</font>")
- 17:03, 23 May 2024 SQL CREATE ALTER DROP VIEW (hist | edit) [604 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL Data Types =Overview= =<tt>CREATE</tt>= <syntaxhighlight lang='sql'> CREATE TABLE person ( id smallint, name varchar(30) NOT NULL, CONSTRAINT pk_person PRIMARY KEY (id) ); </syntaxhighlight> :{| class="wikitable" style="text-align: left;" |- | PostgreSQL || MySQL |- |} =<tt>ALTER</tt>= <syntaxhighlight lang='sql'> ALT...")
- 00:13, 23 May 2024 SQL AUTO INCREMENT (hist | edit) [136 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * <tt>CREATE</tt> | <tt>ALTER</tt> | <tt>DROP</tt> | <tt>TABLE</tt> =Overview=")
- 23:52, 22 May 2024 SQL Constraints (hist | edit) [1,323 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= =Primary Key Constraint= <syntaxhighlight lang='sql'> CREATE TABLE ... ( ... CONSTRAINT pk_someconstraint PRIMARY KEY (somecolumn) ); </syntaxhighlight>")
- 23:14, 22 May 2024 SQL GROUP BY (hist | edit) [242 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= =Overview= <font color=darkkhaki>Make sure I understand thoroughly and link.</font>")
- 23:05, 22 May 2024 SQL Indexes (hist | edit) [175 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview=")
- 23:00, 22 May 2024 SQL Database Metadata (hist | edit) [436 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= A database server stores information about all the database objects (tables, views, indexes, etc.) that were created with the SQL schema statements.")
- 22:40, 22 May 2024 SQL WHERE (hist | edit) [5,076 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL <tt>UPDATE</tt> * SQL <tt>DELETE</tt> * SQL <tt>SELECT</tt>")
- 22:39, 22 May 2024 SQL DELETE (hist | edit) [457 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:39, 22 May 2024 SQL UPDATE (hist | edit) [503 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:38, 22 May 2024 SQL INSERT (hist | edit) [521 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * {{SQL#INSERT|SQL}} * {{SQL_WHERE#Overview|SQL <tt>WHERE</tt>}}")
- 22:23, 22 May 2024 SQL Data Types (hist | edit) [3,043 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= <font color=darkkhaki> * SQL data types * Database-specific data types * Working with different data types * Conversion functions </font>")
- 22:14, 22 May 2024 SQL CREATE ALTER DROP TABLE (hist | edit) [3,189 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * _ALTER_|_DROP_TABLE|SQL")
- 22:10, 22 May 2024 SQL Transaction Statements (hist | edit) [194 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview=")
- 21:10, 22 May 2024 SQL Querying Multiple Tables (hist | edit) [16,801 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Querying Multiple Tables =Overview= Querying Multiple Tables, Joining Tables Define join. Join condition Foreign key")
- 21:02, 22 May 2024 SQL SELECT (hist | edit) [7,813 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= Query execution. SQL optimizer. Subqueries.")
- 21:30, 21 May 2024 Masterminds/squirrel (hist | edit) [353 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://github.com/Masterminds/squirrel * https://medium.com/nerd-for-tech/postgres-libraries-to-try-with-go-8f80191edbff =Overview= <font color=darkkhaki>Intro how to use it: https://medium.com/nerd-for-tech/postgres-libraries-to-try-with-go-8f80191edbff</font>")
- 21:16, 21 May 2024 Jackc/pgx (hist | edit) [2,403 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.youtube.com/watch?v=sXMSWhcHCf8 =Internal= * PostgreSQL Support in Go")