Wakanda is an open-source platform for developing business web and mobile applications in Javascript.
|
Advanced Data Modeling with Entity Relationship...
by Mark Abramson
Agenda Not Set Yet
Room Not Assigned
In this session we will dive in deeper and work on specific challenges that crop up with database designs. This session will be interactive and will benefit from your specific database-related issues. Please hit me on Twitter (@mark__a) or use the "email the speaker" button with your challenges and we'll do our best to cover some approaches for you in the class. Need the basics? Check out my other session on "Intro to DB Design."
Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling. A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies. He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods. Mark Abramson Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder... twitter.com/mark__a /Presenter/2013/Mark-Abramson-5443 CA @mark__a
9
Database
24
SQL Server
374
SQL Azure
599
SQL
|
||
|
Intro to Relational Database Design &...
by Mark Abramson
Agenda Not Set Yet
Room Not Assigned
Mark will cover the basics of designing and setting up a database schema. He'll define some common business scenarios, build out some tables, create relationships, and then demo usage, pitfalls, problems and design tradeoffs.
With so many database-driven projects for consumer desktop software applications, websites and enterprise software systems, the database design plays a crucial role in the success of your project.
You'll see real-life examples and issues such as:
Creating a new table;
Choosing data types;
Normalization (and when to denormalize);
Types of relationships;
Referential integrity;
Join/relationship tables;
1-to-many, many-to-many;
How to actually use these structures in your application;
While the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database. There will be discussion of various commercial and open source tools to streamline your work.
Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling. A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies. He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods. Mark Abramson Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder... twitter.com/mark__a /Presenter/2013/Mark-Abramson-5443 CA @mark__a
9
Database
24
SQL Server
374
SQL Azure
599
SQL
|
||
|
A SQL Server performance warehouse using the...
by Joel Champagne
Agenda Not Set Yet
Room Not Assigned
What if you could take performance data related to SQL Server (and we'll touch on non-SQL Server sources as well) and collect it into a data warehouse that's implemented using the SQL 2012 SSAS Tabular Model? You'd be able to build virtually an infinite number of reports using tools such as Excel 2010+. You'd be able to consolidate different kinds of metrics and define your own KPI's. In this session I'll show you the work I've done to accomplish this, codified in the SQL-Hero product. You'll understand the concepts involved so you can roll your own solutions, or you'll see enough to get up-and-running quickly if you choose to use SQL-Hero. Along the way, you'll also learn about SSAS, PowerPivot and DAX; plus we'll touch on SQL Server Extended Events and some handy DMV queries.
My 20 years in the industry have been largely spent in consulting, helping clients deliver large business solutions, mostly using .NET technologies, SQL Server, SSAS and SSRS. My specialty is in the SQL space, in particular data modeling and BI, although I've been very involved with application frameworks and architecture as well. My company's flagship product, SQL-Hero, codifies many of the daily consulting tasks I've dealt with including code generation, tracing, reporting, and more. Joel Champagne My 20 years in the industry have been largely spent in consulting, helping clients deliver... www.codexframework.com /Presenter/2013/Joel-Champagne-4503 CA sqlheroguy
24
SQL Server
89
Performance
178
SSAS
376
PowerPivot
528
reporting
599
SQL
714
DAX
|
