| Author |
Topic |
|
fazsnatch
Starting Member
4 Posts |
 Posted - 2012-02-29 : 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 ToBuild 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 BenefitsSQL 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 AttendThose who are new to Microsoft SQL Server. Familiarity with relational databases is helpful.Hands-On TrainingThroughout 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 ContentGetting Started with SQL Server 2008Overview of SQL Server architectureFundamentals of relational databases Client/server model SQL Server 2008 editionsStandard Enterprise Workgroup Express Compact Developer SQL Server components and toolsSQL Server Management Studio Management reports Business Intelligence Development Studio SQL Server Agent Database engine Constructing the DatabaseCreating a databaseChoosing files and directories Allocating file size and growth parameters Implementing database schemas Designing tablesAnalysing various datatypes Defining column attributes Indexing tables with Management Studio Adding, deleting or changing columns Protecting data with constraintsEnforcing uniqueness with primary key constraints Check constraints to validate conditions Building relationships with foreign keys Server-Side ProgrammingData retrieval with Transact-SQLLeveraging Query Designer to construct SQL statements Writing multiple table join queries Aggregating data for business analysis Modifying dataAdding new rows with the INSERT command Changing targeted data with UPDATE Deleting specific rows Programming constructsWriting stored procedures for performance and productivity Capturing change events with triggers Simplifying data access with user-defined functions Integrating with Client ApplicationsConnecting to SQL ServerAuthenticating with SQL Server and Windows logins Programming client applications Interacting with Microsoft OfficePulling data from SQL Server into Excel Migrating an Access database to SQL Server Leveraging XML and .NET featuresRetrieving data in XML form Utilising a .NET CLR component Administering SQL Server 2008Securing the database infrastructure Controlling access to SQL Server Granting or revoking permissions Defining roles and user memberships Running the Maintenance Plan WizardAutomating backups by scheduling jobs Checking database integrity and defragmenting data Notifying operators via e-mail Monitoring SQL Server activityViewing locks and queries Requesting management reports with Management Studio Sharing Data through ReplicationDefining the replication architectureSnapshot Transactional Merge replication Choosing a replication strategy Configuring merge replicationDistributing published data Subscribing to a publication Business Intelligence ComponentsTransforming data with Integration ServicesImporting and exporting files Moving and denormalising data into a data warehouse Producing information with Analysis ServicesBuilding multidimensional cubes Predicting trends with data mining Information delivery with Reporting ServicesDesigning reports quickly with the Report Wizard Deploying reports to a Report Server for centralised access
http://www.learningtree.co.uk/courses/uk137.htm |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-02-29 : 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.comBooksOnlinesqlservercentral.comstackoverflow.comBe One with the OptimizerTG |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-02-29 : 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 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
fazsnatch
Starting Member
4 Posts |
Posted - 2012-03-01 : 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
Master Smack Fu Yak Hacker
3451 Posts |
|
|
fazsnatch
Starting Member
4 Posts |
Posted - 2012-03-01 : 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
223 Posts |
Posted - 2012-03-01 : 06:16:33
|
| You can download the AdventureWorks database from the Microsoft site.----------------------------Junior DBA learning the ropes |
|
|
|
malachi151
Posting Yak Master
152 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-03-01 : 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 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
Beginner to SQL - Looking for Advice?