New members: get your first 7 days of ITTutorPro Premium for free! Join for free

Microsoft SQL Server 2019 – PRO*

Course Description

8:48

68

Never worked with a database before? In this course, Instructor goes over the most important features of working with SQL Server 2019, providing brand-new users with a first look at how the server operates. Instructor introduces the main working environment, SQL Server Management Studio, and walks you through how to create tables, define relationships, and write and run queries with Transact- SQL commands. Upon wrapping up this course, you’ll know everything you need to accomplish to create your first database. Start watching to quickly get up and running with this professional-grade database management system.

Clear

Share on:

Course Syllabus

001-Harness the modern and innovative tools in SQL Server 2019
002-What you should know
003-Core concepts
004-SQL Server 2019 editions
005-Install SQL Server Developer Edition
006-Install Management Studio
007-Enable features with Configuration Manager
008-Management Studio first steps
009-Authentication and user permissions
010-Create a new user account
011-Create the first database
012-Database configuration options
013-Table structures
014-Create a simple table
015-Edit a table s structure
016-Enter data into a table using the GUI
017-Import data from CSV files
018-Create tables from flat files
019-Install a sample database
020-Understand data types
021-Table column properties
022-Primary key fields
023-Establish a default value
024-Check constraints
025-Unique constraints
026-Foreign keys
027-Create a foreign key column
028-Create relationships between tables
029-Understand the role of T SQL
030-Use the T SQL editor
031-Create a table with T SQL
032-Add data to a table
033-Retrieve records with SELECT
034-Filter returned results with WHERE
035-Sort records
036-Delete records from a table
037-Update records in a table
038-Join related tables
039-LEFT JOIN and RIGHT JOIN
040-Remove a table from the database
041-Create a view of the data
042-Data table indexes
043-Create additional indexes on a table
044-Columnstore indexes
045-View execution plans
046-SQL Server s Query Store
047-Rebuild indexes
048-Aggregate functions
049-Use built in functions
050-Leverage user defined scalar functions
051-Introduction to stored procedures
052-Create stored procedures
053-Parameterized stored procedures
054-Create a full backup of the database
055-Create a differential backup
056-Restore a backup
057-Automate backups
058-Business continuity solutions
059-User roles and permissions
060-Database schemas
061-Dynamic data masking
062-Always On data encryption
063-Explore the role of system databases
064-Prevent excessive tempdb autogrowth
065-Review the SQL Server error log
066-Dynamic management views
067-Database Console Commands DBCC
068-Next steps

Pro SQL Server 2019 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques.

This course teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The course promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations.

What You Will Learn

  1. Install and configure SQL Server on Windows through the GUI and with PowerShell
  2. Install and configure SQL Server on Linux and in Containers
  3. Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes
  4. Secure and encrypt data to protect against embarrassing data breaches
  5. Ensure 24x7x365 access through high-availability and disaster recovery features
  6. Back up your data to ensure against loss, and recover data when needed
  7. Perform routine maintenance tasks such as database consistency checks
  8. Troubleshoot and solve performance problems in SQL queries and in the database engine
SQL Server 2019 offers a number of performance enhancements and new features, including support for big data clusters and machine learning services. In this course, Adam Wilbert helps you get up to speed with the latest and greatest in the powerful relational database management system. Learn about database engine enhancements, including improvements to persistent memory and UTF-8 support.

Adam also goes over table virtualization with PolyBase, training and creating machine learning models, how Apache Spark and the Hadoop Distributed File System (HDFS) now work together in SQL Server, and other changes that are coming with the 2019 release.

From: $14.99 / month

Clear
  • Vast selection of courses and labs Access
  • Unlimited access from all devices
  • Learn from industry expert instructors
  • Assessment quizzes and monitor progress
  • Vast selection of courses and labs Access
  • Blended Learning with Virtual Classes
  • Access to new courses every quarter
  • 100% satisfaction guarantee

You Will Get Certification After Completetion This Course.

Instructor Led Lectures
All IT Tutor Pro Formerly It Nuggets Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.
Visual Demonstrations, Educational Games & Flashcards
IT Tutor Pro Formerly It Nuggets recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.
Mobile Optimization & Progress Tracking
Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.
Practice Quizzes And Exams
IT Tutor Pro Formerly It Nuggets Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.
World Class Learning Management System
IT Tutor Pro Formerly It Nuggets provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.

Frequently Asked Questions

How does online education work on a day-to-day basis?
Instructional methods, course requirements, and learning technologies can vary significantly from one online program to the next, but the vast bulk of them use a learning management system (LMS) to deliver lectures and materials, monitor student progress, assess comprehension, and accept student work. LMS providers design these platforms to accommodate a multitude of instructor needs and preferences.
Is online education as effective as face-to-face instruction?
Online education may seem relatively new, but years of research suggests it can be just as effective as traditional coursework, and often more so. According to a U.S. Department of Education analysis of more than 1,000 learning studies, online students tend to outperform classroom-based students across most disciplines and demographics. Another major review published the same year found that online students had the advantage 70 percent of the time, a gap authors projected would only widen as programs and technologies evolve.
Do employers accept online degrees?
All new learning innovations are met with some degree of scrutiny, but skepticism subsides as methods become more mainstream. Such is the case for online learning. Studies indicate employers who are familiar with online degrees tend to view them more favorably, and more employers are acquainted with them than ever before. The majority of colleges now offer online degrees, including most public, not-for-profit, and Ivy League universities. Online learning is also increasingly prevalent in the workplace as more companies invest in web-based employee training and development programs.
Is online education more conducive to cheating?
The concern that online students cheat more than traditional students is perhaps misplaced. When researchers at Marshall University conducted a study to measure the prevalence of cheating in online and classroom-based courses, they concluded, “Somewhat surprisingly, the results showed higher rates of academic dishonesty in live courses.” The authors suggest the social familiarity of students in a classroom setting may lessen their sense of moral obligation.
How do I know if online education is right for me?
Choosing the right course takes time and careful research no matter how one intends to study. Learning styles, goals, and programs always vary, but students considering online courses must consider technical skills, ability to self-motivate, and other factors specific to the medium. Online course demos and trials can also be helpful.
What technical skills do online students need?
Our platform typically designed to be as user-friendly as possible: intuitive controls, clear instructions, and tutorials guide students through new tasks. However, students still need basic computer skills to access and navigate these programs. These skills include: using a keyboard and a mouse; running computer programs; using the Internet; sending and receiving email; using word processing programs; and using forums and other collaborative tools. Most online programs publish such requirements on their websites. If not, an admissions adviser can help.
preloader