CIS-376

MCSA/MCSE - Querying Microsoft SQL Server 2012

Name: MCSA/MCSE - Querying Microsoft SQL Server 2012
Brand: Microsoft
Price: 279.99 USD

Beginner Self-paced · 1 year access

58 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

12 Interactive Lessons · 83 topics

01 Understanding SQL Server's Role 6 topics

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

02 Installing SQL Server 2012 10 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

03 Querying SQL Server 15 topics · 17 LiveLab

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

17 LiveLab in this lesson — see the labs panel →

04 Database Concepts and Terminology 5 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

05 ERD and Capacity Planning 6 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

06 Normalization and Other Design Issues 6 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

07 Creating SQL Server Databases 10 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

08 Creating Tables 7 topics · 8 LiveLab

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

8 LiveLab in this lesson — see the labs panel →

09 Indexes and Views 8 topics · 10 LiveLab

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

10 LiveLab in this lesson — see the labs panel →

10 Triggers and Stored Procedures 7 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

11 Appendix A 1 topics · 13 LiveLab

Certification Objectives Map

13 LiveLab in this lesson — see the labs panel →

12 Appendix B 2 topics

Installation Requirements
Installing SQL Server 2012 Express in Windows

Hands-On Labs Our edge

58 LiveLabs

Installation planning phases
SQL Server components
Using Data Access method
Data Write method
Resource Page
Installation Center Tasks

Validating the installation
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
Relationship types
Systems Development Life Cycle
Database Life Cycle
Phases of the design model
Preparing the Visio environment for Entity Relationship diagramming
Creating the Visio Entity Relationship diagram
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
Creating multiple filegroups
Creating the Books database in the GUI
Detaching the Books database in the GUI
Attaching the Books database in the GUI
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
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
Create a trigger
Trigger subtypes
Drop a trigger
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

Labs run in your browser — nothing to install.

Prepare for MCSA/MCSE - Querying Microsoft SQL Server 2012

One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.

1 year of full access
58 LiveLab included
Certificate of completion

Try Free

No credit card required