| Author |
 Topic  |
|
|
fazsnatch
Starting Member
4 Posts |
 Posted - 02/29/2012 : 06:31:03
|
Hi all,
I am just starting my training in SQL server 2008. I was hoping to get some advice on where to go and what are key factors to learn regarding this and also any good source of content. What sort of time frame would you also look to get to know the basics?
I am taking this course listed below, any advice what to look out for and where to go from. Any help and advice be much appreciated.
quote:
You Will Learn How To
Build and manage SQL Server 2008 databases
Retrieve and manipulate data with SQL queries
Integrate SQL Server with .NET, Microsoft Office and XML
Secure and monitor databases with Management Studio
Replicate data over multiple servers with merge replication
Transform data into strategic information using business intelligence processes
Course Benefits
SQL Server 2008 offers a progressive and powerful way to manage your organisation's information. A robust and scalable enterprise solution, SQL Server 2008 extends the features of SQL Server 2005 and improves application development time and cost management. This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and replicating data over multiple servers.
Who Should Attend
Those who are new to Microsoft SQL Server. Familiarity with relational databases is helpful.
Hands-On Training
Throughout the course, you gain extensive experience with SQL Server 2008. Practical exercises include:
Installing SQL Server 2008 R2
Creating tables and constraints
Manipulating data with SQL
Integrating SQL Server with Office
Securing access to SQL Server from intruders
Backing up databases to prevent disasters with the Maintenance Plan Wizard
Replicating data between multiple databases
Rendering a report with Reporting Services
Course Content
Getting Started with SQL Server 2008
Overview of SQL Server architecture
Fundamentals of relational databases
Client/server model
SQL Server 2008 editions
Standard
Enterprise
Workgroup
Express
Compact
Developer
SQL Server components and tools
SQL Server Management Studio
Management reports
Business Intelligence Development Studio
SQL Server Agent
Database engine
Constructing the Database
Creating a database
Choosing files and directories
Allocating file size and growth parameters
Implementing database schemas
Designing tables
Analysing various datatypes
Defining column attributes
Indexing tables with Management Studio
Adding, deleting or changing columns
Protecting data with constraints
Enforcing uniqueness with primary key constraints
Check constraints to validate conditions
Building relationships with foreign keys
Server-Side Programming
Data retrieval with Transact-SQL
Leveraging Query Designer to construct SQL statements
Writing multiple table join queries
Aggregating data for business analysis
Modifying data
Adding new rows with the INSERT command
Changing targeted data with UPDATE
Deleting specific rows
Programming constructs
Writing stored procedures for performance and productivity
Capturing change events with triggers
Simplifying data access with user-defined functions
Integrating with Client Applications
Connecting to SQL Server
Authenticating with SQL Server and Windows logins
Programming client applications
Interacting with Microsoft Office
Pulling data from SQL Server into Excel
Migrating an Access database to SQL Server
Leveraging XML and .NET features
Retrieving data in XML form
Utilising a .NET CLR component
Administering SQL Server 2008
Securing the database infrastructure
Controlling access to SQL Server
Granting or revoking permissions
Defining roles and user memberships
Running the Maintenance Plan Wizard
Automating backups by scheduling jobs
Checking database integrity and defragmenting data
Notifying operators via e-mail
Monitoring SQL Server activity
Viewing locks and queries
Requesting management reports with Management Studio
Sharing Data through Replication
Defining the replication architecture
Snapshot
Transactional
Merge replication
Choosing a replication strategy
Configuring merge replication
Distributing published data
Subscribing to a publication
Business Intelligence Components
Transforming data with Integration Services
Importing and exporting files
Moving and denormalising data into a data warehouse
Producing information with Analysis Services
Building multidimensional cubes
Predicting trends with data mining
Information delivery with Reporting Services
Designing reports quickly with the Report Wizard
Deploying reports to a Report Server for centralised access
http://www.learningtree.co.uk/courses/uk137.htm
|
|
|
TG
Flowing Fount of Yak Knowledge
USA
5469 Posts |
Posted - 02/29/2012 : 13:21:02
|
Start doing actual projects and overcome problems. Find a company that will hire you as an entry level DBA or sql developer. You can't cheat experience.
Good references:
sqlteam.com
BooksOnline
sqlservercentral.com
stackoverflow.com
Be One with the Optimizer
TG |
 |
|
|
Transact Charlie
Flowing Fount of Yak Knowledge
United Kingdom
3433 Posts |
Posted - 02/29/2012 : 13:38:23
|
download an evaluation version of sql server (they are free for about 180 days).
Follow this site and look at the questions people ask. when experts post answers they will usually post some sample data and sql statements. copy those into your local database and see what's happening.
Ask questions.
Eventually try to answer other people's questions.
there is no quicker or better way. In my experience a lot of the courses out there are garbage.
Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
fazsnatch
Starting Member
4 Posts |
Posted - 03/01/2012 : 05:16:55
|
| Do you know where i can find the evaluation for the server and where to check for examples mate? Thanks |
|
|
|
Transact Charlie
Flowing Fount of Yak Knowledge
United Kingdom
3433 Posts |
|
|
fazsnatch
Starting Member
4 Posts |
Posted - 03/01/2012 : 06:14:53
|
Thanks for the help with this. Do you know if i can get a dummy database to mess about with on that 20008r2 evaluation edition?
Cheers |
|
|
|
chris_cs
Posting Yak Master
United Kingdom
223 Posts |
Posted - 03/01/2012 : 06:16:33
|
You can download the AdventureWorks database from the Microsoft site.
----------------------------
Junior DBA learning the ropes |
|
|
|
malachi151
Posting Yak Master
142 Posts |
|
|
Transact Charlie
Flowing Fount of Yak Knowledge
United Kingdom
3433 Posts |
Posted - 03/01/2012 : 09:38:41
|
The reason I'd advise the evaluation version is that it's feature complete -- you can do anything you can do in developer or enterprise. Express doesn't give you the complete toolchain especially for BI.
If 180 days isn't enough then you should buy the developer edition (it's like £20 or something).
Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
| |
Topic |
|
Beginner to SQL - Looking for Advice?
