Skip to content
/ mysql_for_DA_and_BI Public

basic sequel codes (with proper syntaxes and definitions) for Data Analysis and Business Intelligence.

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

akrai37/mysql_for_DA_and_BI

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

82 Commits
10AND_OR_clause.sql
10AND_OR_clause.sql
 
 
11IN-NOT_IN.sql
11IN-NOT_IN.sql
 
 
12LIKE-NOT_LIKE.sql
12LIKE-NOT_LIKE.sql
 
 
13operator_precedence.sql
13operator_precedence.sql
 
 
14(NOT)BETWEEN-AND.sql
14(NOT)BETWEEN-AND.sql
 
 
15is_(not)null.sql
15is_(not)null.sql
 
 
16comparison_operators.sql
16comparison_operators.sql
 
 
17Aggregate_fn(count).sql
17Aggregate_fn(count).sql
 
 
18ORDER_BY.sql
18ORDER_BY.sql
 
 
19GROUP_BY.sql
19GROUP_BY.sql
 
 
1Creating_table.sql
1Creating_table.sql
 
 
20HAVING.sql
20HAVING.sql
 
 
21WHERE_HAVING.sql
21WHERE_HAVING.sql
 
 
22LIMIT.sql
22LIMIT.sql
 
 
23INSERT_statement.sql
23INSERT_statement.sql
 
 
24INSERT_statement2.sql
24INSERT_statement2.sql
 
 
25UPDATE_statement.sql
25UPDATE_statement.sql
 
 
26DELETE_statement.sql
26DELETE_statement.sql
 
 
27COUNT.sql
27COUNT.sql
 
 
28SUM.sql
28SUM.sql
 
 
29MIN()_MAX().sql
29MIN()_MAX().sql
 
 
2customers1table.sql
2customers1table.sql
 
 
30AVG.sql
30AVG.sql
 
 
31ROUND.sql
31ROUND.sql
 
 
32IFNULL( )_COALESCE( ).sql
32IFNULL( )_COALESCE( ).sql
 
 
33INNER_JOIN.sql
33INNER_JOIN.sql
 
 
34LEFT(OUTER)JOIN.sql
34LEFT(OUTER)JOIN.sql
 
 
35RIGHT_JOIN.sql
35RIGHT_JOIN.sql
 
 
36OLD_JOIN_SYNTAX.sql
36OLD_JOIN_SYNTAX.sql
 
 
37prevent_error_code-1055.sql
37prevent_error_code-1055.sql
 
 
38JOIN_and_WHERE.sql
38JOIN_and_WHERE.sql
 
 
39CROSS_JOIN.sql
39CROSS_JOIN.sql
 
 
40AF_with_JOIN.sql
40AF_with_JOIN.sql
 
 
41joining_more_than_2_tables.sql
41joining_more_than_2_tables.sql
 
 
42GROUP_BY_with_JOINS.sql
42GROUP_BY_with_JOINS.sql
 
 
43UNION_UNIONALL.sql
43UNION_UNIONALL.sql
 
 
44IN_nestedin_WHERE.sql
44IN_nestedin_WHERE.sql
 
 
45EXISTS_clause.sql
45EXISTS_clause.sql
 
 
46subqueries(Adv.)_SELECT_FROM.sql
46subqueries(Adv.)_SELECT_FROM.sql
 
 
47AdvancedQueries2.sql
47AdvancedQueries2.sql
 
 
48SELF_JOIN(has_a_WHERE_trick).sql
48SELF_JOIN(has_a_WHERE_trick).sql
 
 
49VIEW.sql
49VIEW.sql
 
 
4default_constraint.sql
4default_constraint.sql
 
 
50routine-PROCEDURES.sql
50routine-PROCEDURES.sql
 
 
51stored_procedures-IN_parameters.sql
51stored_procedures-IN_parameters.sql
 
 
52stored_procedures-INandOUT_parameters.sql
52stored_procedures-INandOUT_parameters.sql
 
 
53Variables.sql
53Variables.sql
 
 
54User_Defined_Functions.sql
54User_Defined_Functions.sql
 
 
55Triggers-original.sql
55Triggers-original.sql
 
 
56Triggers.sql
56Triggers.sql
 
 
57INDEXES.sql
57INDEXES.sql
 
 
58CASE_statement.sql
58CASE_statement.sql
 
 
5Primary_Key.sql
5Primary_Key.sql
 
 
60Task-1.sql
60Task-1.sql
 
 
61Task-3.sql
61Task-3.sql
 
 
62Task-4.sql
62Task-4.sql
 
 
6Foreign_Key.sql
6Foreign_Key.sql
 
 
7Unique_key.sql
7Unique_key.sql
 
 
8not_null_constraint.sql
8not_null_constraint.sql
 
 
9Select_$_Where_clause.sql
9Select_$_Where_clause.sql
 
 
Chart-1 data for visualization.csv
Chart-1 data for visualization.csv
 
 
Chart-3 data for visualization.csv
Chart-3 data for visualization.csv
 
 
Chart-4 data for visualization.csv
Chart-4 data for visualization.csv
 
 
README.md
README.md
 
 
code-1.sql
code-1.sql
 
 

Repository files navigation

mysql_for_DA_and_BI

basic sequel codes (with proper syntaxes and definitions) for Data Analysis and Business Intelligence.

About

basic sequel codes (with proper syntaxes and definitions) for Data Analysis and Business Intelligence.

Topics

aggregate-function views sessions joins triggers ddl-commands dml-commands sql-tableau

Resources

Readme
Activity

Stars

1 star

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages