Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
SQL Developers are in demand due to the increasing reliance on data.
Becoming a SQL developer can be a very rewarding and fulfilling career.
The path is relatively easy compared to other technical careers.
Microsoft SQL Server is among the top 3 relational database management systems in the world
and getting the skills to becoming an SQL Server developer will serve you well and open many job opportunities .
The advantage of this course is the amazing virtual labs facilities that is available for free from Microsoft. The virtual labs comes with Microsoft Server 2012 and also Microsoft SQL Server 2016 and various instances of SQL Server like SQL Server Analysis Server (SSAS), SQL Server Reporting Service (SSRS),SQL Server Integration service (SSIS). The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.
What you will learn in this course includes:
I look forward to seeing on the course.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Database Basics|
Flat File Databases
|Section 2: Setting Up Development Environment|
Microsoft SQL Server Express 2014 Download
Microsoft SQL Server Express 2014 Installation
Download Sample Database
Install Sample Database
MSDN Virtual Labs ( No Installation Required )
|Section 3: Functions|
|Section 4: Developing Databases and Tables with SQL|
Designing and Creating Databases
Designing and Creating TablesPreview
Creating Stored Procedures
|Section 5: Joining Tables|
Why are Table Joins Used
LEFT OUTER Join
RIGHT OUTER Join
|Section 6: T-SQL Refresher|
What is T-SQL
T-SQL INSERT Query
T-SQL DELETE Query
T-SQL UPDATE Query
T-SQL DISTINCT and TOP Query
T-SQL SELECT Query
ORDER BY Clause with T-SQL
Using Comparison Filters with T-SQL
Using Equality Filters with T-SQL
Using String Comparison with T-SQL
Using Logical Operators with T-SQL
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.