Learn SQL From Scratch No Experience Required
- 11.5 hours on-demand video
- 51 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Basic SQL
- Advanced SQL
- Write Ad-Hoc SQL Queries Reports
- Relational Data Modeling
- Entity Relationship Modeling
- Entity Relationship Diagram (ERD)
- Design Databases from Scratch (RDBMS)
- Develop Databases from Scratch
- Oracle SQL Developer Tool (IDE)
- Practice Real-World Hands-On Projects
- Develop Databases for Custom Web Applications
- 50 Downloadable Resources
Reminder: first name, last name, and email is not a Candidate Key because we can reduce the key to email
Superkey is every possible key out there the ones that can be reduced
and the ones that cannot be reduced. The keys that can't be reduced get
elected as Candidate keys and then ONLY one of those candidate keys can
be selected as a primary key. For example, "First Name, Last Name, Email" is a superkey but cannot be a Candidate Key. However, Email is a Candidate Key because Email is unique enough to identify a record without the need of first name and last. In short, First Name, Last Name, Email is superkey not a candidate key.
Important Note: Fourth Normal Form is listed under lecture 124 by the very end of the Physical Phase; I didn't create appendix section. Why did I move 4NF to lecture 124? 4NF+ is more theortical and may confuse you and distract you if I demonstrated it right after 3NF. Also, 4NF and above are supplementary and not mandatory.
You can find lots of free youtube tutorials on how to design ERD on Microsoft Visio. For the time being, don't worry about designing ERD on MS Visio because it's luxury rather necessity. Anyhow, if still interested in MS Visio, here is few resources:
In this lecture, I added the keyword "CONSTRAINT" when assigning primary key and foreign key. Note that the "CONSTRAINT" keyword is optional. The fact is whenever you create a constraint such as primary key or foreign key, the Oracle system automatically
gives each constraint a unique name implicitly; so, rather than letting
Oracle assigning the constraint name automatically, you can use the keyword "CONSTRAINT"
as shown in this lesson. How can assigning CONSTRAINT name help you? It
helps you when you decide to drop the primary key or foreign key from a
table! How would you identify the PK and FK to be dropped? You identify
them through the CONSTRAINT name.
Comments regarding this video tutorial:
You do not necessarily have to enclose an alias with double quotation. The only time you are obliged to wrap double quotation on an alias is when the alias has spaces, such as First Name; you will have to write as "First Name". Also, the keyword AS is optional. You don't have to use it to name an alias.
Congratulations for the excellent effort you put in!
First of all, thank you for joining this training program. Secondly, I prefer all questions to be posted in udemy discussion platform, so your fellow students can learn too. There is no such thing called stupid question. All questions matter to me; ask and never feel shy! I'll be happy to help you out.
Reach me at my personal email firstname.lastname@example.org.
- No experience required
- Know how to use PC
This Oracle database course teaches you everything you need to know about databases!
2-in-1 you get two VERY important subjects in ONE COURSE: database design (theory) and Oracle SQL (hands-on).
Learn necessary skills for getting a highly paid database job.
Whatever you learn in this database course is applicable to Oracle, MySQL, Access, DB2, and the like.
This course is the most comprehensive database course for beginners you could ever find in Udemy.
This course is divided into 4 sections - watch them in sequence:
Section 1. Introduction to Databases (Very Basic)
Section 2. Design Phase (Practical Theory)
Section 3. Physical Phase (SQL) with lots of exercises - You will practice on Oracle platform
Section 4. Five Real-world Hands-on Projects (Fast paced. You have to watch section #2 and section #3 first)
Through out the course, you'll receive 50 downloadable resources such as exercises and projects to help you follow along with me.
With no experience required, this database course will take you from a
complete beginner to a confident and competent database developer who is
able to productively contribute to projects and achieve the results you
Feel free to ask me questions! I'll be happy to help you out.
Database classes are expensive. You pay for Hotel + Food + Travel + Tuition fees! A combined Relational Database Developer (RDBMS) Class + SQL Query Writing Course + Advanced SQL Writing Class quickly adds up to more than $5000. You are getting this course for LESS than a fraction of that cost!
**** WARNING: If you are expecting this course to be part of Udemy's promotion, you are wrong. This course is NOT part of Udemy's promotions and it WILL NOT be part of udemy's promotions. The course's price is $200 and it will remain $200.
Don't miss the course! Start Now...
ANOTHER Warning: this database course is not for everyone. The course is quite intensive and you have to watch them in sequence unless YOU ALREADY HAVE DATABASE EXPERIENCE. I broke the course into many short videos to help beginners understand the course.
P.S. You can download PowerPoint slides in video #4
Don't miss out...Start Now!
- New Graduates
- New Career Seekers
- System Analysts
- Data Analysts
- Business Analysts
- Database Developers
- Software Developers
- Web Developers
- Report Writers
- IT Professionals
- Anyone who wants to learn databases