Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

Database skills are essential in whatever organization and in whatever position and it is crucial that you have this in your arsenal (Resume')

Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will 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 which will take you from installing SQL Server 2016 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.

What's new in this session

• SQL Server Using Powershell 
• JSON and XML

The class runs from Feb 6 to March 13 at Honolulu Community College.
(Register Online)

Feb 6 - March 13; TTH: 5:30 pm to 7:30 pm; 10 Mtgs

Merry Christmas 2017

Hope to post more in coming years....

Keep fit and look forward to great things.

Installing SQL Server Reporting Services 2017 - Part1

Download the following executable file from here:

https://www.microsoft.com/en-us/download/details.aspx?id=55252

SQLServerReportingServices.exe (92.7 MB)
Version: 14.0.600.490 (11/1/2017)

These are from download site:
Reporting Services offers the following: 

Paginated reports optimized for document generation and printing.
Mobile reports optimized for mobile devices, with responsive layout that adapts to different devices and the different ways you hold them.
A modern web portal you can view in any modern web browser.

System requirements:
Supported Operating System
Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016
You'll need
.NET Framework 4.5.2 or later
SQL Server Database Engine (2008 SP4 or later), to store the report server database

You must first install the Reporting Services and then run the Reporting Services Configuration Manager for 2017 which  is installed when you install SQL Server 2017 Developer Edition (in the present case).

Installing SQL Server Reporting Services 2017-a new experience

Prior to SQL Server 2017, there was an option to include SQL Server Reporting Services during SQL Server Installation.

If you have reviewed my previous post related to Installing SQL Server 2017 Development edition you would have noticed the absence of anything related to SQL Server Reporting Services 2017. This is by design.

In SQL Server 2017, you need to install SSRS 2017 separately. The installer file itself is very small about 100 MB. There are three advantages by using the new installer:

• If you have installed SQL Server 2017 Database engine, it just takes a short while to install SSRS 2017
• Update SSRS 2017 very quickly
• The installer is stand-alone without bringing other programs in, you can always install the latest version without impacting your SQL Server databases or other features.

Download SSRS 2017 from here:

https://www.microsoft.com/en-us/download/details.aspx?id=55252

Read report's RDL file details using XML Notepad

A RDL file is a report definition language (RDL) file. It has every bit of information in the file.

You have several options to look at a report's rdl file as shown (by right clicking the (any report) reportany.rdl file.

XmlRdl_0

You could open in Notepad and it is going to be a very large file and you may get yourself lost in it without recognizing the key areas. Even using Microsoft Edge it is the same. You could open in Microsoft Visual Studio, but not every one may have it.

The reccommendation is XML Notepad. This is a good application to review the properties of a report rdl file.

You may download XML Notepad as described here. it is free.

Launch XML Notepad and click FIle menu to open the rdl file. In this case I am using a simple file called SimpleReport.rdl.

The file gets opened as shown. Now you see why I recommend this application. You canveyr clearly see how ggthe report is constructed.

XmlRdl_1.png

Expand the DataSource to see the details.

XmlRdl_2.png

Now open the DataSets node as shown.

XmlRdl_3.png

Click the Fields to see the fields in the data as shown.

XmlRdl_4.rdl

Well, you can also see the report design.

XmlRdl_5.rdl

Explore more and enjoy!

I guess you agree with my assertion that XML Notepad is the best to see the report rdl file.

Connect to SQL Server 2016 using Microsoft SQL Operations Studio

It is so easy to connect to SQL Server database.

Read here: What is Microsoft SQL Operations Studio?

http://hodentekhelp.blogspot.com/2017/12/what-is-sql-operations-studio.html

Read here: Microsoft SQL Operations Studio User Interface

https://hodentekmsss.blogspot.com/2017/12/sql-operations-studio-user-interface.html

Watch this video: Connecting to SQL Server 2016 Developer edition database using

Microsoft SQL Operations Studio

Run a simple query in Microsoft Operations Studio

In order to run a query in Microsoft Operations Studio you must first to connect to a database on an instance of SQL Server.

It is so easy to connect to SQL Server database.

Step 1: Understand what is meant by Microsoft Operations Studio

Read here: What is Microsoft SQL Operations Studio?

http://hodentekhelp.blogspot.com/2017/12/what-is-sql-operations-studio.html

Step 2: Get a handle on using this new Interface

Read here: Microsoft SQL Operations Studio User Interface

https://hodentekmsss.blogspot.com/2017/12/sql-operations-studio-user-interface.html

Step 3: Learn how you may connect to SQL Server (In this example SQL Server 2016 Developer)

Watch this video: Connecting to SQL Server 2016 Developer edition database using

Microsoft SQL Operations Studio

Step 4: Running a query on SQL Server after connecting to Northwind database

Now that you are connected, you can access all the tables, views, etc as shown.

 For any table you have three options Select top 1000, edit or script table to create as shown.

When click on New Query icon in the Microsoft Operations Studio, the query plane is open as shown.

 You will be required to enter a query starting at Line 1. When you type SEL, the Select statement begins.

 You do not get the columns of employees as it is not yet even mentioned. Type in the rest of the query. Click Run. The results pane opens below the Select statement as shown.

 The Results pane has a few controls on the right. This is cool. Now you can export the results to CSV, JSON or EXCEL. You could also view it as a chart.

Perhaps, SSMS should have a view of viewing data as chart.

In summary, it is easy to connect to SQL Server and run queries. It should be noted that there is no syntax check for queries as well as intellisense.