All You Need To Know About A Career In SQL - PowerPoint PPT Presentation

About This Presentation
Title:

All You Need To Know About A Career In SQL

Description:

SQL means Structured Query Language. It is a domain-specific language which is used for communications and also manipulation of data which is stored in the RDBMS database. – PowerPoint PPT presentation

Number of Views:61
Slides: 12
Provided by: janbasktraining

less

Transcript and Presenter's Notes

Title: All You Need To Know About A Career In SQL


1
All You Need To Know About A Career In SQL
2
SQL is Never Less
  • What is SQL Server?
  • Role of the Database Administrator
  • How to become a SQL Consultant or a DBA?
  • Skills Required
  • Importance of Training and Certifications

3
What is SQL Server?
It is software which is run on the Windows Server
and allows its users to both stores and fetch
data in a database using the TSQL language. It is
rare that end users have to directly interact
with SQL Server, but they can only access data in
the form of reports, web pages, and some other
applications. The Database Administrators make
use of the SQL Server Management Studio for
looking after the software.
4
Role of the Database Administrator
5
How to become a SQL Consultant or a DBA?
The most difficult aspect of becoming a DBA is
getting the first employment opportunity as there
are hardly any businesses who will want to hire a
fresher with no previous work experience and give
access to the most prized possession of a
business-its data.
6
Skills Required
7
DBA For A Beginner
Training Error
  • Installation of SQL Server and application of the
    latest service pack in addition to setting up
    jobs and email notifications.
  • Creation and management of users, logins, and
    other roles at the database level.
  • Should have thorough knowledge about GRANT,
    REVOKE and DENY.
  • Creation and modification of tables, views,
    functions, etc.

8
Importance of Training and Certifications
  • It is not necessary that you have to take
    training for the above as many successful DBAs
    have taken up skills by themselves reading from
    books or online videos at their own pace and
    availability.
  • If this is not your cup of tea and you need to be
    coached, then you may prefer short courses which
    focus on SQL Server administration.
  • It is quite obvious that you will not be able to
    become a master in 5 days, but the course will
    put you on the right track as it will act as a
    first step in the learning curve.
  • If you are already employed the high course fee
    is shared by the employers.

9
Estimating Error Rates IV
Bootstrap
  • Works well with small data sets
  • Samples the given training tuples uniformly with
    replacement
  • i.e., each time a tuple is selected, it is
    equally likely to be selected again and re-added
    to the training set

Several boostrap methods, and a common one is
.632 boostrap
  • Suppose we are given a data set of d tuples. The
    data set is sampled d times, with replacement,
    resulting in a training set of d samples. The
    data tuples that did not make it into the
    training set end up forming the test set. About
    63.2 of the original data will end up in the
    bootstrap, and the remaining 36.8 will form the
    test set (since (1 1/d)d e-1 0.368)
  • Repeat the sampling procedue k times, overall
    accuracy of the model

10
Conclusion
There is a lot of scope for a career in SQL as it
finds use in multiple domains. You have to
acquire suitable skills and certifications to be
able to enter the job market. As most
organizations hire only one DBA, so the choice is
a vital one for them. It is a known trend that
mostly such vacancies are filled from the
existing staff members who were working on
different roles but have acquired the DBA skills
along with their career.
11
Thank you
Happy learning
Write a Comment
User Comments (0)
About PowerShow.com