background preloader

Intro to databases - Richer way of intro to db

Facebook Twitter

Set of videos and documents , web sites about databases. Intro to medium level.
A the beginning you have multiple SQL magazines.
Topics are listed as per course flow.
Put your comments and questions with items.

Instructional and Educational Videos, Animated Explanations, - Explania. Classroom 2.0. Lesson plans. This lesson plan has been designed for high school students.

Lesson plans

The recommended timeframe is 1-3 classes. This lesson plan has been designed for middle school students. The recommended timeframe is 1-3 classes. This lesson plan has been designed for elementary school students. The recommended timeframe is 1-3 classes. Project Based Learning. SQL Server. September 2013. Db2. Db1. Prdb. Tables1. Access: Introduction to Databases.

Please look this first. Start up – zoran_11

Microsoft Access 2010 Tutorial Part 01 of 12 - Database Terminology.

MS Access is very cheap and usable. Should know it. – zoran_11

Database Software and Applications. A Visual Explanation of SQL Joins. I love the concept, though, so let's see if we can make it work.

A Visual Explanation of SQL Joins

Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each. id name id name -- ---- -- ---- 1 Pirate 1 Rutabaga 2 Monkey 2 Pirate 3 Ninja 3 Darth Vader 4 Spaghetti 4 Ninja Let's join these tables by the name field in a few different ways and see if we can get a conceptual match to those nifty Venn diagrams. There's also a cartesian product or cross join, which as far as I can tell, can't be expressed as a Venn diagram: SELECT * FROM TableA CROSS JOIN TableB This joins "everything to everything", resulting in 4 x 4 = 16 rows, far more than we had in the original sets.

Introduction to SQL - SQL LESSON 1. Ten Common SQL Programming Mistakes. Database delivery patterns & practices STAGE 2 Continuous Integration: Fundamentals It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries.

Ten Common SQL Programming Mistakes

In this article, Plamen demonstrates some of the most common SQL coding errors that he encounters, explains their root cause, and illustrates potential solutions. Programming in SQL can be both a fun and a challenging task. Those with a background in traditional programming languages such as Java, C, C++, and VB often find it difficult to adapt to the "set-based" mindset.

My intention with this article was to highlight some of the more common mistakes that I've seen people make when coding SQL. SELECT TOP(10) mistake FROM CommonSQLProgrammingMistakes Without further ado, here is the list: The examples are presented using SQL Server's Transact-SQL dialect, but most of the concepts are valid in any SQL implementation.

Colors table: color Black Blue Green Red Products table: sku product_description color 1 Ball Red 2 Bike Blue. Microsoft SQL Server. "MSSQL" redirects here.

Microsoft SQL Server

It is not to be confused with mSQL. Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, 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.

History[edit] Genesis[edit] Prior to version 7.0 the code base for MS SQL Server was sold by Sybase SQL Server to Microsoft, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM DB2, and, later, Sybase. SQL Server 2005[edit] SQL Server 2008[edit] Using the SQL WHERE clause - learn how to filter rows in your database queries at In our introduction to the SQL SELECT statement we saw how to select specific columns from a table.

Using the SQL WHERE clause - learn how to filter rows in your database queries at

In this article we will see how the WHERE clause can be used to select specific rows from the table that match certain specified criteria or conditions. The WHERE clause is an optional clause in the following SQL statements: SELECT statmentsDELETE statementsUPDATE statements This makes the WHERE clause a major foundation to build upon when learning SQL as it is so frequently used.

Comparison Operators SQL uses comparison operators in the WHERE clause to set the criteria that the rows must meet. The comparison operators are listed in the table below. How to share data between stored procedures. An SQL text by Erland Sommarskog, SQL Server MVP.

How to share data between stored procedures

Most recent update 2013-11-02. Introduction This article tackles two related questions: How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement? How can I pass a table data in a parameter from one stored procedure to another?

Hardware and Software, Engineered to Work Together.

  1. emwallace Jun 7 2015
    So interesting. Thanks for sharing Zoran!