background preloader

SQL

Facebook Twitter

Free SQL Training Videos on TrainSignal Training. Learn the Basics of XML for SQL 2012 By Jillian Pandav on January 3, 2013 Perplexed by XML documents? Learn the fundamental concepts of how XML is used to format data in text files in this training clip from our SQL Server 2012 training. How to Create SQL Views By Jillian Pandav on November 15, 2012 Every SQL admin should know what views are and how to create them. In this scenario, you’ll learn how to work with SQL views using combining data from different tables.

How to Configure SQL Server Authentication Modes This video shows you how to use the GUI in SQL Server to configure authentication modes, which, believe it or not, is easier than trying to do the same with with T-SQL. How to Use SQL Server & PowerShell to Manage Tasks Better By Jillian Pandav on November 8, 2012 There are so many things you can do with PowerShell, and this video only cracks the surface. SQL Server 2012 Query Functions for Date & Time. SQL Tutorial. Interactive Online SQL Training for Beginners. Watch the Online Video Course SQL Essential Training. SQL exercises. SQL Tutorial. Learning SQL can be very rewarding. Once you have a basic understanding of SQL, you can start to develop more advanced websites, and you can (hopefully) charge more money for doing so!

This free SQL tutorial covers the SQL (Structure Query Language) syntax and its various SQL commands. It assumes a basic knowledge of databases and database design. Although not essential, you will benefit most from practicing the examples on your own computer - this would require a database program such as MySQL, SQL Server, or Oracle to be configured on your machine.

If you don't have a database program installed on your machine, don't despair, you will still learn what SQL is and its syntax. If you don't have a basic understanding of databases, start with the database tutorial, which steps through the fundamental concepts of databases. Enjoy this page? Link to this page (copy/paste into your own website or blog): Link to Quackit using one of these banner ads. Thanks for supporting Quackit!