SQL Developer Skills from Scratch Certification Video Training Course
The complete solution to prepare for for your exam with SQL Developer Skills from Scratch certification video training course. The SQL Developer Skills from Scratch 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 Developer Skills from Scratch exam dumps, study guide & practice test questions and answers.
SQL Developer Skills from Scratch Certification Video Training Course Exam Curriculum
Setting up Your Test Environment
T-SQL
SQL Server Integration Services - SSIS
SQL Server Reporting Services - SSRS
Data Warehouse and SQL Server Analysis Services -SSAS
Setting up Your Test Environment
-
03:59
1. Introduction
-
02:49
2. SQL Server Express hardware requirements
-
04:08
3. Download SQL Server Express 2014
-
06:47
4. Install SQL Server Express 2014
-
05:06
5. Download Adventureworks 2014 Database
-
04:14
6. Attach Adventureworks 2014 to SQL Server
-
06:52
7. SSMS Quick Tour
T-SQL
-
10:27
1. What is T-SQL
-
08:20
2. What is a Database
-
04:50
3. Primary Key
-
04:39
4. Foreign Key
-
07:52
5. Intellisense
-
14:13
6. Normalization
-
12:53
7. Querying Data with SELECT Statement
-
07:12
8. Using Aliases in T- SQL Queries
-
12:15
9. Case Expressions
-
09:10
10. Creating Views
-
06:07
11. Adding comments to T- SQL Queries
-
11:59
12. Using Stored Procedures
-
06:09
13. Using T-SQL Top Command
-
05:07
14. T-SQL GO Command
-
06:42
15. Using SQL Distinct to remove duplicate records
-
00:27
16. Introduction to Table Joins
-
00:49
17. Why Table Joins are important
-
10:36
18. INNER Join
-
12:26
19. LEFT Outer Join
-
09:30
20. RIGHT OUTER Join
-
02:16
21. Introduction to filtering records
-
13:35
22. Filtering using equality filters
-
06:07
23. Filtering with basic comparisons
-
14:08
24. Filtering with logical comparisons
-
11:22
25. Filtering with String Comparisons
-
04:35
26. Filtering with NULL Comparisons
-
00:31
27. Introduction to sorting returned records
-
03:02
28. Order by clause
-
04:34
29. Sorting by ascending
-
05:03
30. Sorting by descending
-
05:09
31. Sorting by multiple columns
-
02:12
32. Introduction to Aggregate Functions
-
09:24
33. COUNT ()
-
07:52
34. AVG()
-
06:24
35. MAX ()
-
06:37
36. MIN()
-
06:57
37. SUM()
-
05:09
38. Using Multiple Aggregate functions
-
08:10
39. Grouping Data
-
01:40
40. Introduction to modifying data
-
10:34
41. Adding new records to database
-
09:18
42. Updating Records
-
07:53
43. Deleting Records
SQL Server Integration Services - SSIS
-
03:24
1. Introduction to SSIS
-
03:08
2. Visual Studio Requirements
-
07:47
3. Download and Install Visual studio
-
05:09
4. Completing visual studio installation
-
11:44
5. Working with Solution Explorer and Projects Views
-
06:03
6. Download and Install SQL Server Data Tools - SSDT
-
05:35
7. Create basic ETL: New SSIS project
-
06:26
8. Add a Flat File Connection Manager
-
11:12
9. Remapping Column Data Types
-
03:39
10. Add and Configure OLE DB Connection Manager
-
05:02
11. Add a Data Flow Task to a Package
-
04:28
12. Add and configure flat file source
-
11:29
13. Add and configure lookup transformation
-
09:28
14. Add and configure Lookup Datekey Transformation
-
07:53
15. Add and configure OLE DB Destination
-
02:02
16. Test SSIS Package
-
03:29
17. Introduction to implementing Lookup Logic
-
04:05
18. Create new SSIS Package
-
08:10
19. Write data to cache - part 1
-
07:09
20. Write data to cache - part 2
-
09:22
21. Perform Lookups from cached data -part 1
-
09:16
22. Perform Lookups from cached data -part 2
-
03:36
23. Running your SSIS Package
SQL Server Reporting Services - SSRS
-
04:26
1. What is SQL Server
-
00:31
2. What is SQL Server Reporting Services - SSRS
-
03:01
3. Requirements for creating basic report with -SSRS
-
04:10
4. How to enable built-in administrator account in Windows
-
10:46
5. SQL Server Reporting Configuration Manager
-
10:46
6. Configuration of SQL Server Reporting Services
-
06:20
7. Granting Permission
-
03:02
8. Create Report Server Project
-
08:31
9. Create Report Definition File
-
04:50
10. Define Data Source
-
05:42
11. Define Dataset
-
07:25
12. Add a Table to Report
-
06:57
13. Format Report
-
05:05
14. Group Data
-
08:43
15. Add totals to Report
-
04:13
16. Publish Report
Data Warehouse and SQL Server Analysis Services -SSAS
-
11:54
1. Install SQL Server Enterprise - Evaluation
-
09:25
2. Installing multiple instances of SQL Server
-
05:33
3. Download and install AdventureworksDW2014
-
02:33
4. Enable SQL Server Agent
-
01:46
5. Test AdventureworksDW2014 installation
-
06:38
6. Configuring Database Settings for Data Warehousing
-
03:06
7. What is Data Warehouse?
-
02:28
8. What is ETL
-
01:55
9. DW Vs EDW
-
03:15
10. Database Vs Data Warehouse
-
10:42
11. Hardware requirements for Data Warehouse
-
03:56
12. FTDW Sizing Tool
-
04:14
13. Designing a data warehouse: Logical design
-
09:55
14. Physical design of a data warehouse -part 1
-
11:42
15. Physical design of a data warehouse -part 2
-
10:14
16. Designing Dimension Tables
-
02:41
17. Introduction to ETL with SSIS
-
08:41
18. Exploring source data - part 1
-
04:36
19. Exploring source data - part 2
-
09:55
20. Introduction to Control Flow - part 1
-
08:21
21. Introduction to Control Flow - part 2
-
09:44
22. Implementing Data Flow - part 1
-
09:33
23. Implementing Data Flow - part 2
-
07:20
24. Debugging an SSIS Package - part 1
-
06:53
25. Debugging an SSIS Package - part 2
-
10:18
26. Logging SSIS package events
-
08:00
27. Handling errors in an SSIS Package
-
05:36
28. Introduction to Incremental ETL Process
-
04:53
29. Extracting Modified Data -part1
-
07:47
30. Extracting Modified Data -part 2
-
05:29
31. Extracting Modified Data -part 3
-
07:19
32. Extracting Modified Data -part 4
-
07:31
33. Loading modified data - part 1
-
07:25
34. Loading modified data - part 2
-
07:38
35. Working with other slowly changing dimensions
-
08:19
36. Deploying and Configuring SSIS - Integration Services Catalog
-
11:52
37. Deploy SSIS Solution
-
10:58
38. Execute a package with SQL Server Agent
-
05:19
39. Configuring Advanced SSIS Settings
-
06:57
40. Enforce Data Quality: Install Data Quality Services
-
11:28
41. Cleansing Data
-
11:11
42. Finding duplicate data - part 1
-
09:07
43. Finding duplicate data - part 2
-
09:34
44. Using Data Quality Services in an SSIS Data Flow
-
04:16
45. Consuming Data: Business Intelligence
-
08:12
46. SSRS and Data Warehouse -part 1
-
07:00
47. SSRS and Data Warehouse -part 2
-
09:27
48. Data analysis with SQL Server Analysis Server - SSAS
-
05:13
49. Data analysis with SQL Server Analysis Server - SSAS -part2
About SQL Developer Skills from Scratch Certification Video Training Course
SQL Developer Skills from Scratch 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.
This video course is appropriate for those beginners who want to learn SQL and work with it. It is designed to equip you with the following skills: implementing data warehouse solutions, troubleshooting and debugging SSIS packages, creating an ETL process and a SSIS package with the usage of SQL Server Integration Services. In addition, you will learn the ways to install and download SQL Server Data Tools, create reports with the help of SQL Server reporting Services.
138 lectures are included in the course. They are divided into 5 sections. You will start with setting up the text environment. Then, you will go to T-SQL, and this topic involves 43 lectures. Among them, there are lectures about primary and foreign keys; the SELECT statement; case expressions; filtering with logical, basic, string, and NULL comparisons; COUNT(), AVG(), MIN(), MAX(), SUM() functions; grouping data; new records addition. The separate block of 23 lectures cover SQL Server Integration Services. You will learn how to install visual studio; configure and add flat file source, lookup transformation, OLE DB destination, etc.; write data to cache; make new SSIS package, and so on. The topics of Data Warehouse and SSAS, as well as SSRS, are also a part of the curriculum.
At the end of the training, you will be capable of:- Creating tables and databases
- Writing T-SQL queries
- Creating views
- Creating constraints
- Building flat file database
Thus, this course is a good start to become a SQL Server developer, which opens many career opportunities as these skills are in high demand today.
Prepaway's SQL Developer Skills from Scratch video training course for passing certification exams is the only solution which you need.
Pass Databases Courses SQL Developer Skills from Scratch 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
