Packt Publishing – SQL Server 2017 Express Basics
English | Size: 1.47 GB
Category: Microsoft | Storage
Most Important: Friends, please be sure to look through the course curriculum with meticulous care before buying to be sure this course will work for you. Thank you. This course has been updated to bring it up to date with SQL Server 2017. The new course features audio done with a studio microphone. If you are at the intermediate or advanced level in SQL, do not join this course. The explanations can be very detailed at times, so be sure you enjoy that. Some of the videos cover programming, and some cover using a variety of resources without programming. Various topics are discussed through the videos. For example, there is not just one video on indexes because indexes are too big a topic. The author discuss indexes through the videos where they play a role. The same applies to other concepts. Be sure to look under the lesson resources for additional information and the code. The author’s explanations, in some of the videos, but not all, can be very detailed, so be sure you enjoy that before enrolling.
Style and Approach
Learn more SQL programming from this course. All the code is created in the Microsoft SQL Server Management Studio.
Table of Contents
GET THE NEEDED TOOLS
OPERATING ON COLUMNS
OPERATING ON ROWS
CHANGING ONE TABLE
What You Will Learn
Understand how to choose different data types.
Create a table to represent an entity, insert records into tables, create indexes to ensure data integrity
Learn how to create and execute stored procedures, how to restore databases, how to combine tables with inner joins, how to combine a table with left outer joins, how to use joins to make new tables, how to add data input validation to websites, how clustered indexes operate.
Learn about SQL Server execution plans, understand how to use a variety of online resources related to SQL Server.
Learn how to read simple execution plans, physical SQL Server operators like Table Scan and Index Scan, scalar physical operators, understand how/why to apply column constraints.
Understand the concept of a computed column and why they are useful, how to use a variety of logical conditions, how to use where clauses, how to use where clauses with two logical conditions.
Describe the concept of a parameter
Explain the reasons for data conversions, how to use N and $ symbols in data conversions, understand the difference between clustered and non clustered indexes, how to use key statistics like IO/CPU readingsUnderstand how to differentiate between various icons in the SQL plan panel.
Tom Owziak has nine years experience as a teacher of mathematics, physics, statistics, and programming. He has worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and others. Currently, he works as a mathematics and computer science teacher at a college in NY.