Author Topic: Conten of SQL Server 2012 SQL course  (Read 8066 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3880
  • Karma: +35/-11
Conten of SQL Server 2012 SQL course
« on: December 01, 2013, 06:44:07 PM »
This is a perfect start class for those who wants to enter IT field as a Database Analyst or Reporting Engineer.

With its nice interface on windows and easily integration with other Windows Applications, Microsoft SQL Server database has been widely used in many companies.

Although this class will focus on how to use SQL Server 2012 for Database Analyst, this class will show you how to use SQL on both Oracle and SQL Server, and teach T-SQL procedure and cursor programming.

In the first part of the class, you'll learn how to install and configure SQL Server 2012, and how to install an OLTP database and sample Account Payable ERP database into your PC. You will learn the concepts and terms you need for working with Oracle or SQL Server. You'll also learn how to use the Microsoft SQL Server 2012 Management Studio to work with queries and databases. At that point, you'll be prepared for rapid progress as you learn SQL.

In second part, you'll learn all the skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won't have any trouble if you're a SQL novice. And they present skills like using outer joins, summary queries, and subqueries that will raise your SQL expertise if you do have SQL experience.

In the third part, you'll learn how to design a database and how to implement that design by using either SQL DDL (Data Definition Language) statements or the Management Studio. When you're done, you'll be able to design and implement your own databases. But even if you're never called upon to do that, this section will give you perspective that will make you a better SQL developer.

The fourth part of the class presents the skills for working with database features like views, stored procedures, functions, triggers, cursors, transactions, and security. These are the features that give a database management system much of its power and that give you an extra edge in your SQL skills.

The content of SQL Server 2012 class listed as below:

Chapter 1 An Introduction to Microsoft SQL Server and SQL

Chapter 2 How to Install SQL Server 2012

Chapter 3 How to Install and use the Microsoft Studio
How to Install Databases

Chapter 4 How to retrieve data from a single table
An introduction to the SELECT statement
How to code the SELECT clause
How to code the WHERE clause
How to code the ORDER BY clause

Chapter 5 How to retrieve data from two or more tables
How to work with inner joins
How to work with outer joins
How to work with Unions

Chapter 6 How to code summary queries
How to work with aggregate functions
How to group and summarize data
How to summarize data using SQL Server extensions

Chapter 7 How to code subqueries
An introduction to subqueries
How to code subqueries in search conditions
Other ways to use subqueries

Chapter 8 How to insert, update, and delete data
How to create test table
How to use the SELECT INTO statement
How to use copy of the database
How to insert new rows
How to modify existing rows
How to delete existing rows

Chapter 9 How to work with data types and fuctions
A review of the SQL data types
How to convert data
How to work with String data
How to work with numeric data
How to work with data/time data
CASE, COALESCE and ISNULL function
How to use ranking functions

Chapter 10 How to design a database
How to design a data structure
How to normalize a data structure

Chapter 11 How to create and maintain databases and tables with SQL statements
An Introduction to DDL
How to create database, tables, and indexes
How to use constraints
How to change databases and tables
The script to create the AP database

Chapter 12 How to work with views
An introduction to views
How to create and manage views
How to use views
How to use the view Designer

Chapter 13 How to code scripts
An introduction to scripts
How to work with variables and temporary tables
How to control the execution of a script
Advanced scripting techniques

Chapter 14 How to code stored procedures, functions and triggers
How to code stored procedures
How to code user-defined functions
How to code triggers

Chapter 15 How to work with cursors
How to use cursors in SQL Server
How to use cursors to retrieve data
How to modify data through a cursor

Chapter 16 How to manage database security
How to work with SQL Server login IDs
How to work with permissions
How to work with roles
How to manage security using the Management Studio