Khuyen Tran khuyentran1401

## SQL Cheat Sheet.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                khuyentran1401
                / SQL Cheat Sheet.md
            
            
              Last active
              December 5, 2020 17:05
                — forked from janikvonrotz/SQL Cheat Sheet.md
            
              
                SQL Cheat Sheet#SQL#Markdown
              
          
    SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.
DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.
Datatypes

Text types

  
## text_preprocessing.py
import re, string, unicodedata
import nltk
import contractions
import inflect
from nltk import word_tokenize, sent_tokenize
from nltk.corpus import stopwords
from nltk.stem import LancasterStemmer, WordNetLemmatizer

def remove_html(words):
    '''Remove message with html'''

## nb_remove_output.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

"""
Remove output from existing Jupyter Notebooks.
Modified from remove_output by Minrk, damianavila, gabraganca.

References:
    [0]: https://github.com/jupyter/nbformat
    [1]: http://nbformat.readthedocs.org/en/latest/index.html
	import re, string, unicodedata
	import nltk
	import contractions
	import inflect
	from nltk import word_tokenize, sent_tokenize
	from nltk.corpus import stopwords
	from nltk.stem import LancasterStemmer, WordNetLemmatizer

	def remove_html(words):
	'''Remove message with html'''
	#!/usr/bin/env python
	# -- coding: utf-8 --

	"""
	Remove output from existing Jupyter Notebooks.
	Modified from remove_output by Minrk, damianavila, gabraganca.

	References:
	[0]: https://github.com/jupyter/nbformat
	[1]: http://nbformat.readthedocs.org/en/latest/index.html