Back to basics - DB
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWX
1
DB Design
2
serial
TitleLink
3
1Data vs Informationhttps://hemantrohtak.blogspot.com/2016/09/data-vs-information.html
4
2History of the Databasehttps://hemantrohtak.blogspot.com/2016/09/history-of-database.html
5
3Major Transformations in Computing
https://hemantrohtak.blogspot.com/2016/09/major-transformations-in-computing.html
6
4Conceptual and Physical Models
https://hemantrohtak.blogspot.com/2016/09/conceptual-and-physical-models.html
7
5Entities, Instances, Attributes and Identifiers
https://hemantrohtak.blogspot.com/2016/09/entities-instances-attributes-and.html
8
6Entity Relationship Modeling and ERDs
https://hemantrohtak.blogspot.com/2016/09/entity-relationship-modeling-and-erds.html
9
7Identifying Relationshipshttps://hemantrohtak.blogspot.com/2016/09/identifying-relationships.html
10
8ER Diagramming Conventionshttps://hemantrohtak.blogspot.com/2016/09/er-diagramming-conventions.html
11
9Speaking ERDish and Drawing Relationshipshttps://hemantrohtak.blogspot.com/2016/09/speaking-erdish-and-drawing.html
12
10Matrix Diagramshttps://hemantrohtak.blogspot.com/2016/09/matrix-diagrams.html
13
11Supertypes and Subtypeshttps://hemantrohtak.blogspot.com/2016/09/supertypes-and-subtypes.html
14
12Documenting Business Ruleshttps://hemantrohtak.blogspot.com/2016/09/documenting-business-rules.html
15
13Relationship Transferabilityhttps://hemantrohtak.blogspot.com/2016/09/relationship-transferability.html
16
14Relationship Typeshttps://hemantrohtak.blogspot.com/2016/09/relationship-types.html
17
15Resolving Many-to-Many Relationships
https://hemantrohtak.blogspot.com/2016/09/resolving-many-to-many-relationships.html
18
16Understanding CRUD Requirements
https://hemantrohtak.blogspot.com/2016/09/understanding-crud-requirements.html
19
17UIDs and Normalizationhttps://hemantrohtak.blogspot.com/2016/09/uids-and-normalization.html
20
18Normalization and First Normal Form
https://hemantrohtak.blogspot.com/2016/09/normalization-and-first-normal-form.html
21
19Third Normal Formhttps://hemantrohtak.blogspot.com/2016/09/third-normal-form.html
22
20Second Normal Formhttps://hemantrohtak.blogspot.com/2016/09/second-normal-form.html
23
21Arcshttps://hemantrohtak.blogspot.com/2016/09/arcs.html
24
22Modeling Historical Datahttps://hemantrohtak.blogspot.com/2016/09/modeling-historical-data.html
25
23Modeling Change: Timehttps://hemantrohtak.blogspot.com/2016/09/modeling-change-time.html
26
24Modeling Change: Pricehttps://hemantrohtak.blogspot.com/2016/09/modeling-change-price.html
27
25Drawing Conventions for Readability
https://hemantrohtak.blogspot.com/2016/09/drawing-conventions-for-readability.html
28
26Introduction to Relational Database Concepts
https://hemantrohtak.blogspot.com/2016/09/introduction-to-relational-database.html
29
27Basic Mapping: The Transformation Process
https://hemantrohtak.blogspot.com/2016/09/basic-mapping-transformation-process.html
30
28Relationship Mappinghttps://hemantrohtak.blogspot.com/2016/09/relationship-mapping.html
31
29Hierarchies and Recursive Relationships
https://hemantrohtak.blogspot.com/2016/09/hierarchies-and-recursive-relationships.html
32
30Subtype Mappinghttps://hemantrohtak.blogspot.com/2016/09/subtype-mapping.html
33
31
Design virtual Insurance Agent's DB with SQL Developer Data Modeler
https://hemantrohtak.blogspot.com/2016/10/design-virtual-insurance-agents-db-with.html
34
Programming ( use oracle express for samples)
35
serial
TitleLink
36
101 Relational Database Technology
https://hemantrohtak.blogspot.com/2016/10/01-relational-database-technology.html
37
202 Anatomy of a SQL Statementhttps://hemantrohtak.blogspot.com/2016/10/02-anatomy-of-sql-statement.html
38
3
03 Working with Columns, Characters, and Rows
https://hemantrohtak.blogspot.com/2016/10/03-working-with-columns-characters-and.html
39
404 Limit Rows Selectedhttps://hemantrohtak.blogspot.com/2016/10/04-limit-rows-selected.html
40
505 Comparison Operatorshttps://hemantrohtak.blogspot.com/2016/10/05-comparison-operators.html
41
606 Logical Comparisons and Precedence Rules
https://hemantrohtak.blogspot.com/2016/10/06-logical-comparisons-and-precedence.html
42
707 Sorting Rowshttps://hemantrohtak.blogspot.com/2016/10/07-sorting-rows.html
43
808 Introduction to Functionshttps://hemantrohtak.blogspot.com/2016/10/08-introduction-to-functions.html
44
909 Case and Character Manipulation
https://hemantrohtak.blogspot.com/2016/10/09-case-and-character-manipulation.html
45
1010 Number Functionshttps://hemantrohtak.blogspot.com/2016/10/10-number-functions.html
46
1111 Date Functionshttps://hemantrohtak.blogspot.com/2016/10/11-date-functions.html
47
1212 Date / Conversion Functionshttps://hemantrohtak.blogspot.com/2016/10/12-date-conversion-functions.html
48
1313 NULL Functionshttps://hemantrohtak.blogspot.com/2016/10/13-null-functions.html
49
1414 Conditional Expressionshttps://hemantrohtak.blogspot.com/2016/10/14-conditional-expressions.html
50
1515 Cross Joins and Natural Joins
https://hemantrohtak.blogspot.com/2016/10/15-cross-joins-and-natural-joins.html
51
1616 Join Clauseshttps://hemantrohtak.blogspot.com/2016/10/16-join-clauses.html
52
1717 Inner versus Outer Joinshttps://hemantrohtak.blogspot.com/2016/10/17-inner-versus-outer-joins.html
53
1818 Self Joins and Hierarchical Queries
https://hemantrohtak.blogspot.com/2016/10/18-self-joins-and-hierarchical-queries.html
54
1919 Oracle Equijoin and Cartesian Product
https://hemantrohtak.blogspot.com/2016/10/19-oracle-equijoin-and-cartesian-product.html
55
2020 Oracle Nonequijoins and Outer Joins
https://hemantrohtak.blogspot.com/2016/10/20-oracle-nonequijoins-and-outer-joins.html
56
2121 Group Functionshttps://hemantrohtak.blogspot.com/2016/10/21-group-functions_15.html
57
2222 Count, Distinct, NVLhttps://hemantrohtak.blogspot.com/2016/10/22-count-distinct-nvl.html
58
2323 Using GROUP BY and HAVING Clauses
https://hemantrohtak.blogspot.com/2016/10/23-using-group-by-and-having-clauses.html
59
24
24 Using ROLLUP and CUBE Operations and GROUPING SETS
https://hemantrohtak.blogspot.com/2016/11/24-using-rollup-and-cube-operations-and.html
60
2525 Set Operatorshttps://hemantrohtak.blogspot.com/2016/10/25-set-operators.html
61
2626 Fundamentals of Subquerieshttps://hemantrohtak.blogspot.com/2016/10/26-fundamentals-of-subqueries.html
62
2727 Single-Row Subquerieshttps://hemantrohtak.blogspot.com/2016/10/27-single-row-subqueries.html
63
2828 Multiple-Row Subquerieshttps://hemantrohtak.blogspot.com/2016/10/28-multiple-row-subqueries.html
64
2929 Correlated Subquerieshttps://hemantrohtak.blogspot.com/2016/10/29-correlated-subqueries.html
65
3030 INSERT Statementshttps://hemantrohtak.blogspot.com/2016/10/30-insert-statements.html
66
3131 Updating Column Values and Deleting Rows
https://hemantrohtak.blogspot.com/2016/10/31-updating-column-values-and-deleting.html
67
32
32 DEFAULT Values, MERGE, and Multi-Table Inserts
https://hemantrohtak.blogspot.com/2016/11/32-default-values-merge-and-multi-table.html
68
3333 Creating Tableshttps://hemantrohtak.blogspot.com/2016/11/33-creating-tables.html
69
3434 Using Data Typeshttps://hemantrohtak.blogspot.com/2016/11/34-using-data-types.html
70
3535 Modifying a Tablehttps://hemantrohtak.blogspot.com/2016/11/35-modifying-table.html
71
36
36 Intro to Constraints; NOT NULL and UNIQUE Constraints
https://hemantrohtak.blogspot.com/2016/11/36-intro-to-constraints-not-null-and.html
72
37
37 PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
https://hemantrohtak.blogspot.com/2016/11/37-primary-key-foreign-key-and-check.html
73
3838 Managing Constraintshttps://hemantrohtak.blogspot.com/2016/11/38-managing-constraints.html
74
3939 Creating Viewshttps://hemantrohtak.blogspot.com/2016/11/39-creating-views.html
75
4040 DML Operations and Viewshttps://hemantrohtak.blogspot.com/2016/11/40-dml-operations-and-views.html
76
4141 Managing Viewshttps://hemantrohtak.blogspot.com/2016/11/41-managing-views.html
77
4242 Working with Sequenceshttps://hemantrohtak.blogspot.com/2016/11/42-working-with-sequences.html
78
4343 Indexes and Synonymshttps://hemantrohtak.blogspot.com/2016/11/43-indexes-and-synonyms.html
79
4444 Controlling User Accesshttps://hemantrohtak.blogspot.com/2016/11/44-controlling-user-access.html
80
4545 Creating and Revoking Object Privileges
https://hemantrohtak.blogspot.com/2016/11/45-creating-and-revoking-object.html
81
4646 Regular Expressionshttps://hemantrohtak.blogspot.com/2016/11/46-regular-expressions.html
82
4747 Database Transactionshttps://hemantrohtak.blogspot.com/2016/11/47-database-transactions.html
83
4848 Testing ORACLE SQL Programming
https://hemantrohtak.blogspot.com/2016/11/48-testing-oracle-sql-programming.html
84
49
49 Ensuring Quality Query Results– Advanced Technique
https://hemantrohtak.blogspot.com/2016/11/49-ensuring-quality-query-results.html
85
50
50 Sample Project with Oracle Application Express
https://hemantrohtak.blogspot.com/2016/11/50-sample-project-with-oracle.html
86
87
88
89
general
90
1Create database and content using psql
https://hemantrohtak.blogspot.com/2017/03/create-database-and-content-using-psql.html
91
2Designing a Databasehttps://hemantrohtak.blogspot.com/2016/03/designing-database.html
92
3LAMP stackhttps://hemantrohtak.blogspot.com/2016/03/lamp-stack.html
93
4a simple PHP mySQL examplehttps://hemantrohtak.blogspot.com/2016/04/a-simple-php-mysql-example.html
94
5
Is Entity Framework the best performing option for PostgreSQL and .NET applications?
https://hemantrohtak.blogspot.com/2016/03/is-entity-framework-best-performing.html
95
96
97
98
99
100
Loading...
 
 
 
Sheet1