Continuing my SQL education, I have been working with PostgresSQL while taking online courses via Coursera. I have create some SQL statements using cube, rollup and grouping sets operators. See below: Cube ROLLUP: Grouping Sets: Partial Cube: Partial RollUP:
Tag Archives: sql
Entity Relationship Diagram: Conversions
When you finish creating your Entity Relationship Diagram and made sure that there are no errors; you can then start converting to tables by using the conversion rules. See below. Entity Type Rule: Convert the Student, Loan, Institution, Lender and DisburseLine entity types into tables. 1-M Relationships rule for all relationships except Sent relationship. UseContinue reading “Entity Relationship Diagram: Conversions”
Notable Bookkeeping: SQL Work Portfolio Showcase
Happy Friday! I hope you’ve had a great week! Notable Bookkeeping can code! We are proficient in SQL, Python and HTML. See our work samples here. We’re also proficient in Excel including data manipulation methods, such as, vlookup, formulas, pivot tables, graphs and conditional formatting. How are we different? We align customer priorities with strategicContinue reading “Notable Bookkeeping: SQL Work Portfolio Showcase”
Notable 