SQL: From design to Mastery Class Certification Video Training Course
The complete solution to prepare for for your exam with SQL: From design to Mastery Class certification video training course. The SQL: From design to Mastery Class certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Databases Courses SQL: From design to Mastery Class exam dumps, study guide & practice test questions and answers.
SQL: From design to Mastery Class Certification Video Training Course Exam Curriculum
Intro
Lets Recreate a Database Like Udemy's Database
Keys Both Primary and Foreign
Lets Fill In Our Datapoints
THe Select
Sub-queries
Joins
User Defined Functions
The View
Stored Procedures The V8 of the SQL World
Insert Update Delete The Fabulous 3
Getting Real Deep In SQL
Introducing the Pivot
Trouble Shooting and Optimizing Your Database
SQL Server Reporting Services (SSRS)
Random Tips That Make Life Easier
Intro
-
05:18
1. Intro to SQL a 101 Guide to Designing and Building Your First Database
Lets Recreate a Database Like Udemy's Database
-
05:57
1. Lets Talk About Tables And How They Are Used In SQL
-
07:33
2. What Would This Database Need If We Were Recreating Stuff?
-
15:04
3. Person Table
Keys Both Primary and Foreign
-
10:18
1. How to Create Keys In SQL And Why
-
01:50
2. Look What Keys Buy You
Lets Fill In Our Datapoints
-
11:35
1. Adding Data To Your Database
THe Select
-
10:13
1. Select Statement In SQL
-
03:45
2. The Anatomy of the Select Statement in SQL
-
03:50
3. Select Exercises to Help You Learn SQL Faster
-
17:05
4. What Else Can You Do WIth The Select
-
06:54
5. Lets Talk About The Order By Clause In SQL
-
07:15
6. Where Clause Deep Dive
-
08:02
7. Lets Discuss The Like and the In Statements
-
11:25
8. Basic Database Analytics - Introducing Aggregate Functions
-
07:48
9. More Complex Analytics: Group By Clause
Sub-queries
-
09:27
1. What Is A Subquery
Joins
-
15:33
1. Inner Join
-
07:27
2. Left Outer Join
User Defined Functions
-
02:06
1. Introduction to User Defined Functions
-
10:22
2. Scalar Functions
-
04:52
3. Table Functions
The View
-
05:24
1. Lets Talk About Views
Stored Procedures The V8 of the SQL World
-
06:26
1. Our First Stored Procedure
Insert Update Delete The Fabulous 3
-
07:59
1. Insert Statements in SQL
-
05:47
2. Update Statements in SQL
-
06:54
3. SQL Delete Statement
Getting Real Deep In SQL
-
07:56
1. Adding Random Data To Play With
-
05:26
2. Adding More Random Data
Introducing the Pivot
-
02:21
1. Intro to Pivot and Unpivot
-
08:09
2. Our First Example Of A Pivot
Trouble Shooting and Optimizing Your Database
-
07:25
1. A Intro To SQL Profiler
-
04:21
2. A How To On Optimizing Our Datbase
-
09:40
3. Adding Our First Indexes To Our Database
-
25:41
4. Create a Script to Index All Foreign Keys
SQL Server Reporting Services (SSRS)
-
01:52
1. Installing SQL Report Builder 3.0
-
02:44
2. A Very Basic SSRS Report
Random Tips That Make Life Easier
-
02:33
1. How To Use Templates For Quick Access To SQL
About SQL: From design to Mastery Class Certification Video Training Course
SQL: From design to Mastery Class certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Everyone who is interested in the IT world today knows that SQL skills are in high demand now. To obtain them, take this video course. It is intended for those who want to create a complex database for any line of business app. The training is also designed for beginners who are not much experienced in the SQL database. It will lead you to more advanced knowledge and skills.
Let’s see what this training contains. There are 38 lectures and 16 main sections. The course involves lectures about primary and foreign keys. 9 lectures are dedicated to the SELECT statement. Sub-queries are explained in one lecture. There is also a section about user defined functions (Scalar and Table functions). Then, SQL stored procedures are covered. You will learn the INSERT and UPDATE statements, as well as DELETE. You will know what PIVOT and UNPIVOT are. With the help of the course, you will be able to optimize your database and troubleshoot it. Besides, the training contains many tips that can be useful in practice. In general, the course is designed taking into account the students’ practical needs in the field.
Thus, by the end of the training, you will be able to build a database from the very beginning. The explanations are accompanied with multiple examples. The training covers SQL statements, triggers, stored procedures, user-defined functions.
Your new knowledge will allow you to increase your salary. Mastering the SQL skills will lead you to a new level. Besides, with these new competences included in your resume, you will have a higher chance to be promoted.
Prepaway's SQL: From design to Mastery Class video training course for passing certification exams is the only solution which you need.
Pass Databases Courses SQL: From design to Mastery Class Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
