SQL Developer Skills from Scratch
BEST SELLER
138 Lectures
15h 50m 3s
Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.
$14.99
$19.49
Curriculum For This Course
-
1. Introduction3m 59s
-
2. SQL Server Express hardware requirements2m 49s
-
3. Download SQL Server Express 20144m 8s
-
4. Install SQL Server Express 20146m 47s
-
5. Download Adventureworks 2014 Database5m 6s
-
6. Attach Adventureworks 2014 to SQL Server4m 14s
-
7. SSMS Quick Tour6m 52s
-
1. What is T-SQL10m 27s
-
2. What is a Database8m 20s
-
3. Primary Key4m 50s
-
4. Foreign Key4m 39s
-
5. Intellisense7m 52s
-
6. Normalization14m 13s
-
7. Querying Data with SELECT Statement12m 53s
-
8. Using Aliases in T- SQL Queries7m 12s
-
9. Case Expressions12m 15s
-
10. Creating Views9m 10s
-
11. Adding comments to T- SQL Queries6m 7s
-
12. Using Stored Procedures11m 59s
-
13. Using T-SQL Top Command6m 9s
-
14. T-SQL GO Command5m 7s
-
15. Using SQL Distinct to remove duplicate records6m 42s
-
16. Introduction to Table Joins27s
-
17. Why Table Joins are important49s
-
18. INNER Join10m 36s
-
19. LEFT Outer Join12m 26s
-
20. RIGHT OUTER Join9m 30s
-
21. Introduction to filtering records2m 16s
-
22. Filtering using equality filters13m 35s
-
23. Filtering with basic comparisons6m 7s
-
24. Filtering with logical comparisons14m 8s
-
25. Filtering with String Comparisons11m 22s
-
26. Filtering with NULL Comparisons4m 35s
-
27. Introduction to sorting returned records31s
-
28. Order by clause3m 2s
-
29. Sorting by ascending4m 34s
-
30. Sorting by descending5m 3s
-
31. Sorting by multiple columns5m 9s
-
32. Introduction to Aggregate Functions2m 12s
-
33. COUNT ()9m 24s
-
34. AVG()7m 52s
-
35. MAX ()6m 24s
-
36. MIN()6m 37s
-
37. SUM()6m 57s
-
38. Using Multiple Aggregate functions5m 9s
-
39. Grouping Data8m 10s
-
40. Introduction to modifying data1m 40s
-
41. Adding new records to database10m 34s
-
42. Updating Records9m 18s
-
43. Deleting Records7m 53s
-
1. Introduction to SSIS3m 24s
-
2. Visual Studio Requirements3m 8s
-
3. Download and Install Visual studio7m 47s
-
4. Completing visual studio installation5m 9s
-
5. Working with Solution Explorer and Projects Views11m 44s
-
6. Download and Install SQL Server Data Tools - SSDT6m 3s
-
7. Create basic ETL: New SSIS project5m 35s
-
8. Add a Flat File Connection Manager6m 26s
-
9. Remapping Column Data Types11m 12s
-
10. Add and Configure OLE DB Connection Manager3m 39s
-
11. Add a Data Flow Task to a Package5m 2s
-
12. Add and configure flat file source4m 28s
-
13. Add and configure lookup transformation11m 29s
-
14. Add and configure Lookup Datekey Transformation9m 28s
-
15. Add and configure OLE DB Destination7m 53s
-
16. Test SSIS Package2m 2s
-
17. Introduction to implementing Lookup Logic3m 29s
-
18. Create new SSIS Package4m 5s
-
19. Write data to cache - part 18m 10s
-
20. Write data to cache - part 27m 9s
-
21. Perform Lookups from cached data -part 19m 22s
-
22. Perform Lookups from cached data -part 29m 16s
-
23. Running your SSIS Package3m 36s
-
1. What is SQL Server4m 26s
-
2. What is SQL Server Reporting Services - SSRS31s
-
3. Requirements for creating basic report with -SSRS3m 1s
-
4. How to enable built-in administrator account in Windows4m 10s
-
5. SQL Server Reporting Configuration Manager10m 46s
-
6. Configuration of SQL Server Reporting Services10m 46s
-
7. Granting Permission6m 20s
-
8. Create Report Server Project3m 2s
-
9. Create Report Definition File8m 31s
-
10. Define Data Source4m 50s
-
11. Define Dataset5m 42s
-
12. Add a Table to Report7m 25s
-
13. Format Report6m 57s
-
14. Group Data5m 5s
-
15. Add totals to Report8m 43s
-
16. Publish Report4m 13s
-
1. Install SQL Server Enterprise - Evaluation11m 54s
-
2. Installing multiple instances of SQL Server9m 25s
-
3. Download and install AdventureworksDW20145m 33s
-
4. Enable SQL Server Agent2m 33s
-
5. Test AdventureworksDW2014 installation1m 46s
-
6. Configuring Database Settings for Data Warehousing6m 38s
-
7. What is Data Warehouse?3m 6s
-
8. What is ETL2m 28s
-
9. DW Vs EDW1m 55s
-
10. Database Vs Data Warehouse3m 15s
-
11. Hardware requirements for Data Warehouse10m 42s
-
12. FTDW Sizing Tool3m 56s
-
13. Designing a data warehouse: Logical design4m 14s
-
14. Physical design of a data warehouse -part 19m 55s
-
15. Physical design of a data warehouse -part 211m 42s
-
16. Designing Dimension Tables10m 14s
-
17. Introduction to ETL with SSIS2m 41s
-
18. Exploring source data - part 18m 41s
-
19. Exploring source data - part 24m 36s
-
20. Introduction to Control Flow - part 19m 55s
-
21. Introduction to Control Flow - part 28m 21s
-
22. Implementing Data Flow - part 19m 44s
-
23. Implementing Data Flow - part 29m 33s
-
24. Debugging an SSIS Package - part 17m 20s
-
25. Debugging an SSIS Package - part 26m 53s
-
26. Logging SSIS package events10m 18s
-
27. Handling errors in an SSIS Package8m
-
28. Introduction to Incremental ETL Process5m 36s
-
29. Extracting Modified Data -part14m 53s
-
30. Extracting Modified Data -part 27m 47s
-
31. Extracting Modified Data -part 35m 29s
-
32. Extracting Modified Data -part 47m 19s
-
33. Loading modified data - part 17m 31s
-
34. Loading modified data - part 27m 25s
-
35. Working with other slowly changing dimensions7m 38s
-
36. Deploying and Configuring SSIS - Integration Services Catalog8m 19s
-
37. Deploy SSIS Solution11m 52s
-
38. Execute a package with SQL Server Agent10m 58s
-
39. Configuring Advanced SSIS Settings5m 19s
-
40. Enforce Data Quality: Install Data Quality Services6m 57s
-
41. Cleansing Data11m 28s
-
42. Finding duplicate data - part 111m 11s
-
43. Finding duplicate data - part 29m 7s
-
44. Using Data Quality Services in an SSIS Data Flow9m 34s
-
45. Consuming Data: Business Intelligence4m 16s
-
46. SSRS and Data Warehouse -part 18m 12s
-
47. SSRS and Data Warehouse -part 27m
-
48. Data analysis with SQL Server Analysis Server - SSAS9m 27s
-
49. Data analysis with SQL Server Analysis Server - SSAS -part25m 13s
