March 8, 2011 at 1:17 am
hi, i'm biggner in sql i want some one who help me the steps of building a database
for ex: what is scheme used for and what are the components of a database for having an interface
please don't suggest me to read tutorials i want some one to be my teacher,
thanks
March 8, 2011 at 1:37 am
I would suggest you to do your own research/self learning first. Forums are basically for discussions. I guess many would agree with me.
M&M
March 8, 2011 at 2:41 am
hello mohemmed!
you are right,
but i hade some tutorials and video tutorials but just they teach sql language not any thing more
i want someone tell me what are queries used for what are the steps...
March 8, 2011 at 3:10 am
Forums work best best on a question response basis. You provide a well formulated question, we try to respond with an answer. Its a simple formula that has been tried out in many places and seems to work.
Now, if you go to a mechanic and say to him 'build me a car - for free', it is unlikely that he will be able to help. If you ask him what the optimum pressure for a tyre is, he is more likely to help as the question is well formulated and narrow in scope. It is possible to give a distinct answer.
Now from your last post you have a distinct question:'what are queries used for...'. To this, I would respond that they are the basis upon which a DBMS will return results from the available data . The query is the question, the result is the answer. A bit like what I alluded to in the first paragraph. Can you see what I am getting at?
'i hade some tutorials and video tutorials but just they teach sql language '
The those tutorials are a good start. Now if you have mastered one of the fundamentals of a DBMS, you should be able to narrow your focus in terms of what you want to learn. Again, ask a specific question and you may get an answer.
As for your initial post, 'i want some one to be my teacher'. This is possible however you will need to pay for a course. You are unlikey to get that type of help from a volunteer forum.
March 8, 2011 at 3:29 am
soufya91 (3/8/2011)
please don't suggest me to read tutorials i want some one to be my teacher
Allright, I'll be your teacher.
You can pay me with PayPal if you want 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2011 at 3:57 am
To use the anology of the car from a previous post, would you expect to go onto the internet and expect someone t be able to teach you how to build a car?
The only way to learn is by reading books/articles on basic concepts, experimenting, and then get a good mentor in your first job.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
March 8, 2011 at 4:25 am
soufya91 (3/8/2011)
please don't suggest me to read tutorials i want some one to be my teacher
How much are you willing to pay for teacher? Please remember we're all volunteers here, we all have our own jobs.
Are you interested in the development side or administrative side?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2011 at 4:28 am
please it is not building a car !
i had draw ER-D and relationships and i installed sql server mangement studio i know the languages but infact i cannot organize gradually build it
ok for all of answers bye i'll choose another where:cool:
March 8, 2011 at 4:35 am
soufya91 (3/8/2011)
i know the languages but infact i cannot organize gradually build it
Sorry, don't understand what you're saying.
I also don't understand what you're looking for. Development or administration? Designing new databases or querying existing ones? Please be specific, the vaguer the question the harder it is to answer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2011 at 5:26 am
soufya91 (3/8/2011)
hi, i'm biggner in sql i want some one who help me the steps of building a databasefor ex: what is scheme used for and what are the components of a database for having an interface
please don't suggest me to read tutorials i want some one to be my teacher,
thanks
I'll to help a bit.
A schema is all about ownership. Defining a schema is defining a place where objects are owned by the schema. This can be used to isolate certain applications or certain security. It really depends. In general, I recommend using them because just placing everything under the DBO (database owner) schema is lazy.
The thing that people were trying to tell you is, teaching you everything you need to know about SQL Server through a forum is going to be very hard. No one was trying to chase you away. They were trying to set your level of expectations. If you have specific questions, please post them and people will pitch in and help out.
Since you're just getting started, I'd recommend getting a copy of "Beginning SQL Server 2008 Administration." I wrote three of the chapters in the book. It's a decent introduction to the work and concepts of being a DBA.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply