MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 99 lectures (21h 6m) | Size: 8 GB

You learn how to create a database using SQL statements and its tables using SQL statements or the Management Studio.

Advanced SQL Server database development and querying

This course will teach you everything you need to know to master advanced SQL Server database development and querying features of this popular DBMS:

You will master the concepts and terms you need for working with relational databases and SQL

..valuable skill whether you are on the DBA track or not

You learn how to use the Management Studio to work with databases and database objects

How to work with views, scripts, stored procedures, functions, table-value parameters, triggers, transactions, locking, and security

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

Master the details of inner and outer joins, summary queries, and subqueries...it's all here

You need at least 3 months working with SQL Server 2012 or above

Be able to and install the Express Edition of SQL Server 2012 or above

Be able to install Management Studio

Some programming skills in other procedural languages. Basic understanding of programming concepts such as looping (WHILE), conditional branching (IF...THEN) will be beneficial but not required

You must be willing and prepared to complete all the quizzes and all the intensive hands-on exercises

Good analytical abilities

NOTE: SQL Server is a hands-on product. No matter how much videos you watch, to master SQL Server, you need to get your hands dirty. Our course is not for the casual SQL Server database user who just wants to know how to write simple SELECT queries to extract data for ad-hoc reports. This course is for someone who is keen to master SQL Server databases for a career, or for whom SQL Server is an integral part of day to day activities. This course will take you longer to complete than most SQL courses. We provide a lot of quizzes and non-trivial hands-on exercises to help you master SQL Server databases design and querying. If you can have the to go through the course and complete all the quizzes and the exercises, you have come to the right place.

YOU WILL NOT BENEFIT MUCH FROM THIS COURSE IF YOU DO NOT DO THE QUIZZES AND THE EXTENSIVE EXERCISES WE HAVE PROVIDED FOR EACH SECTION OF THE COURSE