SQL Tutorials – online choices for SQL Server Tutorials

Some of the top on-line sql tutorial are available at Tutorial point, w3 schools, and Java. These are the top 3 contenders in sql tutorial top spots as in Google search list in terms of popularity and authority. There are several others available. Any sql tutorial usually provides an overview of the standardized query language that you could use to query, retrieve and manage data in relational databases. These are designed in such a way that even beginners can go through them and gain in expertise as they progress through these courses. The only prerequisites required of learners of sql tutorial is an understanding of what a database, RDBMS is, and what constitutes a programming language, its structure and how does programming language used to construct a program.

Once a learner is generally proficient in SQL, through the use of one of these sql tutorial, he/she is able to work with any of the many databases in heavy use. These include SQL Server, MySQL, Sybase, DB2, Oracle, Access and many others. Obviously, learning SQL would not help you with the new-fangled “no sql” databases.

Many of these sql tutorial offer certification. Candidates are given certificates based on clearing periodic examinations. These certificates accepted by employers as proof of the person being qualified in the SQL programming language.

SQL Tutorial-choices to learn sql online

Every sql tutorial is structured. The structure may be slightly different depending on which sql tutorial you are going to use. Lets take a closer look on some of the sql tutorial available:

  • The top choice in sql tutorial is the on-line course conducted by the Tutorial point. They start their sql tutorial with an overview. This is followed by RDBMS and database concepts. SQL statement syntax and the data types handled are introduced next. The sql tutorial then take the learner through operators, expressions. “Create”, “drop” and “select database statements are then introduced. Table manipulations, insert and select queries, “where” clauses are then introduced. Combining queries, update, delete, like, top clauses are talked about. “distinct” keyword and sorting of results are illustrate. After that advanced features such as Constraints, joins, unions and such others are introduced. Then sql tutorial informs about best practices, questions & answers. They even have a section on HR questions the candidates may have to face while interviewing for a job. Additional reading is suggested too.
  • Sql tutorial by w3 schools is well respected as well. W3 schools offer on-line courses in a very wide range of technologies in computers and the Internet. The w3schools has a little different structure of the material than Tutorial point. It discusses various SQL statement types and data types. The sql tutorial then progresses into a coverage of the functions available. This tutorial too has a quiz section but does not have the “interview” questions of the Tutorial point’s.
  • The sql tutorial from JavaTPoint is another widely used robust technology. It provides web service tutorials for beginners and professionals and has yet another structure.

Take your time to get familiar with different options available. Make your deliberated decision considering your priorities and goals.

Please don’t hesitate to contact us if you have any questions regarding sql tutorial. We, at  SQL Server Tutorial, always happy to help!

 

 

What’s new with Microsoft SQL Server 2008 r2

Microsoft released their product SQL Server 2008 r2 in 2010. As it is usual with their products, MS SQL Server 2008 R2 also has an Express edition that is available for evaluation and use in small systems. Microsoft SQL Server 2008 r2 is available in Standard and Enterprise editions. Having tried out the SQL Server 2008 r2 Express, you would eventually graduate to either the standard or the Enterprise editions depending on your actual needs.  Two other special editions also were released with the MS SQL Server 2008 R2. These are the SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse. These two special editions were introduced to meet increasing demands for datacenters and parallel data warehouse applications (Business Intelligence applications).

As with other versions, Microsoft SQL Server 2008 R2 Express edition is supplied free by Microsoft.  This facilitates your team becoming familiar with the database product, get used to developing web based and desktop applications, etc. You will need the help of Microsoft Visual Studio and Visual Web Developer Express.

Some features added over the MS SQL Server 2008 R2 include the following:

  • A Master Data Services that helps in master data management
  • Multi Server Management, this is a feature that helps manage multiple instances of the server
  • Relational databases, reporting services, analysis and integration services are also managed by the multi server management feature



For getting started with the 2008 R2 you need to download the Express edition first. It is fairly simple to download and install. It is free to use, but you will need to get the product registered with Microsoft. Your team can start getting familiar with it right away. When the team gets into applications development activities, there is another issue you need to take into account. All such database applications need to have the database as part of the application and then the question is if you can re-distribute the database to a third party (your customer). This too is free for the Express edition, but you will have to apply and get the right approved by Microsoft.

The so-called core editions of Enterprise and Standard are the most popular ones of the SQL Server 2008 R2 product.  The SQL Server 2008 R2 Standard is positioned as the database tool for data management as well as business intelligence for departments and also the small and medium business segment. This configuration is supposed to take up minimum of IT resources. Some new features in the Standard edition are:

  • Backups could now be compressed significantly for faster backups
  • The SQL Server 2008 R2 could become a managed instance in applications that use multiple servers and need to manage them
  • Support for processing of complex events

The SQL Server 2008 R2 Enterprise is capable of delivering a data platform but provides the user a secure, highly available and scalable product. Business intelligence features are supported. Some new features in the Enterprise edition include:

  • Complex event processing support
  • Mater data service to make sure of data consistency
  • Support for SharePoint collaborative work
  • Up to 25 server instances could be managed with the available multi-server management

The Microsoft SQL 2008 R2 also offers a free Compact edition for applications on mobile devices besides desktop and the web.

Additional Resources on SQL 2008

  1. Sql server 2008 Tutorial
  2. Download SQL Server 2008 Management Studio
  3. Related info on MS SQL 2008

 

 

Overview of SQL Server 2012 Licensing

SQL Server 2012 is package loaded with features and promises to deliver phenomenal results in terms of improvements in performance. Reading or acquiring information about the licensing policy and procedure may be the last thing that a SQL professional would like to do. But for availing the best features of a product and to get maximum benefit from the same it is an important act to be done.

A specific feature and objective of SQL Server 2012 is that it presents information in an altogether intelligent manner to the organization and assists the organization to analyze the data and the information. Some of the features helping SQL 2012 Server deliver the above mentioned objective are AlwaysOn availability, Contained Databases, Uptime enhancement and ColumnStore Index a fast query tool.

While on the other side, the new licensing policy at Microsoft results in increased expenses for the customers. It is also important to bear in mind that to take full benefit of the enhanced features of SQL 2012 means that enhanced network bandwidth is required which is again an additional burden on the Information Technology Department.

SQL Server 2012 is available in 3 versions – Standard, Business Intelligence and Enterprise. The maximum number of new features are available in the SQL 2012 Enterprise Version. Microsoft has also proceeded to replace the licensing model based on per CPU basis to per core.

For the earlier versions of SQL, only one license was required to be bought for every physical processor irrespective of the number of CPU cores in it. Smart choices made at the time of buying server hardware allowed buying up to eight CPU processors for the price of a single SQL Server license. This would allow saving of licensing fee. For procuring the license for SQL Server 2012 for the same server, one would need 8 core licenses. While the new core license fee is reduced than the earlier per CPU fees, but in case someone has an aptitude to do some serious mathematics, it is easy to see the SQL 2012 Server’s prices have increased considerably.

SQL-Server-2012-licenses1

Figure 1: Comparative Features of SQL 2012 Editions

SQL Server 2012 Licensing Tips

Microsoft released a licensing report for all its customers thinking of associating themselves with this upgraded, brand new technology. Reports by independent agencies like Kirkland brief the SQL 2012 licensing requirements and also offers advice on what issues to take into consideration before buying SQL Server 2012. The important licensing tips are:

  • Understand the Need: In order to make the right decisions regarding licensing, it is imperative to look at and understand the IT requirements of the organization and have complete information about the emerging technologies and the licensing requirements.
  • Understand the Costs: Organizations are required to pay the Server and Client Access License (CAL) costs for procuring a license.
  • Know what is being offered: The process of licensing with respect to SQL Server 2012 has been greatly simplified by Microsoft. Licenses are offered for two SQL editions – Datacenter and Standard. Largely the capabilities of the two editions are identical with one major difference that the Datacenter edition offers unlimited virtualization rights. Allocation of server licenses for Windows Server 2012 is done following a 1: 2 ratio, where one license offers coverage to two processors.


Licensing in case of up gradation from Windows Server 2008

Organizations may also like to procure up gradation rights from Windows Server 2008 R2. This is only possible if their license is covered under Software Assurance. As different editions are offered under Windows Server 2008 R2 licensing, up gradation to Windows Server 2012 requires that costs be calculated. To put it in simple words, it would prove less costly in case an organization resorts to licensing Windows Server 2012 for organizations that have “modest virtualization workloads”.
Before proceeding ahead with our discussion, it is important to understand Virtualization Rights.

Virtualization Rights

Microsoft advertises that the Datacenter edition of Windows Server 2012 offers “unlimited” virtualization rights. Even though an organization may have unlimited virtualization rights there is an upper ceiling limit with reference to the number of virtual machines that can run without resulting in any loss of performance. Experts have expressed their an opinion meaning that stacking of licenses (putting two Windows Server 2012 Standard Licenses on one single physical server in order to avail rights to four VMs).

It is also important to determine the number of servers available and how the VMs would be moved around the organization. There are also restrictions on how many times the licenses can be moved between the servers. This is important for volume license cannot be reassigned from one server to another within a period of 90 days.

There is also a possibility that an organization may be required to downgrade from Windows Server 2012 to 2008, in order to run an organization that may not be ready for Windows Server 2012. Down gradation is permitted in case of Datacenter editions.

Another thing that requires the notice of organizations is using the step up license purchases for this is available to Software Assurance customers only. A step up license purchase lets organizations swap a license to a lower edition with a license to a higher edition after paying the price difference.

 

Follow us on: