mysql_for_DA_and_BI

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

Name		Name	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

akrai37/mysql_for_DA_and_BI

Folders and files

Latest commit

History

Repository files navigation

mysql_for_DA_and_BI

About

Topics

Resources

Stars

Watchers

Forks

Languages