![Andrew Miller](/img/default-banner.jpg)
- 179
- 273 450
Andrew Miller
United States
Приєднався 14 бер 2020
This is my academic channel where I upload lectures and other academic content. This is not affiliated with any institution, and is my personal channel. All opinions expressed on the channel are my own and do not necessarily reflect the opinions of any institutions.
Most course content will be hosted on eLC, so check there for questions.
I am unable to share the slides for the Business Database Systems class, since they are copyrighted by the textbook publisher. However, feel free to use my slides for the Management Information Systems class for personal, educational use:
mstate-my.sharepoint.com/:f:/g/personal/asm357_msstate_edu/ErIE9YRlTitKtMmx-hJNkF8BSv2ZMfZNxqrbG82MhzBC5g?e=xfravz
Most course content will be hosted on eLC, so check there for questions.
I am unable to share the slides for the Business Database Systems class, since they are copyrighted by the textbook publisher. However, feel free to use my slides for the Management Information Systems class for personal, educational use:
mstate-my.sharepoint.com/:f:/g/personal/asm357_msstate_edu/ErIE9YRlTitKtMmx-hJNkF8BSv2ZMfZNxqrbG82MhzBC5g?e=xfravz
Getting Started with Tableau
In this video, I cover the basics of Tableau, including measures, dimensions, visualizations, and data sources.
Переглядів: 92
Відео
Connecting Tableau to a mySQL Server
Переглядів 1523 місяці тому
In this video, I cover how to connect mySQL Server to Tableau. Specifically, I use a local server, but the concept applies to any type of server.
Importing CSV files into mySQL Workbench and getting CREATE statements
Переглядів 1283 місяці тому
In this video, I cover how to import a csv into mySQL using mySQL Workbench. In addition, I cover how to create a table to put the imported data in, and how to view the automatically generated CREATE statements.
Normal Forms (0NF, 1NF, 2NF, 3NF)
Переглядів 2143 місяці тому
In this video, I explain the different normal forms in data modeling, including zero normal form, first normal form, second normal form, third normal form. I explain how each differ from each other, and give an example of each of them.
Introduction to One to One and Recursive Relationships
Переглядів 643 місяці тому
In this video, I introduce and discuss one to one and recursive relationships. Specifically, I talk about what they are, why they occur, and alternative modeling approaches.
Addressing Many to Many Relationships in Data Modeling
Переглядів 2563 місяці тому
In this video, I cover what a many to many relationship is, why they are a problem and cannot be identified without a foreign key, and how to address them using an associative entity.
How to Use SQL Scripts in mySQL
Переглядів 973 місяці тому
In this video, I describe how to use SQL scripts to CREATE TABLEs, and how to work with the error that says Error Code 1824. Failed to open the referenced table.
Types of SQL JOINS
Переглядів 1543 місяці тому
In this video, I discuss the different types of JOINS in SQL, and describe the difference between the LEFT and RIGHT TABLE. Specifically, I discuss INNER, OUTER, FULL, RIGHT and LEFT JOINS. I also show how to use them in mySQL.
SQL SELECT Statement Parts
Переглядів 383 місяці тому
In this video, I cover the basic parts of a SELECT statement, including SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
Inserting Data Into Table in mySQL Workbench
Переглядів 2093 місяці тому
In this video, I cover three ways to insert data into a SQL table. The ways include INSERT INTO statements, using the insert option in mySQL Workbench, and importing from an external file like a csv.
Creating a Table in mySQL Workbench
Переглядів 813 місяці тому
In this video, I cover the basic datatypes and create a sample song table in mySQL Workbench.
First Launch of mySQL Workbench - Establishing Connection to Local Server
Переглядів 1153 місяці тому
In this video, I cover the first launch of mySQL Workbench. I cover how to establish a connection to a local server, and create a first schema.
mySQL - Setting Default Schema and Basic SQL Functions
Переглядів 2603 місяці тому
In this video, I describe how to set a default schema in mySQL Workbench. I also describe how to start a new SQL Query. Finally, I describe the basic SQL functions CREATE, ALTER, SELECT, DROP and DELETE.
How To Download and Install mySQL Workbench and mySQL Community Server
Переглядів 7363 місяці тому
In this video, I download and install mySQL Workbench and mySQL Community Server. Make sure to download the correct version for your system, and restart your computer after installing for the best results.
ERD Tips
Переглядів 953 місяці тому
In this video, I cover tips and tricks for creating an entity relationship diagram.
Microsoft Word Business Report Common Functions
Переглядів 33411 місяців тому
Microsoft Word Business Report Common Functions
Chapter 21 - Malicious Code and Application Attacks
Переглядів 3342 роки тому
Chapter 21 - Malicious Code and Application Attacks
Chapter 20 - Software Development Security - CIS 352
Переглядів 1632 роки тому
Chapter 20 - Software Development Security - CIS 352
Chapter 18 - Disaster Recovery Planning and Chapter 19 - Investigations and Ethics - CIS 352
Переглядів 1772 роки тому
Chapter 18 - Disaster Recovery Planning and Chapter 19 - Investigations and Ethics - CIS 352
Chapter 16 - Managing Security Operations - CIS 352
Переглядів 1862 роки тому
Chapter 16 - Managing Security Operations - CIS 352
Chapter 13 - Data Storage Structures - CIS 402
Переглядів 5282 роки тому
Chapter 13 - Data Storage Structures - CIS 402
Chapter 15 - Security Assessment and Testing - CIS 352
Переглядів 1572 роки тому
Chapter 15 - Security Assessment and Testing - CIS 352
SQL - Intro to Aggregate Functions - BA 223
Переглядів 1092 роки тому
SQL - Intro to Aggregate Functions - BA 223
This was really good, taking this course this semester and i really appreciate the detailed explanations 🫂
Gabriella Road
there is no file at that link. Please clarify. Thank you
I need help with this M.i.S course sir. Who can I write to?
Hello I came across your videos and I’d like to say thank you because I have learned so much. Just a quick question. My college offers both Computer Information systems and Business information systems. Are there any major differences or are they essentially the same? Thank you so much!
Sir I am a student of strategic management and wanted to do work in management consulting profile but in modern time strategy and technology go hand in hand can you please suggest me a business technology course which comprehensively covers everything I would need and also please tell if the management information systems course in your channel would also help thank you🙏🙏🙏
Hi Andrew I tried connecting tableau with mysql database but it shows error everytime
hey teacher this is yavuz taha from turkey, eventhough we are not even in same contry your vids save my life for exams. Im so grateful that.
Is this lecture for the book experiencing MIS 10th edition
Kindly provide me an excel sheet for this video
How do we watch the videos that you mention in the lecture?
"Promo sm" 😘
Love the content but your Heading 1 text was white not black. I found this very useful! Keep up the job work!
The text appears white on my computer because I am using dark mode in MacOS. If printed or if dark mode is disabled, the text would appear black.
Is the word list available for us who haven't studied the course? It would be very appreciated for my own studies.
I have a link in my channel description that contains everything I can share.
@@AndrewMillerPhD Thanks, I'll check it out later. Keep up the great work 🥂
Thank you so much for this lecture. It is very informative.
That was a great series of Lectures... Thank you Prof for this amazing work!!!
🥰🤝
Great lesson... We have really enjoyed and learnt from this lecture. Thank you Prof.
Super insightful as always...Even included Lidar and other new technologies... Thank you Prof.
Thanks for uploading such a high quality lecture:) If you dont mind, can you share us the slides that you have been used?
Absolutely enlightening lesson... Thank you for this effort Prof.
Awesome analysis..... great elaboration Prof.
Great lesson...Pretty pleased student here.
Loved the review.... Very Insightful Prof.
Great lesson Prof... We have certainly learned a lot in this lesson.
Thank you
Insightful Lesson as always. Thank you!
Boss
Certainly learning a lot
Great lesson as always Prof.
The bird is an ostrich... burying it's head in the sand..... Nice lessons Prof.
Custom made steak
Best Lecture on Information Systems... Thank you for the series Prof.
Please clear your voice
Thank you so much for sharing!
Thank you sir
14:21 executive support system
Is this computer information systems????
Yes; CIS, MIS and IS are often used interchangeably.
Respected Andrew, May I have access to the sample document for practice purposes.
Dear Kevin, May I have the access to sample data for practice. Will mean a lot if you can provide it.
Would anybody reach out to me for the document used in this lecture?
Sir great work. Learned alot. Can you please provide the data you are working on for practice purposes? Thanks alot.
Your lectures are great thanks
Can someone explain why 60 is divided by weighted time to calculate capacity?
You saved my homework, and my life. Appreciate!
can you please share the excel file again, its not opening now, there is some error
As a senior Saleaforce admin this is fascinating to learn! You have more interesting playlists than Netflix lol
Thank you for the kind words!
thank you for this amazing lecture you saved me
You the best Professor this is beyond good
Thank you!
This the most excellent lecturing have come across on MIS . You are the best Professor for MIS
Thank you for the kind words!