Lynda.com - SQL Server 2008 Essential Training
Category: Tutorials
- views: 3 810
- date: 8 June 2011
- posted by: danithe

In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server’s database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.
Topics include:
* Using T-SQL (Transact-SQL)
* Managing databases with SQL Server Management Studio
* Understanding database normalization
* Using SELECT statements
* Building indexes
* Monitoring database size and integrity
* Backing up and restoring databases
* Creating functions and stored procedures
* Managing database permissions
* Creating and formatting reports
* Adding charts to reports
* Creating and executing a simple SSIS package
Info:
http://www.lynda.com/SQL-Server-2008-tutorials/Essential-Training/71929-2.html
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm
Information |
|||
![]() |
Users of GUESTS are not allowed to comment this publication. | ||









