Kiran Vasadi | Google Cloud Platform | Azure HDInsight | BigQuery | BigData | Hadoop | HDFS|MapReducer | Sqoop | Hive | Hbase | SparK | Scala | Python | MySql | IBM Cognos | Tableau | Talend | Microsoft Power BI
Friday, 28 September 2018
Wednesday, 26 September 2018
SQL for Data Science
Here are some great SQL Resources to take your hashtag#DataScience game to the next level:
1. Learn the Basics
DataCamp – Intro to SQL for Data Science
https://lnkd.in/gyb4fAr
W3Schools – SQL Tutorial
https://lnkd.in/gxkbRzW
SQLZoo
https://sqlzoo.net/
SQLTeaching
https://lnkd.in/gtwvazf
SQLBolt – Interactive Tutorial
https://sqlbolt.com/
SQL Guide
https://towardsdatascience.com/sql-cheat-sheet-for-interviews-6e5981fa797b
2. Analytical Use-Case Problems
Mode – SQL Business Analytics Training
https://lnkd.in/gM8nMNP
Kaggle – SQL Scavenger Hunt
https://lnkd.in/gU6q7wf
3. SQL & Interviews
SQL – Basic Real World Scenarios
https://lnkd.in/gHJeyQA
How to Ace Data Science SQL Interviews
https://lnkd.in/gEEAAKn
45 Essential SQL Interview Questions and Answers
https://lnkd.in/gqUHGfP
- - -
SQL is one of the most powerful tools for many data scientists and will definitely help you build a foundation for your data science career.
We'll be providing a lot more resources for you, so get ready! And remember, we're always here to help :)!
Who are looking for Python and ML online resource.
Here are some great Python Resources to learn hashtag#DataScience and hashtag#MachineLearning:
- - -
Basics of Python Programming
a. Lists, Tuples, Dictionaries, Conditionals, Loops, etc...
https://lnkd.in/gWRbc3J
b. Data Structures & Algorithms
https://lnkd.in/gYKnJWN
d. NumPy Arrays: https://lnkd.in/geeFePh
c. Regex: https://lnkd.in/gzUahNV
Practice Coding Challenges
a. Hacker Rank: https://lnkd.in/gEufBUu
b. Codeacademy: https://lnkd.in/gGQ7cuv
c. LeetCode: https://leetcode.com/
Data Manipulation
a. Pandas: https://lnkd.in/gxSgfuQ
b. Pandas Cheatsheet: https://lnkd.in/gfAdcpw
c. SQLAlchemy: https://lnkd.in/gjvbm7h
Data Visualization
a. Matplotlib: https://lnkd.in/g_3fx_6
b. Seaborn: https://lnkd.in/gih7hqz
c. Plotly: https://lnkd.in/gBYBMXc
d. Python Graph Gallery: https://lnkd.in/gdGe-ef
Machine Learning / Deep Learning
a. Skcikit-Learn Tutorial: https://lnkd.in/gT5nNwS
b. Deep Learning Tutorial: https://lnkd.in/gHKWM5m
c. Kaggle Kernels: https://lnkd.in/e_VcNpk
d. Kaggle Competitions: https://lnkd.in/epb9c8N
- - -
Hope this helps! Python is definitely a handy tool to learn right now! Feel free to share your list of resources below. Stay tuned for more :)
Kiran Vasadi
Kiran Vasadi
Saturday, 22 September 2018
Google Cloud Architect Exam Study Materials
Google Cloud Architect Exam Study Materials
After recently completing the Google Cloud Architect certification, I wanted to share the preparation materials that I used. Due to the newness of the exam, one challenge is there is not the same abundance of preparation material as there is for other Cloud exams. The official Exam Guide leaves a bit to be desired and there is no official Practice Exam at the current time, so I hope this material is helpful for folks preparing.
I prepared through a combination of methods outlined below (in addition to real-world GCP usage):
After recently completing the Google Cloud Architect certification, I wanted to share the preparation materials that I used. Due to the newness of the exam, one challenge is there is not the same abundance of preparation material as there is for other Cloud exams. The official Exam Guide leaves a bit to be desired and there is no official Practice Exam at the current time, so I hope this material is helpful for folks preparing.
I prepared through a combination of methods outlined below (in addition to real-world GCP usage):
- Official GCP Documentation
- Google Cloud Next ’17 Conference Videos
- Coursera
- Linux Academy
This is probably a little overkill, but none of the aforementioned alone went into the depth in all of the areas that I had hoped. The answer was using the combination, and skipping areas in each that may have been redundant.
Official Documentation
This is the just the official Google Cloud Platform documentation: https://cloud.google.com/docs/.
Side-note: One thing I liked about the exam is that I didn’t feel like any of the questions asked me for point-in-time questions (i.e. what did this feature do when the exam was released versus what it may do now as of July of 2017). As a result, you can prepare well by reviewing the most up-to-date documentation without a fear that your knowledge will be too accurate. That’s kind of a silly thing to say, but other exams from other vendors do have questions where you have to answer them based on a previous point in time, even if the version of the exam and product still match.
Most of these documents are overviews or FAQs. You may want to branch off of them into deeper areas, but I felt the Product Overview and FAQs were solid. I reviewed the product documentation last of all of the study material I used, and mostly used it to fill in gaps of knowledge, though; if you review this material first, you may want to go deeper.
Overview
- https://cloud.google.com/docs/overview/
- https://cloud.google.com/docs/geography-and-regions
- https://cloud.google.com/docs/compare/aws/
Compute Engine
- https://cloud.google.com/compute/docs/regions-zones/regions-zones
- https://cloud.google.com/compute/docs/faq
- https://cloud.google.com/docs/choosing-a-compute-option
- https://cloud.google.com/compute/docs/instances/preemptible
App Engine
- https://cloud.google.com/appengine/kb/
- https://cloud.google.com/appengine/docs/the-appengine-environments
- https://cloud.google.com/appengine/docs/flexible/
- https://cloud.google.com/appengine/docs/standard/
- https://cloud.google.com/appengine/docs/glossary
Container Engine
Storage Decisions
Cloud Storage
Spanner
Cloud SQL
Bigtable
Datastore
- https://cloud.google.com/datastore/docs/concepts/overview
- https://cloud.google.com/datastore/docs/best-practices
Transfer Service
Networking
- https://cloud.google.com/compute/docs/vpc/
- https://cloud.google.com/compute/docs/load-balancing-and-autoscaling
- https://cloud.google.com/compute/docs/vpc/firewalls
- https://cloud.google.com/compute/docs/vpn/overview
Stackdriver Logging
- https://cloud.google.com/logging/
- https://cloud.google.com/logging/docs/basic-concepts
- https://cloud.google.com/logging/docs/view/logs_index
Stackdriver Monitoring
Stackdriver Error Reporting
Stackdriver Trace
- https://cloud.google.com/trace/
- https://cloud.google.com/trace/docs/faq
- https://cloud.google.com/trace/docs/reference/
Stackdriver Debugger
Endpoints
- https://cloud.google.com/endpoints/
- https://cloud.google.com/endpoints/docs/about-cloud-endpoints
- https://cloud.google.com/endpoints/docs/architecture-overview
Security Scanner
- https://cloud.google.com/security-scanner/
- https://cloud.google.com/security-scanner/docs/using-the-scanner
- https://cloud.google.com/security-scanner/docs/faq
Identity and Security
- https://cloud.google.com/security/
- https://cloud.google.com/compute/docs/access/
- https://cloud.google.com/docs/authentication/
- https://cloud.google.com/security/data-loss-prevention/revoking-user-access
- https://cloud.google.com/solutions/securing-gcp-account-security-keys
- https://cloud.google.com/security/security-design/
- https://cloud.google.com/iam/docs/overview
- https://cloud.google.com/iam/docs/faq
Identity-Aware Proxy
KMS
- https://cloud.google.com/kms/docs/object-hierarchy
- https://cloud.google.com/kms/docs/secret-management
Developer Tools
Resource Management
Deployment Manager
- https://cloud.google.com/deployment-manager/docs/fundamentals
- https://cloud.google.com/deployment-manager/docs/best-practices/
DataProc
DataFlow
Pub/Sub
Google Cloud Next Sessions
The sessions from Google Cloud Next are on YouTube now (217 of them), and if there are any areas where you feel you’d like a little more depth (e.g. App Engine, Cloud Storage, Datastore, Stackdriver), these sessions can be helpful. They’re also just all really good sessions in general. Even if you’re not preparing for the exam, I’d recommend watching as many of the videos as you can. I like to watch them at 2.0x speed for maximum productivity.
- Google Cloud Next 2017 Playlist: https://www.youtube.com/playlist?list=PLIivdWyY5sqI8RuUibiH8sMb1ExIw0lAR
Coursera
The Coursera courses are made available by Google to partners but are available for anyone. They have a couple of options for courses, but if you are a current AWS Certified Architect Professional then there is a course available based on that, which is what I took. It compares GCP products with AWS products and is slimmed down from the other option.
I thought it was a valuable course, but lecture videos were fairly short. Total lecture time was 121 minutes, but there are quizzes and labs. The non-AWS specific course appears to be a little longer.
- Coursera — Google Cloud Platform Fundamentals for AWS Professionals: https://www.coursera.org/learn/gcp-fundamentals-aws/
Linux Academy
I subscribe to Linux Academy because they have a ton of great courses in general even outside of GCP, but they also have several Google Cloud Platform courses available. Honestly, I only skimmed through the course because I had done all of the other preparation prior, but the material seems solid.
- Linux Academy — Google Cloud Platform Essentials: https://linuxacademy.com/cp/modules/view/id/133
Final Thoughts
Overall, I thought the exam was done well. It’s not too long, and the questions are good Architect-level questions: it’s about being able to architect solutions, not necessarily memorizing every low-level command. With that said, a few final thoughts as you prepare for the exam:
- As the official exam guide notes, there are Case Studies as part of the exam. I recommend preparing yourself by reading those and figuring out how to define the requirements in each and how those requirements match up to GCP services.
- Know this decision tree well, and understand when to use what:
- Don’t forget about services like Dataflow, Dataproc, Pub/Sub, and other Big Data concepts.
- Like with similar exams, there will be several good options and the best option. Make sure to really dive into each question to understand specific requirements that will help you determine which is best. You really need to know when to use X and when to use Y, even if Y would kind of work.
- Get into Google Cloud Platform and build something! There’s nothing better than real-world experience, and Google makes it really easy to get in and use the platform for free.
Subscribe to:
Posts (Atom)