Tag: SQL Server 22 posts
This page brings you straight to some info on SQL certification exams for the Business Intelligence, Development, and Database Administration. New to SQL? You'l definitely want to get into out SQL 101 free video series.
SQL Server 2008 MCTS (70-448) Business Intelligence Exam Guide
By Mike Rodriguez ⋅ November 15, 2010 ⋅ 2 comments
In the last couple of weeks, we examined the other two Microsoft SQL Server 2008 MCTS exam paths: Implementation and Maintenance (exam 70-432) for database administrators and Database Development (exam 70-433) for database developers. Today’s article will focus on the third, and possibly most complex of the three SQL Server 2008 exam paths: Business Intelligence [...]
SQL Server 2008 MCTS (70-433) Development Exam Guide
By Mike Rodriguez ⋅ November 8, 2010 ⋅ One comment
As we went over in the SQL Server Database Administration Exam Guide last week, Microsoft SQL Server 2008 along with SQL Server 2008 R2 has brought some important changes to the platform since the 2005 version. The Database Development certification path is designed for database developers that write applications, websites, and more that run with, [...]
SQL Server 2008 MCTS (70-432) DBA Exam Guide
By Mike Rodriguez ⋅ November 1, 2010 ⋅ One comment
Microsoft SQL Server 2008 along with SQL Server 2008 R2 has brought a lot of new features into the mix since the 2005 version. Microsoft knows how important and in-demand this software is in any field requiring database administration, and has created a wealth of certifications across the board for the new software. MCTS (70-432) [...]
Interview with the Midnight DBAs: Jen and Sean McCown
By Kasia Lorenc ⋅ September 7, 2010 ⋅ 2 comments
The most fun I’ve ever had doing an interview was at this year’s TechEd when I got a chance to talk with Jen & Sean McCown, the famous Midnight DBAs. Jen and Sean are two amazing SQL Server experts who have a passion for teaching and a knack for making SQL fun. They have tons [...]
SQL Server Sequence Contest: Win a Netbook and More!
By Kasia Lorenc ⋅ March 22, 2010 ⋅ Post a comment
Enter the SQL Server Sequence contest and you could win a brand new netbook or over $1,000 worth of other prizes! Microsoft’s SQL Server Sequence contest in full swing, and there are still 9 weeks to go! Each week, Microsoft will issue a new question on: Facebook, Twitter, and YouTube. Answer a question correctly and [...]
SQL Server 2008 Certification Guide
By Mike Rodriguez ⋅ March 18, 2010 ⋅ One comment
SQL Server 2008 is used in many fields and has opened up many certification opportunities. If you choose to become certified in SQL Server 2008, you have a few career choices. The SQL Server 2008 certification paths allow you to become: Microsoft Certified Technology Specialist Microsoft Certified IT Professional Microsoft Certified Architect Microsoft Certified Master [...]
New Training Release: Advanced SQL Server 2008 Database Administration
By Mel Haynes ⋅ March 2, 2010 ⋅ 2 comments
Hello Train Signal blog readers! This is Mel, and I just finished my Advanced SQL Server 2008 Database Administration Training and wanted to take a minute here to tell you a little bit about it. I will also give you a brief outline of the different SQL Server certification paths and levels and point you [...]
Interview with Mel Haynes, SQL Server Expert
By Kasia Lorenc ⋅ September 24, 2009 ⋅ One comment
A couple of weeks ago, I got a chance to sit down with Mel Haynes, SQL Server expert and your Instructor for SQL Server 2008 Administration Training and the newly released SQL Server 2008 Database Development Training. You also might remember Mel, from the free SQL 101 videos from earlier this year or the video [...]
Free SQL 101 Training Part 10: Database Setup
By Mel Haynes ⋅ August 6, 2009 ⋅ 2 comments
Learn how to setup your own database in SQL Server 2008. In this video you’ll see a demonstration of setting up a database so you can follow along and setup your own SQL database to practice and learn on.
Get SQL Certified: SQL Server 2008 Developer (70-433) Exam Guide
By Gosia Grabowska ⋅ August 4, 2009 ⋅ Post a comment
In my last post about SQL Server Certification we talked about the SQL Server 2008 Administrator (70-432) Exam. I also told you that there are 3 different types of SQL certifications: Implementation and Maintenance Database Development Business Intelligence Development and Maintenance Since exam 70-432 focuses on Implementation and Maintenance and we already covered it, now [...]
Free SQL 101 Training Part 9: Data Control Language
By Mel Haynes ⋅ July 30, 2009 ⋅ Post a comment
In this video from our free SQL 101 training we’ll cover Data Control Language, also known as DCL. We’ll go over the CREATE LOGIN statement, CREATE USER statement and the actual process of creating a new login and user. Finally, you’ll learn how to delete a login account.
Free SQL 101 Training Part 8: Data Definition Language
By Mel Haynes ⋅ July 23, 2009 ⋅ Post a comment
This video from our free SQL 101 training focuses on Data Definition Language, also known in the SQL world as DDL. We’ll take a look at how DDL is different from DML, or Data Manipulation Language, along with the CREATE and DROP statements in SQL. Finally, we’ll go over creating a new table in your SQL database.
Free SQL 101 Training Part 7: Basic Programming Logic
By Mel Haynes ⋅ July 16, 2009 ⋅ 3 comments
This video from our free SQL 101 training covers basic programming logic, including conditional expressions, the nested statement, CASE statement, and adjusting results column names in SQL.
Video Clip: How to Install SQL Server 2008 on Hyper-V
By Ben Culbertson ⋅ July 16, 2009 ⋅ 3 comments
Hey gang, Coach here with a really cool video clip that brings Hyper-V and SQL Server together. Mel and I recently did a bonus video on how to install SQL Server 2008 on Hyper-V for our SQL Server 2008 Administration and Hyper-V trainings and today we wanted to share a short clip from that video. [...]
Free SQL 101 Training Part 6: The DELETE Statement
By Mel Haynes ⋅ July 9, 2009 ⋅ One comment
In this video from our free SQL 101 training, you’ll learn about the DELETE statement and how to use it with job security. What I mean by deleting with job security is deleting data in your database using the UPDATE statement so that if you ever need to recover the deleted data you cab easily do it.
Free SLQ 101 Training Part 5: The UPDATE Statement
By Mel Haynes ⋅ July 2, 2009 ⋅ One comment
This video, from our free SQL 101 training focuses on he UPDATE statement which is used to update records in your SQL database. See how the UPDATE statement is used, what updates based on values are as well as nested statements and updating all rows in your SQL Server database.
Free SQL 101 Training Part 4: The INSERT Statement
By Mel Haynes ⋅ June 25, 2009 ⋅ 5 comments
This video, from our free SQL 101 training focuses on he INSERT statement in SQL which is used to add new data to your SQL database. See how the INSERT statement is used and watch a demo of it in an actual SQL Server database.
Free SQL 101 Training Part 3: Structured Query Language
By Mel Haynes ⋅ June 18, 2009 ⋅ 5 comments
Get started with SQL Server by learning about Structured Query Language. This free video, part of our SQL 101 training series, covers the SELECT Statement, SELECT WHERE Statement, SELECT ORDER BY Statement and SELECT – Multi Table Statement.
Free SQL 101 Training Part 2: Database Concepts
By Mel Haynes ⋅ June 11, 2009 ⋅ 3 comments
In part 2 of our free SQL 101 training you’ll learn some key database terms and concepts that every DBA needs to be familiar with. You’ll also learn about multiple values per field, repeating fields, primary keys, foreign keys and table relationships. The video will also include a section on database schema and the ultimate solution.
Free SQL 101 Training Part 1: Intro to SQL Server
By Mel Haynes ⋅ May 28, 2009 ⋅ 6 comments
In this free SQL 101 video you’ll learn what SQL is, what flat files in SQL are, the definition of relational databases and about SQL vender variations. If you’re interested in learning about SQL then this is the perfect place to start.