New pages
Jump to navigation
Jump to search
- 21:08, 30 May 2024 SQL Conditional Logic (hist | edit) [4,693 bytes] Ovidiu (talk | contribs) (Created page with "=Interna= * <tt>SQL WHERE</tt> =Overview= SQL conditional logic is the ability of SQL statements to take one of several paths during execution, depending on the value of an expression. The SQL has syntax that provides IF/ELSE conditional logic, except that it uses the <code>CASE</code> keyword instead of <code>IF</code>. The <code>CASE</code> expressions can be used in conditional <code>SELECT</code>, <code>SQL_INSERT#Conditional_I...")
- 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,252 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) [4,771 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) [563 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:39, 22 May 2024 SQL UPDATE (hist | edit) [931 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:38, 22 May 2024 SQL INSERT (hist | edit) [639 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,205 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,833 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,913 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= Query execution. SQL optimizer. Subqueries.")
- 21:30, 21 May 2024 Masterminds/squirrel (hist | edit) [2,670 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,044 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.youtube.com/watch?v=sXMSWhcHCf8 =Internal= * PostgreSQL Support in Go")
- 16:25, 21 May 2024 NumPy Fancy Array Indexing (hist | edit) [1,046 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy <tt>ndarray</tt>")
- 16:25, 21 May 2024 NumPy Boolean Array Indexing (hist | edit) [2,999 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy <tt>ndarray</tt>")
- 19:53, 20 May 2024 NumPy Universal Functions (hist | edit) [135 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy Concepts * <tt>ndarray</tt> =Overview=")
- 19:51, 20 May 2024 NumPy Pseudorandom Number Generation (hist | edit) [1,139 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy Concepts =Overview=")
- 19:23, 20 May 2024 NumPy ndarray (hist | edit) [19,522 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Numpy Concepts =Overview= <code>ndarray</code> is an N-dimensional array object, which is a fast, flexible container for large datasets in Python. It is used to implement a Pandas Series.")
- 17:19, 17 May 2024 Python zip() (hist | edit) [365 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Python Language Functions =Overview= <code>zip()</code> "pairs" up the elements of a number of lists, tuples or other sequences to create a list of tuples.")
- 21:48, 16 May 2024 Slicing Lists and Tuples in Python (hist | edit) [4,557 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Lists * Tuples")
- 00:09, 15 May 2024 IPython Operations (hist | edit) [426 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * IPython")
- 00:09, 15 May 2024 IPython Concepts (hist | edit) [537 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * IPython")
- 23:52, 14 May 2024 Miniconda (hist | edit) [129 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * conda")
- 23:50, 14 May 2024 PyTorch (hist | edit) [98 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.statsmodels.org/stable/index.html =Internal= * Python for Data Analysis =Overview=")
- 23:47, 14 May 2024 Statsmodels (hist | edit) [349 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.statsmodels.org/stable/index.html =Internal= * Python for Data Analysis =Overview=")
- 23:39, 14 May 2024 SciPy (hist | edit) [919 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://scipy.org =Internal= * Python for Data Analysis")
- 23:35, 14 May 2024 IPython (hist | edit) [198 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://ipython.org =Internal= * Python for Data Analysis =Overview= An interactive Python interpreter, that encourages an execute-explore workflow instead of the typical edit-compile-run workflow.")
- 23:04, 14 May 2024 Scikit-learn (hist | edit) [176 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Python for Data Analysis")
- 22:40, 14 May 2024 Python for Data Analysis (hist | edit) [1,489 bytes] Ovidiu (talk | contribs) (Created page with "=External= =Internal= * Python Engineering =Overview=")
- 22:29, 14 May 2024 Descriptive Statistics (hist | edit) [155 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.investopedia.com/terms/d/descriptive_statistics.asp =Internal= * Statistical Concepts =Overview=")