Sunday, August 23, 2015

Tutorial : Getting Started with SQL and Database Basics in Minutes



This video tutorial demos how to get started with SQL and practice it easily in a browser / on the web without installing additional database components. It also provides an intuitive example and analogy for beginners to visualize database and database tables using Excel. I did a quick walkthrough of how to use W3School's Try SQL feature to practice SQL language on the web.

Essential Product Management Skills | How to Become a Product Manager in Silicon Valley

This is a short list of essential skills that a product manager in Silicon Valley will want to have. Ideally, the candidate has a lot of experiences and a computer science degree if he/she wants to work for Google / Facebook. This is a first post, will add follow-up posts about 1. a day in life of a product manager 2. interviews of high paying Silicon Valley product managers 3. sample interview questions.

In practice, you don't have to have all skills. Experiences and results really speak louder than a traditional resume. In a later post, we will cover the "touchy feely" "soft" side of Product Management. Comment and ask questions below.

Skills & Tasks
Wireframing prototyping skills
Web analytics skills
Marketing, campaigning the product, Public Relations (PR), "getting the word out"
Product marketing, publicity
Managing prioritizing backlog
Presenting roadmap, flow chart
Engineering estimates
Leading teams
Gathering and researching inputs from stakeholders and customers:

  • From internal teams such as sales, business development, marketing etc.
  • From customers through customer research, define target customers and personas
  • On external market forces such as competition, market dynamic etc.


Deliverables
Product vision
Feature requirements
MVP wireframes (product feature list)
Minimum Viable Product (MVP)
Roadmap
User flow chart
Use cases, epics
Presentation
Product launch plan
Product description
Product release (beta programs)

Testing
User testing
Functional testing

Tools & Techniques
Agile tools and techniques
Waterfall versus agile
PM best practices

Managing / Coordinating people
Designers
Engineers
Product development teams
Stakeholders
Product owners


Beginner Tutorial: Getting Started with AngularJS Hello World in Minutes



This demo tutorial (as opposed to follow-along tutorial) shows that you can hook up AngularJS to your html file in just minutes. Things we cover including how to start the ng-app, evaluate an expression {{ 1+2 }}, set up a controller, even debugging AngularJS.

AngularJS is a big topic and I am not the best developer to explain it. However, I want to demo that just like jQuery, AngularJS requires some initial setup. It takes a bit of muscle memory to get used to. After that, you can start your AngularJS app quickly, and take your time to get better at it.

FAQ


Why do we use a Mac?
Many modern web developers use Mac for various reasons. For beginners, it's easy to program on Macs. The configuration and setup is usually smooth. Some languages are preinstalled and readily available like Ruby and Python.

Why do we use Sublime?
It's a free powerful and clean-cut text editor, which makes it great for beginners.

Why do we use CDN or a hyperlink for the AngularJS source code?
It's easy, readily available, optimized. We don't have to download a copy of the source code and that's nice.

How to debug AngularJS?
AngularJS is JavaScript after all. For beginners, console.log is always your best friend. Use console.log often to make sure your scripts and code is connected.

Comments

  • We like to use a basic expression {{ 1+2 }} that AngularJS can compute to demonstrate that AngularJS code is connected successfully.  We think an AngularJS hello world example is to make this expression evaluate to 3.