- udemy classes --- most of these classes I don't want. Not beginner.
- https://www.udemy.com/beginners-guide-to-postgresql/
- https://www.udemy.com/python-programming-with-postgresql/
- https://www.udemy.com/learn-database-design-using-postgresql/learn/#/
- https://www.udemy.com/draft/371372/learn/#/
- PostgreSQL: Learn how to deploy Streaming Replication
- I wanted to learn about the latest replication in postgresql. I don't think it is as good as MySQL. I have to do some tests.
- Note: http://www.thatguyfromdelhi.com/2014/12/postgresql-certification.html
- Certifications
- PostgreSQL 9.5 Associate Certification
- PostgreSQL 9.5 Professional Certification
- http://www.enterprisedb.com/store/products/dba-training/01t50000001NyiCAAS
- This might require an expensive ridiculous class.
- BrainMeasures -- they have two free tests. Might as well take before the others.
- Login first.
- http://www.brainmeasures.com/online/newtests/217/postgresql-certification.aspx#qq
- http://www.odesk-tests.net/odesk-test-answers/databases/postgresql-test-answers-2016.html
- You can use that to cheat, but I don't recommend do.
- http://www.brainmeasures.com/online/newtests/692/postgresql-8-1-3-certification.aspx#qq
- Even though its oracle, postgresql is copied from it a lot:
- http://www.tutorialspoint.com/sql_certificate/index.htm
- Cheating -- not sure which tests these are for, but you should study the things that you didn't know.
- http://www.odesk-tests.net/odesk-test-answers/databases/postgresql-8_1_3-test-answers-2015/questions.html
- http://www.odesk-tests.net/elance-test-answers/it-programming/postgresql-answers-2015.html
- http://www.odesk-tests.net/odesk-test-answers/databases/postgresql-rdbms-test-answers-2015.html
Friday, March 18, 2016
PostgreSQL certification (status: passed)
You can now get postgresql certification online for the associate and then the advanced for $200 each. I am not sure of the process.
Monday, March 7, 2016
Mongo certification (status: passed one test, will do the other someday)
UPDATE: Got the mongo dba certifcation. Now I want to get the dev one too.
I will be doing two things here. Listing the urls for sample tests and good reading material. And, setup step by step example of stuff to do to learn it.
NOTE: The mongodb certification exams are once a month. I highly recommend taking the free courses at https://university.mongodb.com/courses/catalog which will help with certification. Here's also a trick. The certification exams are $150. A class is thousands of dollars. Take it, fail it, learn what you were weak on, take it again. That's what I did for the MySQL certifications, but I usually passed them the first time. Out of 6 MySQL exams, I barely didn't pass one, studied it, and took it again. Much cheaper than thousands of dollars on courses. I will do the same for Mongo certifications, so we will see how I do on the exams. I have lots of previous Mongo experience, so that helps.
I will rate these links when I get done with them.
I will be doing two things here. Listing the urls for sample tests and good reading material. And, setup step by step example of stuff to do to learn it.
NOTE: The mongodb certification exams are once a month. I highly recommend taking the free courses at https://university.mongodb.com/courses/catalog which will help with certification. Here's also a trick. The certification exams are $150. A class is thousands of dollars. Take it, fail it, learn what you were weak on, take it again. That's what I did for the MySQL certifications, but I usually passed them the first time. Out of 6 MySQL exams, I barely didn't pass one, studied it, and took it again. Much cheaper than thousands of dollars on courses. I will do the same for Mongo certifications, so we will see how I do on the exams. I have lots of previous Mongo experience, so that helps.
I will rate these links when I get done with them.
- Mongo study guides (need to rate these two --- the videos and such)
- https://university.mongodb.com/exam/C100DEV/2016_March/guide
- https://university.mongodb.com/exam/C100DBA/2016_March/guide
- http://www.brainmeasures.com/online/tests/2718/mongodb-test.aspx#qqq
- http://www.menprojects.com/class_notes/EXAMS/brainmeasures_notes.txt
- They try to get you to pay $50 for a lot of questions that were taken from the manual. But to give them credit the test is free and good practice.
- Register first.
- Take test, copy the image locally, copy the webpage of the test results locally.
- Don't buy certificate. I don't think $50 is worth. Good free test but not a great certification test.
- http://www.tutorialspoint.com/mongodb/mongodb_overview.htm
- Good basic review. Go through and do all their examples.
- http://www.sanfoundry.com/1000-mongodb-questions-answers/
- Good questions. I suggest to go over the questions and focus on topics you are weak at.
- https://quizlet.com/32272213/mongo-flash-cards/
- These aren't that great.
- Cheating -- not sure which tests these are for. Study what you don't know
- http://www.odesk-tests.net/elance-test-answers/it-programming/mongodb-answers-2015.html
- http://www.odesk-tests.net/elance-test-answers/it-programming/mongodb-answers-2015/questions.html
----------------------------------------------
All of these steps below will be linked to a file. I havent started it yet as I am looking at the links above, but I will note when I start them and put in the link.
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv EA312927
echo "deb http://repo.mongodb.org/apt/ubuntu trusty/mongodb-org/3.2 multiverse"\
| sudo tee /etc/apt/sources.list.d/mongodb-org-3.2.list
sudo apt-get update
#sudo apt-get install -y mongodb-org
sudo apt-get install -y mongodb-org=3.2.4 mongodb-org-server=3.2.4 mongodb-org-\
shell=3.2.4 mongodb-org-mongos=3.2.4 mongodb-org-tools=3.2.4
Step 1. Setup a standalone mongo on port 3000.
Step 2. Setup 5 mongo node cluster on same machine. 3 config servers. 1 mongos.
Step 3. Start practice stuff.
----------------------------------
Other stuff
----------------------------------
Other stuff
- Leanr mongo chef. It is free for non commercial use. Might as well.
- http://3t.io/mongochef/download/
- https://www.mongodb.com/collateral/quick-reference-cards
- Memorize these after a little practice with each of the sections.
Subscribe to:
Comments (Atom)