SQL tutorial video by Microsoft certified Systems Engineer
This Transact SQL tutorial video is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification. It will also help you become a better Database Administrator.
Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures.
Code:
http://rapidshare.com/files/272340425/videotraining_sql.part1.rar
http://rapidshare.com/files/272344282/videotraining_sql.part2.rar
TCP/IP and Networking Fundamentals (huge cost video tutorial)
Code:
The course is full of the basic concepts you need to truly understand TCP/ IP an integral part of networking.
TrainSignal - TCP/IP and Networking Fundamentals Bonus DVD
The bonus course is full of the basic concepts you need to truly understand TCP/ IP an integral part of networking.
TCP/ IP and Network Fundamentals
Bonus Course Outline
The bonus course is full of the basic concepts you need to truly understand TCP/ IP � an integral part of networking. We will help you gain a general comfort level for what TCP/ IP is and how to configure it on a basic network computer.
Video 1
What is a protocol?
Key Points:
* Definition of a Protocol
* What is the OSI Model?
Video 2
Introduction to TCP/IP
Key Points:
* What is TCP/IP?
* Transport Layer Protocols
* Internet Layer Protocols
Video 3
Configuring an IP Address
Key Points:
* What is TCP/IP?
* Transport Layer Protocols
* Internet Layer Protocols
Video 4
IP Address Planning
Key Points:
* How to plan an IP Addressing scheme
* Rules for IP Addressing
* What is Classful IP Addressing
* Private IP Addressing vs. Public IP Addressing
* What is Network Address Translation (NAT)?
Video 5
Binary Numbers
Key Points:
* Decimal vs. Binary
* Convert Binary to Decimal
* Convert Decimal to Binary
* Using a Calculator
* IP Address Conversion
Video 6
Internetworking
Key Points:
* IP Address Review
* What is a Router?
* What is a Default Gateway?
* Client Configuration
* Subnetting
Video 7
Classless Interdomain Routing
Key Points:
* Problems with Classful IP Addressing
* Variable Length Subnet Masks
* Subnetting with CIDR & VLSM
* Formulas
* Basic Network
* CIDR Notation
Video 8
Fundamentals of IPv6
Key Points:
* Disadvantages of IPv4
* IPv6 Solutions
* IPv6 Addressing
* Types of IPv6 Addressing
Code:
http://rapidshare.com/files/272788484/TrainSignal_TCP.IP_NF.part01.rar
http://rapidshare.com/files/272796995/TrainSignal_TCP.IP_NF.part02.rar
http://rapidshare.com/files/272810106/TrainSignal_TCP.IP_NF.part03.rar
http://rapidshare.com/files/273157751/TrainSignal_TCP.IP_NF.part04.rar
http://rapidshare.com/files/273197248/TrainSignal_TCP.IP_NF.part05.rar
http://rapidshare.com/files/273208698/TrainSignal_TCP.IP_NF.part06.rar
http://rapidshare.com/files/273216805/TrainSignal_TCP.IP_NF.part07.rar
09-12-2009, 08:50 PM
SQL tutorial video by Microsoft certified Systems Engineer
Linear Mode
Similar Threads
