Daisy的博客

1. Starting with error handling

1. Python Basics</> The Python InterfaceExperiment in the IPython Shell; type 5 / 8, for example.Add another line of code to the Python script on the top-right (not in the Shell): print(7 + 10).Hit Submit Answer to execute the Python script and r

Hierarchical and Recursive Queries in SQL Server1. Recursion and Common Table Expression (CTE)</> A CTE is … Find the wrong fact!Please find the statement that is NOT true about CTEs. A CTE could be applied to recursive and non-recursive functio

Database Design1. Processing, Storing, and Organizing Data</> OLAP vs. OLTPCategorize the cards into the approach that they describe best.OLAPQueries a larger amount of dataHelps businesses with decision making and problem solvingTypical

Functions for Manipulating Data in SQL Server1. Choosing the appropriate data type</></></></>

Time Series Analysis in SQL Server1. Working with Dates and Times</> Break out a date into year, month, and dayUse the YEAR(), MONTH(), and DAY() functions to determine the year, month, and day for the current date and time.DECLARE @SomeTime DAT

Intermediate SQL Server1. Summarizing Data</> Creating aggregationsWrite a T-SQL query which will return the average, minimum, and maximum values of the DurationSeconds column.SELECT AVG(DurationSeconds) AS Average, MIN(DurationSeconds) A

Introduction to SQL Server1. SELECTion Box</> Simple selectionsSELECT the country column FROM the eurovision table.SELECT countryFROM eurovision;countryIsraelFranceSwedenCroatia...Amend your query to return the points column instead of

Introduction to Importing Data in Python1. Introduction and flat files</> Exploring your working directoryYour task is to use the IPython magic command ! ls to check out the contents of your ...

Introduction to Relational Databases in SQL1. Your first database2. Enforce data consistency with attribute constraints3. Uniquely identify records with key constraints4. Glue together tables with...

Joining Data in SQL1. Introduction to joins</> Inner joinBegin by selecting all columns from the cities table.SELECT *FROM cities;name country_code city_proper_pop metroarea_pop urbanare...

Introduction to SQL1. Selecting columns</> Onboarding | TablesFrom looking at the tabs, who is the first person listed in the people table? Kanye West Biggie Smalls 50 Cent Jay Z</&...

Python Data Science Toolbox (Part 1)1. Writing your own functions</> Strings in PythonExecute the following code in the shell:object1 = "data" + "analysis" + "visualization"object2 = 1 * 3...

Introduction to Data Science in Python1. Getting Started in Python</> Importing Python modulesModules (sometimes called packages or libraries) help group together related sets of tools in Pyt...