Data-Analyst-with-SQL-Server
文章平均质量分 57
DataCamp Career Track
This track follows the curriculum for Microsoft certification exam 70-461: "Querying Microsoft SQL Server 2012/2014".
radar_sun
kite in the hurricane
展开
-
Data-Analyst-with-SQL-Server
Learn the basics of database design and the different SQL data types. Then master the core concepts for the exam. In this track, you’ll learn how to write queries, functions, and stored procedures. You’ll also find out how to manage transactions, handle er原创 2021-03-24 13:50:42 · 257 阅读 · 0 评论 -
1-Introduction-to-SQL-Server
1.SELECTion BoxWelcomeSimple selectionsMore selectionsOrdering and filteringOrder byWhereWhere againWorking with NULL valuesWHERE the wild things areExploring classic rock songsExploring classic rock songs - AND/ORUsing parentheses in your quer原创 2020-11-26 20:10:06 · 716 阅读 · 0 评论 -
2-Introduction-to-Relational-Databases-in-SQL
Introduction to Relational Databases in SQLYour first databaseEnforce data consistency with attribute constraintsUniquely identify records with key constraintsGlue together tables with foreign key...原创 2019-12-23 19:13:36 · 4280 阅读 · 0 评论 -
3-Intermediate-SQL-Server
1 Summarising DataData analysis with aggregationsCreating aggregationsCreating grouped aggregationsDealing with missing dataRemoving missing valuesImputing missing values (I)Imputing missing values (II)Binning data with CASEUsing CASE statementsC原创 2020-11-26 20:33:07 · 1024 阅读 · 0 评论 -
4-Time-Series-Analysis-in-SQL-Server
1. Working with Dates and TimesBuilding datesBreak out a date into year, month, and dayBreak a date and time into component partsDate math and leap yearsRounding datesFormatting dates for reportingFormatting dates with CAST() and CONVERT()Formattin原创 2020-11-26 21:17:21 · 824 阅读 · 0 评论