Databases | SQL | Oracle | MS Access Answers

For each student count the number of courses he or she has taken: Got this one it is SELECT Name, COUNT(CourseNumber) AS Course_Count FROM STUDENTS LEFT JOIN COURSES ON STUDENTS.STudentID=COURSES.Student ID GROUP BY Name;
Having problems with: Modify the above query to only count CMIS Courses (a coursenumber is ex. CMIS345) Hint: You'll need to use the SUBSTR function on the COURSENUMBER column to extract the first four letters. then compare this to 'CMIS'

Researching the concepts and technology of data ETL (Extraction, Transformation&Loading) and document the process from start to finish using Microsoft SSIS (SQL Server Integration Services) as the basis of your study. could you tell me the indepth steps contained on Transforming Data.
also what example could i provide on this thanks

I need the SQL query for display the string after @ symbol
Ex: example@hh.com then I want only 'hh.com.'

Had have Sql Server 2005 installed on my sys?
Today morning when i started management studio
an error msg popuped saying cannot find sp_configure stored procedure.
so how can i add the missing sp_configure stored procedure back in master Database ?

I need your help about my homework. It's related with sql er diagraming. I have a short text file. I need to create the er diagram of this file. How can you help me?

Create a list to display customer name, phone, address using PL/SQL.

How can I assign "words" to the string and call them when I need? Please explain with code example.

Hi,

I am using EMS SQL Query 2010 and Data export 2010

I have build a query and tried to export it but I see significant difference between the data visible in the ‘Results’ tab of the Query tool and the data I get after exporting them to CSV…

Those differences concern dates.