Microsoft

MCSA/MCSE - Querying Microsoft SQL Server 2012

(CIS-376)
Lessons
Lab
Lab (Add-on)
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Understanding SQL Server's Role

  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Lesson Essentials
2

Installing SQL Server 2012

  • Installation Planning
  • Installing a Default Instance
  • Installing Named Instances
  • Installing to a Cluster
  • Installing Extra Features
  • Upgrading from Previous Versions
  • Validating an Installation
  • Removing an Installation
  • Summary
  • Lesson Essentials
3

Querying SQL Server

  • Understanding the SQL Language
  • SQL Statement Types
  • SQL Syntactical Elements
  • Coding Recommendations
  • Using SELECT Statements
  • Advanced Query Techniques
  • Using DDL Statements
  • Using DCL Statements
  • Modifying Data
  • Create and modify constraints (simple statements).
  • Work with functions
  • SqlGeography Methods
  • Tuning and Optimizing Queries
  • Summary
  • Lesson Essentials
4

Database Concepts and Terminology

  • Relational Database Theory
  • Database Design Processes
  • Project Management for the DBA
  • Summary
  • Lesson Essentials
5

ERD and Capacity Planning

  • Planning a Database
  • Understanding Entity Relationship Diagramming
  • Building an ERD
  • Capacity Planning
  • Summary
  • Lesson Essentials
6

Normalization and Other Design Issues

  • Designing for Normalization
  • Designing for Performance
  • Designing for Availability
  • Designing for Security
  • Summary
  • Lesson Essentials
7

Creating SQL Server Databases

  • SQL Server Databases
  • Database Storage
  • Database Options and Properties
  • Creating Databases in the GUI
  • Creating Databases with T-SQL
  • Creating Databases with PowerShell
  • Attaching and Detaching Databases
  • Database Snapshots
  • Summary
  • Lesson Essentials
8

Creating Tables

  • Data Types
  • Query and manage XML data.
  • Collations
  • Table Creation Process
  • Data Partitioning
  • Summary
  • Lesson Essentials
9

Indexes and Views

  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Lesson Essentials
10

Triggers and Stored Procedures

  • Triggers Defined
  • Using Triggers
  • Creating Triggers
  • Understanding Stored Procedures
  • Creating Stored Procedures
  • Summary
  • Lesson Essentials
A

Appendix A

  • Certification Objectives Map
B

Appendix B

  • Installation Requirements
  • Installing SQL Server 2012 Express in Windows

1

Installing SQL Server 2012

  • Installation planning phases
  • SQL Server components
  • Using Data Access method
  • Data Write method
  • Resource Page
  • Installation Center Tasks
  • Validating the installation
2

Querying SQL Server

  • Opening the Query Editor window
  • Retrieving All Records from a Table
  • Retrieving selected records from a table
  • Using the DISTINCT keyword
  • Using the LIKE operator
  • Using the Left Join
  • Using the GREATER THAN relational operator
  • Using the IS NOT NULL condition
  • Using the IS NULL condition
  • Using the MIN() function
  • Using the MAX() function
  • Using the AVG() function
  • Deleting a table from a database using T-SQL code
  • Inserting a record in a table of a database
  • Using the WHERE clause in a table of a database
  • Updating a record in a table of a database
  • Deleting a record from a table of a database
3

Database Concepts and Terminology

  • Relationship types
  • Systems Development Life Cycle
  • Database Life Cycle
  • Phases of the design model
4

ERD and Capacity Planning

  • Preparing the Visio environment for Entity Relationship diagramming
  • Creating the Visio Entity Relationship diagram
5

Normalization and Other Design Issues

  • Normalizing the unnormalized model to the first normal form
  • Normalizing the first normal form to the second normal form
  • Normalizing the second normal form to the third normal form
6

Creating SQL Server Databases

  • Creating multiple filegroups
  • Creating the Books database in the GUI
  • Detaching the Books database in the GUI
  • Attaching the Books database in the GUI
7

Creating Tables

  • Assigning collations at the column level
  • Executing a make table query
  • Adding a column to a table
  • Creating columns
  • Selecting the primary key
  • Specifying table properties and saving the table
  • Launching the Table Designer
  • Scripting the table for documentation
8

Indexes and Views

  • Setting the primary key
  • Creating the LastName non-clustered index
  • Creating the City non-clustered index
  • Creating an index on a column of a table of a database
  • Creating the Covering index
  • Creating the Filtered index
  • Dropping an index from a column of a table of a database
  • Disabling an index by using T-SQL Code
  • Enabling an index on a column of a table of a database using T-SQL code
  • Creating a view using T-SQL code
9

Triggers and Stored Procedures

  • Create a trigger
  • Trigger subtypes
  • Drop a trigger

1

Appendix A

  • Creating and Alter a Table Using Transact SQL Syntax
  • Creating and Alter Views
  • Creating and Modifying Constraints
  • Create and Alter DML Triggers
  • Query Data by using SELECT Statements
  • Implementing Sub queries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Query and Manage XML Data
  • Modifying Data
  • Working with Functions
  • Optimizing Queries
  • Troubleshooting Queries

MCSA/MCSE - Querying Microsoft SQL Server 2012

$279.99

Buy Now

Related Courses

All Course