Basic SQL course in Honolulu, Hawaii - 2015

You are welcome to attend my course at the Pacific Center for Advanced Technology Training (PACTT). Please register at the PCATT.org site.

Summary:

Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about databases and the basics of Structured Query Language (SQL) including sorting, distinct, and aggregate functions and grouping of data. All SQL statements will initially be written from one table. Most practical, modern and relational databases will include a large number of tables. SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course.


New in 2015: You will also get an introduction to Power Shell.

Dates: (Section 1) Section 1 - Feb 17 - Mar 12, 2015; TTh; 5:30 pm - 7:30 pm; 10 mtgs.
Venue: Honolulu Community College;

Note: SQL Server 2012 Express will be used and a knowledge of SQL Server is not assumed. Students will be using the free version.

For details : Access http://pcatt.org/index.php/search and look up the course or write to:
Hodentek@live.com with course name in the Subject line.

Honolulu SQL Training: Register, the classes are going to start soon

The two non-credit courses offered by the Pacific Center for Advanced Training are going to start soon. Register and upgrade your database skills.

Course content and more details here:
http://hodentek.blogspot.com/2013/12/sql-training-in-honolulu-introduction.html

Creating and connecting to a Contained Database in SQL Server 2012

Contained databases are the best choice if you have migration in mind and with SQL Servers both in-house and the cloud, migration will always be an important item to consider.

Read this article for the benefits of Contained databases:
http://stackoverflow.com/questions/5932293/what-is-the-real-benefit-of-contained-databases

SQL Server 2012 only supports partially contained databases and in future versions this may change.

Depending of the version of SQL Server Management Studio you may or may not be able to connect to the Contained database although you will be able to create one. Once you get connected (SQL Server authentication) you will be able to access only the connected database.

The following link describes some error messages you may encounter trying to create a contained database and connect to it. You can use both SSMS as well as T-SQL to create a partially contained database.

http://hodentekmsss.blogspot.com/2014/01/troubleshooting-connection-to-contained.html

The next image shows the tree structure of a partially contained database.

 

What are Solutions and Projects in SQL Server Managment Studio?

When you are working on a SQL Server Database related problem you may design Tables, Views, Stored Procedures and sometimes it may involve components other than the Data Engine. SQL Server Management Studio provides a means to group together all your codes in one place as part of a SQL Server Project. A solution is a container for a project(s) containing all logically related scripts and files in one place. It is available even in SQL Server 2012 Express. This is the platform to use if you want to develop scripts for Database Engine and Analysis Services. SQL Server is tightly integrated with Visual Studio,

You can work with Solutions and Projects with this interface in SSMS.

Related to Solutions you can do the following:
Create a New Solution
Open an Existing Solution
Close a Solution
Delete a Solution
Copy Items in a Solution
Remove or Delete an Item or Project
Move Items in a Solution
Rename Solutions and Project Items

Related to Projects you can carry out the following:

Create a Project
Add an Existing Project to a Solution
Change the Default Location for Projects
View Project Properties
Add New Items to a Project
Associate a Query with a Connection in a Project
Change the Connection Associated with a Query View
Change the Properties of a Connection in a Project

More about Projects and Solutions in SQL Server Management Studio  here:
HodentekMSSS

Training Course in Honolulu: Introduction to Structured Query Language (SQL)

You are welcome to attend my course at the Pacific Center for Advanced Technology Training (PACTT).
Summary:
Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about databases and the basics of Structured Query Language (SQL) including sorting, distinct, and aggregate functions and grouping of data. All SQL statements will initially be written from one table. Most practical, modern and relational databases will include a large number of tables. SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course.

Dates: (Section 1) Nov 5 - Dec 10; Tuesdays and Thursdays; 5:30 pm - 7:30 pm; 10 meetings.
Venue: Honolulu Community College;

Course code: 134F1TSQL001A
Note: SQL Server 2012 Express will be used and a knowledge of SQL Server is not assumed. Students will be using the free version.

For details : Access http://pcatt.org/index.php/search and look up the course or write to:
Hodentek@live.com with course name in the Subject line.