Microsoft SQL:02 - Transact-SQL and Database

"This wonderful online course is all about the Creating and Managing Database concepts in SQL. You will learn in detail concepts like Accessing data from a database, Modifiying a database in sql server management studio etc. This course also talks about Practical examples of Creating and Managing Database. "

90

 3h 16m | 24 Videos | 89571 Views |   Intermediate

This training introduces you to database concepts and the process of building a database from the ground up. The Microsoft SQL Server Training course provides a brief overview of all major components of SQL Server product suite, but focuses on relational DBMS

What is Microsoft SQL?
Each modern business needs to have a way of collecting and analyzing large amounts of data. There are many Relational Database Management Systems (RDBMS) you could choose from, but Microsoft’s SQL Server is the most popular one used by top enterprises as well as small to medium-sized businesses.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.

Throughout this course you will learn the following concepts:
Transact SQL Language
Outline the key features of Transact SQL
Discuss variables
Discuss data types and comments in transact SQL
Summarize functions in transact SQL
Expressions in transact SQL
Describe data definition language and identify the commonly used DDL commands
Describe Data manipulation language and identify the commonly used DML commands
Explain Data Control Language and identify the commonly used DCL commands
Describe how to execute transact SQL commands as:
Single Statements
Batches
Scripts
List and explain the enhancements in transact SQL

Transact SQL Language (LAB Guide)
Use the transact SQL commands with SQL server 2005
Write statements , functions and expressions
Execute Statements in batches
create and execute scripts

Creating and Managing Database
Introduction
SQL Server supported databases
System Databases
User defined Databases
AdventureWorks Database
Filegroups and Transaction Logs
Filegroups
Transaction Logs
Database modification and Dropping Database
Database Modification Methods
Dropping a database
Database Snapshot

Creating and Managing Database (Lab Guide)
Exercise 1 :- Creating a database in sql server
Exercise 2 :- Modifiying a database in sql server management studio
Exercise 3 :- Creating and dropping database snapshots
Exercise 4 :- Controlling the size of database

Accessing data from a database
Introduction
Need for data retrieval
Select Statement
Select without FROM
Displaying All Columns
Displaying Selected Columns
Different Expressions with Select
Using Constants in result Sets
Renaming result set column names
Computing values in result set
Using Distinct
Using TOP and PERCENT
Various Clauses with SELECT

Accessing data from a database
GROUPBY clause
ORDER BY Clause

What are the requirements?

– SQL Server
– Desire To Learn
– Basic knowledge of T-SQL Is helpful, but not required

What am I going to get from this course?

– Over 24 lectures and 3 hours of content!
– Understand the database concepts.
– Creating & Managing Database
– Accessing Data From Database

What is the target audience?

– Useful for people who have heard of databases but never built one.
– IT Professionals who wish to gain Microsoft Certification.
– New database administrators
– Anyone who is trying to learn about Microsoft’s flagship database system.

Back to top ^