Two-day Microsoft SQL Server 2008 Course

You will learn:

Day 1:

• What is SQL
• SQL Server 2008
• Editions of SQL Server 2008
• Documentation Conventions
• SQL Server Management Studio
• Object Explorer
• Object Explorer Details Page
• Configuring Startup Options
• Moving, Closing and Hiding Components
• Using Help - Launching Books Online
• System Databases
• Database Files
• Create a Database
• Detach and Attach Data Files
• Master database
• The contents of the sysdatabases table
• Table Design
• Fields Properties other than Name and data type
• Primary Key
• Data Entr - Enter Data using Microsoft SQL Server Management Studio
• SQL (Structured Query Language) and T-SQL
• Using T-SQL
• T-SQL Comments
• The Select statement
• Conditions
• The NULL Constant
• The IS Operator
• Operators
• Using Select with condition
• Create Database and tables using T-SQL
• ALTER DATABASE using TSQL
• Using Multiple Databases
• Data Entry using T-SQL
• Import an Access Database
• Adjacent Data entry
• Random Data Entry
• Data Type Syntax
• T-SQL WHERE Clause
• The LIKE Condition
• AND & OR
• Using parentheses to form complex expressions
• BETWEEN ... AND
• NOT operator
• Select DISTINCT
• ORDER BY
• SQL Update
• DELETE
• Count Function
• Function AVG(Column)
• Function MAX(column)
• Function SUM(column)
• Using GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• Data Import
• Delete Database
• UNIONS
• The IN Operator
• Table and Field Aliases
• SQL – As
• SQL - Mathematical Operators
• SQL - Incrementing a Value using Update
• Add and Drop a Column
• SQL Subquery
• SQL Case Statement
• Using DateAdd
• Using SQL TRUNCATE
• Create a Database using the help of the Template
• Build a Query using the Query Designer
  
  

Day 2:

• Create Stored Procedures
• Create Stored Procedures to create a Database, to create a table
• Input Records with a stored procedure
• Delete a Stored Procedure
• Define stored procedure with input parameters
• Calling Stored Procedures
• Using the GUI to execute a stored Procedure
• What is a Trigger
• Create a Trigger for INSERT
• Test the Trigger for INSERT
• Create a Trigger for UPDATE
• Test the Trigger for UPDATE
• Create a Trigger for DELETE
• Test the Trigger for DELETE
• Using Views
• Select data from three base tables to present a virtual table of commonly needed data
• Use of Built-in functions
• Calling the Extended Stored Procedure
• Some Useful Extended Stored Procedures
• Using xp_fileexist, xp_regread, xp_repl_encrypt, xp_dirtree, xp_ availablemedia and xp_ availablemedia
• User-defined function
• Types of user-defined functions
• SQL Server 2005/2008 Administration
• Adding/Editing SQL Server Groups
• Adding/Editing SQL Server Registration
• Create Logins
• Using sp_addlogin
• Granting login rights to a database
• Roles
• View a SQL Server login
• Change the default database of a login
• Remove a SQL Server login
• To view the roles defined in a database
• To remove a user account from a database role
• To add/remove a database role
• To view a database user properties
• To allow access database objects by granting permissions
• Using the SQL server Import and Export Wizard
• Export a database to an Access file
• Using the bulk copy command-line utility, bcp.
• Create a job
• Deterministic and Nondeterministic Functions
• Database Backup
• Database Restore
   

Date: Thursday 22 March and Friday 23 March 2012

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

Expert IT also offers on-site training courses at your place anywhere in Australia. We offer one-day and two-day on-site courses at your place anywhere in Australia and you can choose dates that suit you. Price for one-day course is $330 per person and for two-day course is $660 per person based on a class size of two or more people. For an on-site course for one person, an additional 20% of the total cost is required. Please email to us for details: melbourne@expert.com.hk