Ending In:
$2,000
98% off
Courses
10
Lessons
651
Enrolled
172
Courses
10
Lessons
651
Enrolled
172
What's Included
Up & Running with Power BI Desktop
$200 Value
Introduction to SQL Training
$200 Value
Data Analysis Essentials with Microsoft Excel
$200 Value
Jira Crash Course: Jira Fundamentals for Agile Projects
$200 Value
Java Interview Questions: Data Structures & Algorithms
$200 Value
SAS Programming Complete: Learn SAS & Become a Data Ninja
$200 Value
Access Masterclass Level 1 & 2: Beginner to Intermediate
$200 Value
The Complete Jira Agile Project Management Course
$200 Value
Big Data in Advertising: Explained in Plain English
$200 Value
Intermediate SQL: Create & Alter Databases
$200 Value
Product Details
Access
Lifetime
Content
10.0 hours
Lessons
116
Up & Running with Power BI Desktop
Transform, Analyze & Visualize Data with 10 Hours of Content on Microsoft Power BI Desktop
By Chris Dutton | in Online Courses
If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models, and design stunning, interactive dashboards from scratch.
4.6/5 average rating from 77,351 students enrolled:
★ ★ ★ ★
★
- Access 116 lectures & 10 hours of content 24/7
- Build professional-quality business intelligence reports from the ground up
- Understand the business intelligence workflow from end-to-end
- Blend and transform raw data into beautiful interactive dashboards
- Design and implement the same B.I. tools used by professional analysts & data scientists
Maven Analytics | Award-Winning Analytics & BI Training
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.
332,633 Total Students
99,793 Reviews
4.6/5 Instructor Rating:
★ ★ ★ ★
★
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014, they've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.
332,633 Total Students
99,793 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
Requirements
- Microsoft Power BI Desktop
Course Outline
- Your First Program
- Getting Started
- Course Structure & Outline - 1:43
- DOWNLOAD: Course Resources
- Introducing the Adventure Works Project - 3:02
- Setting Expectations - 2:21
- Introducing Power BI Desktop
- Introduction - 0:26
- Meet Power BI - 5:30
- Downloading Power BI & Adjusting Settings - 4:05
- IMPORTANT: Regional Settings
- The Power BI Interface & Workflow - 2:34
- Helpful Resources - 1:44
- UPDATE: New Power BI Ribbon (2020) - 7:15
- QUIZ: Introducing Power BI Desktop
- Connecting & Shaping Data
- Introduction - 0:30
- Types of Data Connectors - 3:53
- The Query Editor - 4:28
- Basic Table Transformations - 10:03
- Text-Specific Tools - 14:54
- Number-Specific Tools - 8:37
- Date-Specific Tools - 8:53
- PRO TIP: Creating a Rolling Calendar - 7:08
- Index & Conditional Columns - 8:30
- Grouping & Aggregating Data - 7:33
- Pivoting & Unpivoting - 8:04
- Merging Queries - 6:41
- Appending Queries - 6:29
- PRO TIP: Appending Files from a Folder - 7:38
- Data Source Settings - 5:05
- Query Refresh Settings - 3:06
- Additional Data Types & Categories - 7:19
- Defining Hierarchies - 4:35
- PRO TIP: Importing Models from Excel - 5:40
- Data Connection Best Practices - 2:09
- QUIZ: Connecting & Shaping Data
- HOMEWORK: Connecting & Shaping Data
- HOMEWORK SOLUTION: Connecting & Shaping Data - 12:36
- Creating a Data Model
- Introduction - 0:19
- What is a "Data Model"? - 5:17
- Database Normalization - 4:07
- Data Tables vs. Lookup Tables - 7:25
- Relationships vs. Merged Tables - 2:31
- Creating Table Relationships - 4:34
- "Snowflake" Schemas - 3:09
- Managing & Editing Relationships - 2:44
- Active vs. Inactive Relationships - 2:45
- Relationship Cardinality - 5:08
- Connecting Multiple Data Tables - 8:26
- Understanding Filter Flow - 6:33
- Two-Way Filters (Use with Caution!) - 13:16
- Hiding Fields from Report View - 4:15
- UPDATE: New Model View - 8:32
- Data Model Best Practices - 1:34
- QUIZ: Creating a Data Model
- HOMEWORK: Creating a Data Model
- HOMEWORK SOLUTION: Creating a Data Model - 14:09
- Adding Calculated Fields with DAX
- Introduction - 0:32
- Meet DAX - 1:03
- Intro to Calculated Columns - 7:33
- Intro to Measures - 2:51
- RECAP: Calculated Columns vs. Measures - 1:34
- Adding Columns & Measures - 3:12
- Implicit vs. Explicit Measures - 6:27
- Filter Context Examples - 8:07
- Step-by-Step Measure Calculation - 2:39
- DAX Syntax & Operators - 3:49
- Common DAX Function Categories - 3:16
- Basic Date & Time Functions - 12:24
- Logical Functions - 10:06
- Text Functions - 9:24
- Joining Data with RELATED - 8:54
- Basic Math & Stats Functions - 14:01
- COUNT Functions - 7:46
- IMPORTANT: Order Line Items - 6:21
- The CALCULATE Function - 13:06
- CALCULATE & ALL - 9:25
- CALCULATE & FILTER - 9:37
- Iterator ("X") Functions - 12:27
- DAX Time Intelligence Formulas - 12:29
- DAX Best Practices - 2:57
- QUIZ: Adding Calculated Fields
- HOMEWORK: Adding Calculated Fields
- HOMEWORK SOLUTION: Adding Calculated Fields - 15:05
- Visualizing Data with Reports
- Introduction - 0:29
- The "Report" View - 5:33
- Adding Simple Objects - 3:07
- Inserting Basic Charts & Visuals - 5:47
- UPDATE: Conditional Formatting - 2:58
- Formatting Options - 9:51
- Report Filtering Options - 11:09
- DEMO: Matrix Visuals - 6:38
- DEMO: Date Slicers - 7:14
- DEMO: Cards & KPIs - 9:24
- DEMO: Text Cards - 6:14
- DEMO: Map Visuals - 7:15
- DEMO: Treemaps - 3:21
- DEMO: Line & Area Charts - 6:23
- DEMO: Trend Lines & Forecasts - 5:36
- DEMO: Gauge Charts - 6:43
- Editing Report Interactions - 6:38
- Adding Drillthrough Filters - 5:08
- Adding Report Bookmarks - 5:49
- "What-If" Parameters - 11:47
- Managing & Viewing Roles - 5:27
- PREVIEW: Custom Visuals (Log-In Required) - 2:05
- PREVIEW: Designing for Phone vs. Desktop - 2:54
- PREVIEW: Publishing to Power BI Service - 2:27
- Data Visualization Best Practices - 1:35
- QUIZ: Visualizing Data with Reports
- HOMEWORK: Visualizing Data with Reports
- HOMEWORK SOLUTION: Visualizing Data with Reports - 7:22
- NEW: Artificial Intelligence (AI) Visuals
- The Q&A Visual - 10:54
- The Key Influencers Visual (Part 1) - 12:34
- The Key Influencers Visual (Part 2) - 5:11
- IMPORTANT: Correlation vs. Causation - 4:24
- The Decomposition Tree Visual - 8:59
- Wrapping Up
- More from Maven Analytics
- REFERENCE: Monthly Power BI Updates
Access
Lifetime
Content
1.0 hours
Lessons
55
Introduction to SQL Training
Earn Some Major Business Clout--Become a Data Wizard with SQL Training!
By Webucator | in Online Courses
The digital world and business world are one in the same these days, and SQL is quickly becoming an essential tool for day-to-day operations. Learn to extract and manipulate data using SQL, so you can easily report and answer important questions as efficiently and accurately as possible. This course is packed with readings, trainer presentations, and exercises for mastering this essential language, from basic database concepts to advanced queries.
4.7/5 average rating from 304 students enrolled:
★ ★ ★ ★
★
- Access 55 lectures & 1 hour of content 24/7
- Dive into the history of SQL & understand database fundamentals
- Utilize SQL to build applications or generate business reports
- Apply SQL to all major databases
- Study potential differences between databases
- Understand how relational databases work
- Learn to write queries for extracting data from multiple tables
Webucator | Global Training Company
4.1/5 Instructor Rating:
★ ★ ★ ★
★
Webucator is a global training company founded in 2003 that has trained over 60,000 students. It provides onsite and online training on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Webucator has trained more than 63,677 students from over 11,907 organizations and is a Microsoft Certified Partner for Learning Solutions (CPLS).
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Class Files
- Class Files and Setup
- Relational Database Basics
- Brief History of SQL
- Relational Databases
- Popular Databases
- SQL Statements
- Relational Database Concepts - 6:25
- Simple SELECTs
- Introduction to the Northwind Database
- Exploring the Tables
- SELECTing Specific Columns
- Using SELECT Demo - 6:15
- SELECTing Specific Columns (Exercise)
- Sorting Records
- Sorting Demo - 5:06
- Sorting Results
- The WHERE Clause and Operator Symbols
- WHERE Clause Demo - 6:51
- Using the WHERE clause to check for equality or inequality
- Using the WHERE clause to check for greater or less than
- Checking for NULL
- Using WHERE and ORDER BY Together
- The WHERE Clause and Operator Words
- WHERE Clause Operators Demo - 5:51
- More SELECTs with WHERE
- Checking Multiple Conditions
- Multiple Conditions Demo - 7:20
- Writing SELECTs with Multiple Conditions
- Advanced SELECTs
- Calculated Fields
- Calculated Fields Demo - 7:34
- Calculating Fields
- Aggregate Functions and Grouping
- Aggregate Functions Demo - 6:54
- Working with Aggregate Functions
- Built-in Data Manipulation Functions
- Data Manipulation Demo - 9:35
- Data Manipulation Functions
- Subqueries, Joins and Unions
- Subqueries
- Subquery Demo - 6:21
- Subqueries (Exercise)
- Joins
- Using Joins Demo - 8:43
- Using Joins
- Outer Joins
- Unions
- Outer Joins and Unions - 8:34
- Working with Unions
- Conditional Processing with CASE
- Using CASE
- Using Case Demo - 8:18
- Working with CASE
- Inserting, Updating and Deleting Records
- INSERT
- INSERT Demo - 5:44
- Inserting Records
- UPDATE and DELETE
- UPDATE and DELETE Demo - 5:54
- Updating and Deleting Records
Access
Lifetime
Content
11.0 hours
Lessons
121
Data Analysis Essentials with Microsoft Excel
Apply Important Concepts & Techniques of Data Analysis Using Excel
By Symon He | in Online Courses
Whether you're working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data. What data do you need? How do you prep that data? How do you analyze it to answer specific questions? This course will show you exactly how to that, starting with the very basics. This course is as much about Excel, if not more, than data analysis concepts and techniques. Why? Excel is still the most popular tool used by analysts in all industries, across all roles. It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.
4.5/5 average rating from 40,473 students enrolled:
★ ★ ★ ★
★
- Access 121 lectures & 11 hours of content 24/7
- Confidently use the most crucial Excel functions & techniques for analysis
- Correctly use appropriate charts
- Apply analysis techniques to datasets
- Build presentation ready dashboards
- Turn real-world data into business insights in Excel
Symon He | Stanford MBA | Real Estate | Financial & Data Analysis
Symon He is a real estate investor and business consultant based out of Los Angeles CA. He currently helps private real estate investors with their acquisitions and deal structuring and advises startup entrepreneurs on their financial models and projections for their businesses. He is also a co-founder of LearnAirbnb, a boutique consultancy and education blog specializing in the home-sharing economy. He also writes articles about real estate, investing, small business, and whatever else he's into at the moment at his personal blog.
206,789 Total Students
20,185 Reviews
4.5/5 Instructor Rating:
★ ★ ★ ★
★
Symon He is a real estate investor and business consultant based out of Los Angeles CA. He currently helps private real estate investors with their acquisitions and deal structuring and advises startup entrepreneurs on their financial models and projections for their businesses. He is also a co-founder of LearnAirbnb, a boutique consultancy and education blog specializing in the home-sharing economy. He also writes articles about real estate, investing, small business, and whatever else he's into at the moment at his personal blog.
206,789 Total Students
20,185 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel 2013+
- Basic computer skills
Course Outline
- Jumpstart Introduction
- Course Intro - 1:14
- Jumpstart Overview - 4:55
- Jumpstart Part 1 - 8:49
- Jumpstart Part 2 - 6:22
- Jumpstart Part 2 Unique Filter - 3:11
- Jumpstart Part 3 - 6:48
- Getting acclimated with Excel
- Getting Acclimated Section Intro - 0:27
- The Excel Interface - 5:21
- Adding, Deleting, and Editing Data - 3:01
- Intro Excel Short Cuts - 1:51
- Navigation Shortcuts - 2:34
- Data Selection Keyboard Shortcuts - 2:20
- Insert and Deleting Rows and Columns Keyboard Shortcuts - 4:21
- Autofit Column & Row Sizes - 1:31
- Freeze Panes & Split View - 4:32
- Formatting Numbers - 7:24
- Formatting Cells - 4:03
- Grouping and Hiding Rows and Columns - 1:57
- Installing Excel Add-ins - 0:44
- Basic Excel Functions and Formulas
- Basic Functions and Formulas Section Intro - 0:32
- Basic Math Functions - 4:48
- Conditional Math Functions - 6:13
- Min Max Average Functions - 5:51
- Logical Operators and Functions - 8:55
- Anchoring Cell References and Naming - 9:14
- Array Functions - 5:03
- Internal Rate of Return - 9:17
- Net Present Value & Cash Multiple - 13:09
- CAGR - 3:26
- Loan Amortization - 3:28
- Formula Auditing - 4:47
- Fill Commands - 4:10
- IS Functions - 4:17
- Rounding Functions - 6:35
- Handling Text, Time, and Date Data
- Text Dates and Times Section Intro - 0:26
- How Excel Treats Text, Times, and Dates - 4:52
- Changing the case of words - 2:32
- Combining Text Together in Excel - 2:23
- Cutting Substrings from a Text - 5:10
- Cutting Substrings from a Text Part 2 using FIND - 5:29
- Searching for text in data - 5:37
- Splitting a text field into mutiple columns - 3:51
- Converting Dates from Text into Values - 3:05
- Adding and Subtracting Dates - 5:14
- Compile Monthly and Annual Totals - 4:43
- Combining Date & Time - 3:40
- Add & Subtract Times - 5:39
- Hours of the Day Analysis - 5:17
- Day of the Week Analysis - 4:06
- Date - Today() - 4:14
- Intro to Statistics in Excel
- Intro to Statistics Section Intro - 0:22
- Brief overview of statistics - 3:35
- Mean Median Mode - 8:39
- Percentile & PercentileRank - 6:03
- Frequency Distribution - 6:40
- Standard Deviation and Variance - 6:11
- Looking at Trends in Data - 7:18
- Correlation - 6:23
- Handling Data in Excel
- Lookup and Database Functions Section Intro - 0:37
- Lookup with VLOOKUP - 4:16
- Lookup with HLOOKUP - 2:26
- Naming Arrays - 3:22
- Nested IF Statements - 4:20
- Avoid Errors with IF and ISNUMBER - 5:39
- Create Dropdowns for Filtering - 9:27
- Create Unique Lists - 4:49
- Fast Lookup with INDEX and MATCH - 10:00
- Multi-Condition Lookup with DSUM - 6:23
- Rankings with SMALL and LARGE - 5:26
- Multi-Condition Lookup with INDEX and MATCH - 5:50
- Pivot Tables
- Pivot Tables Section Intro - 0:42
- Insert a Pivot Table - 6:38
- Prepare Data for Pivoting - 9:10
- Learn to Pivot a Table - 9:35
- Group Rows and Columns - 5:24
- Format for Readability - 5:28
- Modify Output Values for Insights - 8:25
- Insert Calculated Fields - 8:16
- Sort, Filter and Slicer - 8:54
- Handle New Data in Pivot Tables - 8:21
- Building Excel Charts
- Excel Charts Section Intro - 0:30
- Why use charts in Excel? - 10:11
- Charts - Line - 4:52
- Charts - Pie - 5:35
- Charts - Bar - 3:54
- Charts - Clustered Column - 6:26
- Charts - Stacked Column - 5:36
- Charts - 100 Percent Stacked Column - 5:40
- Charts - Combo Chart - 2:24
- Charts - Scatter Plot - 3:12
- Charts - Area Chart - 4:21
- Charts - Bubble - 5:19
- Charts - Gantt - 4:15
- Charts - Bullet - 9:16
- Charts - Waterfall - 15:19
- Dashboards section Intro - 0:39
- Case cases
- Case Studies Overview - 4:40
- Crypto Data Overview - 3:06
- Crypto Getting and Prepping Data - 12:53
- Crypto SP500 vs Bitcoin_ - 13:32
- Cryptos Combined vs SP500 - 8:38
- Cryto BTC Moving Averages_ - 11:04
- Case Study - Survey Data
- Survey Data Overview - 3:12
- Survey Data Prep - 6:14
- Survey Data Demographics_ - 9:39
- Survey Data Pivot Part 1 - 11:05
- Survey Data Pivot Part 2 - 6:09
- Case Study - Startup Market
- So You Want to Do a Startup - 3:12
- A Note on Data Preparation - 3:57
- Scan the Data - 2:02
- Dig into Categories - 8:55
- Exercise 1 - 1:10
- Pivot and Chart - 7:31
- Pivot and Chart Part 2 - 8:29
- Analysis Leads to Finding - 5:01
- Case Study - Data Prep for Startup Market Data
- Startup Funding CSV File Import - 15:21
- Import and Fix Startup Info Data - Part 1 - 12:06
- Import and Fix Startup Info Data - Part 2 - 11:34
- Import and Fix Startup Info Data - Part 3 - 7:36
- Join the Two Tables - 12:28
- Make Unique Lists - 5:40
Access
Lifetime
Content
2.0 hours
Lessons
7
Jira Crash Course: Jira Fundamentals for Agile Projects
Manage Your Projects the Agile Way! This 2-Hour Course Shows You the Basics, Ins & Outs, and Significance of Jira
By Mauricio Rubio | in Online Courses
Jira is a simple, intuitive, mature, robust, and powerful software development tool used by Agile teams around the world. By learning about Jira, you'll be managing your projects efficiently and effectively. This will in turn allow you to achieve recognition not only from your supervisor but also from your stakeholders. In this course, you'll be learning everything you need to get started with Jira and use real-world examples.
4.1/5 average rating from 4,765 students enrolled:
★ ★ ★ ★
★
- Access 7 lectures & 2 hours of content 24/7
- Know the ins & outs of Jira
- Learn about practical applications of Jira in the real world
- Manage your projects the Agile way
- Position yourself as a qualified professional knowledgeable in Agile practices & tools
Mauricio Rubio | Agile Guru & Founder of AgileKB | Ureducation
195,794 Total Students
44,325 Reviews
4.3/5 Instructor Rating:
★ ★ ★ ★
★
Mauricio Rubio has been a Project Manager for over a decade and is currently a Senior Project Manager at one of the top Universities in the world (1st in Australia and 8th in the world among young Universities). He also worked with some of the big brands such as Johnson&Johnson and is a seasoned veteran in Project Management.
195,794 Total Students
44,325 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required:
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- Introduction to Jira from Atlassian; Agile project management tool - 11:44
- Jira's History - 10:54
- Jira Essentials
- Initial Jira Tour - 26:02
- Components in Jira - 6:22
- Scrum Boards in Jira - 43:35
- Reports in Jira and the Burndown Chart - 9:57
- The Product Backlog in Jira also known as the Backlog or the Jira Backlog - 15:44
Access
Lifetime
Content
6.0 hours
Lessons
58
Java Interview Questions: Data Structures & Algorithms
The Best Java Interview Guide with the Most Common Beginner Questions Asked by FANG Companies
By John Bura | in Online Courses
Learn the most commonly asked questions by the likes of Facebook, Google, Amazon, and Spotify for beginners. Preparing for the Java interview is hard. You need to understand not only concepts but also be able to articulate your thought process as you plan and execute a solution. In this course, you'll learn the best way to answer an interview question, look at the most commonly asked questions, and analyze the time complexity of various algorithms. You'll learn through hands-on coding examples and learn to solve problems quickly.
- Access 58 lectures & 6 hours of content 24/7
- Learn the most commonly asked questions by the likes of Facebook, Google, Amazon, & Spotify
- Articulate your thought process as you plan & execute a solution
- Know the best way to answer an interview question
- Analyze the time complexity of various algorithms
- Learn to solve problems quickly through hands-on coding examples
John Bura | Best-Selling Instructor | Web/App/Game Developer
John Bura has been programming games since 1997 and teaching since 2002. John is the owner of the game development studio Mammoth Interactive. This company produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. Mammoth Interactive recently sold a game to Nickelodeon!
John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple’s app store. In his spare time, John likes to play ultimate Frisbee, cycle, and work out.
235,868 Total Students
14,514 Reviews
4.3/5 Instructor Rating:
★ ★ ★ ★
★
John Bura has been programming games since 1997 and teaching since 2002. John is the owner of the game development studio Mammoth Interactive. This company produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. Mammoth Interactive recently sold a game to Nickelodeon!
John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple’s app store. In his spare time, John likes to play ultimate Frisbee, cycle, and work out.
235,868 Total Students
14,514 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
Requirements
- Experience with object-oriented programming fundamentals
Course Outline
- Section 0 - Introduction
- 00 Course Overview - 3:25
- 01 Fizzbuzz - 9:58
- FizzBuzz Code
- Section 1 String and Array Interview Questions
- 01 Reverse Words In A String - 5:36
- 02 Rotate Array - 9:11
- 03 Isomorphic Strings - 12:28
- 04 Kth Largest Element In An Array - 15:19
- 05 Testing Our Solution - 3:39
- Section 1 Code
- Section 2 Matrix Interview Questions
- 01 Set Matrix Zeros - 11:28
- 02 Spiral Matrix - 9:01
- 03 Number Of Islands - 20:21
- 04 Testing Our Solution - 20:21
- Section 2 Code
- Section 3 Linked List Interview Questions
- 01 Implement a Stack Using an Array - 7:01
- 02 Add Two Numbers - 6:43
- 03 Testing Our Solution - 7:55
- Linked List Source Code
- Section 4 Binary Tree Interview Questions
- 01 Inorder Traversal - 8:13
- 02 Preorder Traversal - 8:13
- 03 Postorder Traversal - 6:35
- 04 Binary Tree Maximum Path Sum - 12:41
- Binary Tree Source Code
- Section 5 Graph Interview Questions
- 01 Clone An Undefined Graph - 13:09
- 02 Building And Traversing The Graph - 11:22
- 03 Testing Our Solution - 4:27
- Graph Interview Questions Source Code
- Section 6 Sorting and Time Complexity
- 01 Types Of Time Complexity - 13:25
- 02 Bubble Sort Algorithm - 4:26
- 03 Selection Sort Algorithm - 5:08
- 04 Insertion Sort Algorithm - 4:13
- 05 Quick Sort - 7:14
- 06 Merge Sort Algorithm - 12:30
- 07 Time Complexity Of Different Sorting Algorithms - 2:55
- Time Complexity of Different Sorting Algorithms Slides
- Section 6 Sorting and Time Complexity Code
- Section 7 - Dynamic Programming
- 01 Coin Change - 9:09
- 02 Edit Distance - 10:15
- 03 Distinct Subsequences - 8:45
- 04 Maximum Sum Subarray - 4:44
- Dynamic Programming Source Code
- Section 8 Bit Manipulation Interview Questions
- 01 Bitwise And Shift Operators - 7:19
- 02 Single Number - 3:54
- 03 Number Of 1 Bits - 4:51
- 04 Sum Of Two Integers - 3:30
- 05 Reverse Bits - 6:05
- 06 Bitwise And Of A Range - 10:26
- Bitwise and Shift Operators Slides
- Bit Manipulation Source Code
- Section 9 Combinations and Permutations Interview Questions
- 01 Permutations - 12:11
- 02 Distinct Permutations Of A String - 13:37
- 03 Letter Combinations Of A Phone Number - 13:10
- 04 Factor Combinations - 16:20
- Combinations and Permutations Interview Questions Code
- Section 10 Math Interview Questions
- 01 Reverse Integer - 10:44
- 02 Palindrome Number - 11:40
- 03 Excel Sheet Column Number - 5:45
- Math Interview Questions Code
Access
Lifetime
Content
10.0 hours
Lessons
146
SAS Programming Complete: Learn SAS & Become a Data Ninja
Delve Into the Data Analysis Software 92% of Fortune 100 Companies Use & Easily Pass SAS Base Certification
By Ermin Dedic | in Online Courses
SAS programming is the language of choice of most enterprises/corporations. In 2018, 92% of Fortune 100 companies used SAS. It is the go-to for many industries, including banking/finance, insurance, healthcare, pharmaceutical, and automotive. If you want to pass the SAS Base Certification, start a career, or move up at your company, then this course is for you! This course will teach you how to code in the SAS programming and be able to utilize the data step, proc step, and macro programming. Now is the time to gain a valuable skill, sign up, and learn a skill that pays.
4.2/5 average rating from 12,088 students enrolled:
★ ★ ★ ★
★
- Access 146 lectures & 10 hours of content 24/7
- Understand how to import data, merge data, filter your observations, clean your data, use conditional logic & much more
- Be able to do statistical analysis (t-tests, chi-square, linear regression, multiple regression)
- Apply SQL to compare tables, find duplicate records, create conditions & more
- Perform common tasks on Indexed data sets & understand the ramifications
Ermin Dedic | Data Science + Psychology
Ermin Dedic is passionate about statistics, data science, object-oriented programming, and psychology/mental health. He's developed an expertise in SAS programming and beginner/intermediate statistics largely through his schooling and partly self-study. He's also self-taught in object-oriented programming. Currently, Ermin Dedic teaches 24 courses.
36,678 Total Students
3,804 Reviews
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Ermin Dedic is passionate about statistics, data science, object-oriented programming, and psychology/mental health. He's developed an expertise in SAS programming and beginner/intermediate statistics largely through his schooling and partly self-study. He's also self-taught in object-oriented programming. Currently, Ermin Dedic teaches 24 courses.
36,678 Total Students
3,804 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- All the data-sets (so you can follow along)
- How to Find, Install, and Use SAS Studio/SAS OnDemand For Academics
- How to Find, Install, and Use WPS - 9:40
- Important Note About Watching Course
- Maps Activity (This one you can just watch!) - 4:47
- Importing - Using SAS to Import Data
- Import txt - 2:00
- Import csv - 6:05
- Import xlsx - 3:59
- Fundamentals - Understanding SAS Better
- Data Step vs Proc Step - 4:02
- SAS Syntax - 7:07
- Comparing R, Python and SAS When Manually Creating Data - 8:05
- Working with Data
- Data Set Options - 4:39
- Delimiters - 2:55
- Reading Data Instream - 5:10
- How to read Dates - 6:02
- Creating Variables and Calculations - 4:01
- More on Creating New Variables - 4:16
- Automatic Variables - 3:57
- Filtering Observations - 2:04
- If-then Conditional Logic - 5:40
- Do Iterative Loop And Variations - 6:51
- More on DO Group Processing (without index/counter variable) - 3:55
- More on Where Expression - 3:56
- If vs. Where
- Sorting Observations - 3:21
- Merging Two Data-sets - 3:33
- Using SET statement to Merge - 3:41
- Data Reduction and Cleaning - 6:43
- Length Statement - 8:08
- Counting Variable - 4:26
- Input Types and Informats + User-defined formats
- List Input - 4:18
- Column Input - 4:21
- Formatted input and Informats - 5:55
- User Defined Formats - 7:48
- SAS Arrays
- Arrays 1 (Recoding Variables) - 7:00
- Arrays 2 (Constructing new Variables) - 4:48
- SAS Functions
- Understanding SAS Functions - 9:16
- RAND Function - 5:29
- Length Functions - 6:56
- Trim Function - 2:55
- Compress Function - 3:53
- Input and Put Functions - 7:42
- Catx Function - 3:15
- Scan Function - 3:28
- Coalesce Function - 3:24
- Verify Function - 5:04
- Substr Function - 4:08
- Advanced Techniques - Flexibility and Efficiency
- Flexible Programming 1 - Combining multiple raw data files vertically - 10:42
- Assignments for Data Step
- Integration Assignments Intro
- Integration Assignment 1
- Integration Assignment 1 Solution
- Integration Assignment 2
- Integration Assignment 2 Solution
- Visual Representation of Data
- Scatter Plot - 4:45
- Bar Graph - 2:12
- Statistical Analysis 1
- Information For This Section
- T-Test Independent Overview - 7:03
- Performing T-Test Using SAS - 3:24
- Chi-Square Independent Overview - 6:08
- Perform Chi-Square Using SAS - 3:18
- Statistical Analysis 2
- Performing a Linear Regression - 4:10
- Performing Multiple Regression - 3:38
- Case Study for Data Step
- Case Study Part 1 - 9:46
- Case Study Part 2 - 11:33
- SAS SQL Fundamentals
- SQL Syntax - 8:38
- Where Clause - 6:08
- Select Statement - 5:17
- Case Logic - 3:17
- Summary Functions - 3:20
- SAS SQL Assignment 1
- SAS SQL Assignment 1 Solution
- SAS SQL and Joining
- Inner Join - 8:52
- Joining Three Tables - 2:24
- How to Perform a Left/Right Join - 4:05
- How to Perform a Full Join - 6:18
- SAS SQL Assignment 2
- SAS SQL Assignment 2 Solution
- Working with Tables using SAS SQL
- Creating a Table - 4:26
- Altering Columns - 5:27
- Inserting Rows - 7:02
- SAS SQL Assignment 3
- SAS SQL Assignment 3 Solution
- Practical Applications of SAS SQL
- Comparing Tables SQL - 2:28
- Finding Duplicate Rows - 3:05
- Only Display Unique Records/Rows
- Customize the way you Sort - 3:40
- Updating Table Under Certain Conditions - 4:58
- SAS SQL Assignment 4
- SAS SQL Assignment 4 Solution
- Fundamentals of utilizing SAS Indexes
- Intro to Indices - 1:56
- Should you use an Index? - 2:01
- Types of Indices - 2:01
- Index Options - 1:45
- Testing with Large Data-sets - 4:04
- Selecting Variable(s) for your Index - 4:18
- PROC Data-sets and WHERE Expression - 5:59
- BY Statement (Sorting variables, while exploiting your Index) - 3:59
- Using PROC SQL to create Indices
- Creating an Index During Data Step Execution
- Deleting Indices
- Handling Common Tasks with an Indexed Data-set - 3:27
- Updating the Master Data-Set with new variables or observations - 7:06
- Macro Facility Fundamentals
- Macro Facility Intro Article
- Types of Macro Variables - 4:46
- Don't Lose Track of your Macro Variables - 2:31
- Macro Variable Assignment Rules - 3:14
- Masking Special Characters - 4:09
- Macro Functions (%Index and %Upcase) - 3:58
- Macro Functions 2 (%Scan) - 4:31
- Macro Programs Intro - 5:59
- Macro 1 - Average Sales Example - 6:39
- Macro 2 - Sales Reports for different days - 5:59
- Debugging - 3:32
- Storing Macros - 4:23
- Macro Case Study
- Brainstorming for Case Study - 4:57
- Macro Case Study 1 - 7:59
- Macro Case Study 2 - 7:14
- Introduction to Predictive Modeling With SAS
- Understanding The Business Applications - 2:04
- Analytics Challenges - 3:03
- Predictive Modeling Major Steps - 4:28
- Intuitive Understanding of Logistic Regression - 7:56
- Problem Statement And Hypothesis Generation - 3:42
- Data Audit - 6:02
- Univariate Analysis - 11:22
- Bivariate Analysis - 13:48
- House-keeping important - 7:09
- Sources, Patterns and Mechanisms of Missing Data - 6:09
- Update Your Code
- Evaluating Missing Data Patterns with SAS - 4:51
- 3 Phase Multiple Imputation Process using SAS - 11:42
- Some additional code for PROC MI (if you are getting an error)
- Considering the Output from PROC MI - 3:21
- Mean, Mode and Median Imputation (Article, SAS Code)
- Oversampling and Adjusting for Oversampling - 9:42
- Categorical Inputs - 8:47
- Variable Clustering - 8:00
- Multicollinearity - 5:17
- Subset Selection - 6:32
- Parameter Estimates - 2:13
- Discrimination vs. Calibration (Article)
- ROC Curve - 7:51
- Scoring Validation Data Set Using Code - 3:31
- Decile Calibration Plot - 5:55
- Kolmorgov-Smirnov (Article)
- Feature Engineering - 2:52
- Appendix - Extra Content
- Top 5 SAS Base Certification Questions Answered - 19:36
Access
Lifetime
Content
6.0 hours
Lessons
92
Access Masterclass Level 1 & 2: Beginner to Intermediate
Take Advantage of Access Capabilities — Whether You Intend to Use It Exclusively or Along with Excel
By Ermin Dedic | in Online Courses
This course is ideal for beginners on Access or databases and delves into more intermediate topics like VBA and Macros. Access was designed to make it possible to build solid desktop databases by largely using the GUI. This makes development faster and easier, and it is one of the reasons that Access has continued to be popular despite new competition. This course starts by using the Access Graphical User Interface to build tables, reports, queries, and forms. These sections get you comfortable working with the Access Graphical User Interface to create and work with the 4 main objects in Access.
- Access 92 lectures & 6 hours of content 24/7
- Work w/ the Graphical User Interface & the 4 Main Objects
- Understand & apply database principles to ensure data integrity
- Import Excel spreadsheets into Access via GUI & VBA while applying proper database principles
- Understand the fundamentals of Access Macros & VBA
Ermin Dedic | Data Science + Psychology
Ermin Dedic is passionate about statistics, data science, object-oriented programming, and psychology/mental health. He's developed an expertise in SAS programming and beginner/intermediate statistics largely through his schooling and partly self-study. He's also self-taught in object-oriented programming. Currently, Ermin Dedic teaches 24 courses.
36,678 Total Students
3,804 Reviews
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Ermin Dedic is passionate about statistics, data science, object-oriented programming, and psychology/mental health. He's developed an expertise in SAS programming and beginner/intermediate statistics largely through his schooling and partly self-study. He's also self-taught in object-oriented programming. Currently, Ermin Dedic teaches 24 courses.
36,678 Total Students
3,804 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
Requirements
- Any device with basic specifications
Course Outline
- Introduction To Access Masterclass
- How To Have The Best Course Experience - 2:51
- How To Access, Access
- All The Databases So You Can Follow Along
- Why Use Excel And Access? (Comparison) - 8:58
- Everything About Tables In Access
- Intro Working With Tables And Navigation - 3:51
- Fundamentals Of Editing Records Adding And Deleting - 5:57
- Sorting In Access - 1:32
- Filtering In Access - 2:24
- Find And Replace Tables - 2:37
- Creating Our First Table, 1 - 4:13
- Creating Our First Table, 2 - 2:47
- Creating Our First Table, 3 - 1:41
- Field Properties(field size,format,input masks) - 7:00
- Default Values And Validation Rules - 6:33
- Zero Length Text Fields - 3:12
- Look-ups In Access - 7:33
- Moving fields, Adding fields In Design View - 2:37
- Working With Reports In Access
- Intro To Reports - 7:24
- Move Resize Align Reports - 7:23
- Unbound Controls Access - 1:38
- Bounded Control - 2:36
- Calculated Controls Access - 1:52
- First Control Text Box in Report - 10:07
- Grand Total Control In Report - 4:55
- Grouping In Reports - 2:26
- Conditional Formatting in Reports - 3:18
- Select Queries
- Intro to Queries and Designing Queries - 6:44
- Sorting In Queries - 2:40
- Criteria In Queries - 3:06
- Wildcards In Queries - 2:24
- Formulas In Queries - 5:20
- Calculations In Queries - 2:06
- Parameter Queries - 3:34
- Top Records Queries - 3:19
- Totals Queries - 2:15
- Crosstab Queries - 3:30
- Action Queries
- Update Query Access - 5:13
- Make Table Query - 3:11
- Append Query - 4:48
- Forms In Access
- Intro To Forms - 1:01
- Creating Customer Form - 5:20
- Alignment In Forms - 3:11
- Styling our Form - 3:01
- Controlling Tab Order - 1:51
- Transactions Form List - 1:38
- Creating SubForm - 4:58
- Final Touches Customer Transactions - 7:13
- Understanding Form Record Source - 2:34
- Good Form Design Advice - 5:45
- Database Design 1 (Becoming a Database Expert from Other Areas)
- Advice for Spreadsheet Experts - 1:25
- Advice For The End User vs. Developer - 1:34
- Advice for Coding Experts - 1:32
- Database Design 2, Illustrating Normalization Practically
- First Rule of Database Design - 2:43
- Second Rule of Database Design - 1:55
- Third Rule of Database Design - 1:50
- Database Design 3, Table Design
- Primary Key - 3:59
- Selecting A Starting Auto-Number - 4:29
- Is Duplication Sometimes Necessary? - 1:38
- Non-Normalized To Normalized - 2:44
- Field Type Consistency - 0:57
- Database Design 4, Relationships and Referential Integrity
- Relationships and Referential Integrity - 4:03
- One-To-Many Relationship - 1:55
- Many-To-Many Relationship - 4:09
- One-To-One Relationship - 1:04
- Hands-On Referential Integrity Illustration - 6:42
- Hands-on Cascade Delete Illustration - 3:46
- Cascade Update - 1:02
- Database Design Activity
- Database Design Activity - 7:16
- Importing Excel into Access using GUI and Database Principles
- Intro To Excel And Access - 1:26
- The No Heading Problem - 3:42
- Import Errors (Excel to Access) - 4:49
- Data Check/Considerations Before Import - 3:10
- Many Excel Files to One - 2:01
- Creating Master Table in Access - 6:13
- Normalize by Creating Specific Tables and Implementing Relationships - 8:15
- Appending, in Order very important - 8:26
- Essence of Programming - Program Flow And Controlling Flow/Direction
- Control Structures - 1:41
- Decision Structures - If Then Else - 5:24
- Loop/Repetition Structures - Do While - 4:57
- An Intro To Access Macros
- Creating an AutoExec Macro - 4:23
- Standalone and Embedded Macros - 2:12
- Exploring Options in Macro Action Catalog - 6:03
- Button Control Macros using Wizard - 9:44
- AutoExec Macro 2 - Using Table and Form to Create Welcome Message, 1 - 11:50
- AutoExec Macro 2 - Using Table and Form to Create Welcome Message, 2 - 2:14
- AutoExec Macro 2 - Finishing Touches - 2:57
- Importing Excel into Access using VBA
- Simplest Way To Import Excel Files to Access using VBA - 8:59
- More Flexibility When Importing Excel to Access using VBA - 27:38
- The Best User Experience and Flexibility When Importing Excel Files using VBA - 12:47
- Finish Line
- Final Thoughts - 1:03
- Appendix - Extra
- Why Access Is Still Popular And Future - 13:58
- Access Scalability - 4:31
Access
Lifetime
Content
1.0 hours
Lessons
37
The Complete Jira Agile Project Management Course
Master Your Workflow the Jira Software Way in Just an Hour of Project Management Training
By Danny Liu | in Online Courses
Have you been tasked by your company to figure out how to make software and business projects work more smoothly? In this course, you'll learn how to master JIRA Agile cloud software to help you streamline your projects while turning yourself into a project management professional! Whether you're new to JIRA or Agile methodologies, an Agile Certified Scrum Master, product owner or software developer, this course will provide you the strategic and tactical essentials to get the most out of your JIRA Agile projects using a REAL web design example project, while saving you tons of time during the learning process.
4.3/5 average rating from 1,903 students enrolled:
★ ★ ★ ★
★
- Access 37 lectures & 1 hour of content 24/7
- Configure & customize board components, swimlanes, columns and layouts to help your team visualize work in progress w/ ease
- Understand the key differences between Epics, Stories, Sub-Tasks & Bugs
- Leverage burndown, control & cumulative flow charts for reporting
- Create & understand the key differences between JIRA Scrum and Kanban boards
- Understand the Jira issue workflow & how to create issues
Danny Liu | Jira Software & Productivity Ninja, Digital Entrepreneur
Danny Liu is an Agile Release Manager and a CSPO/CSM & Digital Product Creator. As a seasoned 15-year career technologist, Danny has led high-performance teams, ranging from technology infrastructure engineering design & support to modern-day cloud computing and web development teams that leverage DevOps and CI/CD approaches to deliver digital products early and often.
2,101 Total Students
611 Reviews
4.3/5 Instructor Rating:
★ ★ ★ ★
★
Danny Liu is an Agile Release Manager and a CSPO/CSM & Digital Product Creator. As a seasoned 15-year career technologist, Danny has led high-performance teams, ranging from technology infrastructure engineering design & support to modern-day cloud computing and web development teams that leverage DevOps and CI/CD approaches to deliver digital products early and often.
2,101 Total Students
611 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic understanding of Agile terminology and concepts
- Access to Jira server or cloud
Course Outline
- Introduction
- Introduction to the Course - 1:25
- About the Instructor - 1:02
- Why Jira? - 3:45
- Why This Course? - 1:26
- Pre-Requisites - 1:43
- Create Your 1st Jira Project
- The Setup - 4:23
- Take Action: Setting Up Your Project and Components - 0:42
- Creating JIRA Issue Types (Epics, Stories, Bugs and Tasks)
- Creating Issue Types: Overview - 0:47
- Epics - 4:03
- Take Action: Create Your 1st Epic! - 0:22
- Stories - 4:45
- Bulk Editor - The #1 JIRA Productivity Tool - 2:22
- Take Action: Create Your Stories and Tagged Epic - 0:27
- Tasks - 2:37
- Bugs - 1:48
- Summary - 0:24
- How to Create Effective Scrum & Kanban Boards
- What is a Board? - 1:22
- Create a Scrum Board - 2:18
- Create a Kanban Board - 5:28
- Summary: Key Takeaways for Scrum and Kanban Boards - 1:13
- Customizing Your Board Settings
- Board Settings Overview - 0:37
- General Board Settings - 2:56
- Columns Board Settings - 3:01
- Swimlanes Board Settings - 2:08
- Quick Filters Board Settings - 2:33
- Card Colors Board Settings - 1:33
- Card Layout Board Settings - 2:35
- Estimation Board Settings - 4:45
- Working Days Board Settings - 1:44
- Issue Detail View Board Settings - 2:27
- Board Settings Summary - 2:00
- Release Management 101
- Introduction to Release Management 101 - 3:41
- How to Create a Jira Release Version - 4:57
- Backlog Management 101
- Section7Lesson1BacklogIntro - 1:17
- Section7Lesson2BacklogMgmt_DeletingisOK - 0:57
- Section7Lesson3BacklogMgmt_CommonMyths - 2:43
- Section7Lesson4BacklogMgmt_BulkDelete - 7:22
Access
Lifetime
Content
1.0 hours
Lessons
5
Big Data in Advertising: Explained in Plain English
Understand How Advertisers Use Big Data to Target Their Ads
By Ben Silverstein | in Online Courses
Big Data is a popular buzzword but it is very vague and can be somewhat scary. In this course, you'll learn what Big Data in advertising actually is, and try to remove some of the confusion around the subject. This course gives everyone from beginners to professionals a quick overview of what data means to digital advertising. This course will review the companies involved, define the types of data advertisers look for, when, and why advertisers buy data, how users share it (knowingly or unknowingly), and much more.
4.0/5 average rating from 174 students enrolled:
★ ★ ★ ★
★
- Access 5 lectures & 1 hour of content 24/7
- Understand why companies look to collect data in the first place
- Better know all the different types of companies involved in the data collection & advertising delivery process
- Make smarter decisions about your digital advertising efforts
- Advance your career with a deeper understanding of the digital advertising industry
Ben Silverstein | Digital Advertising Professional & Entrepreneur in NYC
28,756 Total Students
3,328 Reviews
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Ben Silverstein is an award-winning digital media professional with over a decade of experience working in the digital space. He's managed hundreds of millions of dollars for local, national, and international brands including Six Flags Amusement Parks, Giorgio Armani, Cafe de Columbia, William Grant & Sons, and the FDA Real Cost which won a 2015 gold Effie in the Disease Awareness and Education category. When he's not teaching on Udemy, Silverstein works full time in the mobile advertising space and is a consultant for the IAB's Learning & Development and certification group.
28,756 Total Students
3,328 Reviews
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Introduction
- Introduction to the course and your teacher - 1:33
- Personal Data & Laws
- Personal Data & Laws Around Collecting Data - 6:14
- Data Collection & Categories
- Data Categories - What Kind of Data Do Advertising Want? - 7:49
- Data Collection - How is The Data Actually Collected? - 7:40
- Ad Tech Companies & Closing Statements
- Ad Tech Companies, DMP, and Closing Statements - 11:32
Access
Lifetime
Content
1.0 hours
Lessons
14
Intermediate SQL: Create & Alter Databases
Define Your Own Database from Scratch & Understand How to Apply It to Your Own Projects
By ZENVA | in Online Courses
Advance your knowledge of SQLite, the hugely popular, self-contained database engine. In this course, you will learn the different constraints that can be added to your database, and how to insert and manage tables and data into your database. By the end of this course, you will be able to create and define your own database from scratch and understand how to apply it to your own projects.
- Access 14 lectures & 1 hour of content 24/7
- Create, alter & delete tables
- Insert, update & delete data
- Understand foreign key constraints
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development.
The e-learning platform Zenva Academy is the leading place to upskill, learn, and gain key tech skills for the innovation economy.
The e-learning platform Zenva Academy is the leading place to upskill, learn, and gain key tech skills for the innovation economy.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: all levels
Requirements
- Basic skills with SQLite
Course Outline
- Introduction
- Introduction - 3:03
- Source Files
- Additional Resources
- Anaconda Development Environment - 8:35
- Managing Database Tables with SQL
- Creating Tables - 14:11
- Inserting Rows into a Table - 7:11
- Updating Rows in a Table - 4:48
- Deleting Rows from a Table - 2:38
- Deleting Tables - 2:22
- Altering Tables - 4:15
- Removing a Column From a Table - 10:28
- Foreign Keys - Part 1 - 13:46
- Foreign Keys - Part 2 - 8:14
- Conclusion
- Conclusion - 1:57
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.