Mike Isano wrote:Don't bother with the exam. Most employers are using Microsoft SQL Server or Oracle. Just download the free versions of each, and start playing. Learn about database design as well as how to make backups, etc.
Jeanne Boyarsky wrote:If you want to be a software developer, I would say no. If you want to maintain databases, I would start with a different one as Mike noted.
Rahul Sudip Bose wrote:True, but i also see some job ads that say "PHP and MySQL". Is there any cert in oracle or ms-sql ? Can you suggest some books/links to begin the same ?
Why are ms-sql and oracle more popular than my-sql ?
Rahul Sudip Bose wrote:I dont know much about DB, so please bear with me if the doubts sound silly. I want to use/apply DB and perhaps have some knowledge of its internals but not make one. (Like knowing how to drive a car, few things inside the hood...but i dont want to be an automobile engineer ) What is meant by "maintaining a DB" ?
Jeanne Boyarsky wrote:
My concern about certifying in a database is that is sends the wrong message. If you do get one, make sure it is clearly a developer certification and not an administration one.
Jeanne Boyarsky wrote:
A DBA (database administrator) may code stored procedures/sql, but is not generally a developer. Here's a list of some DBA responsibilities.
Jeanne Boyarsky wrote:... Why train someone who is going to leave?
chris webster wrote:....
chris webster wrote:Finally, I'm guessing that Jeanne simply meant that if your certificates tell people you're a "DBA", but you apply for a "developer" job, they may wonder if you really want to be a developer or a DBA. So forget about the certificates right now, and don't worry too much about all this stuff, just grab whichever DB seems suitable for you and get started!
Rahul Sudip Bose wrote: But i was wondering why does oracle offer MySQL also when its not the first preference of corporates ?
Rahul Sudip Bose wrote:Saw some sites from the search...deleted MySQL.
--Now what to learn - oracle express or ms-sql express ?
--Do the free editions prepare one for handling the paid versions OR are they just "toy" versions and i will have to learn the paid versions from scratch, once in a job ?
--Which is easier for newbies to DB ?
--Do i have to learn about DB first(from say, korth & silberstaz) or i can jump directly to oracle or ms ?
Use MySQL client programs to interface with the MySQL Server interactively and in batch
Describe SQL Modes and their impact on behavior of MySQL
Identify characteristics which have session scope
General MySQL Syntax
Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
Identify MySQL data type properties and appropriate usage
Recognize and use common functions and expressions for all MySQL data types
Identify and use comment syntax
Describe and utilize prepared statements
Describe transactions and transaction isolation levels and the impact they have on database behavior
Creation and Design of MySQL Schema Objects
Design and create normalized databases
Create and modify tables using appropriate data types and indexing
Describe and create table constraints enforcing data integrity
Creating and modifying views
Identify and use various methods to obtain metadata for MySQL database objects
Creation, Design and Use of MySQL Stored Programs
Describe and use triggers
Create and execute stored procedures
Create and use stored functions
Implement error handling within stored procedures
Querying for Data
Execute a basic SELECT statement
Limit rows returned by a SELECT statement
Limit columns returned by a SELECT statement
Apply sorting to SELECT statement results
Execute SELECT statements which aggregate and group data
Describe and execute INSERT statements
Describe and execute REPLACE statements
Describe and execute UPDATE statements
Describe and execute TRUNCATE statements
Describe and execute LOAD DATA statements
Describe and execute DELETE statements
Joins, subqueries and UNION
Identify, describe and use JOINs in MySQL commands
Describe and utilize subqueries in MySQL commands
Perform operations using UNION clause
MySQL Application Development
Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
Write a basic Java application that uses MySQL
Write a basic PHP application that uses MySQL
Write a basic .NET application that uses MySQL
Interpret MySQL error messages
Collect available diagnostic information
Describe and use NoSQL and memcached API
Identify statements requiring optimization
Recognize and create optimal indexes for query optimization
Recognize and fix sub-optimal SQL commands
Identify appropriate optimization strategies for InnoDB usage
Optimize performance through data normalization
permaculture is largely about replacing oil with people. And one tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koophttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton