Transcript SQL_Starter_-_Database_Developersx

SQLSTARTER - INTRO TO
DATABASE DEVELOPMENT
Kevin Kline
•
•
•
•
Technical Evangelist, SQL Sentry
SQL Server MVP since 2003
Twitter, FB, LI, KEKline
Blog: http://blogs.sqlsentry.com/KevinKline
Tuning blog: http://www.sqlperformance.com/
Normally $10. Get them free at http://SQLSentry.com/ebooks.
Book a one-on-one demonstration at
www.sqlsentry.com/BookADemo!
FREE!
AGENDA
• Introductions
o Database developer as a career
o A day in the life of a database developer
o Required skills
• Wrap-up
DATABASE DEVELOPER AS A CAREER
• Wages?
• Work?
Percentile
10%
25%
Hourly Wage
$21.37
$44,450
$28.97
$60,250
Annual Wage
50%
(Median)
$38.24
$79,530
75%
90%
$49.79
$103,570
$62.89
$130,800
o Create, modify, and test the code, forms, and scripts that allow database
applications to run.
o Work from specifications drawn up by dev, database, or PM leads.
o May assist in analyzing user needs and designing database solutions.
o May develop and write database-centric programs to store, locate, and
retrieve specific data, reports, and ETL processes.
• More details? Check the Bureau of labor statistics at
http://www.bls.gov/oes/current/oes151131.htm
PATHS FORWARD
Consulting
Sr DBA
Enterprise
Architect
Business Intelligence
DBA
DB
Dev
Management
A DAY IN THE LIFE…
• Work as part of a team, rarely solo.
• Spend most of your day writing T-SQL code,
reports or stored procedures, and designing
SSIS packages
• Administrivia
REQUIRED SKILLS: TECH
• Technical:
o Reading database models
o Documenting building database metadata and processes
o SQL, SQL and more SQL:
• Stored procedures
• Queries & transactions
• Performance tuning
o Possibly SSIS packages
REQUIRED SKILLS: INTERPERSONAL
• Interpersonal:
o Strong writing skills
o Good interpersonal communication skills
o Prioritization
o Research
NEXT STEPS?
• Engage with the local community:
o IndyPASS.org meets the 2nd Tuesday of each month
o A likely source for your next gig
• Don’t stop learning!
o SQLPASS.org virtual chapters present many webinars each month
o SQLPASS.org Summit and virtual chapter webinar recordings
o Other great webinar/video resources:
• MSSQLTips.com, PragmaticWorks.com, Microsoft Virtual Academy, SQLSentry.TV
o Great content resources:
• SQLServerCentral.com, Red-Gate and Simple-Talk.com (amazing eBooks!), SQLBlog.com,
SQLPerformance.com, SQLMag.com
o Great help resources:
• Dba.stackexchange.com, answers.sqlperformance.com, #sqlhelp on Twitter
• Don’t neglect interpersonal skill development!
WRAP-UP
Let’s connect!
Facebook, LinkedIn, Twitter
at KEKLINE.
Email at
[email protected]
Blogs at
http://blogs.sqlsentry.com/
kevinkline
Q&A
PLEASE FILL OUT THE SESSION EVAL!
• Send questions to me at: [email protected]
• Twitter, Facebook, LinkedIn at KEKline
• Slides at http://blogs.sqlsentry.com/kevinkline/ and lots at
http://slideshare.net/kkline84
• THANK YOU!