SQL (5) 썸네일형 리스트형 SQL functions basics Temporary table Temporary tables in a SQL database that aren't stored permanenlty. They are automatically deleted from the database when you end your SQL session. They can be used as a holding area for storing values if you are making a series of calculations. (pre-processing) They can collect the results of multiple, separate queries. (staging) They can store a filtered subset of the database. Using fewer SQL .. [Coursera] Course 5. Analyze Data to Answer Questions WEEK1 - Organizing data to begin analysis [Definition] -Filtering: Showing only the data that meets a specific criteria while hiding the rest -Sorting: When you arrange data into a meaningful order to make it easier to understand, analyze, and visualize Sort sheet: All of the data in a spreadsheet is sorted by the ranking of a specific sorted column - data across rows is kept together Sort range.. Regular Expression [Tutorial] https://www.regular-expressions.info/tutorialcnt.html Regular Expression Tutorial Table of Contents Regular Expressions Tutorial Table of Contents This regular expressions tutorial teaches you every aspect of regular expressions. Each topic assumes you have read and understood all previous topics. If you are new to regular expressions, you should read th www.regular-expressions.info [.. [Coursera] Course 3. Prepare Data for Exploration WEEK 1 - Data types and structures [Definition] First-party data Second-party data Third-party data Data collected by an individual or group using their own resources Data collected by a group directly from its audience and the sold Data collected from outside sources who did not collect it directly Discrete data Continuous data Data that is counted and has a limited number of values Data that i.. 이전 1 다음