Introduction

1. Introduction Welcome Back By Carlos Coronel

2. After a long break….. Coming back to school requires re-focusing, opening your mind… Let’s try some mind exercises….

3. Do I really need to take this class? • YES, you have to and need to • You will learn something new:“the brighter you are, the more you have to learn..” Don Herold. • Explore new areas, challenge yourself:“as knowledge increases, wonder deepens..”C. Morgan. • You will need focus…… Let's try doing some focusing exercises!

4. How is the class going to be? • Lecture …listen & assimilate • Interactive …engage & participate • Hands-on …do it & experiment • Team work … lead, collaborate • Come to class and participate: “readers are plentiful; thinkers are rare” Harriet Martineau • Make good choices:“It is our choices that show what we truly are, far more than our abilities.” - J.K. Rowling

5. How should I prepare for this class? • Set weekly goal/objective. • Guidance to reach goal/objectives. • Ask questions… • Experiment: • listen & remember • compare, analyze, evaluate • apply, synthesize • understand the answer, steps, goal “It does not matter how slowly you go as long as you do not stop.” Confucius

6. Are we going to learn about and use computer technology? • Yes, you must master fundamentals! • Computers are useful, when you know how to use them:“computers are useless, they can only give you answers..” P. Picasso. “imagination is more important than knowledge...” A. Einstein

7. Do I have to read the textbook? YES, it’s for your own good! Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't  mttaer in waht oredr the ltteers in a wrod are,   the olny iprmoetnat tihng is taht   the frist and lsat ltteer be at the rghit pclae.   The rset can be a total mses and you can sitll raed it wouthit porbelm.   Tihs is bcuseae the huamn mnid deos not raed ervey lteter by istlef,   but the wrod as a wlohe.   Amzanig huh?  

8. Do I have to do homework? • Yes, you have to do the assignments. • Do it: “I hear it and I forget it, I see it and I remember it, I do it and I learn it” – old Chinese proverb • Practice: “In theory, there is no difference between theory and practice. But in practice, there is." – Yogi Berra (1925-) • An intelligent fool can make things bigger and more complex. It takes a touch of genius – and a lot of courage to move in the opposite direction. -– Albert Einstein • Have a good attitude:“It’s not the load that breaks you down, it’s the way you carry it” – Lena Horne / Lou Holtz

9. Learning is a pathway not a destination? What should I do to learn the material? A study on Average Memory Retention shows that a person retains: … • 10% if reading it. (You will read the material) • 20% if hearing it. (You will hear it in class) • 30% if seeing it. (You will see it in class) • 50% if seeing it and hearing it. (You are doing it now!) • 70% if saying it (repetition…) (you better read it at loud!) • 90% if DOING IT!!! (You MUST do it!) • So, if you : • Read the book (before class, read the chapter, glossary of terms and, summary); • Come to class, don’t fall asleep, open your eyes, and pay attention; • Read the material out loud again and try to explain it to a friend; • Do all the problems, homework assignments and projects….on time • You should learn the material and do well in this and any class! • “Pain is unavoidable, suffering is optional” - (Zen Aphorism) relate to other concepts find connections contrast - compare pose as question? take notes ask questions put in context

10. Teacher and Students Expectations…. The National Survey of Students Engagement • What first year students say they expect to do in college typically exceeds in almost every category of performance what they actually do. • Students typically don’t exceed their own academic expectations. • But students will go beyond what they think they can do under certain conditions, especially when teachers expect, challenge, and supports them. • Is teaching an art, or a science? • “Both. It is a science in that you can apply set principles and follow certain rules, but the real art comes when those principles and rules don’t work on a student and you have to improvise.” -Leigh Lewis

11. Use your imagination and creativity! You can tackle any task, you can learn to fly! “It's not that I am so smart, it is just that I stay with problems longer.” Albert Einstein.

12. What students say… Good morning Carlos! I wanted to thank you for a great semester. ….. I truly enjoyed your class - and, don't let your head get too big but - you are by far the best teacher I've had at MTSU. I appreciate your sense of humor. It helped make a complicated subject more interesting.. Thanks again for everything!!! Stephanie Tuttle Spring 2003 ====================================================== “[Coronel] is dedicated and hard working, and cares a bit about student learning. Like almost all professors in all schools, [Coronel] is very expert in his subject, but has a hard time getting it across to students. You have to READ THE MATERIAL in the book to STAY AHEAD OF HIM so you will understand what he says in class. If he says something in class you don't understand, STOP HIM AND ASK FOR CLARIFICATION!” AnonymousSpring 2002

13. What students say...some like it! Mr. Coronel:             I don’t know if you remember me, but I was in your Database Techniques class last fall. I liked database work so much that I decided to take Dr. Holmes’s Access class in the spring. It gave me an even better appreciation of Oracle and how powerful it is. I graduated in May and looked for an Oracle developer job for about 3 weeks, but had no luck. So I got a book from the MTSU library and learned SQL Server. I was surprised how similar Oracle and SQL Server are to one another. Because of what I learned in your class, I was able to learn SQL Server in less than a week.             Now I have a job as a data analyst at a company named SmartDM in Nashville. I load raw data feeds from the servers and ftp sites that our clients like the NHL, NBA, many of their individual teams, Ticket Master, Archtics (another ticket service), etc. send to us. After I create DTS packets to import the data, I write stored procedures and other code that reformats, cleans, and massages the data, so it can be loaded into the databases. I also create tables, views, and stored procedures that go to the servers so clients can run routine queries against the data. Sometimes they even send in requests for special requests for which I write ad-hoc queries and send them the results. I am seeing the importance of what you taught us about tuning the queries. We have some data loads with 500,000 rows. Removing duplicates from this data with a complex inner join on the existing table which can have millions of rows sometimes takes 20 minutes or more. We have fairly new and powerful servers, too. That is what I am trying to optimize now. It is great to be doing something that I knew I was going to love as soon as I started learning it in your class. If I hadn’t learned so much in your class, I would never have been able to learn SQL Server so quickly, and wouldn’t have a job I love so much. Thank you for all you taught me. I plan to pursue a career as a database administrator in the future, once I have learned all I can where I am. Kevin Durham Fall 2003

14. What students say…some don’t! the gripe line Anonymous comments via MTSUReview: “He is hard to understand and his class in boring and confusing. Most students are lost in the class. He doesn't give you enough information in the class to do the homework…” “The tests were very hard, and he didn't help much to prepare the students.” “Final Exam Was a Project from Hell of Which He Was No Help! <Expletives Omitted - MTSU Review>” “He is more theoretical than practical. I thought I would have learned more about db through hands-on assignment, but i ended up memorizing db terms. It became worst when i came to the project because he was not always available outside the class to help students. If you need to learn db because you need it for your work, DON'T take his class. If you just need to pass the db class, he is yours. “

15. Typical student not ready for class No…just kidding. It’s just a brain freeze moment…

16. A career on IT will lead to your very own Lamborgini... Let's start! NOW!

17. The proverbial Brownie Points!It’s a long class! We need energy! Teacher Favorites White Chocolate Mocha