Course Curriculum
Course Curriculum
| SQL for Data Analytic - Beginner Level | |||
| Module: 01 | |||
| Introduction | FREE | 00:16:00 | |
| Tools for Creating Views | 00:11:00 | ||
| Examples | 00:21:00 | ||
| Updating Data Using a View | 00:13:00 | ||
| Columns and Indexed Views | 00:18:00 | ||
| Module: 02 | |||
| Introduction Stored Procedures | 00:18:00 | ||
| Creating Stored Procedures | 00:19:00 | ||
| Returning Data | 00:14:00 | ||
| Module: 03 | |||
| Testing and Debugging | 00:17:00 | ||
| Execute with Result Sets | 00:11:00 | ||
| Creating Triggers | 00:26:00 | ||
| Module: 04 | |||
| Overview and Scalar Functions | 00:20:00 | ||
| Inline Table Valued Functions | 00:11:00 | ||
| Multi Statement | 00:16:00 | ||
| Views and Stored Procedures | 00:18:00 | ||
| Module: 05 | |||
| Transaction Concepts | 00:30:00 | ||
| Applications and Transactions | 00:13:00 | ||
| Creating Explicit Transactions | 00:29:00 | ||
| Structured Error Handling | 00:25:00 | ||
| Module: 06 | |||
| Introduction to SQL CLR | 00:08:00 | ||
| Writing SQL CLR Code | 00:24:00 | ||
| Using SQL CLR Code | 00:22:00 | ||
| SQL CLR Code | 00:13:00 | ||
| SQL CLR Security | 00:20:00 | ||
| SQL for Data Analytic - Intermediate Level | |||
| Module: 07 | |||
| Topic A Aggregates | FREE | 00:27:00 | |
| Topic B User Defined Types | 00:17:00 | ||
| Topic C Table and Functions | 00:10:00 | ||
| Topic D Managing Code Modules | 00:08:00 | ||
| Module: 08 | |||
| Topic A Introduction Data Tools | 00:19:00 | ||
| Topic B Connected Database Development | 00:20:00 | ||
| Topic C Updating a Connected Database | 00:16:00 | ||
| Module: 09 | |||
| Topic A Creating New Objects with TSQL | 00:12:00 | ||
| Topic B Comparing Database Schemas | 00:10:00 | ||
| Topic C Offline Database Development | 00:13:00 | ||
| Topic D Database Project Settings | 00:18:00 | ||
| Module: 10 | |||
| Topic A Using APPLY | 00:15:00 | ||
| Topic B MERGE Statement | 00:23:00 | ||
| Topic C Creating Recursive Queries | 00:08:00 | ||
| Topic D Grouping Sets | 00:12:00 | ||
| Module: 11 | |||
| Topic A ROLLUP and CUBE Operators | 00:12:00 | ||
| Topic B Creating Pivot Queries | 00:14:00 | ||
| Topic C Executing Dynamic SQL | 00:28:00 | ||
| Module: 12 | |||
| Topic A Complex Query Execution | 00:26:00 | ||
| Topic B Using Execution Plans | 00:16:00 | ||
| Topic C Execution Plan Operators | 00:12:00 | ||
| Topic D Common Join Operators | 00:16:00 | ||
| Module: 13 | |||
| Topic A Hierarchy ID Data Type | 00:12:00 | ||
| Topic B Exploring a Hierarchy | 00:09:00 | ||
| Topic C Sparse Columns | 00:16:00 | ||
| Topic D Column Sets | 00:12:00 | ||
| Module: 14 | |||
| Topic A Filtered Indexes | 00:09:00 | ||
| Topic B FILESTREAM Storage | 00:22:00 | ||
| Topic C Adding Sequences to Queries | 00:22:00 | ||
| Module: 15 | |||
| Topic A Introduction to Spatial Data | 00:13:00 | ||
| Topic B Spatial Data in SQL Server | 00:23:00 | ||
| Topic C Manipulating Spatial Shapes | 00:10:00 | ||
| Topic D Interactions Between Objects | 00:09:00 | ||
| SQL for Data Analytic - Advanced Level | |||
| Module: 16 | |||
| Topic A Partitioning | FREE | 00:20:00 | |
| Topic B Creating Partition Tables | 00:30:00 | ||
| Topic C Querying Partitions | 00:14:00 | ||
| Topic D Managing Partitions | 00:17:00 | ||
| Module: 17 | |||
| Topic A Complex Querying | 00:22:00 | ||
| Topic B Rankings | 00:15:00 | ||
| Topic C SubQueries | 00:21:00 | ||
| Topic D Common Table Expressions | 00:17:00 | ||
| Module: 18 | |||
| Topic A Complex Data and Structures | 00:26:00 | ||
| Topic B Efficient Queries | 00:36:00 | ||
| Topic C Complex Queries | 00:17:00 | ||
| Module: 19 | |||
| Topic A XML Data Type | 00:28:00 | ||
| Topic B XML Schemas | 00:17:00 | ||
| Topic C Querying XML | 00:20:00 | ||
| Topic D Best Practices | 00:08:00 | ||
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha 
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan 
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor 
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson 
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh 
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan 
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana 
Original price was: $485.11.$26.41Current price is: $26.41.
1 Year Access 
0 Students -
20 hours, 50 minutes