Which of these tools has more market on data projects?
Anonymous Poll
37%
SQL Server
31%
Power BI
64%
Python
5%
Integration Service
2%
C#
3%
JAVA
19%
R
2%
JavaScript
6%
AZURE
3%
AWS
Chapter 1
Record 001 : #Explanation_about_exam_and_book #Job_Career #select
Record 002 : #Select_Distinct_From #And_or_<> #Where_groupBy_OrderBy #Top_From_Ties #Offset_fetch
Record 003 : #like #convert #cast #Data_types #Declare
Record 004 : #Set_Operators
Record 005 : #innerJoins #leftJoins #rightJoins #fullJoins #crossJoins
Record 006 : #self_join #composit_join #multiple_join #isnull #exists #Excution_plan
Record 007 : #Date_Functions #try_convert #try_cast #Data_types #Declare #sysdatetime #sysutcdatetime #datename #datepart #dateadd #datediff #Char_Functions #concat #coalesce #charindex #patindex #len_datalength #Replicate #Sting_spilit #Case #Rowcount
Record 008 : #compress #cast_decompress #drop_creat_table #NewID #uniqueIdentifier #NewSequentialID #+_-_*_/ #count
Record 009 : #Inserting_Data #use_drop_exists_Go_creattable #Constraints #NOTNULL #UNIQUE #PRIMARY_KEY #FOREIGN_KEY #CHECK #DEFAULT #Insert_into #delete_truncate #Set_Identity #Stored_procedure #Copying_table #Alter_table
Record 0010 : #Update_table #deterministic_update #Non_deterministic_update #Update_all_at_once #Update_base_on_variables
Record 0011 : #Delete(3 Types) #Truncate
Record 0012 : #merge #Matched #Not_matched_by_target #Not_matched_by_source
Record 0013 : #output(Insert,delete,update,merge) #Action #coalesce #Altering_table #Altering_table_constraint
Chapter 2
Record 0014 : #sub_query #crossapply #outerapply #Derived_table #Table_expression #common_table_expression(CTE) #recursive_query #Functions #creatFunction_returnstable_as_return
Record 0015 : #Multiple_Grouping_Sets #Grouping_Sets #Role_up #Cube #Grouping #Pivoting_Data
Record 0016 : #windows_Functions #PartionBy_OrderBy #Rank #Dense_rank #Row_Number #Ntile #Lag_lead #Firist_value #last_value #Sum #Avg #count #DataFrame
Record 001 : #Explanation_about_exam_and_book #Job_Career #select
Record 002 : #Select_Distinct_From #And_or_<> #Where_groupBy_OrderBy #Top_From_Ties #Offset_fetch
Record 003 : #like #convert #cast #Data_types #Declare
Record 004 : #Set_Operators
Record 005 : #innerJoins #leftJoins #rightJoins #fullJoins #crossJoins
Record 006 : #self_join #composit_join #multiple_join #isnull #exists #Excution_plan
Record 007 : #Date_Functions #try_convert #try_cast #Data_types #Declare #sysdatetime #sysutcdatetime #datename #datepart #dateadd #datediff #Char_Functions #concat #coalesce #charindex #patindex #len_datalength #Replicate #Sting_spilit #Case #Rowcount
Record 008 : #compress #cast_decompress #drop_creat_table #NewID #uniqueIdentifier #NewSequentialID #+_-_*_/ #count
Record 009 : #Inserting_Data #use_drop_exists_Go_creattable #Constraints #NOTNULL #UNIQUE #PRIMARY_KEY #FOREIGN_KEY #CHECK #DEFAULT #Insert_into #delete_truncate #Set_Identity #Stored_procedure #Copying_table #Alter_table
Record 0010 : #Update_table #deterministic_update #Non_deterministic_update #Update_all_at_once #Update_base_on_variables
Record 0011 : #Delete(3 Types) #Truncate
Record 0012 : #merge #Matched #Not_matched_by_target #Not_matched_by_source
Record 0013 : #output(Insert,delete,update,merge) #Action #coalesce #Altering_table #Altering_table_constraint
Chapter 2
Record 0014 : #sub_query #crossapply #outerapply #Derived_table #Table_expression #common_table_expression(CTE) #recursive_query #Functions #creatFunction_returnstable_as_return
Record 0015 : #Multiple_Grouping_Sets #Grouping_Sets #Role_up #Cube #Grouping #Pivoting_Data
Record 0016 : #windows_Functions #PartionBy_OrderBy #Rank #Dense_rank #Row_Number #Ntile #Lag_lead #Firist_value #last_value #Sum #Avg #count #DataFrame
Record 0017 : #System_Temporal_Tabels #ValidFrom #validTo #System_Versioning #Tran
Record 0018 : #Review #schemabinding #objectdefenition
Chapter 3
#modify_data_by_view #over #Scop_Identity
Record 0019 : #User_Defined_Functions #Scalar_Value_Function #Table_Value_Function #Inline_Table_Value #Multistatment_Table_value #Constraints #Schema
Record 0020 : #Stored_Procedure #Dynamic_SQL #output #Mixtures
Record 0018 : #Review #schemabinding #objectdefenition
Chapter 3
#modify_data_by_view #over #Scop_Identity
Record 0019 : #User_Defined_Functions #Scalar_Value_Function #Table_Value_Function #Inline_Table_Value #Multistatment_Table_value #Constraints #Schema
Record 0020 : #Stored_Procedure #Dynamic_SQL #output #Mixtures
Media is too big
VIEW IN TELEGRAM
حل تمرین TSQL مبحث View از سری فیلم های TSQL کانال @datascienceie