How You Can Master the Fundamentals of Transact-SQL

How You Can Master the Fundamentals of Transact-SQL

Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 465 MB


Genre: eLearning Video | Duration: 49 lectures (2 hour, 4 mins) | Language: English

A Real World Introduction to Transact-SQL

What you'll learn

At the conclusion of this course you'll have a fundamental understanding of Transact-SQL.
You'll learn the 4 components of every query.
You'll also learn the difference between DML and DDL and when to use each.

Requirements

You'll need to download a copy of SQL Server Express. However, don't do it now. We will do this early in the course.
You'll need a copy of the SQL Server *play* database. Again, don't worry about that now. We will do that before we really dig into the course.

Description

SQL Server is a combination of two core items The first is the administration side of the house. Creating databases, managing logins and users, backups,... etc.

The second part of the equation is that of developing code in a language called Structured Query Language.

Microsoft's flavor of SQL is called Transact-SQL.

Transact was designed primarily to work with relational databases. Transact is the language used to talk to SQL Server.

When we want to create a database a database we use DDL or Data Definition Language. I'm defining an object when I use the statement with the code.

When we want to see data inside a table we use DML or Data Manipulation Language. I'm not creating an object I'm manipulating the data inside that object.

In this course we are going to learn the basics of Transact-SQL or T-SQL.

We will cover the fundamentals of Transact using real world examples. Additionally, we will discuss some of the best practices associated with crafting clean, high performance code.

You'll learn why stored procedures are so important to well-designed applications and why ad hoc queries aren't.

The knowledge you gain from the course will not only help you learn to develop but will also give you a great first step to learning how to pinpoint performance issues due to poorly written code.

Thanks for your interest in "Real World Transact-SQL from the Ground Up."

See you in the course.

Who this course is for:

This course is for anyone interested in learning the basics of Transact-SQL.
This IS an entry level course.
Everything you need for the course will be included in the course.

Download:

http://longfiles.com/d5i04fcbxj29/How_You_Can_Master_the_Fundamentals_of_Transact-SQL.rar.html

[Fast Download] How You Can Master the Fundamentals of Transact-SQL


Related eBooks:
Coordination Models and Languages
HBase High Performance Cookbook
PostgreSQL Cookbook
COMPUTER PROGRAMMING: 4 Books in 1: Data Science, Hacking with Kali Linux, Computer Networking for B
SQL: Beginner's Guide to Learn SQL for Database and Data Analysis
Python Programming For Beginners: The Beginner's Guide to Learning the Basics of Python. Tips and Tr
Web Programming for Business: PHP Object-Oriented Programming with Oracle
Real Estate Analysis in the Information Age : Techniques for Big Data and Statistical Modeling
Numeric Computation and Statistical Data Analysis on the Java Platform
Data Science Careers, Training, and Hiring
Guide to Big Data Applications
Oracle Database Transactions and Locking Revealed
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.