Browsing articles tagged with " Training"

7 Databases in 170 Minutes: Workshop at NoSQLNow!

Jan 26, 2016   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, Events, NoSQL, Speaking, Training  //  No Comments

image

My friend Joey D’Antoni ( @jdanton | blog ) and I will be giving a workshop at NoSQLNow! about new database and datastore technologies like Hadoop, Neo4j, Cassandra, Vertica, Document DB, and others.  This will be a fast-paced, demo-heavy, practical sessions for data professionals.  We’ll talk about where a modern data architecture would best use these technologies and why it’s not an either/or question for relational solutions in a successful enterprise. And, as always, our goal is to make the time we spend fun and interactive.   This session will be a great starting point for some other session on Monday that go into data modeling for NoSQL as well as for all the other in-depth, database-specific talks the rest of the week.

Sunday, April 17, 2016
Level:
Intermediate

imageWe’ve been busy keeping relational data consistent, high quality, and available. But over the last few years, new database and datastore technologies have come to the enterprise with different data stories. Do we need all our data to be consistent everywhere? What does data quality mean for analytics? Will we need relational database?

Learn how traditional and new database technologies fit in a modern data architecture. We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, columnar, and column family databases and how and when they should be considered. We’ll show you demos of each.

Finally, we will wrap up with 7+ tips for working with new hybrid data architectures: tools, techniques and standards.

 REGISTER

Use code “DATACHICK” to save:

$100 off for  Tutorials Only + Seminar Only Registration and $200 off for Full Event, Conference+Tutorials, Conference +Seminar, and Conference Only Registration.

Super early registration ends 29 January, so take advantage of both discounts now (yes, they stack!).

Educator Grants for Microsoft Azure

Sep 8, 2015   //   by Karen Lopez   //   Blog, Cloud, Database, DLBlog, NoSQL, Professional Development  //  2 Comments

Are you an educator teaching at an accredited university or college?  Do you want Azure cloud subscription grants for you and your students?  All you need to do is register with some basic information at:

https://www.microsoftazurepass.com/azureu

The current grant amounts (subject to change and regional differences, of course) for reference:

Azure Grant $250/month instrcutor, $100 month Student

If you teach a technology-related course, you may be eligible for these grants.  Remember, Azure includes more than Microsoft technologies, so these grants can cover a wide variety of course subjects.

Join us at #SQLBits: Designing for Performance Training, with Video and Snark

Jan 6, 2015   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, SQL Server  //  No Comments
At SQLBits

I’m excited to announce that Thomas LaRock (@sqlrockstar | blog) and I will be presenting a full-day Training Day (PreCon) at SQLBIts XIV in London, UK.

Our session, Designing For Performance: Myths and Misunderstandings, is going to feature hands-on labs, exercises and lots of challenges to help you master your own SQL Server superpowers. It will be held on Thursday, 5 March 2015. Registration is open NOW.

 


 

image

 

Everyone agrees that great database performance starts with great database design. So why do so many poorly designed databases exist in the world? Attend this session to understand why bad designs will always exist, what you can do to avoid them, and how best to work with them when needed.
Discussion topics will include:

  • Server/Infrastructure design
    • VM/Server configuration
    • Physical file layouts
    • HA/DR options
    • Archiving
  • Database/Table design
    • Table design
    • PK/FK choices
    • Index strategies
  • Benchmarking
    • Monitoring for performance
    • Control reports

Attendees will leave this session with an understanding of the following:

  • Why common issues are so common
  • How to better anticipate issues before they happen 
  • How to deploy and implement design choices that benefit everyone
  • Proper performance benchmarking and control reports

 


SQLBits Superheroes

 

This will be my 3rd SQLBits conference,  They are a lot of fun and jam-packed full of learning and networking.  As you can see from the video above, Tom and I will also ensure that you aren’t just sitting through 8 hours of bullet points and sparse slides with funny pictures.  We’ll be talking about what design approaches work in what situations and all the myths and misunderstandings out there about database design and configurations.

Register now and engage your own superpowers. Or just stand there looking pretty.  It’s up to you.

Join Me at Enterprise Data World and Save $200 + $200

Conference Session Photo

I’ve been attending Enterprise Data World for more than 15 years.  This event, focused on data architectures, data management, data modeling data governance and other great enterprise-class methods is part technical training and part revival for data professionals.  It’s just that good.

This year the big bash is being held in Austin, TX, a thriving tech-oriented community, 27-April to 1 May.  And this year’s theme is “The Transformation to Data-Driven Business Starts Here.”

And right now there’s a $200 Early Bird Discount going…plus if you use coupon code “DATACHICK” you can save $200 more on a multi-day registration or fifty bucks on a one day pass.  There.  I just saved you $400.  And no, I get no kickbacks with this discount code.  I don’t need them.  I need you to be at this event, sharing your knowledge and meeting other data professionals. I need you to be part of the community of data professionals.

Top 10 Reasons You Need to Go to EDW 2014

  1. Data is HOT HOT HOT.  I deemed 2013 The Year of Data and I see no signs that organizations are going to back to software-is-everything thinking.  2014 is still going to be a year full of data. There’s even an executive, invitation-only CDOvision even co-located.
  2. Not Just Bullet Points.  There are over 20 hours of scheduled networking events for you to chat with other data-curious people.  Chatting with other data professionals is my favourite part of this event.  Bring your business cards…er… .vcs contact file.
  3. Lots of Expertise. Not just data celebrities, but also other data professionals with thousands of hours of hands-on experiences, sharing their use cases around data.  And not just data modeling.  Big Data.  Analytics.  Methods.  Tools.  Open Data.  Governance. NoSQL. SQL. RDBMS. Fun.
  4. Certifications.  You can take advantage of the Pay-Only-If-You-Pass option for the CDMP on-site certification testing.
  5. Workshops. I’m doing a half day tutorial on Driving Development Projects with Enterprise Data Models.  I’ll be talking about how data models fit within real-life, practical, get-stuff-done development projects. No ivory towers here.
  6. SIGs.  There are special interest groups on data modeling products, industries and methods. You can meet people just like you an share your tips and tricks for data lovin.  I will be leading the ER/Studio SIG.
  7. Ice Cream.  This conference has a tradition of the ice cream break on the exhibit floor.  Nice ice cream, even.
  8. Austin. Austin is one of the more vibrant cities in Texas.  So cool, it even has a Stevie Ray Vaughan statue. Museums, Theatres, indoor golf, clubs.  There’s a reason why SxSW is held here.
  9. Vendors. Yes, we love them, too.  Meet the product teams of the makers of the tools you use every day.  Or meet new teams and ask for a demo.  They are good people.
  10. Love Your Data.  There’s no better way to show your love than to network with other data professionals and learn from industry leaders.

Come learn how to help your organization love data better.  You might even see me in a lightning talk holding a martini.  Or taking impromptu pics of @data_model and other data professionals.  Or debating data management strategy with people from around the globe.  In other words, talking data. With people who love their data.  Join us.

Save up to $200 with DATACHICK – #EDW13

Apr 3, 2013   //   by Karen Lopez   //   Blog, Data, Data Governance, Data Modeling, Database Design, Events, Speaking  //  No Comments

image

I’ll be participating in this year’s Enterprise Data World 28 April to 2 May in San Diego, CA.  If you register using the coupon code DATACHICK you can get $200 off a multi-day registration.  That code saves you $50 on a one-day registration.

On Thursday, 2 May I’m giving a half day workshop on the data modeling process:

S5: Advanced Data Modeling: Be Happier, Add More Value and Be More Valued

Karen Lopez
Karen Lopez
Sr. Project Manager & Architect
InfoAdvisors

Thursday, May 2, 2013
01:15 PM – 04:30 PM

Level: 
Advanced

In this advanced workshop, Karen Lopez covers how to make data modeling more relevant in 2012 and removing pain points for modelers and other team members. It includes how to be successful in an agile/scrum environment, how to make models valuable in a NoSQL project, how to better work with DBAs, Developers, Project Managers and how to sound and be more valuable.

This follows a workshop format, with both individual and team exercises. It is expected that attendees will have more than two years of hands-on data modeling and database design skills at the enterprise level.

Starting a Blog for Data Professionals

On Wednesday I’m doing a professional development session on getting started with blogging:  Starting a Blog: Easy Step Show and Tell for Data Professionals.  This session is nicely placed between the coffee and desserts segment on the exhibit floor and the ice cream social that happens right after.  I’m expecting a lot of sugar-motivated potential bloggers.

I’ll also be doing some special activities with vendors and sponsors: watch your inbox for information from them about their events.

EDW is one of my favourite conferences of the year – part technical education, part data professional reunion, part data community revival.  You don’t want to miss it. 

Join Me for Data Modeling Training Oct 1-4 in Des Moines, Iowa

Sep 18, 2012   //   by Karen Lopez   //   Blog, Data, Data Modeling, Events, Training  //  1 Comment

image

I’ll be leading two data modeling courses in Des Moines, Iowa the first week of October. Register now as spots are limited. 

Basic Data Modeling: For New Data Modelers

Registration and Networking: 7:45 AM Monday

Monday and Tuesday 8:00 AM to 5:00 PM and Wednesday 8:00 AM to Noon

In this introductory workshop, Karen Lopez covers the theory and skills required to being working on data models in an enterprise environment on modern project teams.

Format

With demonstrations and several exercises, this training course provides the basics and tests attendees to demonstrate their new skills. This course follows a workshop format, with both individual and team exercises.

…but this isn’t your average "Here are all the Normal Forms, now go create a model" course.  Our goal is to make data modeling relevant to modern development practices and tools.  We’ll talk about some of the pain points modelers feel, why developers and DBAs sometimes don’t see the same beauty in our data models and how to ensure everyone, IT and business, sees the value of data modeling and data modelers.

Participant Pre-requisites

As a basic course, it is not expected that attendees will significant data modeling experience.  However, we do expect them to have more than two years of hands-on information technology skills at the enterprise level.   We offer advanced courses for those who do have data modeling experience.  It is also common for attendees of the Basics course to sit in on the Advanced courses to get a better understanding of the issues that experienced data modeler see on a regular basis.


Advanced Data Modeling: Be Happier, Add More Value and Be More Valued

Registration and Networking: 12:45 PM Wednesday

Wednesday 1:00 PM to 5:00 PM and Thursday 8:00 AM to 5:00 PM

In this advanced workshop, Karen Lopez covers how to make data modeling more relevant in 2012 and removing pain points for modelers and other team members.   It includes how to be successful in an agile/scrum environment, how to make models valuable in a NoSQL project, how to better work with DBAs, Developers, Project Managers and how to sound and be more valuable.

Format

With demonstrations, exercises and peer-discussions its goal is to give attendees the attitude and skills to add value and be more valued on modern project teams.  This course follows a workshop format, with both individual and team exercises.

Participant Pre-requisites

As an advanced course, it is expected that attendees will have more than two years of hands-on data modeling and database design skills at the enterprise level.   We offer a basics course for those who do not have this experience or feel they need a refresher before participating in this course.


Instructor Bio

Karen Lopez is a Sr. Project Manager and Architect at InfoAdvisors. She has 20+ years of experience in project and data management on large, multi-project programs.  Karen specializes in the practical application of data management principles. She is a SQL Server MVP, an advisory board member for Zachman International, and an Advisory Committee member of DAMA International.

Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com.


Fees

Intro class: $500 for DAMA members, $550 for non-members

Advanced class: $300 for DAMA members, $350 for non-members

Data Modeling Essentials, 3rd Edition,Graeme Simsion,Graham Witt,ISBN9780126445510Important: Karen strongly recommends purchasing a copy of Data Modeling Essentials 3rd Edition by Graeme Simsion and Graham Witt. These classes will be based on this book.

See DAMA Iowa event page for information about registration and cancellation policies.


Get Hands On with SQL Server 2012 – Virtual Labs

Feb 3, 2012   //   by Karen Lopez   //   Blog, Data, Database, Professional Development, SQL Server  //  1 Comment

Want to get your hands on SQL Server 2012 right now?  You can be up and running without needing a server or to install SQL Server locally.  Just visit SQL Server Virtual Labs (use IE)  and choose a lab to get started.  The labs run in a virtual machine, so these aren’t just slides and a demo.  This is real, hands-on working with the tools.  Here’s your chance to get up to speed on SQL Server before the other 99%. Smile.

You can get real experience with new SQL Server 2012 features such as:

  • AlwaysOn, SQL Server’s new High Availability feature.  I have to say this is fun to play with.  Pull the plug and watch SQL Server gracefully fail over.  Like nothing happened at all.  Monitor the status of all the AlwaysOn components.  Very cool stuff here.
  • Master Data Services, SQL Server’s new feature for managing reference and master data.
  • Data Quality Services, a new feature for helping you Love Your Data even more.
  • Sparklines and Data bars, new data visualization features.
  • Columnstore Indexes, SQL Server’s new feature to make queries just fly.
  • Spatial and Location Services for mashing your data up with location based services.

 

image

image

While you are running the VM set up, register for the SQL Server 2012 Launch events coming in March in the US.  I hope to make it to one or two of those.

Pages:12»

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1