A collection of cheat sheets for Treehouse Courses
cheatsheets's Introduction
cheatsheets's People
Forkers
firebuggirl theotherside ovunck phippsy jamesrochabrun karn09 lukemonson whizkidefos zubetube kokochris jjdperryman joeyliu2012 amoghotra mygith1 mastrouser varenigmatic galinavwall fletcherwu shawnwq jalexander47 n8kolenberg rebeccamooneyham kristiemcgoldrick patrickmockridge bayoojo1 gdaimon bpaschal17 acb-site zjohnson1 sharonaldeguer jtaqleh permanentdaylight suddenven realjasona nicolasp01 ocl29 anjolovic rbuddha jasondeving davidwright123 samarth4487 mallik369 futureprogrammer2030 nocks aziztovbaev krishna19 brightfirejk danieldugan kazoowee nicholasgreen94 danijelsvk mahmoudezayed ashu-y kaorihannah leanseverino1022 kennysang5 adriculous wickedgamer19 baptisteboulonnais geo86 golden-ocean pidubiel akumaldo rstaniek jonathanfrancisco u-learn hit1st pikachupikachuhaha ostrander-nathan slaguerta twycrossjamie svroye cupofjoey hablebuble sward42 briwyatt edisplay jennyro80 steelerbaby michaelerobertsjr abdrrahmenz alertnikole ngothanhtung leltad vinayaknigam90 josephbabu bredek engineeremily brsbl-zz antonionrodrigues kayla425 samory070 wadethemaker blackdout astrowuff thakkarsagar12 lemyn216 maestrly nuclearmonkey sivasathcheatsheets's Issues
INCOMPLETE: modifying_data_with_sql_orlee_gillis
INTRO TO TRANSACTIONS
AUTOCOMMIT TRANSACTIONS -- DEFINITION:
"Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or rolled back when it completes. If a statement completes successfully, it is committed; if it encounters any error, it is rolled back.
A connection to an instance of the Database Engine operates in autocommit mode whenever this default mode has not been overridden by either explicit or implicit transactions." -- Microsoft TechNet
SEED SCRIPT -- DEFINITION:
"A script that populates your database with a set of test data. It can be as simple as a bunch of INSERT statements, or something much more elaborate." -- ycombinator thread
TRANSACTIONS -- DEFINITION + FUNCTION:
-- Used to switch-off 'autocommit'
BEGIN TRANSACTION/BEGIN -- DEFINITION + FUNCTION:
"Start a transaction"
COMMIT (OPERATOR) -- DEFINITION + FUNCTION:
"Commits all transactions since the transaction begin and turns autocommit mode on"
- Cannot be undone.
SEEDING -- DEFINITION + FUNCTION:
"Populating a database for the first time (in the form of a 'Script File')
**'UPDATES' -- DEFINITION + FUNCTIONS:
"Getting rid of changes that haven't been committed yet."
- ROLLBACK (OPERATOR) -- DEFINITION + FUNCTION:
Undo changes you made.
Always an option.
SET (OPERATOR) -- DEFINITION + FUNCTION:
Assigning a new VALUE to an existing VALUE
AUTO INCREMENT (OPERATOR) -- DEFINITION + FUNCTION:
Generates the latest ID for you so you don't have to.
Designates the ID column as an 'auto-incremented column'.
OBJECT-RELATIONAL-MAPPING (ORM):
"Used to perform CRUD operations with a language other than SQL."
(Many developers, while using databases, aren't required to write a single line of SQL code. They use special software libraries called ORMs.)
DATA-MANIPULATION-LANGUAGE (DML):
Incomplete sentence
In outer joins example's, last sentence seems to be incomplete:
The following two examples will yield the same results, however one is an
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.