MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 96 lectures (14h 2m) | Size: 6.51 GB

Looking to get started with SQL Server?

Looking for a solid reference as you polish your SQL?

You will learn the essential skills for querying Microsoft SQL Server databases based on SQL Server 2012 and above.

Learn the concepts and terms you need for working with relational databases and SQL

Learn to use the Management Studio to work with SQL Server database

Use the Query Designer to help build you SELECT and Action queries.

How to write SQL statements that retrieve and update the data in a database

Learn simple techniques to update data without compromising data integrity

How to create a database and its tables using SQL statements or the Management Studio

How to work with inner and outer joins, summary queries, and subqueries

Be able to install SQL Server instance (2012 or higher). At least Express Edition required

Be able to install SQL Server Management Studio

Basic Windows skills (copying, deleting, creating folders) are required

No knowledge of SQL scripting required

This course shows you how to code the SQL statements that you need for your application if you are already in the industry. If you are a student preparing to enter a competitive world, this course will give you the advantage you need to succeed. We teach you how to code SQL scripts so they run efficiently. The course shows you how to take advantage of the most useful advanced features that SQL Server has to offer. This course is a good choice for any one who wants to learn standard SQL. Most of the SQL code in this course will work with any database management system. Once you use this course to learn how to use SQL to work with a SQL Server database, you can transfer most of what you learn to another database management system such as Oracle, DB2, or MySQL.

Data Analyst who want to experience the power of SQL queries to manipulate data

Report developers who need to work with SQL data

SQL Server database administrators

IT/Business students preparing to enter the industry

Managers looking to extract SQL data on ad-hoc bases



DOWNLOAD
uploadgig